oracle 各种恢复方式,oracle各种恢复场景列举及演示

RMAN不完全恢复

1、基本时间恢复

c:\set nls_date_format=yyyy-dd-mm hh24:mi:ss

c:\rman target  sys/oracle@test nocatalog

RMAN>run {

startup force mount;

set until time='2010-08-22 12:00:08';

restore database;

recover database;

sql 'alter database open resetlogs;

}

2、基于SCN恢复

RMAN>run {

startup force mount;

set until scn=123456;

restore database;

recover database;

sql 'alter database open resetlogs';

}

3、基于日志序列号恢复

RMAN>run {

startup force mount;

set until seqence=10;

restore database;

recover database;

sql 'alter database open resetlogs';

}

4、基于备份控制文件恢复

c:\set nls_date_format=yyyy-dd-mm hh24:mi:ss

c:\rman target  sys/oracle@test nocatalog

RMAN>startup force nomount;

RMAN>set dbid=1113606269;

RMAN>restore controlfile from autobackup maxseq 6;

RMAN>alter database mount;

RMAN>run {

set until time='2010-08-22 12:00:08';

restore database;

recover database;

sql 'alter database open resetlogs;

}