在读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