Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

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 /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'

SIZE 4194304 REUSE AUTOEXTEND ON NEXT 1048576 MAXSIZE 33554432 ;

ALTER TABLESPACE TEMP ADD TEMPFILE

'/clone_path/temp02.dbf' REUSE;

ALTER DATABASE TEMPFILE '/clone_path2/temp02.dbf'

OFFLINE;

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

tempfiles, proceed to the next step.

275Using Database FlashSnap for backup and off-host processing

Cloning a database (dbed_vmclonedb)