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
114
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.
CAUTION 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.