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

rmora_rollback
SYNOPSIS
rmora_rollback -s <oracle_sid> -p <db_server> -t <timestamp> [-o
data|arch] [-v] [-w] [-f]
DESCRIPTION
The rmora_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
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; if they do, they will be rolled back along with the datafile and
archive log virtual volumes. To avoid possible data corruption for other applications caused
by rolled-back volumes, the volumes used by the database should not be shared with other
applications.
•
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 and virtual copy 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.
•
The specified virtual copy must have an Available status (not mounted).
Recovery Manager for Oracle saves an ASCII 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.
You must run this command as a super user or Oracle owner user from the backup server. To allow
the Oracle Database Administrator (Oracle owner) to run this command, an identical Oracle
Database Administrator user must exist on the backup server. In addition, permission on the Recovery
Manager for Oracle Installation and Repository directories must be changed appropriately.
OPTIONS
The following options are supported:
-s <oracle_sid>
The Oracle SID of the database instance. For Real Application Cluster (RAC) database, an Oracle
SID of any RAC instance can be specified.
-p <db_server>
The corresponding host name of the database server where the specified Oracle database instance
is running. The value of the database server name must match the output of the hostname
command.
80 Using the Recovery Manager Command Line Interface