RMAN各类文件恢复及恢复方式

1、恢复SPFILE通过RMAN连接到目标数据库startup nomountset dbid 1234567restore spfile to '/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora' from autobackup;shutdown immediate;startup;2、恢复控制文件startup nomountrestore controlfile from autobackup;   --from可以是具体的备份文件alter database mount;recover database;alter database open resetlogs;3、重建重做日志shutdown immediatestartup mountrecover database until cancelalter database open resetlogs4、恢复表空间 例如表空间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,97、基于时间的恢复 例如恢复到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 mountrecover database until cancel9、基于SCN的恢复 例如恢复到scn号为123456的点：startup mountrestore database until scn 123456recover database until scn 123456alter database open resetlogs10、基于日志序列的恢复startup mount;restore database until sequence 1000 thread 1;recover database until sequence 1000 thread 1;alter database open resetlogs;