Oracle RAC 的日常维护管理

《Oracle RAC 的日常维护管理》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1.OracleRAC的日常维护管理数据库启动关闭：集群系统默认是自动启动的，手工启动命令如下：用户root用户启动cd/u01/crs/bin./crsctlstartcluster–all或者在两个节点分别启动./crsctlstartcluster启动集群数据库：su-oraclesrvctlsartdatabase-dlzdb#启动全部实例srvctlsartdatabase-dlzdb-nlzdb1#启动p710a节点实例srvctlsartdatabase-dlzdb-nlzdb2#启动p710b节点实例关闭RAC集群数据库和集群软件分别在2个节点执行：su-oraclesrvct

2、lstopdatabase-dlzdb再关闭集群软件（root用户）cd/u01/crs/bin/./crsctlstopcluster1．状态检查：p570a->su-grid-c"crs_stat-t-v"NameTypeR/RAF/FTTargetStateHost----------------------------------------------------------------------ora.CRS1.dgora....up.type0/50/ONLINEONLINEp570aora.DATA1.dgora....up.type0/50/ONLINEONLINEp570

3、aora....ER.lsnrora....er.type0/50/ONLINEONLINEp570aora....N1.lsnrora....er.type0/50/0ONLINEONLINEp570aora.asmora.asm.type0/50/ONLINEONLINEp570aora.eonsora.eons.type0/30/ONLINEONLINEp570aora.gsdora.gsd.type0/50/OFFLINEOFFLINEora....networkora....rk.type0/50/ONLINEONLINEp570aora.oc4jora.oc4j.type0/50/

4、0OFFLINEOFFLINEora.onsora.ons.type0/30/ONLINEONLINEp570aora....SM1.asmapplication0/50/0ONLINEONLINEp570aora....00.lsnrapplication0/50/0ONLINEONLINEp570aora.p570a.gsdapplication0/50/0OFFLINEOFFLINEora.p570a.onsapplication0/30/0ONLINEONLINEp570aora.p570a.vipora....t1.type0/00/0ONLINEONLINEp570aora....

5、SM2.asmapplication0/50/0ONLINEONLINEp570bora....00.lsnrapplication0/50/0ONLINEONLINEp570bora.p570b.gsdapplication0/50/0OFFLINEOFFLINEora.p570b.onsapplication0/30/0ONLINEONLINEp570bora.p570b.vipora....t1.type0/00/0ONLINEONLINEp570bora.scan1.vipora....ip.type0/00/0ONLINEONLINEp570a2．验证集群化数据库已开启$su-gri

6、d-c"crsctlstatusresource-w"TYPEco'ora'"-t"p570a->su-grid-c"crsctlstatusresource-w"TYPEco'ora'"-t"--------------------------------------------------------------------------------NAMETARGETSTATESERVERSTATE_DETAILS--------------------------------------------------------------------------------Local

7、Resources--------------------------------------------------------------------------------ora.CRS1.dgONLINEONLINEp570aONLINEONLINEp570bora.DATA1.dgONLINEONLINEp570aONLINEONLINEp570bora.LISTENER.lsnrONL