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

The Database Rollback Utility
HP 3PAR Recovery Manager Software for Oracle’s database rollback utility (rmora_rollback)
promotes a virtual copy's volumes back to its base virtual volumes. In other words, the base virtual
volumes used by the database are rolled back to the virtual copy volumes. Once the rollback
process completes successfully, the base virtual volumes are exactly the same as the virtual copy
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 -o option to rollback 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 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 (datafile and/or archive log) virtual volumes must be temporarily removed from the
original database server.
NOTE: For detailed instructions and examples for using the rollback utility, see “Using the Recovery
Manager Rollback Utility” (page 99) .
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.
Recovery Manager for Oracle and Third-Party Backup Tools
HP 3PAR Recovery Manager Software for Oracle integrates HP 3PAR Virtual Copy Software with
Symantec NetBackup (NBU) and/or Oracle RMAN to perform off-host backup. Off-host backups
can dramatically reduce performance impact on the database server and minimize database down
time or database in backup mode during backup.
Recovery Manager for Oracle creates a virtual copy (snapshot) of the database, mounts it to the
backup server, then performs backup of the virtual copy.
Recovery Manager for Oracle supports online (hot), offline (cold), datafile, or archive log backups.
•
Online backup - A database backup while it is OPEN.
•
Offline backup - A database backup while it is CLOSED.
•
Datafile backup - A backup of datafiles only.
•
Archive log backup - A backup of archive logs only.
Recovery Manager for Oracle can be configured to perform either NBU (user-managed) backup
or Oracle RMAN backup.
The Database Backup Utility
HP 3PAR Recovery Manager Software for Oracle’s database backup utility supports full and/or
incremental backup of an Oracle database or archive log destination. Full backup of an Oracle
database or archive log destination are always supported regardless of backup method (NBU
Recovery Manager for Oracle and Third-Party Backup Tools 17