proper setting of archive log.

[mashihab]

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

[Thomasps]

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.

[mashihab]

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

[Thomasps]

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

[mashihab]

thank you very much...