【正文】 啟動RMAN恢復控制文件 rman target / RMAN run2 {3 allocate channel ch00 type 39。sbt_tape39。4 send 39。NB_ORA_CLIENT=I2000_OM,NB_ORA_SERV=NBUServer39。5 restore controlfile from 39。trl_73_1_71519731939。6 release channel ch00。7 } l NB_ORA_CLIENT指示需要恢復的數(shù)據(jù)庫主機備份用主機名l NB_ORA_SERV指示NBU服務器的主機名l trl_73_1_715197319指示需要恢復的控制文件，該文件名需要提前從NBU管理控制臺或者命令行查找，具體參見本節(jié)步驟4.恢復過程顯示如下：using target database control file instead of recovery catalogallocated channel: ch00channel ch00: SID=1088 device type=SBT_TAPEchannel ch00: Veritas NetBackup for Oracle Release (2009050106)sent mand to channel: ch00Starting restore at 01APR10channel ch00: restoring control file恢復完成后退出RMAN rman exit步驟 8 檢查恢復的控制文件 cd /opt/oracle/oradb/oradata/inomc ls顯示如下：步驟 9 檢查NBU管理控制臺的控制文件恢復任務執(zhí)行狀態(tài). 1）顯示成功2）雙機打開執(zhí)行的任務，可以看到恢復的文件清單。結束2. 恢復數(shù)據(jù)庫步驟 1 使用Oracle管理員登錄需要恢復的數(shù)據(jù)庫服務器步驟 2 啟動數(shù)據(jù)庫至mount狀態(tài) sqlplus / as sysdba。SQL alter database mount。SQL exit步驟 3 登錄RMAN rman target /顯示如下:Recovery Manager: Release Production on Sat Jun 30 08:50:30 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: INOMC (DBID=929669469, not open)步驟 4 執(zhí)行如下RMAN腳本恢復數(shù)據(jù)文件RUN{ ALLOCATE CHANNEL ch00 TYPE 39。sbt_tape39。ALLOCATE CHANNEL ch01 TYPE 39。sbt_tape39。RESTORE DATABASE。RECOVER DATABASE。RELEASE CHANNEL ch00。RELEASE CHANNEL ch01。}當顯示如下信息時，系統(tǒng)開始自動恢復oracle數(shù)據(jù)庫數(shù)據(jù)文件，同時NBU服務器也會自動執(zhí)行對應的恢復任務。2 3 4 5 6 7 8using target database control file instead of recovery catalogallocated channel: ch00channel ch00: SID=1088 device type=SBT_TAPEchannel ch00: Veritas NetBackup for Oracle Release (2007072400)allocated channel: ch01channel ch01: SID=1089 device type=SBT_TAPEchannel ch01: Veritas NetBackup for Oracle Release (2007072400)Starting restore at 30JUN07Starting implicit crosscheck backup at 30JUN07Finished implicit crosscheck backup at 30JUN07Starting implicit crosscheck copy at 30JUN07Finished implicit crosscheck copy at 30JUN07searching for all files in the recovery areacataloging files...cataloging doneList of Cataloged Files=======================File Name: /opt/oracle/oradb/flash_recovery_area/INOMC/archivelog/2007_06_29/……File Name: /opt/oracle/oradb/flash_recovery_area/INOMC/archivelog/2007_06_29/channel ch00: starting datafile backup set restorechannel ch00: specifying datafile(s) to restore from backup setchannel ch00: restoring datafile 00002 to /opt/oracle/oradb/oradata/inomc/channel ch00: restoring datafile 00004 to /opt/oracle/oradb/oradata/inomc/channel ch00: restoring datafile 00010 to /opt/oracle/oradb/data/channel ch00: restoring datafile 00016 to /opt/oracle/oradb/home/dbs/c:channel ch00: reading from backup piece bk_20_1_626521335channel ch01: starting datafile backup set restorechannel ch01: specifying datafile(s) to restore from backup setchannel ch01: restoring datafile 00006 to /opt/oracle/oradb/data/channel ch01: reading from backup piece bk_21_1_626521335channel ch01: piece handle=bk_21_1_626521335 tag=HOT_DB_BK_LEVEL0channel ch01: restored backup piece 1channel ch01: restore plete, elapsed time: 00:01:15channel ch01: starting datafile backup set restorechannel ch01: specifying datafile(s) to restore from backup setchannel ch01: restoring datafile 00007 to /opt/oracle/oradb/data/channel ch01: reading from backup piece bk_22_1_626521421channel ch00: piece handle=bk_20_1_626521335 tag=HOT_DB_BK_LEVEL0channel ch00: restored backup piece 1channel ch00: restore plete, elapsed time: 00:02:00channel ch00: starting datafile backup set restorechannel ch00: specifying datafile(s) to restore from backup setchannel ch00: restoring datafile 00001 to /opt/oracle/oradb/oradata/inomc/channel ch00: restoring datafile 00003 to /opt/oracle/oradb/oradata/inomc/channel ch00: restoring datafile 00005 to /opt/oracle/oradb/data/channel ch00: restoring datafile 00012 to /opt/oracle/oradb/data/channel ch00: reading from backup piece bk_23_1_626521496channel ch01: piece handle=bk_22_1_626521421 tag=HOT_DB_BK_LEVEL0channel ch01: restored backup piece 1channel ch01: restore plete, elapsed time: 00:01:41channel ch00: piece handle=bk_23_1_626521496 tag=HOT_DB_BK_LEVEL0channel ch00: restored backup piece 1channel ch00: restore plete, elapsed time: 00:01:35Finished restore at 30JUN07Starting recover at 30JUN07starting media recoveryarchived log for thread 1 with sequence 24 is already on disk as file /opt/oracle/oradb/flash_recovery_area/INOMC/archivelog/2007_06_29/media recovery plete, elapsed time: 00:00:02Finished recover at 30JUN07released channel: ch00released channel: ch01步驟 5 退出 RMAN. RMAN exit步驟 6 檢查恢復的數(shù)據(jù)文件 cd /opt/oracle/oradb/oradata/inomc ls顯示如下： cd /opt/oracle/oradb/data ls顯示如下：步驟 7 重置日志. sqlplus/ as sysdba 。SQL alter database open resetlogs。SQL exit l resetlogs用于重置日志序列號，清空或重建REDO。l 當執(zhí)行控制文件恢復或數(shù)據(jù)庫不完全恢復時，需要先執(zhí)行resetlogs才能打開數(shù)據(jù)庫。步驟 8 檢查日志 cd /opt/oracle/oradb/oradata/inomc ls顯示如下：步驟 9 在NBU管理控制臺檢查恢復任務執(zhí)行狀態(tài)。 1）在Acivity Monitor界面，查看恢復任務執(zhí)行狀態(tài)。2）通過雙擊恢復任務，可以查看具體的執(zhí)行記錄。結束 Oracle備份恢復聯(lián)調（單機）單機備份恢復聯(lián)調可參考冷雙機的操作，唯一的區(qū)別是在單機備份中，不需要業(yè)務浮動IP檢測腳本，備份策略Backup Selections中直接配置RMAN腳本即可。 Oracle備份恢復聯(lián)調（RAC）RAC環(huán)境中，如果使用的ASM或文件系統(tǒng)共享存儲，需要把歸檔日志目錄設置在共享存儲上，此時數(shù)據(jù)文件、控制文件以及歸檔日志文件都位于共享存儲，通過某個Oracle instance 即可完成對整個RAC環(huán)境的數(shù)據(jù)庫數(shù)據(jù)文件、控制文件備份，備份過程和單機備份一般無二。從冗余考慮，RAC環(huán)境的每臺服務器，一般都需要安裝NBU Agent，但在備份策略中，只需要添加其中一臺服務器進行備份即可，避免對數(shù)據(jù)庫進行重復備份。當選定備份的服務器異常時，如果需要繼續(xù)備份，則可以修改備份策略中的客戶端；如果需要恢復，可使用已備份的數(shù)據(jù)通過異機恢復模式從其它正常的RAC服務器恢復。第3章 附錄 附錄一 Oracle數(shù)據(jù)庫備份腳本樣例如下四個腳本樣例僅供參考，實際項目中RMAN部分腳本，建議從NBU自帶腳本模板中按照備份操作中的修改指導進行修改。1) ，數(shù)據(jù)庫備份腳本，用于備份數(shù)據(jù)庫的全部數(shù)據(jù)文件、歸檔日志文件和控制文件（含spfile）,備份成功后歸檔日志不刪除。2) hot_ archive ，數(shù)據(jù)庫歸檔日志備份腳本，用于備份歸檔日志文件和控制文件（含spfile），每次做全備，備份成功后刪除已備份的歸檔日志。3) 4) archive 20050916華為機密，未經(jīng)許可不得擴散第47頁,