| archivelog ot noarchivelog [message #58386] |
Fri, 22 August 2003 00:46  |
R.SIVAKUMAR
Messages: 48
Registered: February 2002
|
Member |
|
|
i have a oracel database server.
the version is oracel 8.05.
it is working in windows 2000 os.
There are 200 users connected to the server via tcp ip.
Monthly once I am taking backup using exp80 command.
Now i have scared about certain database corruption/ hard disk failure.
Now the database not in the archivelog mode.
should i change it to archivelog mode?.
is it necessary ?.
which one is best ?
if archivelog mode is best, tell me the way how to i change
to archivelog mode.
what r the precautions i have take before change into archivelog mode ?.
pllease tell me some tips how to maintain the oracel server.
tnx...
kumar
|
|
|
|
| Re: archivelog ot noarchivelog [message #58401 is a reply to message #58386] |
Sat, 23 August 2003 22:03  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
it is simple to put db in archive log mode
1) modify your init.ora parameter file (log_archive*) to tell oracle what to do when you get into archivelogmode (where to put the archive logs, what to call them, etc.)
2) shutdown the database
3) STARTUP MOUNT
4) ALTER DATABASE ARCHIVELOG; --this is what actually puts your db into archivelog mode
4B) ALTER DATABASE NOARCHIVELOG; --if you ever want to take it out of archivelog mode
5) ALTER DATABASE OPEN
6) Take a Backup ASAP (not using export utilty)
If you are going to only backup using export utility, dont waste your time putting db in archivelog mode.
Otherwise, now you need to take actually backups (OS copies of the datafiles) and you need to maintain your archive logs (decide where to keep them like on tape or something).
|
|
|
|
| Re: archivelog ot noarchivelog [message #58411 is a reply to message #58401] |
Mon, 25 August 2003 05:29 |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
Hello Kumar,
Well archieve log mode is more beneficial then export.
and there might be a situation where you can not restore from a export.
But before starting the db in archieve log mode..you need to take a cold backup.
also you will have to edit the init.ora parameters:
archive log mode = true , the destination of the files and format of filename of the redo logs that need to be archieved.
after that you can start the db and go through all the steps listed above.
Regards,
Vikas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
