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

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

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

[grid@rac1 ~]$ asmcmdASMCMD> lsDATA/ASMCMD> cd DATAASMCMD> lsRACDB/rac-cluster/ASMCMD> mkdir ARCHASMCMD> cd ARCHASMCMD> pwd+DATA/RACDB/ARCH

2.修改归档路径参数

[oracle@rac1 ~]$ sqlplus / as sysdbaSQL> 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                                                        ONLINE  ONLINE       rac2                                         ora.LISTENER.lsnr               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.asm               ONLINE  ONLINE       rac1                     Started                            ONLINE  ONLINE       rac2                     Started             ora.gsd               OFFLINE OFFLINE      rac1                                                        OFFLINE OFFLINE      rac2                                         ora.net1.network               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.ons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       rac2                                         ora.LISTENER_SCAN2.lsnr      1        ONLINE  ONLINE       rac1                                         ora.LISTENER_SCAN3.lsnr      1        ONLINE  ONLINE       rac1                                         ora.cvu      1        ONLINE  ONLINE       rac1                                         ora.oc4j      1        ONLINE  ONLINE       rac1                                         ora.rac1.vip      1        ONLINE  ONLINE       rac1                                         ora.rac2.vip      1        ONLINE  ONLINE       rac2                                         ora.racdb.db      1        OFFLINE OFFLINE                               Instance Shutdown         2        OFFLINE OFFLINE                               Instance Shutdown   ora.scan1.vip      1        ONLINE  ONLINE       rac2                                         ora.scan2.vip      1        ONLINE  ONLINE       rac1                                         ora.scan3.vip      1        ONLINE  ONLINE       rac1 

4.将一个节点数据库启动到mount状态

[grid@rac1 ~]$ srvctl start instance -d racdb -i racdb1 -o mount

5.修改数据库的归档模式并启动数据库

SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.

6.检查状态

SQL> archive log list; Database log mode          Archive ModeAutomatic archival         EnabledArchive destination        +DATA/racdb/archOldest online log sequence     5Next log sequence to archive   6Current log sequence           6

7.启动2节点数据库

[grid@rac1 ~]$ srvctl start instance -d racdb -i racdb2

8.检查集群状态

[grid@rac1 ~]$ crsctl stat res -t --------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.LISTENER.lsnr               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.asm               ONLINE  ONLINE       rac1                     Started                            ONLINE  ONLINE       rac2                     Started             ora.gsd               OFFLINE OFFLINE      rac1                                                        OFFLINE OFFLINE      rac2                                         ora.net1.network               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.ons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr      1        ONLINE  ONLINE       rac2                                         ora.LISTENER_SCAN2.lsnr      1        ONLINE  ONLINE       rac1                                         ora.LISTENER_SCAN3.lsnr      1        ONLINE  ONLINE       rac1                                         ora.cvu      1        ONLINE  ONLINE       rac1                                         ora.oc4j      1        ONLINE  ONLINE       rac1                                         ora.rac1.vip      1        ONLINE  ONLINE       rac1                                         ora.rac2.vip      1        ONLINE  ONLINE       rac2                                         ora.racdb.db      1        ONLINE  ONLINE       rac1                     Open                      2        ONLINE  ONLINE       rac2                     Open                ora.scan1.vip      1        ONLINE  ONLINE       rac2                                         ora.scan2.vip      1        ONLINE  ONLINE       rac1                                         ora.scan3.vip      1        ONLINE  ONLINE       rac1