今天应客户要求更改11g rac的归档模式,rac模式更改相对比较复杂
1.首先在任意一个节点查询归档模式
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 4273
Next log sequence to archive 4274
Current log sequence 4274
2.
2. 查看并修改 cluster_database参数
SQL> show parameter cluster_database;
NAME TYPE VALUE
———————————— ———– ——————————
cluster_database boolean TRUE 此处修改为false
执行命令修改cluster_database=false
SQL> alter system set cluster_database=false scope=spfile sid='zlsora91';
alter system set cluster_database=false scope=spfile sid='zlsora91'
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
发现使用的是pfile,只能直接在参数文件里修改
zls8640@oracle[/u01/app/oracle/admin/zlsora9/pfile]ls
init.ora.526201144128
zls8640@oracle[/u01/app/oracle/admin/zlsora9/pfile]vi init.ora.526201144128
同理更改rac2的cluster_database
3.关闭2个节点的数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
4.启动rac1到mount状态
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.3629E+10 bytes
Fixed Size 2194168 bytes
Variable Size 6979323144 bytes
Database Buffers 6610223104 bytes
Redo Buffers 37339136 bytes
Database mounted.
5.更改归档模式为noarchivelog
SQL> alter database noarchivelog;
Database altered.
6.open数据库
SQL> alter database open;
Database altered.
更改cluster_database=ture
7.启动rac2到mount状态遇到问题
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode
关闭rac1,然后启动rac2正常。更改归档模式,open数据库。
更改rac2的cluster_database=true.
启动rac1,同样遇到:ORA-01102: cannot mount database in EXCLUSIVE mode
在网上查找原因,发现rac2的
cluster_database_instances这个参数的值为1.
同样检查rac1,cluster_database_instances的值,都改为2.
SQL> alter system set cluster_database_instances=2 scope=spfile;
System altered.
然后启动正常!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22821701/viewspace-700956/,如需转载,请注明出处,否则将追究法律责任。