資源描述:
《Oracle RAC 的日常維護(hù)管理》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫(kù)。
1、1.OracleRAC的日常維護(hù)管理數(shù)據(jù)庫(kù)啟動(dòng)關(guān)閉:集群系統(tǒng)默認(rèn)是自動(dòng)啟動(dòng)的,手工啟動(dòng)命令如下:用戶root用戶啟動(dòng)cd/u01/crs/bin./crsctlstartcluster–all或者在兩個(gè)節(jié)點(diǎn)分別啟動(dòng)./crsctlstartcluster啟動(dòng)集群數(shù)據(jù)庫(kù):su-oraclesrvctlsartdatabase-dlzdb#啟動(dòng)全部實(shí)例srvctlsartdatabase-dlzdb-nlzdb1#啟動(dòng)p710a節(jié)點(diǎn)實(shí)例srvctlsartdatabase-dlzdb-nlzdb2#啟動(dòng)p710b節(jié)點(diǎn)實(shí)例關(guān)閉RAC集群數(shù)據(jù)庫(kù)和集群軟件分別在2個(gè)節(jié)點(diǎn)執(zhí)行:su-oraclesrvct
2、lstopdatabase-dlzdb再關(guān)閉集群軟件(root用戶)cd/u01/crs/bin/./crsctlstopcluster1.狀態(tài)檢查: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.驗(yàn)證集群化數(shù)據(jù)庫(kù)已開啟$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