HP 3PAR Application Software Suite for Oracle - Manual (Page 156)

6.42
Recovery Manager 3.0.3/3.0.4 for Oracle User’s Guide
COMMAND
vcdba_rollback
SYNOPSIS
vcdba_rollback -s <oracle_sid> -p <db_host> -t <timestamp>
[-o data|arch] [-v] [-w] [-f]
DESCRIPTION
Rolls back database volumes from an online, offline, datafile or archive log destination only
virtual copy.
The vcdba_rollback command promotes a database virtual copy's volumes back to their
base virtual volumes. Once promoted, the database virtual volumes will be exactly the same as
the the database virtual copy's volumes. If the virtual copy is the snapshot image of a standby
database, it can only be used to promote back to the standby database virtual volumes.
When rolling back from an online virtual copy, both datafile and archive log virtual volumes
are rolled back by default. Use the -o option to roll back only datafile virtual volumes or only
archive log virtual volumes.
When rolling back from an offline or datafile virtual copy, only datafile virtual volumes are
rolled back.
When rolling back from an archive log virtual copy, only archive log virtual volumes are rolled
back.
The following restrictions apply when rolling back a virtual copy:
■ The online redo logs and control files should not reside on the same virtual volumes used
by the datafiles and archive logs. Otherwise, they will be rolled back along with the
datafile and archive log virtual volumes.
■ The database instance must be CLOSED for this operation. If the database is an RAC
database, all RAC instances must be CLOSED.
■ The base (data file and/or archive log) virtual volumes must not be exported.
■ If the base virtual volumes are involved in a Remote Copy group you must use -f to
promote the virtual copies back to their base volumes.
Recovery Manager saves an ACII control file and a binary control file for each created virtual
copy in its repository. After a rollback, you may need to restore the control file in order to
perform database recovery.