您好,登錄后才能下訂單哦!
1.創(chuàng)建數(shù)據(jù)庫(kù)目錄
2.從原來(lái)主機(jī)復(fù)制pfile文件,并更改oracle_sid
vi .bash_profile source .bash_profile
3.啟動(dòng)數(shù)據(jù)到nomount狀態(tài)
$ sqlplus / as sysdba SQL> startup nomount pfile='pfile文件絕對(duì)位置'; ORACLE instance started. SQL> exit
4.查看備份controlfile列表
$ /usr/openv/netbackup/bin/bplist -S 備份服務(wù)器 -C 備份客戶(hù)端 -t 4 -s 09/10/2000 -e 09/11/2000 -R -l / 該命令中-s參數(shù)后面接開(kāi)始日期,-e參數(shù)接結(jié)束日期,表示獲取該時(shí)間段內(nèi)的控制文件列表
5.恢復(fù)controlfile文件
$ rman target / RMAN> run{ allocate channel a0 type 'sbt_tape'; allocate channel a1 type 'sbt_tape'; send 'nb_ora_serv=備份服務(wù)器 , nb_ora_client=備份客戶(hù)端'; restore controlfile from ' cntrl_xxx_x_xxxxxxxxx'; #控制文件名由上一步驟中得到 release channel a0; release channel a1; } RMAN> exit
注意:在這里報(bào)錯(cuò)
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of allocate command on a0 channel at 06/14/2011 11:45:03 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library race文件發(fā)現(xiàn)沒(méi)有l(wèi)ibobk.so所致,拷貝libobk.so至oracle安裝目錄下的lib/下面 cp /usr/openv/netbackup/bin/libobk.so64.1 /opt/oracle/product/9.2/lib/libobk.so 或者做一個(gè)軟鏈接 ln -s /usr/openv/netbackup/bin/libobk.so64 /opt/oracle/product/9.2/lib/libobk.so
6.啟動(dòng)數(shù)據(jù)庫(kù)到mount狀態(tài)
$ sqlplus / as sysdba SQL> alter database mount; Database altered. SQL> exit
7.恢復(fù)數(shù)據(jù)庫(kù)
$ rman target / run{ allocate channel a0 type 'sbt_tape'; allocate channel a1 type 'sbt_tape'; allocate channel a2 type 'sbt_tape'; allocate channel a3 type 'sbt_tape'; send 'nb_ora_serv=備份服務(wù)器 , nb_ora_client=備份客戶(hù)端'; restore database; recover database; release channel a0; release channel a1; release channel a2; release channel a3; }
8.Reset log 打開(kāi)數(shù)據(jù)庫(kù)
$ sqlplus / as sysdba SQL> alter database open resetlogs;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。