Oracle Database 2 Day DBA 11g Release- P10:Oracle Database 2 Day DBA is a database administration quick start guide that teaches you how to perform day-to-day database administrative tasks. The goal of this guide is to help you understand the concepts behind Oracle Database. It teaches you how to perform all common administrative tasks needed to keep the database operational, including how to perform basic troubleshooting and performance monitoring activities. | Displaying Backup Reports Validating Backups for Restore Operations You can test whether or not a sufficient set of backups exists that can be used to restore the specified database files. After you specify which tablespaces to restore and possibly a time as of which to restore them RMAN selects a set of backups that contain the needed data. RMAN reads the selected backups in their entirety to confirm that they are not corrupt but does not produce output files. Validating the restoration of files tests whether or not the file can be restored given the available backups but it does not test whether or not all backups of the specified object are valid. To verify whether or not specified database files can be restored 1. On the Database Home page click Availability to display the Availability subpage. 2. In the Availability page click Perform Recovery. The Perform Recovery page appears. 3. In the User-Directed Recovery section select Datafiles or Tablespaces from the Recovery Scope list depending on what you want to validate. 4. For the Operation Type select Restore Datafiles or Restore Tablespaces and then click Recover. The Perform Object Level Recovery page appears. 5. Click Add to add tablespaces or datafiles for the validate operation. After making your selections click Next. The Perform Object Level Recovery Restore page appears. 6. In the Backup Selection section specify which backups should be restored. 7. In the Backup Validation section select Validate the specified backup without restoring the datafiles. Then click Next. The Perform Object Level Recovery Review page appears. 8. Click Submit Job to run the validation. The Perform Recovery Result page appears. See Also Oracle Database Backup and Recovery User s Guide to learn how to use the RESTORE . VALIDATE command Displaying Backup Reports Backup reports contain summary and detailed information about past backup jobs run by RMAN including both backups run through Oracle Enterprise Manager Database Control
