建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
在異機(jī)實(shí)現(xiàn)Oracle不完全恢復(fù)
1、將數(shù)據(jù)庫(kù)完全備份集和歸檔日志備份集傳到執(zhí)行恢復(fù)的 Oracle 服務(wù)器
# 傳到中轉(zhuǎn)服務(wù)器
創(chuàng)新互聯(lián)公司專業(yè)為企業(yè)提供撫順網(wǎng)站建設(shè)、撫順做網(wǎng)站、撫順網(wǎng)站設(shè)計(jì)、撫順網(wǎng)站制作等企業(yè)網(wǎng)站建設(shè)、網(wǎng)頁(yè)設(shè)計(jì)與制作、撫順企業(yè)網(wǎng)站模板建站服務(wù)，十多年撫順做網(wǎng)站經(jīng)驗(yàn)，不只是建網(wǎng)站，更提供有價(jià)值的思路和整體網(wǎng)絡(luò)服務(wù)。
scp -P 2222 database.20181030.5* 218.17.56.50:/tmp/backup
scp -P 2222 archivelog.20181029.5ltgrqir_1_1.rman 218.17.56.50:/tmp/backup
scp -P 2222 archivelog.20181030.* 218.17.56.50:/tmp/backup# 傳到 Oracle 服務(wù)器
scp -r backup/ [email protected]:~/2、注冊(cè)備份集到控制文件
catalog backuppiece '/home/oracle/backup/archivelog.20181029.5ltgrqir_1_1.rman';
catalog backuppiece '/home/oracle/backup/archivelog.20181030.5stguer0_1_1.rman';
catalog backuppiece '/home/oracle/backup/archivelog.20181030.5ttguer0_1_1.rman';
catalog backuppiece '/home/oracle/backup/archivelog.20181030.5utguesp_1_1.rman';
catalog backuppiece '/home/oracle/backup/archivelog.20181030.5vtguesr_1_1.rman';
catalog backuppiece '/home/oracle/backup/archivelog.20181030.60tgueuk_1_1.rman';
catalog backuppiece '/home/oracle/backup/database.20181030.5otgue2k_1_1.rman';
catalog backuppiece '/home/oracle/backup/database.20181030.5ptgue2k_1_1.rman';
catalog backuppiece '/home/oracle/backup/database.20181030.5qtgueid_1_1.rman';3、處理 incarnation (有需要?jiǎng)t執(zhí)行)
shutdown immediate;
startup mount;
list incarnation;
reset database to incarnation 1;4、執(zhí)行不完全恢復(fù)
# rman 腳本
cat restore.rman
run {
shutdown immediate;
startup mount;
set until time = "to_date('30-10-18 12:00:00','dd-mm-yy hh34:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}
# 恢復(fù)
rman target / @restore.rman注意：如果恢復(fù)報(bào)錯(cuò)，檢查備份集 Status 是否為 AVAILABLE。如果備份集有效，仍然無(wú)法創(chuàng)建數(shù)據(jù)文件，則從裝系統(tǒng)和數(shù)據(jù)庫(kù)可解決此問(wèn)題。
當(dāng)前文章：在異機(jī)實(shí)現(xiàn)Oracle不完全恢復(fù)
文章路徑：http://fisionsoft.com.cn/article/ipsohh.html
