Wednesday, October 10, 2012

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;
 or
RMAN> list backup of archivelog all completed after 'sysdate -1';

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


Thank you
Osama Mustafa

No comments:

Post a Comment