ORACLE归档模式的切换

要使用RMAN进行热备，那么就需要在归档模式下方可进行。否则只能在停机状态下进行数据库冷备。

  10g,11g的切换方式是一样的，都是在mount状态对数据库的归档模式进行调整

         首先进入数据库查看当前数据库的归档状态，当前的归档状态为使用归档。

[oracle@ora10g ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.1.0 -Production on Wed Jun 1 13:20:03 2016

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise EditionRelease 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and DataMining options

 

SQL> archive log list

Database log mode              Archive Mode

Automatic archival            Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     7

Next log sequence to archive   9

Current log sequence           9

 

         要关闭归档模式需要重启数据库到mount状态，更改归档模式

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  419430400 bytes

Fixed Size                  2021248 bytes

Variable Size             188745856 bytes

Database Buffers          226492416 bytes

Redo Buffers                2170880 bytes

Database mounted.

 

         切换到非归档模式

 

SQL> alter database noarchivelog;

 

Database altered.

 

         启动数据库，查看当前归档模式

 

SQL> alter database open;

 

Database altered.

 

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival            Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     7

Current log sequence           9

 

         同样的要将非归档模式切换成归档模式一样，需要重启到mount状态，然后切换状态

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

 

Total System Global Area  419430400 bytes

Fixed Size                  2021248 bytes

Variable Size             192940160 bytes

Database Buffers          222298112 bytes

Redo Buffers                2170880 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     7

Next log sequence to archive   9

Current log sequence           9