oracle rac归档模式的更改

  在读oracle 9i的rac管理文档，读到Changing the Archiving Mode in Real Application Clusters，所以动手实验一下，发现10g比9i更改模式简单的多了。

具体步骤如下（归档修改为非归档，非归档修改为归档类似，只是需要设置归档的位置）：

[oracle@rac1 ~]$ srvctl stop database -d devdb
[oracle@rac1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 23 09:51:22 2011

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  1219160 bytes
Variable Size              96470440 bytes
Database Buffers          213909504 bytes
Redo Buffers                2973696 bytes
Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> !
[oracle@rac1 ~]$ exit
exit

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
[oracle@rac1 ~]$ srvctl start database -d devdb
[oracle@rac1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 23 09:53:58 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +DG1/devdb/
Oldest online log sequence     23
Current log sequence           24

在2节点查看一下

root@rac2 ~]# su - oracle
[oracle@rac2 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 23 09:54:27 2011

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +DG1/devdb/
Oldest online log sequence     14
Current log sequence           15
SQL> 

已经修改好了。

这里再贴下别人实验的帖子，针对10gR1之前的版本和10gR2版本及后续版本归档模式的修改

http://space.itpub.net/35489/viewspace-706307