Using Physical Standby for EBS 12 Environments on 11g Databases

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

Comments:

Hi,
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
a. Data guard.
b. Streams replication
c. Golden gate.
Thank you in advance,
Awaiting for your valuable comments.
Regards,

Naushad

Posted by naushad on November 11, 2010 at 08:11 PM PST #

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.

Regards,
Steven

Posted by Steven Chan on November 12, 2010 at 04:06 AM PST #

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?

Marc

Posted by Marc De Weerdt on November 14, 2010 at 09:57 PM PST #

Marc,

See this externally-published article:

Comparing Oracle Data Guard vs. Active Data Guard for EBS Environments
http://blogs.oracle.com/stevenChan/2008/10/comparing_oracle_data_guard_vs_active_data_guard_f.html

Regards,
Steven

Posted by Steven Chan on November 15, 2010 at 01:20 AM PST #

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 ?

Regards,
C.

Posted by C DBA on December 15, 2010 at 12:16 PM PST #

Hi, C.,

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

Regards,
Steven

Posted by Steven Chan on December 16, 2010 at 02:36 AM PST #

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>
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor
please advise!

Posted by claudja on June 14, 2011 at 03:30 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on June 14, 2011 at 03:56 AM PDT #

Thanks Steven!

Posted by guest on June 16, 2011 at 04:12 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today