Check Rman Backup/Validate

There’s More than One Way to Do it :

Check One :

To check Datavase Backup

RMAN > Restore Validate Database ;

Check Two : 

Check Spfile

RMAN > restore validate spfile to ‘c:\temp\spfile.ora’;

Check Three :

Test Control File

RMAN> restore validate controlfile to ‘c:\temp\control01.ctl’;

Check Four :

Test Archive log

RMAN> list backup of archivelog all;


RMAN> list backup of archivelog all completed after ‘sysdate -1’;


RMAN> restore validate archivelog from sequence XXX until sequence XXX; 

Thank you
Osama Mustafa