How to Turn Archiving OFF/ON
1. Shut down the database instance
SQL> shutdown immediate
2. Start up a new instance and mount, but do not open the database
SQL> startup mount
3. Put the database into archivelog mode/noarchivelog mode
SQL> alter database noarchivelog;
SQL> alter database archivelog; >>>>>>>>>>> IF YOU NEED TO TURN ON ARCHIVING
4. Open the database
SQL> alter database open;
5. Verify your database is now in noarchivelog/archivelog mode.
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 22
Next log sequence to archive 24
Current log sequence 24
SQL> alter system switch logfile;
1. Shut down the database instance
SQL> shutdown immediate
2. Start up a new instance and mount, but do not open the database
SQL> startup mount
3. Put the database into archivelog mode/noarchivelog mode
SQL> alter database noarchivelog;
SQL> alter database archivelog; >>>>>>>>>>> IF YOU NEED TO TURN ON ARCHIVING
4. Open the database
SQL> alter database open;
5. Verify your database is now in noarchivelog/archivelog mode.
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 22
Next log sequence to archive 24
Current log sequence 24
SQL> alter system switch logfile;
No comments:
Post a Comment