linux的NBU的異地恢復(fù)

《linux的NBU的異地恢復(fù)》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。

1、有一份linux的NBU的異地恢復(fù)的SOP參考看一下DBRMANRecoverFromTapeSOP一．????目的為規(guī)範(fàn)標(biāo)準(zhǔn)化C38使用RMAN從磁帶恢復(fù)數(shù)據(jù)庫(kù)，特製作此SOP二．????恢復(fù)前準(zhǔn)備1.????服務(wù)器準(zhǔn)備????磁盤空間考量：DB所需要空間數(shù)據(jù)文件166G+索引文件125G=291G????????OS安裝：安裝RedhatLinux4.7（參考Linux安裝SOP）????????Oracle安裝：安裝Oracle9207（參考Oracle在linux下安裝SOP）2.???

2、?恢復(fù)目錄準(zhǔn)備需使用oracle賬號(hào)在OS中創(chuàng)建C38恢復(fù)數(shù)據(jù)所需目錄（主要為控制文件和數(shù)據(jù)文件和日誌文件存放的路徑）mkdir–p??/oracle/app/oracle/admin/sfgd/bdumpmkdir–p??/oracle/app/oracle/admin/sfgd/cdumpmkdir–p??/oracle/app/oracle/admin/sfgd/udumpmkdir–p??/oracle/app/oracle/oradata/sfgd/mkdir–p??/sfisarch

3、/sfgd/mkdir–p??/sfisdata/sfgd/mkdir–p??/sfisdata/sfisredo1/mkdir–p??/sfisindex/sfisredo2/mkdir–p??/sfisindex/sfgd/mkdir–p??/oracle/sfisundo/sfgd/3.????恢復(fù)DB準(zhǔn)備：確認(rèn)DB的密碼文件，初始化參數(shù)文件已經(jīng)準(zhǔn)備4.????NBU客戶端安裝與檢查：安裝NBU6.5Client并測(cè)試備份恢復(fù)可用性(參考NBUClient安裝SOP)5.????修改NBU

4、參數(shù)，設(shè)定備份來(lái)源服務(wù)器~]#vi/usr/openv/netbackup/bp.conf修改CLIENT_NAME=DB????????????Server=cetnbu#vi/etc/hosts172.10.115.19??DB三．????全恢復(fù)步驟1.????登陸RMAN并連接需要恢復(fù)的目標(biāo)庫(kù)，如果所恢復(fù)的服務(wù)器上有多個(gè)DB恢復(fù)前請(qǐng)先執(zhí)行ORACLE_SID參數(shù)（exportORACLE_SID=sfgd）2.????控制文件恢復(fù)：????在citnbu上查找控制文件備份~]#bplist

5、-Cpc38-Scetnbu-l-t4-s09/05/2010-e09/08/201002:00:00–R/得到結(jié)果為：/pa51_cntrl_1297_1_729030600恢復(fù)控制文件，RMAN提示符下命令行????Logintorecover_machineuseoracle????exportORACLE_SID=sfgd????SQL>sqlplus/nolog????SQL>conn/assysdba????SQL>startupnomount;????rman????connect

6、target????run{??????allocatechannelc1type'sbt_tape';??????send'NB_ORA_SERV=cetnbu,NB_ORA_CLIENT=DB';??????restorecontrolfilefrom'/pa51_cntrl_1297_1_729030600';??????releasechannelc1;????}3.????數(shù)據(jù)文件恢復(fù)：RMAN提示符下命令行????恢復(fù)數(shù)據(jù)文件SQL>alterdatabasemount;RMAN>r

7、un{??????allocatechannelc1type'sbt_tape';??????allocatechannelc2type'sbt_tape';??????send'NB_ORA_SERV=cetnbu,NB_ORA_CLIENT=DB';??????restoredatabase;??????releasechannelc1;??????releasechannelc2;????}????恢復(fù)日志文件RMAN>run{??????allocatechannelc1type'sbt

8、_tape';??????allocatechannelc2type'sbt_tape';??????send'NB_ORA_SERV=cetnbu,NB_ORA_CLIENT=DB';??????restorearchivelogfromsequence14499;??????releasechannelc1;??????releasechannelc2;????}run{??????allocatechannelc1type'sbt_tape';??????allocatechannelc2