19 Advanced User-Managed Recovery Scenarios

This chapter describes several common media failure scenarios. It shows how to recover from each failure when using a user-managed backup and recovery strategy, that is, a strategy that does not depend upon Recovery Manager. This chapter includes the following topics:

• Recovering After the Loss of Datafiles: Scenarios

• Recovering Through an Added Datafile with a Backup Control File: Scenario

• Re-Creating Datafiles When Backups Are Unavailable: Scenario

• Recovering Through RESETLOGS with Created Control File: Scenario

• Recovering NOLOGGING Tables and Indexes: Scenario

• Recovering Read-Only Tablespaces with a Backup Control File: Scenario

• Media Recovery of Transportable Tablespaces: Scenario

• Recovering After the Loss of Online Redo Log Files: Scenarios

• Recovering After the Loss of Archived Redo Log Files: Scenario

• Recovering from a Dropped Table: Scenario

• Performing Media Recovery in a Distributed Environment: Scenario

• Dropping a Database with SQL*Plus

This chapter was last modified June 17, 2005 6:30 pm