proper setting of archive log.
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...
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.
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?
You must be working in Middle East!
Yes, Set the parameter
log_archive_dest_1='location= ARCHIVE LOCATION'
Read this chapter before you start.
Last edited by Thomasps; 06-24-2007 at 05:08 AM.
Click Here to Expand Forum to Full Width