Performing User-Directed Recovery

User-Directed Recovery 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

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 Oracle Recovery Manager (RMAN). Use the RESTORE and RECOVER commands to perform whole database or object-level recovery.

This section contains the following topics: