{"id":414,"date":"2008-03-24T03:15:55","date_gmt":"2008-03-24T07:15:55","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/"},"modified":"2008-03-24T03:15:55","modified_gmt":"2008-03-24T07:15:55","slug":"oracle-applications-11i-hot-backup-cloning-with-rapid-clone","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/","title":{"rendered":"Oracle Applications 11i Hot Backup Cloning with Rapid Clone"},"content":{"rendered":"

We are getting lot of questions on Hot Backup Cloning of 11i in the\u00a0forum. So we thought that, if we write one article regarding this, it will be more useful for the apps newbies. Here I am sharing the information that, what i follow during the hotbackup cloning. You all might have done this before.<\/p>\n

\u00a0\u00a0 Source System (PROD):<\/strong>\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (a)\u00a0\u00a0 P4 3.0 GHz System with 2GB RAM and 200 GB HDD (Redhat Linux AS 4)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/d01 ——- 40 GB (Application Tier Files)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/d02 ——- 10 GB (10g Oracle Home)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/d03 ——- 80 GB (Data Files)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\/backup —- 100 GB (NFS mount point Shared on TEST Server)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0 Hostname: prodserver<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0 \u00a0 Application Version: 11.5.10.2<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0Database Version: 10.2.0.2<\/strong>\u00a0Target System (TEST):<\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(b)\u00a0 P4 2.6 GHz system with 1.5 GB RAM with 300 GB HDD (Redhat Linux AS 4)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/d01 ——- 40 GB (Application Tier Files)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/d02 ——- 10 GB (10g Oracle Home)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\/d03 ——- 80 GB (Data Files)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/backup —- 100GB (NFS Share Directory)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0\u00a0\u00a0\u00a0 Hostname: testserver<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0 \u00a0\u00a0 Application Version: 11.5.10.2<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\u00a0 \u00a0\u00a0 Database Version: 10.2.0.2<\/strong>\u00a0<\/p>\n

Note: This target System was previously cloned with cold backup. This is second time cloning with Hot Backup from PRODSERVER.\u00a0\u00a0\u00a0<\/p>\n

Stage1: Prerequisites:<\/strong>\u00a0<\/p>\n

\u00a0========> Apply OUI22 Patch, 5035661 to every IAS Oracle Home<\/font><\/pre>\n
          and RDBMS Oracle Home to be cloned. <\/font><\/pre>\n
          If you are having 10g Oracle Home,<\/font><\/pre>\n
          there is no need of applying this patch. <\/font><\/pre>\n
\u00a0         <\/font>You need to apply this patch on IAS Oracle Home <\/font><\/pre>\n
         (if Database is not 10g)<\/font><\/pre>\n
\u00a0\u00a0\u00a0 \u00a0\u00a0 A. Applying the patch on the iAS $ORACLE_HOME:<\/font><\/p>\n
\u00a0\u00a0 ====================================================<\/font><\/pre>\n
\u00a0<\/font>\u00a0 (a)\u00a0 Unzip the patch into the <iAS ORACLE_HOME> directory:<\/font><\/pre>\n
\u00a0<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0 $unzip -od \/d01\/prodora\/iAS p5035661_11i_LINUX.zip<\/font><\/pre>\n
\u00a0\u00a0 (<\/font>b)<\/font>\u00a0\u00a0 Source the Apps environment file :<\/font><\/pre>\n
\u00a0<\/font>        $. $APPL_TOP\/APPSORA.env<\/font><\/pre>\n
\u00a0  (<\/font>c)<\/font>\u00a0  Change directory to the <IAS ORACLE_HOME>\/appsoui\/setup<\/font><\/pre>\n
\u00a0       <\/font>$cd $IAS_ORACLE_HOME\/appsoui\/setup<\/font><\/pre>\n
\u00a0  (d<\/font>)<\/font>\u00a0\u00a0Execute the perl script OUIsetup.pl:<\/font><\/pre>\n
\u00a0<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0 $perl OUIsetup.pl<\/font><\/pre>\n
\u00a0<\/font>\u00a0NOTE:<\/font><\/pre>\n
\u00a0 In the case of a Multi-Node instance, the above process<\/font><\/pre>\n
\u00a0 should be repeated on the <iAS ORACLE_HOME> of each Node.<\/font><\/pre>\n
(B) Applying the patch on the RDBMS $ORACLE_HOME: <\/font><\/pre>\n
     (This step is not required for my current setup, <\/font><\/pre>\n
    because my database version is 10g R2)<\/font><\/pre>\n
\u00a0<\/font>\u00a0(a)\u00a0 Unzip the patch into the <RDBMS ORACLE_HOME> directory:<\/font><\/pre>\n
\u00a0<\/font>\u00a0\u00a0\u00a0\u00a0\u00a0 $unzip -od \/u01\/proddb\/9.2.0 p5035661_11i_LINUX.zip<\/font><\/pre>\n
\u00a0<\/font>\u00a0(b)\u00a0 Source the DB environment file :<\/font><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>\u00a0$. $ORACLE_HOME\/PROD_prodserver.env<\/font><\/pre>\n
\u00a0 (<\/font>c)<\/font>\u00a0Change directory to the <RDBMS ORACLE_HOME>\/appsoui\/setup<\/font><\/pre>\n
\u00a0     <\/font>$cd $ORACLE_HOME\/appsoui\/setup<\/font><\/pre>\n
\u00a0 (<\/font>d) Execute the perl script OUIsetup.pl:<\/font><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/font>$perl OUIsetup.pl<\/font><\/pre>\n
======> Check all other Requirements as Perl, JRE, JDK, ZIP utilities on Source and Target Nodes as per<\/font><\/pre>\n
        document \"Cloning Oracle Applications Release 11i with Rapid Clone\"<\/font><\/pre>\n
=======> Apply the Latest AD Minipack on Application Tier (Latest One is AD.I.5)<\/font><\/pre>\n
=======\u00e8 Apply the Latest Autoconfig Template Patch and Latest Rapidclone Patches to Application Tier (Check Metalink for These Patches)<\/font><\/pre>\n
Stage2: Prepare the Source System (PRODSERVER)<\/strong><\/font><\/pre>\n
\u00a0     <\/font><\/strong>(a)<\/font>\u00a0Login into Database Tier as ORACLE<\/strong> user and run the preclone<\/font><\/pre>\n
\u00a0<\/font>\u00a0\u00a0\u00a0       $cd $ORACLE_HOME\/appsutil\/scripts\/PROD_prodserver<\/font><\/pre>\n
\u00a0      <\/font>\u00a0\u00a0\u00a0 $perl adpreclone.pl dbTier<\/font><\/pre>\n
\u00a0     <\/font>(b)<\/font>\u00a0Login into the Application Tier as APPLMGR<\/strong> User and run the\u00a0 preclone<\/font><\/pre>\n
\u00a0\u00a0\u00a0   <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0$cd $COMMON_TOP\/admin\/scripts\/PROD_prodserver<\/font><\/pre>\n
\u00a0     <\/font>\u00a0\u00a0\u00a0\u00a0 $perl adpreclone.pl appsTier<\/font><\/pre>\n
Stage3: Put the Database in Begin Backup Mode and copy the Database Files <\/strong><\/font><\/pre>\n
\u00a0      <\/font><\/strong>(a)<\/font>\u00a0\u00a0\u00a0Login into database as sysdba user<\/font><\/pre>\n
\u00a0      <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0 $sqlplus \"\/as sysdba\"<\/font><\/pre>\n
\u00a0\u00a0     <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Sql> alter database begin backup;<\/font><\/pre>\n
\u00a0      <\/font>(b)<\/font>\u00a0\u00a0 Copy Archive log files created during hot backup to \/backup directory.<\/font><\/pre>\n
       (c)<\/font>\u00a0\u00a0 Copy the All Data files to \/backup directory.<\/font><\/pre>\n
       (d)<\/font>\u00a0\u00a0 Backup the control file to trace.<\/font><\/pre>\n
\u00a0      <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0 Sql> alter database backup control file to trace;<\/font><\/pre>\n
\u00a0       <\/font>\u00a0\u00a0\u00a0\u00a0 Copy this trace file to \/backup directory<\/font><\/pre>\n
\u00a0      <\/font>(e)<\/font>\u00a0\u00a0 Copy the current init.ora file to \/backup directory<\/font><\/pre>\n
       (f)<\/font>\u00a0\u00a0 End the Begin Backup Mode.<\/font><\/pre>\n
\u00a0     <\/font>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Sql> alter database end backup.<\/font><\/pre>\n
\u00a0<\/font>Stage4: Copy the Application Tier File System Files<\/font><\/strong><\/pre>\n
\u00a0        <\/font><\/strong>(a)<\/font>Login into the Application Tier as APPLMGR user and copy the APPL_TOP, COMMON_TOP, <\/font><\/pre>\n
             IAS ORACLE HOME and 8.0.6 Oracle Home to \/backup directory<\/font><\/pre>\n
\u00a0<\/font>Stage5: Copy the Source Database files and Application Files to Target server<\/font><\/strong><\/pre>\n
\u00a0<\/font><\/strong>\u00a0\u00a0 \u00a0Copy the parameter file, backup control file and archive log files from \/backup directory \u00a0<\/font><\/pre>\n
         \u00a0to \/d01, \/d02 and \/d03 in target server.<\/font><\/pre>\n
\u00a0<\/font><\/strong>Stage 6: Configure the Target Database (TESTSERVER)<\/font><\/strong><\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Log on to the target system as the ORACLE user\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (1)\u00a0\u00a0\u00a0\u00a0 Configure the <RDBMS ORACLE_HOME>\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cd <RDBMS ORACLE_HOME>\/appsutil\/clone\/bin\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl adcfgclone.pl dbTechStack\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 (2)\u00a0\u00a0\u00a0\u00a0 Create the target database control file manually\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0Open the backed up control file \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0a. remove all lines before the startup nomount statement\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0b.\u00a0Modify the REUSE to SET\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c.\u00a0Modify Source DB SID to Target SID (Here PROD to TEST)\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0d.\u00a0Modify NORESETLOGS TO RESETLOGS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 e. delete all lines after the CHARACTER SET\u00a0statement<\/p>\n
————————————\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE CONTROLFILE SET DATABASE “TEST” NORESETLOGS\u00a0 ARCHIVELOG…<\/p>\n
LOGFILEGROUP 1<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/d03\/log01.log’ SIZE 50M,<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 …<\/p>\n
DATAFILE<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/d03\/system01.dbf’,<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\/d03\/undotbs01.dbf’,<\/p>\n
\u00a0\u00a0\u00a0 …<\/p>\n
CHARACTER SET UTF8;\u00a0<\/p>\n
—————————————————–<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 On the target system, modify the init.ora to\u00a0have the target SID and location of the control file and also\u00a0make sure\u00a0that init.ora parameters are set for archive log mode\u00a0On the target system,<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0starup the database in nomount stage<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sql> startup nomount pfile=< Target init.ora path><\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sql> @clone.ctl\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( here clone.ctl is the control file which we have modified above)<\/p>\n
\u00a0\u00a0\u00a0\u00a0 Once control file is created, database will be in mount stage<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 execute recover command using backup control file after the database is mounted\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;\u00a0<\/p>\n
\u00a0After the last archive log has been applied, issue the following command \u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL> alter database open resetlogs;\u00a0\u00a0\u00a0\u00a0 \u00a0<\/p>\n
\u00a0After opening the database, add temp files to target database\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(3) Run the library update script against the database\u00a0\u00a0\u00a0 \u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0cd <RDBMS ORACLE_HOME>\/appsutil\/install\/<CONTEXT NAME\u00a0\u00a0\u00a0\u00a0 sqlplus “\/ as sysdba” @adupdlib.sql <libext>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Where <libext> is “sl” for HP-UX, “so” for any other UNIX platform and \u00a0\u00a0\u00a0\u00a0\u00a0not required for Windows.\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (4)Configure the target database (the database must be open)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 cd <RDBMS ORACLE_HOME>\/appsutil\/clone\/bin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 perl adcfgclone.pl dbconfig <target context file>\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 where target context file is: <RDBMS ORACLE_HOME>\/appsutil\/<Target CONTEXT_NAME>.xml<\/p>\n
\u00a0\u00a0 \u00a0Stage 7 :\u00a0 Configure the Target Application Tier<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0Logon to the target system as the APPLMGR user and type the following commands\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 $Cd $COMMON_TOP\/clone\/bin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Perl adcfgclone.pl appsTier\u00a0\u00a0<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0Finishing tasks:<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0(1)\u00a0\u00a0\u00a0\u00a0 Update Profile options<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (2)\u00a0\u00a0\u00a0\u00a0 Update Printer Settings<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (3)\u00a0\u00a0\u00a0\u00a0 Update the workflow configuration settings<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (4)\u00a0\u00a0\u00a0\u00a0 Verify the APPLCSF variable setting<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(5)\u00a0\u00a0\u00a0\u00a0 Update the session_cookie_domain value in icx_parameters\u00a0<\/p>\n
For the finishing tasks, check the finishing tasks section of the following document<\/p>\n
\u00a0Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
We are getting lot of questions on Hot Backup Cloning of 11i in the\u00a0forum. So we thought that, if we […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-414","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nOracle Applications 11i Hot Backup Cloning with Rapid Clone -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Applications 11i Hot Backup Cloning with Rapid Clone -\" \/>\n<meta property=\"og:description\" content=\"We are getting lot of questions on Hot Backup Cloning of 11i in the\u00a0forum. So we thought that, if we […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-03-24T07:15:55+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/\",\"name\":\"Oracle Applications 11i Hot Backup Cloning with Rapid Clone -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-03-24T07:15:55+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Applications 11i Hot Backup Cloning with Rapid Clone\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Applications 11i Hot Backup Cloning with Rapid Clone -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Applications 11i Hot Backup Cloning with Rapid Clone -","og_description":"We are getting lot of questions on Hot Backup Cloning of 11i in the\u00a0forum. So we thought that, if we […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/","article_published_time":"2008-03-24T07:15:55+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/","name":"Oracle Applications 11i Hot Backup Cloning with Rapid Clone -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-03-24T07:15:55+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/03\/24\/oracle-applications-11i-hot-backup-cloning-with-rapid-clone\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Applications 11i Hot Backup Cloning with Rapid Clone"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=414"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/414\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}