Running Pre-Clone on the Source Apps Tier: perl adpreclone.pl appsTier Running Pre-Clone on the Source DB Tier: perl adpreclone.pl dbtier Copying Application Tier from Source to Target: connect to target application server with root user and copy the run edition filesystem from source to target. TARGET> cp -r /u01/fs1 /u01/cloned Copying RDBMS Oracle Home from the Source To Target: connect to target db server with root user and copy databsae oracle home from source to target. TARGET> cp -r /u01/database/11.2.0 /u01/clonedb/ Backing up to database online (with rman) : Connect to source database using rman, and backup your database plus archive log in to the directory you want.. rman target / backup device type disk format '/u01/rman/%d_full_%s_%p.bck' database plus archivelog; Running Post Clone in the Target Database Server: cd /u01/cloned/11.2.0/appsutil/clone/bin perl adcfgclone.pl dbTier Target System Hostname (virtual or normal) [oraapps] : Target Instance is RAC (y/n) [n] : Target System Database SID : CLONE Target System Base Directory : /u01/clonedb Target System utl_file_dir Directory List : /usr/tmp Number of DATA_TOP's on the Target System [1] : Target System DATA_TOP Directory 1 [/proddb/db/apps_st/data] : /u01/clonedb/data Target System RDBMS ORACLE_HOME Directory [/crpdb/db/tech_st/11.1.0] : /u01/clonedb/11.2.0 Do you want to preserve the Display [oraapps:0.0] (y/n) : n Target System Port Pool [0-99] : 5 $ cd /u01/clonedb/11.2.0 $ . CLONE_hostname.env Edit the initCLONE.ora file and add the following parameters db_file_name_convert='/u01/database/data','/u01/clonedb/data' log_file_name_convert='/u01/database/data','/u01/clonedb/data' save the file sqlplus / as sysdba startup pfile=<initCLONE.ora location> nomount create spfile from pfile rman auxiliary / RMAN>duplicate target database to "CLONE" backup location '/u01/rmanbkp'; Running Post Clone in the Target Application Tier : perl adcfgclone.pl appsTier Do you want to add a node (yes/no) [no] : Target System File Edition type [run] : Provide the values required for creation of the new APPL_TOP Context file. Target System Hostname (virtual or normal) [prod] : Target System Database SID : CLONE Target System Database Server Node [apps] : Target System Database Domain Name [apps.dba.com] : Target System Base Directory : /u01/clonedb Target System Instance Home Directory [/u01] : Do you want to preserve the Display [erpprod:0.0] (y/n) : n Target System Display [erppreprod:0.0] : Target System Root Service [enabled] : Target System Web Administration [enabled] : Target System Web Entry Point Services [enabled] : Target System Web Application Services [enabled] : Target System Batch Processing Services [enabled] : Target System Other Services [enabled] : Do you want the target system to have the same port values as the source system (y/n) [y] ? : n Target System Port Pool [0-99] : 1 1. /usr/tmp 2. /usr/tmp 3. /u01/oracle/product/11.2.0.3/db/appsutil/outbound/PREPROD_erppreprod 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] : Do you want to startup the Application Services for PREPROD? (y/n) [n] : n Running Pre-Clone on the Target Apps Tier: . APPSCLONE_apps.env perl adpreclone.pl appsTier Copying EBSpps directory from Run edition to patch edition (in this case fs1 to fs2) in the Target Application server: [approd@apps ~]# cp -rvnf /u02/cloneapps/fs1/EBSapps /u02/cloneapps/fs2/ CLONE DATABASE SIDE sqlplus "/as sysdba" SQL>alter system set service_names='PREPROD','ebs_patch','PREPROD_patch' scope=memory; System altered. SQL> alter system set local_listener=PREPROD scope=memory; System altered. SQL> alter system register; System altered. Running postclone on the Patch Edition of the Target Application server: cd /u01/cloneapps/fs2/EBSapps/comn/clone/bin (patch edition 's clone/bin) perl adcfgclone.pl appsTier Do you want to add a node (yes/no) [no] : Target System File Edition type [run] : patch Location of Run File System context file : /u02/cloneapps/fs1/inst/apps/CLONE_apps/appl/admin/CLONE_apps.xml Target System Port Pool [0-99] : 2 1. /usr/tmp 2. /usr/tmp 3. /u01/clonedb/11.2.0/appsutil/outbound/CLONE_apps 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] : ./adstrtall apps/apps1 U02/cloneapps/fs1/FMW_Home/user_projects/domains/EBS_domain_CLONE/config/