RMAN不完全恢復指令的常用樣式
1.基于時間的不完全恢復
---------------------------------------------
run
{
set until time "to_date('06/12/05 15:00:00','mm/dd/yy hh24:mi:si')";
restore database;
recover database;
alter database open resetlogs;
}

or

startup mount;
restore database until time "to_date('06/12/05 15:00:00','mm/dd/yy hh24:mi:si')";
recover database until time "to_date('06/12/05 15:00:00','mm/dd/yy hh24:mi:si')";
alter database open resetlogs;

2.基于SCN的不完全恢復
----------------------------------------------------
startup mount;
restore database until scn 100000;
recover database until scn 100000;
alter database open resetlogs;
說明：上面語句將還原數據庫到SCN 100000(不包含100000這個SCN)

3.基于日志序列的不完全恢復
----------------------------------------------------
startup mount;
restore database until sequence 100 thread 1;
recover database until sequence 100 thread 1;
alter database open resetlogs;
說明：上面語句將還原數據庫到線程1的日志序列為100的archvielog(不包含100這個archivelog)

ITPub博客

RMAN--不完全恢復指令的常用樣式

最新文章