我的Rman恢复日记（10g）全部测试过，写得比较简单，做过的看就明白

 

 

全恢复

connect target www/www@kong;
run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_CLIENT=mes-backup.SESC.COM,NSR_SERVER=sesc-41nrhhgty5)';
restore database;
restore archivelog;
release channel t1;
}

时间点恢复，注意时间格式

**********time recovery *****  resetlog at last****

run {
allocate channel r1 type 'SBT_TAPE';
allocate channel r2 type 'SBT_TAPE';
set until time "to_date('01/16/2008 11:13:16','mm/dd/yyyy,hh24:mi:ss')";
send 'env=(nsr_client=mes-backup.sesc.com,nsr_server=sesc-41nrhhgty5)';
restore database;
recover database;
sql 'alter database open resetlogs';
release channel r1;
release channel r2;
}

cancel 恢复
************until scn recovery ****resetlog at last****

run {
allocate channel r1 type 'SBT_TAPE';
allocate channel r2 type 'SBT_TAPE';
allocate channel r3 type 'SBT_TAPE';
send 'env=(nsr_client=mes-backup.sesc.com,nsr_server=sesc-41nrhhgty5)';
restore database;
recover database until scn 2506651;
sql 'alter database open resetlogs';
release channel r1;
release channel r2;
release channel r3;
}

非当前日志恢复

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
logfile if archived then

SQL>alter database clear logfile group 1;
if unarchived logfile must run;
SQL>alter database clear unarchived logfile group 1;

SQL>alter database open;
*************************************************************88

控制文件及redo全部丢失（可能部分数据丢失）

 

-----controlfile and redo all lost ------

change pfile , add the last sentence:
_allow_resetlogs_corruption=TRUE

then:
alter session set events '10015 trace name adjust_scn level 1';
startup spfile

  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12753752/viewspace-150418/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12753752/viewspace-150418/