6 using the recovery manager rollback utility, Rmora_rollback usage, Rollback using a database read-only virtual copy – HP 3PAR Application Software Suite for Oracle Licenses User Manual
Page 100
6 Using the Recovery Manager Rollback Utility
Recovery Manager for Oracle provides a way to rollback a database to a point-in-time image by
promoting a read-only or read-write Virtual Copy back to the base (database) virtual volumes.
The base (database) virtual volume must not be exported to any host during the rollback process.
In other words, the database LUNs of the corresponding database virtual volumes must be removed
from the database server prior to the rollback process. Once the rollback process completes, the
database LUNs can be exported back to the database server.
NOTE:
When using rollback utility with Remote Copy configuration. The Virtual Copy will rollback
on the secondary HP 3PAR StoreServ Storage system. Refer to the HP 3PAR Remote Copy Software
User’s Guide to reverse the Remote Copy configuration. If a Virtual Copy is a standby database,
the base virtual volumes of the standby database (not the primary database) is rolled back.
rmora_rollback Usage
Refer to
for the syntax and available options for the
rmora_rollback
command.
Syntax: rmora_rollback -s <oracle_sid> -p <primary_host> -t <timestamp>
[-o data|arch] [-v] [-w] [-f]
The purpose of this procedure is to rollback the database base volumes to the point in time when
the Virtual Copy was taken.
Rollback Using a Database Read-Only Virtual Copy
1.
On the database server, shutdown the database. If the database is a Real Application Clusters
(RAC) database, all RAC instances must be shutdown.
2.
On the database server, unmount all database file systems if they are on file systems.
Example for systems with VxFS:
# umount /oradata
3.
On the database server, drop the database ASM disk groups if ASM is in use.
Example:
SQL>drop diskgroup <disk_group> including contents;
4.
On the database server, deport the database VxVM disk groups if Symantec VxVM is in use.
Example:
# vxdg deport <diskgroup>
5.
On the HP 3PAR StoreServ Storage system, remove the VLUNs for the database virtual volumes.
Example:
cli>removevlun Oracle_data1 101 pilot
6.
Keep the list of the VLUNs, which are removed by the command above. The database virtual
volumes need to be exported to the same VLUNs.
100 Using the Recovery Manager Rollback Utility