实验：oracle 11g RAC change archive log mode

[oracle@croracle01 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jun 25 04:15:26 2009

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


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

SQL> archive log list
Database log mode No Archive Mode <--Here!!!
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 114
Current log sequence 115
SQL> quit





[oracle@croracle01 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE croracle01
ora....01.lsnr application ONLINE ONLINE croracle01
ora....e01.gsd application ONLINE ONLINE croracle01
ora....e01.ons application ONLINE ONLINE croracle01
ora....e01.vip application ONLINE ONLINE croracle01
ora....SM2.asm application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE ONLINE croracle02
ora....e02.gsd application ONLINE ONLINE croracle02
ora....e02.ons application ONLINE ONLINE croracle02
ora....e02.vip application ONLINE ONLINE croracle02
ora....SM3.asm application ONLINE ONLINE croracle03
ora....03.lsnr application ONLINE ONLINE croracle03
ora....e03.gsd application ONLINE ONLINE croracle03
ora....e03.ons application ONLINE ONLINE croracle03
ora....e03.vip application ONLINE ONLINE croracle03
ora....SM4.asm application ONLINE ONLINE croracle04
ora....04.lsnr application ONLINE ONLINE croracle04
ora....e04.gsd application ONLINE ONLINE croracle04
ora....e04.ons application ONLINE ONLINE croracle04
ora....e04.vip application ONLINE ONLINE croracle04
ora....d1.inst application ONLINE ONLINE croracle01
ora....d2.inst application ONLINE ONLINE croracle02
ora....d3.inst application ONLINE ONLINE croracle03
ora....d4.inst application ONLINE ONLINE croracle04
ora.crprod.db application ONLINE ONLINE croracle01
[oracle@croracle01 bin]$



SQL> alter system set cluster_database=false scope=spfile;

System altered.


[oracle@croracle01 ~]$ srvctl stop database -d crprod
[oracle@croracle01 ~]$




[oracle@croracle04 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE croracle01
ora....01.lsnr application ONLINE ONLINE croracle01
ora....e01.gsd application ONLINE ONLINE croracle01
ora....e01.ons application ONLINE ONLINE croracle01
ora....e01.vip application ONLINE ONLINE croracle01
ora....SM2.asm application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE ONLINE croracle02
ora....e02.gsd application ONLINE ONLINE croracle02
ora....e02.ons application ONLINE ONLINE croracle02
ora....e02.vip application ONLINE ONLINE croracle02
ora....SM3.asm application ONLINE ONLINE croracle03
ora....03.lsnr application ONLINE ONLINE croracle03
ora....e03.gsd application ONLINE ONLINE croracle03
ora....e03.ons application ONLINE ONLINE croracle03
ora....e03.vip application ONLINE ONLINE croracle03
ora....SM4.asm application ONLINE ONLINE croracle04
ora....04.lsnr application ONLINE ONLINE croracle04
ora....e04.gsd application ONLINE ONLINE croracle04
ora....e04.ons application ONLINE ONLINE croracle04
ora....e04.vip application ONLINE ONLINE croracle04
ora....d1.inst application OFFLINE OFFLINE
ora....d2.inst application OFFLINE OFFLINE
ora....d3.inst application OFFLINE OFFLINE
ora....d4.inst application OFFLINE OFFLINE
ora.crprod.db application OFFLINE OFFLINE



[oracle@croracle01 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jun 23 01:53:51 2009

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

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 801701888 bytes
Fixed Size 2148680 bytes
Variable Size 461375160 bytes
Database Buffers 335544320 bytes
Redo Buffers 2633728 bytes
Database mounted.
SQL>



[oracle@croracle01 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jun 23 01:53:51 2009

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

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 801701888 bytes
Fixed Size 2148680 bytes
Variable Size 461375160 bytes
Database Buffers 335544320 bytes
Redo Buffers 2633728 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter system set cluster_database=true scope=spfile;

System altered.


SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL>


[oracle@croracle04 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE croracle01
ora....01.lsnr application ONLINE ONLINE croracle01
ora....e01.gsd application ONLINE ONLINE croracle01
ora....e01.ons application ONLINE ONLINE croracle01
ora....e01.vip application ONLINE ONLINE croracle01
ora....SM2.asm application ONLINE ONLINE croracle02
ora....02.lsnr application ONLINE ONLINE croracle02
ora....e02.gsd application ONLINE ONLINE croracle02
ora....e02.ons application ONLINE ONLINE croracle02
ora....e02.vip application ONLINE ONLINE croracle02
ora....SM3.asm application ONLINE ONLINE croracle03
ora....03.lsnr application ONLINE ONLINE croracle03
ora....e03.gsd application ONLINE ONLINE croracle03
ora....e03.ons application ONLINE ONLINE croracle03
ora....e03.vip application ONLINE ONLINE croracle03
ora....SM4.asm application ONLINE ONLINE croracle04
ora....04.lsnr application ONLINE ONLINE croracle04
ora....e04.gsd application ONLINE ONLINE croracle04
ora....e04.ons application ONLINE ONLINE croracle04
ora....e04.vip application ONLINE ONLINE croracle04
ora....d1.inst application ONLINE ONLINE croracle01
ora....d2.inst application ONLINE ONLINE croracle02
ora....d3.inst application ONLINE ONLINE croracle03
ora....d4.inst application ONLINE ONLINE croracle04
ora.crprod.db application ONLINE ONLINE croracle02
[oracle@croracle04 bin]$


[oracle@croracle01 bin]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jun 23 02:02:37 2009

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


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

SQL>

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

成了！