Restoring and Recovering the Database

This section demonstrates how to restore and recover the entire database. This example assumes that you are restoring and recovering your database after the loss of one or more data files, but you still have a usable server parameter file and control file. You can also use Database Control to restore a lost server parameter file or control file.

To restore and recover the entire database:

1. Perform Step 1 through Step 7 from the procedure in "Rewinding a Database Using Oracle Flashback Database".

2. Do one of the following:

   • Select Recover to the current time to recover all transactions to your database up until now.

   • Select Recover to a prior point-in-time to recover transactions only up through some point in time in the past.

   For this example, select Recover to the current time, and then click Next.

   The Perform Whole Database Recovery: Rename page appears.

3. Select No to restore the files to their default locations, and then click Next.

   The Perform Whole Database Recovery: Review page appears.

4. Click Submit to start the restoration and recovery of the database.

   Note: In some repair scenarios, such as a complete restoration and recovery of your database, the database state is altered by steps you take while using the wizard. Database Control displays warnings each time a significant database change results from selecting Continue during the recovery process. Pay close attention to these warnings.

   When the recovery completes, the Perform Recovery: Result page appears.

5. Click Open Database and then OK.