2 Replies Latest reply on May 23, 2016 2:41 AM by Vijay.Cherukuri-Oracle

    EBS Cloning : adpreclone.pl dbTier

    Vijay.Cherukuri-Oracle

      Hi,

       

      I am newbie to cloning  , referring to MOS DOC id : Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

       

      During source system prepare phase, we need  to run adpreclone.pl on DB tier, it creates stage directory and copies (template and driver files)  some of the DB config files .

      and these zip files located under $ORACLE_HOME/appsutil location.

       

      perl adpreclone.pl dbTier 
      

       

      But while creating new DB on target system, we use either hot backup or RMAN to take database backup (possibly redo or archives also. ), We DONT copy / backup $ORACLE_HOME here.

       

      and we are NOT copying those ZIP files generated during adpreclone.pl on source node to target node.

       

      Then what is use of running adpreclone.pl  on source DB server ?

      Please clarify.

       

       

      -Thanks.

        • 1. Re: EBS Cloning : adpreclone.pl dbTier
          Roy-Susmit

          Hi,

           

          It is recommended to copy the ORACLE_HOME when you are using RMAN/Hot Backup to create the database on target. 

           

          See 5.1 Refreshing a Target System

           

          2. If the RDBMS ORACLE_HOME or the database needs to be refreshed, copy the database node file system. If refreshing the database, be sure to refresh the ORACLE_HOME at the same time.


          This actually make sure any ORACLE HOME patches that you have applied in Source also gets migrated to target (you can ofcourse re apply them in target but that requires additional downtime and effort). And for this running adpreclone dbtier is mandatory so that the Cloning Driver Files, Scripts, Templates gets created that will be used in target during,

          adcfgclone dbTechStack(Check Section 5.7 Cloning the Database Separately).



          However if you are not copying the ORACLE_HOME and using a target ORACLE HOME as is and using RMAN/Hot Backup only to duplicate database, adpreclone dbtier on Source is not really required.

          • 2. Re: EBS Cloning : adpreclone.pl dbTier
            Vijay.Cherukuri-Oracle

            Thank you. That clarified my confusion.