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.

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

thank you very much...