This content has been marked as final. Show 2 replies
You can use the below command to check the validity of the backup
This command does not restore the database, but checks if the backups can be used to perform the restore.
RMAN>restore database validate;
Similarly, you have the "backup..validate" command which checks datafiles for physical and logical block corruption but here RMAN would not be producing any backup sets.
Refer this http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm in order to get a clear picture.
Handle: user8983130If you feel that your questions have been answered, then please consider closing them by providing appropriate points and marking them as answered.
Status Level: Newbie
Registered: Jan 12, 2010
Total Posts: 189
Total Questions: 77 (27 unresolved)
Besides the RESTORE DATABASE VALIDATE command, you must also run RESTORE ARCHIVELOG VALIDATE.
Hemant K Chitale