proper setting of archive log.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: proper setting of archive log.

  1. #1
    Join Date
    Jun 2007
    Posts
    42

    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

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    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.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jun 2007
    Posts
    42

    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

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    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 05:08 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Jun 2007
    Posts
    42
    thank you very much...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width