Oracle RAC开启归档

1.禁用集群实例

[oracle@racnode1 ~]$  sqlplus / as sysdba

SQL>   alter system set cluster_database=false scope=spfile sid='racdb1';

System altered.

2.关闭集群数据库实例

[oracle@racnode1 ~]$  srvctl stop database -d racdb

3.mount数据库

[oracle@racnode1 ~]$  sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 21 19:26:47 2009

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

Connected to an idle instance.

SQL>  startup mount
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size            1073743864 bytes
Database Buffers          570425344 bytes
Redo Buffers                7135232 bytes

4.开启归档

SQL>  alter database archivelog;

Database altered.

5.开启集群实例

SQL>  alter system set cluster_database=true scope=spfile sid='racdb1';

System altered.

6.关闭实例

SQL>  shutdown immediate

ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

7.开启数据库

[oracle@racnode1 ~]$  srvctl start database -d racdb

8.检查归档

[oracle@racnode1 ~]$  sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 21 19:33:38 2009

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>  archive log list
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     69
Next log sequence to archive   70
Current log sequence           70