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

Comments

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET