Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

you can then recreate any needed tempfiles on the clone database as described

in the following procedure.

To recreate the Oracle tempfiles

If the tempfiles were not residing on the same file systems as the datafiles,

dbed_vmclonedb will display the WARNING and INFOmessages 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.

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.

Make a copy of the 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 add_tf.pune.sql

-- Commands to add tempfiles to temporary tablespaces.

-- Online tempfiles have complete space information.

-- Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE

'DBED:ADJUST_BEFORE_RUN/snap_data11r1/pune/temp01.dbf'

SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

Evaluate whether you need to recreate any temp files. If you want to recreate

tempfiles, proceed to the next step.

Using Database FlashSnap for backup and off-host processing

Cloning a database (dbed_vmclonedb)

286