Performing User-Directed Recovery

Oracle Enterprise Manager Database Control (Database Control) User-Directed Recovery provides a Recovery wizard that enables you to use flashback features and perform restore operations and recovery procedures. For example, you can do the following:

• Repair unwanted changes to database objects with the logical flashback features

• Rewind the entire database with Oracle Flashback Database

• Completely restore and recover the database

• Perform point-in-time recovery of the database or selected tablespaces

• Perform block media recovery of data files that have corrupted blocks

Database Control can determine which parts of the database must be restored and recovered, including detecting situations such as corrupted database files before they affect database operations. Database Control guides you through the recovery, prompting you for any required information and performing the specified recovery actions.

This section contains a few typical recovery examples so that you can become familiar with the Perform Recovery page. You can use the Perform Recovery page to access other whole database or object-level recovery features of Database Control.

This section contains the following topics:

• Rewinding a Table Using Oracle Flashback Table

• Recovering a Dropped Table Using Oracle Flashback Drop

• Rewinding a Database Using Oracle Flashback Database

• Restoring and Recovering the Database