Recovering an Oracle 10g database

Learning objective

After completing this topic, you should be able to recover a database.

Exercise overview

In this exercise, you're required to recover datafiles using Enterprise Manager.

This involves the following tasks:

• recovering a file in ARCHIVELOG mode
• recovering a file in NOARCHIVELOG mode
• preparing databases for Flashback
• using Flashback

Task 1: Recovering a file in ARCHIVELOG mode

In this case, the database is in ARCHIVELOG mode. You discover that a datafile is missing and want to retrieve only that file.

Recover the sysaux01 file to the most recent time possible.

Steps list

Instructions
1. Select Maintenance
2. Select Perform Recovery
3. Click Next
4. Click Add
5. Select the sysaux01 file
6. Click Select
7. Click Next
8. Click Next
9. Click Submit

Task 2: Recovering a file in NOARCHIVELOG mode

In this case, the database is in NOARCHIVELOG mode.

Initiate the recovery of the inventory file to the most recent time possible.

Steps list

Instructions
1. Select Maintenance
2. Select Perform Recovery
3. Click Next

Task 3: Preparing databases for Flashback

You also want to leverage the advances in the Flashback technology.

You are preparing a table for trainee sales-staff. They will be working in the SCOTT schema. You want to set up the SALGRADE table for their use and be able to flash it back if you need to.

Steps list

Instructions
1. Click Administration
2. Click Tables
3. Type Scott in the Schema text box and click Go
4. Click the SALGRADE hyperlink.
5. Click Edit
6. Click Options
7. Select Yes from the Enable Row Movement dropdown
8. Click Apply

Task 4: Using Flashback

The data in the SALGRADE table has become corrupted. You want to use Flashback technology to resolve this problem.

Flashback the SALGRADE table to Feb 16 2007, 2:20 PM.

Steps list

Instructions
1. Click Main t enance
2. Click Pe r form Recovery
3. Click Perform Object Level Recovery button
4. Select the Flashback to a timestamp radio button
5. Click Next
6. Type Scott.Salgrade in the Tables To Flashback text box, press Enter, and click Next
7. Click Submit