VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 10, Using Database FlashSnap for Backup and Off-Host Processing
Prerelease 8 September 2005, 8:55am Cloning a Database (dbed_vmclonedb)
249
-- 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;
4. Evaluate whether you need to recreate any temp files. If you want to recreate tempfiles,
proceed to the next step.
5. In the add_tf.$ORACLE_SID.sql file, edit the sizes and default path names of the
tempfiles as needed to reside on cloned volumes configured for database storage.
Note Do not run the script without first editing it because path names may not exist and the
specified mount points may not contain sufficient space.
6. After you have modified the add_tf.$ORACLE_SID.sql script, execute it against your
clone database.
7. After you have successfully run the script, you may delete it.