VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
467
▼
To clone a database manually
In a single-host configuration:
To mount file systems and create a clone of the primary database on the same host as the primary
database without recovering the clone database, use the dbed_vmclonedb command as follows.
The clone database must be manually recovered before it can be used:
$ /opt/VRTS/bin/dbed_vmclonedb -S PROD -g SNAP_PRODdg \
-o mountdb,new_SID=NEWPROD -f snap1 -r /clone
dbed_vmclonedb started at 2003-04-02 15:34:41
Mounting /clone/prod_db on
/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
Mounting /clone/prod_ar on
/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_ar.
All redo-log files found.
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 2004-04-02 15:34:59
Recover the database manually.
Update the snapshot status (database_recovered) for the clone database on the primary host
after manual recovery has been completed:
$ /opt/VRTS/bin/dbed_vmclonedb -o
update_status,new_sid=NEWPROD -f snap1 -r /clone
dbed_vmclonedb started at 2004-04-02 15:19:16
The snapshot status has been updated.
dbed_vmclonedb ended at 2004-04-02 15:19:42
In a two-host configuration:
To mount file systems and create a clone of the primary database on a secondary host without
recovering the clone database, use the dbed_vmclonedb command as follows. The clone
database must be manually recovered before it can be used:
$ /opt/VRTS/bin/dbed_vmclonedb -S PROD -g SNAP_PRODdg \
-o mountdb,new_sid=NEWPROD,vxdbavol=SNAP_arch -f snap2
dbed_vmclonedb started at 2003-04-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.