Hot Cloning Oracle Application
Posted: Thu May 07, 2009 6:08 am
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
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