Provides you with an in-depth understanding of the Oracle archiving mode.

Commands in Oracle archive mode must be mastered during Oracle Database learning. The following describes the commands in Oracle archive mode for your reference.

Oracle databases can run in two modes: archivelog and noarchivelog ). The archive mode can improve the recoverability of Oracle databases. Production Databases should all run in this mode. The Oracle archive mode should be combined with the corresponding backup policies, only the Oracle archive mode does not have the corresponding backup policy, which can only cause trouble.

Run the following command to check the Oracle archive mode:

SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 15 Current log sequence 17
 
Set the archive mode:

SQL> shutdown immediate; Database closed. database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. total System Global Area 1258291200 bytes Fixed Size 1219160 bytes Variable Size 318768552 bytes Database Buffers 922746880 bytes Redo Buffers 15556608 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; 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 15 Next log sequence to archive 17 Current log sequence 17
 
To stop the archive mode, run the alter database noarchivelog command. Before Oracle10g, you also need to modify the initialization parameters so that the database is in the automatic archiving mode. Set the following parameters in pfile/spfile:

Log_archive_start = true
 
Restart the database. This parameter takes effect when the database is in automatic archiving mode. It can also be manually executed during database startup:

Archive log start
 
Enable automatic archiving for the database, but the database is still in manual archiving mode after restart. 10 Gb uses db_recovery_file_dest as the storage location for archiving logs.

SQL> show parameter db_recovery NAME TYPE VALUE db_recovery_file_dest string/home/oracle/ora10g/flash_reco very_area/db_recovery_file_dest_size big integer 20G
 
The db_recovery_file_dest_size parameter can be modified.

Alter system set db_recovery_file_dest_size = 21474836480
 
 

Oracle mobile redo log file

Oracle mobile data file Method

How to view Oracle logs

Concepts of oracle users

How to query Oracle user session information