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
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.
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.
- 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:
- 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)
- 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.)
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.
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)).