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

■ To perform a complete media recovery:

SQL> SET AUTORECOVERY ON;

SQL> RECOVER DATABASE;

■ To perform an incomplete media recovery, use one of the following:

SQL> RECOVER DATABASE UNTIL CANCEL;

SQL> RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’;

(You can confirm the time of error by checking the ../bdump/alert*.log file.)

SQL> RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’\

using backup controlfile;

SQL> RECOVER DATABASE UNTIL CHANGE scn;

■ To open the database after an incomplete media recovery, use the following:

SQL> ALTER DATABASE OPEN RESETLOGS;

RESETLOGS resets the log sequence. The RESETLOGS option is required after

an incomplete media recovery. After opening the database with the RESETLOGS

option, remove the Storage Checkpoint you just rolled back to as well as any

Storage Checkpoints that were taken before that one. These earlier Storage

Checkpoints can no longer be used for storage rollback. After removing these

Storage Checkpoints, be sure to create a new Storage Checkpoint.

Warning: Attempting to roll back to the same Storage Checkpoint more than once

can result in data corruption. After rolling back, be sure to delete the Storage

Checkpoint that you rolled back to and then create a new one.

See your Oracle documentation for complete information on recovery.

209Using Database Storage Checkpoints and Storage Rollback

Guidelines for Oracle recovery