Saturday, November 06, 2010

Enable and Disable the archive log

To Disable the Archive Log:

change the following value to false in the init.ora file
log_archive_start=false
shutdown the database:
shutdown immediate


disable the archivelog:
startup mount
alter database noarchivelog;
alter database open;
archive log list;


To Enable the Archive Log:

change the following value to true in the init.ora file
log_archive_start=true
shutdown the database:
shutdown immediate

enable the archivelog:
startup mount
alter database archivelog;
alter database open;
archive log list;
archive log all;





Regards,
Sukhwinder Singh.


.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget