VERITAS FlashSnap Point-In-Time-Copy Solutions Administrator's Guide

Chapter 6, Database Recovery

Rolling Back a Database

4. Use one of the following commands to perform an incomplete media recovery of the database:

◆ Recover the database until you stop the recovery:

recover database until cancel;

...

alter database [database] recover cancel;

◆ Recover the database to the point just before a specified system change number, scn:

recover database until change scn;

◆ Recover the database to the specified time:

recover database until time ’yyyy-mm-dd:hh:mm:ss’;

◆ Recover the database to the specified time using a backup control file:

recover database until time ’yyyy-mm-dd:hh:mm:ss’ using \

backup controlfile;

Note To find out when an error occurred, check the ../bdump/alert*.log file.

See the Oracle documentation for complete and detailed information on database recovery.

5. To open the database after an incomplete media recovery, use the following command:

alter database open resetlogs;

Note The resetlogs option is required after an incomplete media recovery to reset the log

sequence. Remember to perform a full database backup and create another Storage

Checkpoint after log reset.

6. Perform a full database backup, and use the VxDBA utility to remove any existing Storage

Checkpoints that were taken before the one to which you just rolled back the database. These

Storage Checkpoints can no longer be used for Storage Rollback. If required, use the VxDBA

utility to delete the old Storage Checkpoints and to create new ones.