Hot Cloning Oracle Application

[lukman]

Dear all,

Just want to remind you that if you follow Metalink's Document 760772.1 that modified 11 Februari 2009 to clone Oracle Application 11i/12 when the database and applications still running (hot cloning) then you MUST add temporary tablespace BEFORE you configure target database (step 12) using command :

perl adcfgclone.pl dbconfig <target context file>

where target context file is:

<RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml

It's because at Step 3 to create control file Oracle wants you to remove all and leave "only" the CREATE CONTROLFILE clause where actually when you issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE in step 2, the creation of temporary tablespace was already in the trace file.

Thank you