oracle恢复总结

块恢复:　
RMAN> blockrecover datafile 2 block 2,3,4;

数据文件恢复:

SQL> alter database datafile 2 offline;
RMAN>restore datafile 2;
RMAN>recover datafile 2;
RMAN>sql "alter database datafile 2 online";

表空间的恢复:

RMAN>restore tablespace users;
RMAN>recover tablespace users;
RMAN>sql "alter tablespace users online";

undo和system表空间的恢复:(此时oracle肯定已关闭)
SQL>startup mount;
RMAN>restore tablespace system;
RMAN>recover tablespace system;
SQL>alter database open;

控制文件的恢复:
RMAN>set DBID=1195474494
RMAN>restore controlfile from autobackup;
RMAN>alter database mount;
RMAN>recover database;
RMAN>alter database open resetlogs;

日志文件的恢复:(非当前日志组,直接删掉重建即可)
SQL>recover database until cancel;
SQL>alter database open resetlogs;