Archiving mode for Oracle databases (Archivelog modes)

The Oracle database can run in 2 modes:

1. Archive Mode (Archivelog)

Archiving mode can improve the recoverability of Oracle database, the production database should run in this mode, the archiving mode should be combined with the corresponding backup strategy, only the archive mode does not have a corresponding backup strategy will only cause trouble.

1. Non-archive mode (Noarchivelog)

How to enable and disable archiving mode for a database.

1.shutdown Normal or shutdown immediate close the database

2.startup mount Boot database to mount state

3. Enable or stop the archive mode

Enable archive mode: ALTER DATABASE Archivelog

Deactivate archive mode: ALTER DATABASE Noarchivelog

4. View Archive mode: Archive Log list

sql> shutdown Immediate Database closed. Database dismounted. ORACLE instance shut down. Sql> startup Mount; ORACLE instance started. Total System Global area 1653518336 bytes Fixed Size 2253784 bytes Variable Size 1207962664 bytes Database buffers 436207616 bytes Redo buffers 7094272 bytes Database mounted. sql> ALTER DATABASE archivelog; Database altered. sql> archive log list; Database Log Mode Archive mode Automatic Archival Enabled Archive Destination use_db_recovery_file_dest Oldest online log sequence 18 Next Log sequence to archive 20 Current log Sequence 20

Archiving mode for Oracle databases (Archivelog modes)