Oracle 11g RAC 开启、修改归档方法

目的：把归档模式打开并且将日志放在共享存储（ASM）上
环境信息：RHEL6U8，Oracle11gR2
主机名：rac1.onlymiss.cn,rac2.onlymiss.cn
实例名：racdb1,racdb2

操作步骤：
1.在ASM建归档路径

[grid@rac1 ~]$ asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd DATA
ASMCMD> ls
RACDB/
rac-cluster/
ASMCMD> mkdir ARCH
ASMCMD> cd ARCH
ASMCMD> pwd
+DATA/RACDB/ARCH

2.修改归档路径参数

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> alter system set log_archive_dest_1='location=+DATA/RACDB/ARCH' scope=spfile sid='*';
System altered.

3.关闭数据库，全部节点都要关闭

[grid@rac1 ~]$ srvctl stop database -d racdb

检查数据库关闭后状态

[grid@rac1 ~]$ crsctl stat res -t 
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac1