Veritas FlashSnap Point-In-Time Copy Solutions 5.0 AdministratorÆs Guide, HP-UX 11i v3, First Edition, May 2008

59Database recovery
Rolling back a database
3 Start up, but do not open, the database instance by selecting 1 Database
Administration > Startup Database Instance in the VxDBA utility.
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.