Oracle11gR2 RAC环境中启用存档日志

以 oracle 用户身份登录到一个节点（即 racnode1），通过在当前实例中将 cluster_database 设置为 FALSE 来禁用集群实例参数

[oracle@racnode1 ~]$ sqlplus / AS sysdba

SQL*Plus: Release 11.2.0.1.0 Production ON Tue Jan 31 13:48:08 2012

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> ALTER system SET cluster_database=FALSE scope=spfile sid='racdb1';

System altered.

SQL>

以 oracle 用户身份关闭所有 访问集群化数据库的实例

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

使用本地实例,挂载数据库,启动存档功能

[oracle@racnode1 ~]$ sqlplus / AS sysdba

SQL*Plus: Release 11.2.0.1.0 Production ON Tue Jan 31 13:56:58 2012

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

Connected TO an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed SIZE                  2217992 bytes
Variable SIZE             599787512 bytes
DATABASE Buffers          234881024 bytes
Redo Buffers                2396160 bytes
DATABASE mounted.
SQL> ALTER DATABASE archivelog;

DATABASE altered.

通过在当前实例中将实例参数 cluster_database 修改为TRUE，重新启用对集群的支持,然后关闭本地实例

SQL> ALTER system SET cluster_database=TRUE scope=spfile sid='racdb1';

System altered.

SQL> shutdown immediate
ORA-01109: DATABASE NOT OPEN


DATABASE dismounted.
ORACLE instance shut down.
SQL>

以oracle帐户身份使用srvctl命令重启所有实例

[oracle@racnode1 ~]$ srvctl START DATABASE -d racdb

[oracle@racnode1 ~]$ sqlplus / AS sysdba

SQL*Plus: Release 11.2.0.1.0 Production ON Tue Jan 31 14:03:50 2012

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     65
NEXT log SEQUENCE TO archive   66
CURRENT log SEQUENCE           66
SQL>