• Check các datafile cần recover:
SELECT FILE#, CHANGE# FROM V$RECOVER_FILE;
select * from v$datafile where status='RECOVER'; -- chú ý trường STATUS nếu RECOVER thì phải recover file 187
select * from dba_data_files where file_id=187; -- chú ý trường ONLINE_STATUS nếu RECOVER thì phải recover file 187
• Restore và recover toàn bộ database
RMAN> STARTUP FORCE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
• Restore và recover 1 tablespace
RMAN> SQL 'ALTER TABLESPACE users OFFLINE';
RMAN> RESTORE TABLESPACE users;
RMAN> RECOVER TABLESPACE users;
RMAN> SQL 'ALTER TABLESPACE users ONLINE';
• Restore and recover a datafile
RMAN> SQL 'ALTER DATABASE DATAFILE 64 OFFLINE';
RMAN> RESTORE DATAFILE 64; --RECOVER DATAFILE '/oracle/dbs/tbs_10.dbf';
RMAN> RECOVER DATAFILE 64;
RMAN> SQL 'ALTER DATABASE DATAFILE 64 ONLINE';
• Performing Recovery không đầy đủ
RMAN> RECOVER DATABASE UNTIL CHANGE 10034; -- SCN 10034
RMAN> ALTER DATABASE OPEN RESETLOGS;
• Recovering Block
RMAN> BLOCKRECOVER CORRUPTION LIST;
RMAN> BLOCKRECOVER DATAFILE 7 BLOCK 233, 235 DATAFILE 4 BLOCK 101;