Tuesday, August 11, 2009

Restore validate using RMAN

Use RESTORE VALIDATE commands to validate RMAN backups to be sure they can be used for a restore.

Use below command to test most recent RMAN backup:
RMAN> restore validate database;

Use below command to test the most recent RMAN spfile backup:
RMAN> restore validate spfile to '/backup/testdb/spfile.ora';

Use below command to test the most recent RMAN controlfile backup:
RMAN> restore validate controlfile to '/backup/testdb/control01.ctl';

Use below command to test the most recent RMAN archivelog file(s) backup:
Find which archivelog sequences are in the last backup:
RMAN> list backup of archivelog all;
or
RMAN> list backup of archivelog all completed after 'sysdate -1';

RMAN> restore validate archivelog from sequence xxxxx until sequence XXXXX;
Where xxxxx is the sequence number.

Click here to lean How to validate RMAN backup.

Click here for Block recovery using RMAN.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/

2 comments: