79906

Performing User-Directed Recovery

Uscr-Dircctcd Rccovcry cnablcs you to use flashback features and perform restore opcrations and recovery proccdures. For cxamplc, you can do the following:

■Rcpair unwanted changcs to databasc objects with thc logical flashback features ■Rewind the entire databasc with Oracle Flashback Databasc ■Complctcly restore and recovcr thc database

■Perform point-in-time recovery of the databasc or selccted tablcspaccs ■Perform błock media recovery of data files that have corrupted blocks You 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.

This section contains a few typical recovery examples so that you can become familiar with the performing whole database or object-level recovery using RMAN. Use the RESTORE and RECOVER commands to perform whole database or object-level recovery.

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 ■Rcstoring and Recovcring thc Databasc