Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBED_CKPTROLLBACK (1) |
User Commands |
[ -T TABLESPACE | -F DATAFILES | -f DATAFILE_LIST ] [ -b BUFF_SIZE ] [ -t THREADS ] [ -i ] [ -h ]
rpm -qa | grep VRTSdbed
Database rollback requires that the database be shut down before Storage Rollback begins. The dbed_ckptrollback command will not begin if the Oracle database is up.
After Storage Rollback is complete, the Oracle database must be recovered using Oracle recovery.
Only database rollback is allowed for instant Storage Checkpoints. All the datafiles along with control files and online redo log files are rolled back. It is not possible to roll back tablespaces and datafiles to an instant Storage Checkpoint. After database rollback is complete, you must recover the Oracle database instance. Rolling the database forward is not supported; that is, you cannot apply archived redo logs.
The above commands run without interaction from the user. However, if you want to be prompted before critical actions are taken, use the -i option. If you are using this command for the first time, it is recommended that you use the -i option.
Database changes that have occurred since a Storage Checkpoint was created may make it impossible to run Storage Rollback successfully. Running Storage Rollback may be impossible if the control files for the database have recorded the addition or removal of datafiles. In order to provide recovery options for the database administrator, a backup copy of the control file for the database is saved in the SFDB repository just after a Storage Checkpoint is created. This file may be used by the database administrator to assist with database recovery if necessary. If possible, both an ASCII and a binary version of the control file will be left in the SFDB repository. The binary version will be compressed to conserve space. Recovery using alternate control files should be approached with care by experienced database administrators.
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/9i \.br -c Checkpoint_903937870
To roll back a tablespace of an offline Oracle database to a Storage Checkpoint:
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/9i \.br -T DATA01 -c Checkpoint_903937870
To roll back datafiles of an offline Oracle database to a Storage Checkpoint:
$ /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/9i \.br -F /oradata1/data01.dbf,/oradata2/index01.dbf \.br -c Checkpoint_903937870
Veritas Storage Foundation for Oracle Administrator's Guide Veritas Storage Foundation for Oracle RAC Installation and Configuration Guide ~
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.