VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Cloning a Database (dbed_vmclonedb) Prerelease 8 September 2005, 8:55am
248 VERITAS Storage Foundation for Oracle Administrator’s Guide
Example
In this example, the clone database is re-started on the secondary host (a two-host configuration).
$ /opt/VRTS/bin/dbed_vmclonedb -S PROD -g SNAP_PRODdg \
-o restartdb,new_sid=NEWPROD,vxdbavol=SNAP_arch -f snap2
dbed_vmclonedb started at 2003-04-09 23:03:40
Mounting /clone/arch on
/dev/vx/dsk/SNAP_PRODdg/SNAP_arch.
Mounting /clone/prod_db on
/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
Oracle instance NEWPROD successfully started.
dbed_vmclonedb ended at 2003-04-09 23:04:50
Recreating Oracle tempfiles
After a clone database is created and opened, the tempfiles are added if they were residing on the
snapshot volumes. If the tempfiles were not residing on the same file systems as the datafiles,
dbed_vmsnap does not include the underlying volumes in the snapshot. In this situation,
dbed_vmclonedb issues a warning message and you can then recreate any needed tempfiles on
the clone database as described in the following procedure.
▼ To recreate the Oracle tempfiles
1. If the tempfiles were not residing on the same file systems as the datafiles,
dbed_vmclonedb will display the WARNING and INFO messages similar to the following:
WARNING: Not all tempfiles were included in snapshot for $ORACLE_SID,
there is no snapshot volume for
/clone_path/temp02.dbf.
WARNING: Could not recreate tempfiles for $ORACLE_SID due to lack of
free space.
INFO: The sql script for adding tempfiles to $ORACLE_SID is at
/tmp/add_tf.$ORACLE_SID.sql.
Note $ORACLE_SID is the name of the clone database.
2. A script named add_tf.$ORACLE_SID.sql is provided in the /tmp directory for the
purpose of recreating Oracle tempfiles. This script contains the SQL*Plus commands to
recreate the missing tempfiles.
3. Make a copy of the /tmp/add_tf.$ORACLE_SID.sql script and open it to view the list
of missing tempfiles.
An example of the add_tf.$ORACLE_SID.sql script is shown below:
$ cat /tmp/add_tf.$ORACLE_SID.sql