HP StoreServ Application Suite for Oracle Media manual Vcdbarollback

Recovery Manager for Oracle User’s Guide

COMMAND

vcdba_rollback

SYNOPSIS

vcdba_rollback -s <oracle_sid> -p <primary_host> -t <timestamp> [-o dataarch] [-v] [-w] [-f]

DESCRIPTION

Rolls back database volumes from an online virtual copy.

The vcdba_rollback command promotes a virtual copy’s volumes back to their base virtual volumes. The base virtual volumes used by the database are rolled back to the virtual copy’s volumes. Once the promote (rollback) process completes successfully, the base virtual volumes will be exactly the same as the virtual copy’s volumes. If the base volume size has been changed since the virtual copy was taken, the rollback process will not affect the new size.

When rolling back from an online virtual copy, both datafile and archive log virtual volumes are rolled back by default. Use the -ooption to roll back only datafile virtual volumes or only archive log virtual volumes.

When rolling back from an offline 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 file 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.

■The specified virtual copy must have an Available (not mounted) status.

■If the base virtual volumes are involved in a Remote Copy group you must use -fto promote the virtual copies back to their base volumes.

Command

6.35