Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using FlashSnap for Backup and Recovery
Cloning a Database (dbed_vmclonedb)
Chapter 5
110
dbed_vmclonedb started at 2006-03-09 23:26:50
Mounting /clone/arch on /dev/vx/dsk/SNAP_PRODdg/SNAP_arch.
Mounting /clone/prod_db on /dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
All redo-log files found.
Altering instance_name paramter in initpune.ora.
Altering instance_number paramter in initpune.ora.
Altering thread paramter in initpune.ora.
Starting automatic database recovery.
Database NEWPROD (SID=NEWPROD) is in recovery mode.
If the database NEWPROD is recovered manually, you must run
dbed_vmclonedb -o update_status to change the snapshot status.
dbed_vmclonedb ended at 2006-03-09 23:27:17
2. The database is recovered manually.
3. The snapshot status (database_recovered) is updated for a clone database on a
secondary host after manual recovery has been completed.
$ /opt/VRTS/bin/dbed_vmclonedb -o update_status,new_sid=NEWPROD \
-f snap2
dbed_vmclonedb started at 2006-03-09 23:34:01
The snapshot status has been updated.
dbed_vmclonedb ended at 2006-03-09 23:34:35
To clone the database automatically
• Use the dbed_vmclonedb command as follows:
$ /opt/VRTS/bin/dbed_vmclonedb -S ORACLE_SID -g snap_dg \
-o recoverdb,new_sid=new_sid[,vxdbavol=vol_name] -f SNAPPLAN \
[-H ORACLE_HOME] [-r relocate_path]
Where:
Table 5-10 dbed_vmclonedb command options
ORACLE_SID Represents the name of the Oracle database used to create the
snapshot.
snap_dg Represents the name of the diskgroup that contains all the
snapshot volumes.
new_sid Specifies the ORACLE_SID for the clone database.
vxdbavol Represents the volume that contains the snapplan data.
This name is provided after you run dbed_vmsnap -o snapshot.
SNAPPLAN Represents the name of the snapplan file.
ORACLE_HOME Represents the ORACLE_HOME setting for the ORACLE_SID
database.