對(duì)oracle數(shù)據(jù)庫(kù)進(jìn)行容災(zāi)(veritasvolumereplicator)-資料下載頁(yè)
2025-06-18 08:20本頁(yè)面
【正文】 Nov516:55:122007 Copyright(c)1982,2005,Oracle.Allrightsreserved. Connectedto: OracleDatabase10gEnterpriseEditionReleaseProduction WiththePartitioning,OLAPandDataMiningoptions SQLcreatetabletest(avarchar(20))tablespaceusers Tablecreated. SQLinsertintotestvalues(39。139。) 1rowcreated. SQLmit Commitplete. SQLinsertintotestvalues(39。239。) 1rowcreated. SQL SQL SQLmit Commitplete. ======================================立即異常關(guān)閉oracle和操作系統(tǒng)============================ root@lxsfrac02psef|egrepora_|asm_|grepvgrep|grepvcrs|awk39。{print$2}39。|xargskill9 root@lxsfrac02 root@lxsfrac02psef|grepora root19301016:08:13?0:02/opt/VRTSobc/pal33/bin/vxpalaStorageAgentx oracle1942019419016:55:12?0:00oracleracg1(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle1941419410016:55:11pts/30:00bash oracle1941919414016:55:12pts/30:00sqlplus/assysdba root198723725016:56:49pts/20:00grepora root@lxsfrac02 root@lxsfrac02poweroff 從系統(tǒng)日志/var/tmp/messages可以查看到相關(guān)信息： Nov516:57:26lxsfrac02poweroff:[ID662345]poweroffedbyroot =======================================在備用節(jié)點(diǎn)進(jìn)行接管======================================= root@lxsfrac01vradmingoradgmigrateora_rvglxsfrac01priv VxVMVVRvradminWARNINGV55293MakesureapplicationsusingPrimarydatavolumesarestopped. vradmin:Continuewithmigrate(y/n)?y MessagefromHostlxsfrac01priv: VxVMVVRvradminERRORV552449Secondaryora_rvgdoesnothaveanactivePrimary. root@lxsfrac01 root@lxsfrac01vradmingoradgtakeoverora_rvg root@lxsfrac01date MonNov517:05:13CST2007 root@lxsfrac01vxprinthtqgoradg dgoradgdefaultdefault10000 dmAMS_WMS0_2AMS_WMS0_2auto655364116224 dmAMS_WMS0_3AMS_WMS0_3auto65536146687968 rvora_rvg1ENABLEDACTIVEprimary1srl rlrlk_lxsfrac02priv_ora_rvgora_rvgENABLEDACTIVElxsfrac02privoradgrlk_lxsfrac01priv_ora_rvg voravolora_rvgENABLEDACTIVE20971520SELECTfsgen ploravol01oravolENABLEDACTIVE20971520CONCATRW sdAMS_WMS0_301oravol01AMS_WMS0_30209715200AMS_WMS0_3ENA ploravol02oravolENABLEDACTIVELOGONLYCONCATRW sdAMS_WMS0_201oravol02AMS_WMS0_20352LOGAMS_WMS0_2ENA ploravol03oravolENABLEDACTIVELOGONLYCONCATRW sdAMS_WMS0_303oravol03AMS_WMS0_322609920352LOGAMS_WMS0_3ENA vsrlora_rvgENABLEDACTIVE1638400SELECTSRL plsrl01srlENABLEDACTIVE1638400CONCATRW sdAMS_WMS0_302srl01AMS_WMS0_32097152016384000AMS_WMS0_3ENA root@lxsfrac01 ================================啟動(dòng)備用節(jié)點(diǎn)Oracle數(shù)據(jù)庫(kù)，并檢查數(shù)據(jù)完整======================== root@lxsfrac01mountFvxfs/dev/vx/dsk/oradg/oravol/oracle root@lxsfrac01 root@lxsfrac01suoracle SunMicrosystemsInc.SunOSGenericJanuary2005 oracle@lxsfrac01$sysdba SQL*Plus:ReleaseProductiononMonNov517:05:372007 Copyright(c)1982,2005,Oracle.Allrightsreserved. Connectedtoanidleinstance. SQLstartup ORACLEinstancestarted. TotalSystemGlobalArea2147483648bytes FixedSize2120448bytes VariableSize496870656bytes DatabaseBuffers1644167168bytes RedoBuffers4325376bytes Databasemounted. Databaseopened. SQLselect*fromtest A 1 2 ================================ 顯示數(shù)據(jù)正常 =========================== 在第二個(gè)節(jié)點(diǎn)vxdg import oradg 然后recover 直到兩個(gè)節(jié)點(diǎn)vxprint htqg oradg都正常：ENABLED/ACTIVE ，我遇到了兩次，一次是在createpri，一次在addsec，原因是主備的DCM默認(rèn)都需要mirror，所以所在的磁盤組都最少包括兩塊磁盤(或LUN)，通過(guò)vxdg g oradg adddisk another_disk解決?！oot@lxsfrac01 vradmin g oradg createpri ora_rvg \ system,sysaux,temp,users,example,ctlfile1,ctlfile2,ctlfile3,redo101,redo102,redo103,undo11,spfile\ srl MessagefromPrimary: VxVMvxassistERRORV51434Cannotallocatespacefor32blocklog root@lxsfrac01vradmingoradgaddsecora_rvglxsfrac01privlxsfrac02priv MessagefromHostlxsfrac02priv: VxVMvxassistERRORV51434Cannotallocatespacefor352blocklog root@lxsfrac02psef|grepvrad|grepvgrep root98081016:24:47?0:00/usr/sbin/vradmind 如果進(jìn)程狀態(tài)不對(duì)，使用下面語(yǔ)句來(lái)手工啟動(dòng)： /etc/start 可以看到vradmin是隨系統(tǒng)自啟動(dòng)的： root@lxsfrac02find/etc/rc*name39。*vr*39。print /etc/ /etc/ /etc/ /etc/15 / 15
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1