要使用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