Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

Re-apply archive logs to the point before the table was deleted to recover the

database to 4:00 p.m. Use one of the following commands:

SQL> recover database until cancel

SQL> recover database until change

SQL> recover database until time

Open the database with the following command:

SQL> alter database open resetlogs

Delete the Storage Checkpoint you created at 11:00 a.m. and any other Storage

Checkpoints created before that time.

Create a new Storage Checkpoint.

Guidelines for Oracle recovery

For an optimal Oracle recovery, the following steps should be taken:

■ Back up all control files before Storage Rollback

■ Ensure that the control files are not rolled back

■ Ensure that all archived redo logs are available

■ Media recovery procedures

Back up all control files before Storage Rollback

This guideline is recommended in case the subsequent Oracle recovery is not

successful.

Oracle recommends that you keep at least two copies of the control files for each

Oracle database and that you store the copies on different disks. Control files

should also be backed up before and after making structural changes to databases.

Note: The dbed_ckptcreate command automatically saves control file and log

information when you create a Storage Checkpoint.

Ensure that the control files are not rolled back

A control file is a small binary file that describes the structure of the database

and must be available to mount, open, and maintain the database. The control file

207Using Database Storage Checkpoints and Storage Rollback

Guidelines for Oracle recovery