beautypg.com

Rollback using a database read-write virtual copy – HP 3PAR Application Software Suite for Oracle User Manual

Page 119

background image

9.

From the database server, activate logical volumes and import/start volume groups.

Example:

- For Symantec VxVM volume groups:
# vxdg import

# vxvol -g startall
Example:
# vxdg import myvxvmdb_datadg

# vxvol -g myvxvmdb_datadg startall
- For HP-UX logical volume groups, using the tmpfile generated during vgexport.
# vgimport -m pvname1, pvname2, ...

# vgchange -a y
Example:
# vgimport -m /tmp/lvmtest_datadg.map lvmtest_datadg /dev/disk/disk68

/dev/disk/disk69

# vgchange -a y lvmtest_datadg
- For Linux logical volumes:
# vgscan

# vgimport rh6lvm-datavg

# lvchange -ay /dev/rh6lvm-datavg/lvol0

# lvchange -ay /dev/rh6lvm-datavg/lvol1

10. From the database server, perform file system check, and then mount the database file systems

if database files are on file systems.

Example:

# fsck -y /dev/vxdsk/datadg/datavol

# mount -F vxfs /dev/vx/dsk/datadg/datavol/oradata

11. From the database server, mount database ASM disk groups if ASM is in use.

Example:

SQL>alter diskgroup mount

12. From the database server, follow Oracle documentation to perform media recovery to recover

the database.

NOTE:

If both datafile and archive log volumes are rolled back, then an incomplete recovery

must be performed to recover the database on the database server. The binary or ASCII control
file from the Recovery Manager for Oracle Virtual Copy’s repository can be used if required.

Rollback Using a Database Read-Write Virtual Copy

The steps to rollback from a read-write Virtual Copy are the similar to rollback from a read-only
Virtual Copy. First, perform step 1 to 6 from the section

“Rollback Using a Database Read-Only

Virtual Copy” (page 117)

on the database server for the primary database. Then perform the

following steps:

1.

From the backup server, if a clone database is created, shutdown the database. If the clone
instance is part of a Real Application Clusters (RAC) database, all RAC instances must be
shutdown.

2.

From the backup server, unmount all file systems which are mounted using the read-write virtual
copy volumes.

Example:

# umount /oradata

rmora_rollback Usage

119