The Latest Technology Stack News Directly from EBS Development

Using Physical Standby for EBS 12 Environments on 11g Databases

Steven Chan
Senior Director
Database disaster recovery, sometimes also lumped into the broader category of business continuity planning, is a topic that many EBS sysadmins seem to struggle with.  Oracle Data Guard is a set of services that create, manage, and monitor one or more standby databases to enable a primary database to survive disasters and data corruption. If the primary database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch a standby database to the primary role, minimizing the downtime.   
Physical architecture diagram showing target architecture for an E-Business Suite Release 12 disaster recovery deployment
We've previously published EBS-specific documentation covering this for 10gR2 databases: Our EBS database architects have recently updated that documentation to cover physical standby for both the 11gR1 and 11gR2 databases for E-Business Suite 12 environments.  This updated documentation has been streamlined and updated with our latest recommendations for disaster recovery environments using physical standby.  It's published here: References Related Articles

Join the discussion

Comments ( 9 )
  • naushad Friday, November 12, 2010


    I am naushad a regular reader of your blogs. Thank you so much for giving great valuable informations. Now this is the first time I am writing to you with an expectation of a comment from your side.

    We have around 7 locations across the middle east and we are planning to implement EBS 12.1.2 with 11g database. The constraint here is the sufficient bandwidth availability from the service provider, if we are planning through a centralized installation. Most of the department requires consolidated data and they are ready for a delay upto 6 to 8 hours and it is not a 24/7 environment. Each location is having around 60 conc users. If we are planning with an instance on each location what are the possibility of replication. We are evaluating


    Data guard.


    Streams replication


    Golden gate.

    Thank you in advance,

    Awaiting for your valuable comments.



  • Steven Chan Friday, November 12, 2010

    Hi, Naushad,

    Thanks for the feedback on our blog. Glad to hear that you've found it useful.

    We do not support or recommend the type of architecture that you're proposing. The E-Business Suite is not designed to be able to handle the reconciliation of data from multiple remote E-Business Suite instances into a single instance.



  • Marc De Weerdt Monday, November 15, 2010

    Steven, what about Active Data Guard? I don't see that mentioned in the note. Do you know if that is supported for E-Business Suite?


  • Steven Chan Monday, November 15, 2010


    See this externally-published article:

    Comparing Oracle Data Guard vs. Active Data Guard for EBS Environments




  • C DBA Wednesday, December 15, 2010

    Hi Steven,

    Thank you for publishing this article. I was wondering how the application teir will be switched to standby site?

    Is there any Applications DataGaurd ?



  • Steven Chan Thursday, December 16, 2010

    Hi, C.,

    See Section 6.4, "Configuring application tiers after role transition" in Note 1070033.1, referenced in the article above.



  • claudja Tuesday, June 14, 2011

    Hello, i am having some issues in setting up our oracle apps standby on the application tier side.

    I am getting the following error on the standby server when trying to connect via sqlplus on teh appstier>


    ORA-12505: TNS:listener does not currently know of SID given in connect


    please advise!

  • Steven Chan Tuesday, June 14, 2011

    Hello, Claudja,

    I'm sorry to hear that you've encountered an issue with this.

    We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.



  • guest Thursday, June 16, 2011

    Thanks Steven!

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.

Recent Content