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;
RMAN各类文件恢复及恢复方式
于 2024-05-20 15:46:28 首次发布