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
113
In this example, the clone database is re-started.
$ /opt/VRTS/bin/dbed_vmclonedb -S PROD -g SNAP_PRODdg \
-o restartdb,new_sid=NEWPROD,server_name=host1\
-f snap1 -r /clone
dbed_vmclonedb started at 2006-03-02 15:14:49
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.
Oracle instance NEWPROD successfully started.
dbed_vmclonedb ended at 2006-03-02 15:15:19
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 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.
where $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
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE
'/clone_path/temp01.dbf'