Oracle archive mode and non-archive mode switch

Switch between the archive mode and non-archive mode in Oracle. 1. Check whether oracle is in archive mode in arichiveloglist.

Switch the Oracle archive mode to non-archive Mode 1. Check whether oracle is in archive mode arichive log list.

Oracle archive mode and non-archive mode switch

1. Check whether oracle is in archive Mode

Arichive log list;

Database Log mode non-archive Mode
Disable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
The earliest online log sequence 6
Current Log sequence 8

It is displayed that oracle is not in archive mode at this time. It is set to archive mode below.

2. Input: shutdown

The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.

3. Start the database in mount mode and enter startup mount.

The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.

4. Change to archive mode, alter database arichive;

The database has been changed.

Now the modification has been completed. Check the arichive log list.

Database Log mode archiving Mode
Enable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
The earliest online log sequence 6
Next archive log sequence 8
Current Log sequence 8

Related reading:

Oracle 11g rac modify archive Mode

Oracle manual full recovery case (archive Mode)

Oracle manual recovery case (non-archive Mode)

Instructions for setting Oracle archive Mode

Backup script in Oracle 10g archive Mode