更改RAC归档模式
(1) 更改归档模式必须在MOUNT状态下--》关闭系统--》 启动系统到MOUNT状态下;
关闭系统
srvctl stop database -d TEST
启动系统到mount状态下
srvctl start database -d TEST -o mount
(2) 登录系统,更改归档模式
export ORACLE_SID=TEST1
sqlplus / as sysdba
(3) show parameter name 进行验证操作的数据库实例名称
(4) alter system archivelog;
(5) alchive log list 验证!
(6) 更改归档地址
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATADG/OMS/ARCHIVELOG/ARCHIVE1/ARC1' SCOPE=both SID='OMS1' ;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=+DATADG/OMS/ARCHIVELOG/ARCHIVE1/ARC2' SCOPE=both SID='OMS1' ;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATADG/OMS/ARCHIVELOG/ARCHIVE2/ARC1' SCOPE=both SID='OMS2' ;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=+DATADG/OMS/ARCHIVELOG/ARCHIVE2/ARC2' SCOPE=both SID='OMS2' ;
(7) 对参数进行确认 show parameter LOG_ARCHIVE_DEST_1
(8) 分别alter database open;