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;
Thursday, June 26, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment