4 Replies Latest reply on Jan 5, 2016 5:18 PM by Hussein Sawwan-Oracle

    Disaster plan

    966638

      Hi,

       

        We have oracle E-Biz installed in one server. Database in one server and apps in another server

       

        Database server name = DBServ

        R12.1.2  server name =  APPSSer

       

        and users are connecting to erp using link http://appsser:8000

       

      Please suggest best/easy/recommended ways to setup a DR plan.

       

       

       

      Thanks,

        • 1. Re: Disaster plan
          VishnuVinnakota

          Configure Data Guard for DB DR and you can use rsync for application tier.

           

          In case of switch over, you just need to Switch to DR Database. Run adcfgclone.pl for the 1st time. From the next time this wouldn't be necessary.

           

          If you need more clarification or any detailed plan, let me know

          • 2. Re: Disaster plan
            966638

            Thanks for the update. Didn't get clear picture. what I understood is

             

            a) DB server -> Create new server DBSer2 and configure DataGuard

            b) Apps server -> Create a new server APPSSer2 and resync all files ( apps/db/inst), need to manual resync ?

            c) When there is a crash, need to run adcfgclone from APPSSer2 and connect to DG database

            d) There will be a service disturbance when there is crash ..rt?

             

            Please correct me with correct steps.

            • 3. Re: Disaster plan
              VishnuVinnakota

              Create a virtual DNS name for application tier 1st like erp.company.com etc and ask them to point it to the current PROD host:

              If you are using a Load Balancer like DNS or F5: Just change s_login, s_external_url,s_webentryhost,s_webentrydomain

               

               

              Post switch over instead of pointing erp.ammroc.ae to PROD URL, you will point to DR URL but for the users, the URL won't change.

               

               

              On PROD:

              • Run adpreclone.pl on DB and APPS Tier
              • Copy the DB Home to DR
              • Copy the application tier file system from PROD to DR

              Steps on DR Site:

              DB Tier:

              • Run adcfgclone.pl techStack (To configure OH)
              • Create the Physical Standby Database with the help of rman duplicate from prod (target)
              • Switchover the DB from PROD to DR
              • Run adcfgclone.pl dbConfig (To configure DB for APPS)

              APPS Tier:

              • Run adcfgclone.pl appsTier
              • Check Services
              • Bring down apps

               

               

              From Next Switchover, you just need to switch to Physical Standby and run autoconfig on db tier, apps tier once and start

               

              Switch back to PROD! Run autoconfig on DB, Apps Node. Start redo apply.

               

              For application tier, configure "rsync" for weekly sync or daily (As you know apps tier changes only when u apply patches or technical team modify java pages/forms etc.)

              • 4. Re: Disaster plan
                Hussein Sawwan-Oracle

                966638 wrote:

                 

                Hi,

                 

                  We have oracle E-Biz installed in one server. Database in one server and apps in another server

                 

                  Database server name = DBServ

                  R12.1.2  server name =  APPSSer

                 

                  and users are connecting to erp using link http://appsser:8000

                 

                Please suggest best/easy/recommended ways to setup a DR plan.

                 

                 

                 

                Thanks,

                 

                All the steps are documented in (Using Active Data Guard and Discoverer Reporting with Oracle E-Business Suite Release 12.1 and an Oracle 11g or 12c Database as a Physical Standby (Doc ID 1070491.1)).

                 

                Thanks,

                Hussein