This content has been marked as final. Show 3 replies
If you know the primary key of the backup ( needs a catalog ) then you can do something like :
In Oracle 11 you can use the validate command to validate all the backup pieces in FRA :
RMAN>validate backupset 73;
Given the information you have provided I believe you need to catalog first.
RMAN>validate recovery area;
You can use the BACKUP VALIDATE command to do the following:
Check datafiles for physical and logical block corruption
Confirm that all database files exist and are in the correct locations
When you run BACKUP VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. RMAN does not, however, actually produce any backup sets or image copies.
To validate files with the BACKUP VALIDATE command:
Start RMAN and connect to a target database and recovery catalog (if used).
Run the BACKUP VALIDATE command.
For example, you can validate that all database files and archived logs can be backed up by running a command as shown in the following example. This command checks for physical corruptions only.
To check for logical corruptions in addition to physical corruptions, run the following variation of the preceding command:
Hope this will help you