RE: How to validate RMAN backup

Whilst restore validate database is a good option, perhaps bettered by duplicating the database somewhere else, perhaps another approach is to run a script after the backup has completed to restore the controlfile to /tmp.  

I appreciate that this does not try reading every datafile of the tape but it does actually read a file off the tape that has just been written to and recover it physically to disk.  

Just a thought  

John    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yadavalli Aditya Sent: 25 May 2006 02:06
To: oracle-l_at_freelists.org
Subject: How to validate RMAN backup  

Hi,  

We use RMAN to take backup of the database.

Once we had problem to restore the backup, so we want to validate backups once they are taken.  

I came to know about following options.  

1. RESTORE VALIDATE DATABASE;
2. VALIDATE BACKUPSET <backup set number>

Which is the best way..? Is there any other option..?  

Please Let me know.I will be happy to hear from you.  

Thanks,

Prasanna.      

--
http://www.freelists.org/webpage/oracle-l