【導(dǎo)讀】的情況下，如何保證生產(chǎn)數(shù)據(jù)的安全和關(guān)鍵業(yè)務(wù)的不中斷運(yùn)行。傳統(tǒng)的保護(hù)方法離線備份、備份介質(zhì)異地。7x24不中斷，應(yīng)對激烈的市場競爭和提高客戶滿意度，企業(yè)必須在IT系統(tǒng)圍繞―連續(xù)‖主題進(jìn)行構(gòu)。建，實(shí)施業(yè)務(wù)連續(xù)/容災(zāi)備份計劃，包括業(yè)務(wù)連續(xù)性、高可用性管理、容災(zāi)、數(shù)據(jù)復(fù)制和恢復(fù)方案、安全等，下面就對數(shù)據(jù)復(fù)制技術(shù)做一個簡單的介紹。TrueCopy等，特點(diǎn)對主機(jī)透明，對應(yīng)用系統(tǒng)的影響較小，技術(shù)成熟，有較多的成功案例，但是投資較大，對網(wǎng)絡(luò)連接的要求也較高。據(jù)庫日志實(shí)現(xiàn)的，優(yōu)點(diǎn)是硬件投資小，對生產(chǎn)系統(tǒng)的影響比較小，對主、備用系統(tǒng)的硬件平臺沒有選擇性；可以在廣域網(wǎng)范圍內(nèi)使用。但它對數(shù)據(jù)庫系統(tǒng)有嚴(yán)格的要求，并且主、備用系統(tǒng)必須使用相同的數(shù)據(jù)庫版。通過對邏輯卷的同步和異步復(fù)制模式，保證數(shù)據(jù)的完整性和一致性；不允許人工直接對SRL進(jìn)行訪問。用于連接主RVG和備用RVG之間的一個―鏈接‖，一個主的RVG最多可以有32個RLINK。

　　

【正文】 ated. SQL SQL SQL mit 。 Commit plete. ====================================== 立即異常關(guān)閉 oracle 和 操作系統(tǒng) ============================ root@rac02 ps ef|egrep ora_|asm_|grep v grep |grep v crs|awk 39。{print $2}39。 |xargs kill 9 root@rac02 root@rac02 ps ef|grep ora root 1930 1 0 16:08:13 ? 0:02 /opt/VRTSobc/pal33/bin/vxpal a StorageAgent x oracle 19420 19419 0 16:55:12 ? 0:00 oracleracg1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 19414 19410 0 16:55:11 pts/3 0:00 bash oracle 19419 19414 0 16:55:12 pts/3 0:00 sqlplus /as sysdba root 19872 3725 0 16:56:49 pts/2 0:00 grep ora root@rac02 root@rac02 poweroff 從系統(tǒng)日志 /var/tmp/messages可以查看到相關(guān)信息： Nov 5 16:57:26 rac02 poweroff: [ID 662345 ] poweroffed by root ======================================= 在 備 用 節(jié) 點(diǎn) 進(jìn) 行 接 管 ======================================= root@rac01 vradmin g oradg migrate ora_rvg rac01priv VxVM VVR vradmin WARNING V55293 Make sure applications using Primary data volumes are stopped. vradmin: Continue with migrate (y/n)? y Message from Host rac01priv: VxVM VVR vradmin ERROR V552449 Secondary ora_rvg does not have an active Primary. root@rac01 root@rac01 vradmin g oradg takeover ora_rvg root@rac01 date Mon Nov 5 17:05:13 CST 2020 root@rac01 vxprint htqg oradg dg oradg default default 10000 dm AMS_WMS0_2 AMS_WMS0_2 auto 65536 4116224 dm AMS_WMS0_3 AMS_WMS0_3 auto 65536 146687968 rv ora_rvg 1 ENABLED ACTIVE primary 1 srl rl rlk_rac02priv_ora_rvg ora_rvg ENABLED ACTIVE rac02priv oradg rlk_rac01priv_ora_rvg v oravol ora_rvg ENABLED ACTIVE 20971520 SELECT fsgen pl oravol01 oravol ENABLED ACTIVE 20971520 CONCAT RW sd AMS_WMS0_301 oravol01 AMS_WMS0_3 0 20971520 0 AMS_WMS0_3 ENA pl oravol02 oravol ENABLED ACTIVE LOGONLY CONCAT RW sd AMS_WMS0_201 oravol02 AMS_WMS0_2 0 352 LOG AMS_WMS0_2 ENA pl oravol03 oravol ENABLED ACTIVE LOGONLY CONCAT RW sd AMS_WMS0_303 oravol03 AMS_WMS0_3 22609920 352 LOG AMS_WMS0_3 ENA v srl ora_rvg ENABLED ACTIVE 1638400 SELECT SRL pl srl01 srl ENABLED ACTIVE 1638400 CONCAT RW sd AMS_WMS0_302 srl01 AMS_WMS0_3 20971520 1638400 0 AMS_WMS0_3 ENA root@rac01 ================================ 啟動備用節(jié)點(diǎn) Oracle 數(shù)據(jù)庫，并檢查數(shù)據(jù)完整 ======================== root@rac01 mount F vxfs /dev/vx/dsk/oradg/oravol /oracle root@rac01 root@rac01 su oracle Sun Microsystems Inc. SunOS Generic January 2020 oracle@rac01 $ sysdba SQL*Plus: Release Production on Mon Nov 5 17:05:37 2020 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 2120448 bytes Variable Size 496870656 bytes Database Buffers 1644167168 bytes Redo Buffers 4325376 bytes Database mounted. Database opened. SQL select * from test 。 A 1 2 ================================ 顯示數(shù)據(jù)正常 =========================== SQL !date Mon Nov 5 17:06:58 CST 2020 SQL exit Disconnected from Oracle Database 10g Enterprise Edition Release Production With the Partitioning, OLAP and Data Mining options 附：創(chuàng)建配置 VVR 過程中部分錯誤診斷 1．錯誤 V513370，備份異常中斷，復(fù)制不能繼續(xù) root@rac01 vxrlink g oradg recover rlk_rac02priv_ora_rvg VxVM VVR vxrlink ERROR V513370 Can not recover rlk_rac02priv_ora_rvg until ora_rvg is recovered root@rac01 vxrecover g oradg s root@rac01 vxprint ………………顯示正常 2．錯誤 V552449，需要檢查主、備節(jié)點(diǎn)磁盤組狀態(tài)為 import，并且 volume/rlink/srl狀態(tài)為 enabled和 active root@rac01 vradmin g oradg a startrep ora_rvg Message from Host rac01priv: VxVM VVR vradmin ERROR V552449 Secondary ora_rvg does not have an active Primary. 在第二個節(jié)點(diǎn) vxdg import oradg 然后 recover 直到兩個節(jié)點(diǎn) vxprint htqg oradg 都正常： ENABLED/ACTIVE 3．錯誤 V51434，我遇到了兩次，一次是在 createpri，一次在 addsec，原因是主備的 DCM默認(rèn)都需要 mirror，所以所在的磁盤組都最少包括兩塊磁盤 (或 LUN)，通過 vxdg g oradg adddisk another_disk解決。 root@rac01 vradmin g oradg createpri ora_rvg \ system,sysaux,temp,users,example,ctlfile1,ctlfile2,ctlfile3,redo101,redo102,redo103,undo11,spfile \ srl Message from Primary: VxVM vxassist ERROR V51434 Cannot allocate space for 32 block log root@rac01 vradmin g oradg addsec ora_rvg rac01priv rac02priv Message from Host rac02priv: VxVM vxassist ERROR V51434 Cannot allocate space for 352 block log 4．檢查 vvr后臺進(jìn)程 root@rac02 ps ef|grep vrad|grep v grep root 9808 1 0 16:24:47 ? 0:00 /usr/sbin/vradmind 如果進(jìn)程狀態(tài)不對，使用下面語句來手工啟動： /etc/ 可以看到 vradmin 是隨系統(tǒng)自啟動的： root@rac02 find /etc/rc* name 39。*vr*39。 print /etc//etc//etc//etc