Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Sunday, February 05, 2006

Archive Log

Steps in changing database from no archive mode to archive mode:

sql/>shutdown normal/immediate/transactional (You can use any value)

sql/>startup mount

sql/>alter database archivelog

sql/>alter database open


Go for Full Database backup


Keep in mind a user must have ALTER SYSTEM PRIVILEGE to alter the archivelog mode of the database.

Setting the database in Archivelog mode doesnot enable the Archiver (ARCN) process!

AUTOMATIC & MANUAL Archiving

Set the parameter file for LOG_ARCHIVE_START=TRUE

Hmm mean while you can do multiple arcn process

LOG_ARCHIVE_MAX_PROCESSES

And a maximum of ten ARCN processes can be specified and its dynamic

Sql/>alter system set LOG_ARCHIVE_MAX_PROCESSES=3;

Well if you find more about this let me know.

2 comments:

  1. I'm used to do it the other way round. Setting the parameters first, and then changing the Database mote to Archivelog. But anyway it's just the same.

    Don't forget to edit your post and add comments on LOG_ARCHIVE_DEST_n, LOG_ARCHIVE_DEST_STATE_n or a link th TFM.

    Yoann

    ReplyDelete
  2. Anonymous11:04 PM

    Hi Ravi

    Add one more parameter to this
    log_archive_format="%s.Arc"
    where s=log seq. no.


    Regards,
    Krishna

    ReplyDelete

 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved