-
proper setting of archive log.
DEAR FRIENDS,
My current DB Mode is NOARCHIVELOG.I will change it ARCHIVELOG.my log_archive_dest,log_archive_dest_1,..... are empty.Will it make any problem to shift to archive log?Do we need to multiplex archive log?
I am a very new DBA...
THANKS IN ADVANCE...
SHIHAB
-
First understand why archivelog is required. Why the DB was running in NOARCHIVELOG so far? Shifting into Archivelog mode will not make any issue. Remember to have a backup stratagey for archivelog files and clearning it down. Multiplexing archivelogs, again depend on, how important is your data. I don't think such an important DB will run in NOARCHIVELOG mode with a new DBA.
-
comment
Actually the data is important.The management is not very aware of these kinds of things.So far so good.Should I put log_archive_dest before I shift to ARCHIVELOG mode?
Thank you.
Shihab
-
You must be working in Middle East!
Yes, Set the parameter
log_archive_dest_1='location= ARCHIVE LOCATION'
Read this chapter before you start.
http://download-west.oracle.com/docs...o.htm#i1008343
Last edited by Thomasps; 06-24-2007 at 04:08 AM.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|