Oracle archive mode and non-archive mode switch

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 shows that oracle is not in archive mode at this time, and 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

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