RAC开启或关闭归档与单实例操作略有区别。但有一点是相同的必须在mount状态下修改归档模式。
##############################################
Oracle Environment=>11.2.0.4.0 rac on two nodes
OS Environment=>redhat 6.3 (64bit)
##############################################
1.shutdown immediate all database instances
[grid@rac2 ~]$ srvctl stop database -d doudou
2.startup database in mount mode
[grid@rac2 ~]$ srvctl start database -d doudou -o mount
SYS@doudou2> alter database archivelog ; ##-->all nodes were enabled archive logging
##SYS@doudou2> alter database noarchivelog ; ##-->all nodes were disabled archive logging
4.stop all database instances
[grid@rac2 ~]$ srvctl stop database -d doudou
5.restart all database instances
[grid@rac2 ~]$ srvctl start database -d doudou
6.verify archiving is enabled/disenabled by means of
SYS@doudou1> archive log list;
Database log mode Archive Mode -->database was archive mode for node1
SYS@doudou2> archive log list;
Database log mode Archive Mode -->database was archive mode for node2
本文参考:How To Enable/Disable Archive Logging In RAC Environment for 10.2 and higher version (文档 ID 1186764.1)
#################################################
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
【QQ交流群:53993419】
#################################################