Friday 22 March 2013

ENABLING ARCHIVE LOG AND DISABLING ARCHIVE LOG MODE

ENABLING ARCHIVE LOG AND DISABLING ARCHIVE LOG MODE

TO ENABLE ARCHIVE LOG MODE


 SQL>
archive log list;
shutdown immediate;
startup mount
alter database archivelog;
alter database open;
archive log list;


NOTE: Please perform all the actions as sys user and take a full database backup after you toggle the database to archive or noarchive log mode


How to disable archive log mode :



sql> shutdown immediate;

sql> startup mount;

sql> alter database noarchivelog;
sql> alter database open;


select log_mode from v$database;

No comments:

Post a Comment