1、恢复SPFILE

通过RMAN连接到目标数据库

startup nomount

set dbid 1234567

restore spfile to '/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora' from autobackup;

shutdown immediate;

startup;

2、恢复控制文件

startup nomount

restore controlfile from autobackup;   --from可以是具体的备份文件

alter database mount;

recover database;

alter database open resetlogs;

3、重建重做日志

shutdown immediate

startup mount

recover database until cancel

alter database open resetlogs

4、恢复表空间

例如表空间users被意外删除，恢复过程：

sql  'alter tablespace users offline';

restore tablespace users;

recover tablespace users;

sql 'alter tablesapce users online';

5、恢复数据文件

例如5号数据文件丢失，恢复过程：

sql  'alter database datafile 5 offline';

restore datafile 5;

recover datafile 5;

sql 'alter database datafile 5 online';

6、恢复坏块

例如恢复5号数据文件的8号,9号块：

blockrecover datafile 5 block 8,9

7、基于时间的恢复

例如恢复到2024-5-10 12:00:00这个时间点：

run

{

set until time 'to_date('2024-5-10 12:00:00','yyyy-mm-dd hh24:mi:ss' );

restore database;

recover database;

alter database open resetlogs;

    }

8、基于取消的恢复

startup mount

recover database until cancel

9、基于SCN的恢复

例如恢复到scn号为123456的点：

startup mount

restore database until scn 123456

recover database until scn 123456

alter database open resetlogs

10、基于日志序列的恢复

startup mount;

restore database until sequence 1000 thread 1;

recover database until sequence 1000 thread 1;

alter database open resetlogs;