Two types of Oracle archive Mode

The following articles mainly describe how to correctly start or disable the Oracle archive mode. We all know that the Oracle database runs in two modes, mainly implementing the Oracle archive mode (archivelog) non-archive mode (noarchivelog ).

The Oracle archive mode can improve the recoverability of Oracle databases. Production Databases should all run in this mode. The Archive mode should be combined with the corresponding backup policies, only when the archive mode does not have a corresponding backup policy will it be troublesome.

This article briefly introduces how to enable and disable the Oracle archiving mode for databases.

1. shutdown normal or shutdown immediate

 
 

  
  
oracle@jumper oracle]$ sqlplus "/ as sysdba"  
  
  
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Oct 15 15:48:36 2005  
  
  
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.  
  
  
Connected to:  
  
  
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production  
  
  
With the Partitioning option  
  
  
JServer Release 9.2.0.4.0 - Production  
  
  
SQL> shutdown immediate;  
  
  
Database closed.  
  
  
Database dismounted.  
  
  
ORACLE instance shut down.  
 
 

2. Start the database to the mount status.

 
 

  
  
SQL> startup mount;  
  
  
ORACLE instance started.  
  
  
Total System Global Area 101782828 bytes  
  
  
Fixed Size 451884 bytes  
  
  
Variable Size 37748736 bytes  
  
  
Database Buffers 62914560 bytes  
  
  
Redo Buffers 667648 bytes  
  
  
Database mounted.  
 
 

3. Enable or stop archive Mode

To enable the Oracle archiving mode, use

 
 

  
  
Alter database archivelog command.
  
  
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/opt/oracle/oradata/conner/archive
  
  
Oldest online log sequence 148
  
  
Next log sequence to archive 151
  
  
Current log sequence 151
 
 

The above content is an introduction to how to enable or disable the Oracle archive mode.