The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

  • October 10, 2008

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

Steven Chan
Senior Director

[Nov 6 Update: Our High Availability team has suggested some additional uses for Active Data Guard in E-Business Suite environments. Article updated with those additional use cases.]

Given the number of questions I've fielded about Active Data Guard through other channels, it was inevitable that my recent article about strategies for
handling EBS reporting loads
would prompt questions about its compatibility with the E-Business Suite. 

The answer to this deceptively-simple question is only meaningful if you understand what's happening behind the scenes when users log into the E-Business Suite.  This article compares the operational implications of using Oracle Active Data Guard
versus Oracle Data Guard in E-Business Suite environments.

What Is Active Data Guard?

Active Data Guard is a new option for Oracle Database 11g Enterprise Edition. From its official product literature:

Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, web-based access, etc., while continuously applying changes received from the production database.

I've emphasized the read-only nature of the replicated database because of this feature's implications for E-Business Suite environments. But first, a little background.

Behind the Scenes: Logging Into the E-Business Suite 

In the E-Business Suite world, every user is assigned one or more responsibilities.  These responsibilities govern the E-Business Suite applications (i.e. menu functions) and data that a given user can access.  For example, as a manager, I
might be assigned responsibilities that allow me to review my employees' compensation and approve their expense reports.  I'm also an employee, which means that I can review my own payslips and file new expense reports.

Every time anyone logs into a running E-Business Suite instance, the following things happen:

  1. Their authenticated credentials are checked against their assigned E-Business Suite responsibilities.


  2. A user session is created in the E-Business Suite database.


  3. All activities are logged for audit and tracking purposes, even queries against existing data.

This level of security prevents E-Business Suite unauthorized users from, say, assigning stock options to themselves.  It also provides an audit trail in case someone abuses their position by attempting to cook the books in the midst of a financial
industry meltdown.

This also applies to the use of external reporting tools like Oracle Discoverer.  Discoverer users must log into the E-Business Suite instance, which checks their assigned responsibilities to prevent users from running reports against data that they're
unauthorized to view.

So What About Active Data Guard?

Putting this together: 

  • Active Data Guard makes a read-only replication of a given database. 

  • Even the simple act of logging into an E-Business Suite database requires write access.

Therefore, it may be possible to use Active Data Guard to replicate an E-Business Suite database, but there's not much benefit in doing so if your objective is to offload reporting functions from your production environment.  After all, if you have an Apps read-only database that you can't access, it's not all that useful for creating
standalone databases for reporting purposes.

Nov 6, 2008 Update: Note that this limitation precludes the use of Active Data Guard if you're interested in creating a reporting instance that requires read-write EBS access. However, nothing stops you from using Active Data Guard as part of your failover strategies for your E-Business environments. For example, you can use Active Data Guard to make a read-only copy of your production E-Business Suite environment; in the event of failover, that environment would fail over to the Active Data Guard database thus opening it to normal read-write EBS operations.

If course, this means that you might ask, "Besides that failover scenario, why do I care about Active Data Guard if I can't really use the physical standby in read-only mode? Two possible ways that the Active Data Guard standby could still provide incremental value compared to a regular physical standby are:

  • If you use any read-only reporting scripts or packages, you can now direct those to the Active Data Guard physical standby.
  • Another component of the Active Data Guard option is that it enables RMAN fast incremental backups on the Active Data Guard physical standby (i.e. basically supporting RMAN block change tracking file on the physical standby). This is another potential way of offloading some processing from the production database to the standby database.

What Works for Reporting Instances:  Data Guard Redo Apply With Physical Standby Databases

As an alternative to Active Data Guard for creating reporting instances, we support the use of Oracle Data Guard.  From its official product literature:

Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.

Data Guard maintains these standby databases as synchronized copies of the production database. These standby databases can be located at remote disaster recovery sites thousands of miles away from the production data center, or they may be located in the
same city, same campus, or even in the same building. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, thus minimizing the downtime associated with
the outage, and preventing any data loss.


Specifically, we support the use of Oracle Data Guard Redo Apply with physical standby databases for E-Business Suite environments.  We do not support the use of this feature with logical standby databases due to the lack of Oracle LogMiner support for
certain datatypes used in the E-Business Suite.

Our Maximum Availability Architecture team has put together some excellent papers describing various certified Data Guard configurations for Oracle E-Business Suite Release
11i and 12.  For more details, see:

Related Articles

Join the discussion

Comments ( 69 )
  • Naveen Saturday, October 11, 2008


    This is a great article, thanks a lot. I asked you this question sometime back, so it was nice to see an article on this.

    However, a lot of typical EBS environments have a lot of reporting needs (in our case, we have Discoverer, Oracle 10g reports, Brio etc). These application are pure read-only and do account for over 50% of our system load. The new active data guard feature of 11g might be of great benefit to an environment like ours. Do you think you should jst clarify this for everybody's sake?


    Naveen Garg

  • Steven Chan Monday, October 13, 2008

    Hi, Naveen,

    As I noted above:

    This also applies to the use of external reporting tools like Oracle Discoverer. Discoverer users must log into the E-Business Suite instance, which checks their assigned responsibilities to prevent users from running reports against data that they're unauthorized to view.

    This also applies to Oracle Reports, too. Both Discoverer and Oracle Reports require an E-Business Suite environment that can create an ICX session before generating a report. You cannot run Discoverer or Oracle Reports against a read-only EBS database.

    I'm afraid that I can't comment authoritatively on how Brio works. I would speculate that Brio has the same limitations as any other reporting tool. You may wish to check with Brio Support on whether their products are compatible with Active Data Guard databases.



  • Jay Weinshenker Tuesday, October 14, 2008


    Thanks for this post. Although it's been nice to surprise my clients with this solution, I'm glad to see it's got the blessing from Oracle Support and will hopefully gain wide wide acceptance :D

  • John Stouffer Tuesday, October 14, 2008


    So if I understand this note correctly, neither 10g nor 11g data guard features will allow 'native' Oracle E-Business type reports (XML, Discoverer, 10gReports) to run against the "standby" environment. Correct?

    I understand the scale up approaches but having a significant amount of hardware in a DR site for standby does not maximize the use of all available hardware. With 11g and Active Data Guard, however, couldn't we develop queries/reports using non-EBusiness tools like OBIEE or BI Publisher and treat the E-Business 11g standby database as the source?



  • Steven Chan Tuesday, October 14, 2008

    Hi, Jay,

    "Blessing from Oracle Support"? I suppose so, since we establish the base certifications here in Oracle Development.

    If there are any conflicts between the response you're getting from Oracle Support and the guidance that we publish here in Oracle Development, please feel free to let me know.



  • Steven Chan Tuesday, October 14, 2008


    I appreciate the concerns about unused capacity in the DR instance.

    We need to be careful about the product references. "Oracle Data Guard" supports the use of "native" reporting tools against standby environments, since those environments allow read-write access.

    "Oracle Active Data Guard" creates read-only environments, which prevent the use of "native" reporting tools with E-Business Suite databases created by this technology.

    If you use "Oracle Data Guard" (and not "Oracle Active Data Guard") for your EBS disaster recovery instance, then the DR site can be used for reporting purposes.



  • Sandra Vucinic Monday, October 27, 2008

    Hi Steven,

    Could you please elaborate on your comment:

    If you use "Oracle Data Guard" (and not "Oracle Active Data Guard") for your EBS disaster recovery instance, then the DR site can be used for reporting purposes.

    As in EBS environment we can only use physical standby. The database is in a mount mode and it is not open, so how could it be used for reporting purposes.

    Thanks, Sandra

  • Steven Chan Tuesday, October 28, 2008

    Hi, Sandra,

    You're quite right, and I didn't mean to mislead readers with potentially-confusing statements. The disaster recovery database can only be used for reporting purposes if it's opened, i.e. you've got a fully functioning environment that allows end-users to access it via middle-tier reporting tools like Discoverer that have been configured to read from the DR database rather than the production database.



  • Mark W. Farnham Wednesday, November 5, 2008

    Since RDBMS 6.0.33 and the pre-Oracle product customer built standby databases that rely only on the fully supported recovery model, it has been possible to cancel recovery (usually at a carefully chosen and consistent point in the business cycle such as the completion of the generation of receivables), shut down the standby, copy the standby database, and startup rename the copy of standby with reset logs. After the rename is complete the un-renamed standby may then be resumed. The frozen in time copy of standby may then be opened as the new database it is, and after appropriate surgery to the outstanding jobs tables (excising processing jobs, restoring saved pending report jobs from the previous cycle exported for the purpose, redefining the printers used, applications may be run just fine. Negotiating licensing for this particular topology has varied widely from circa 1994 when Oracle regarded it as an interesting alternative for a handful of its very large Apps customers who were pushing the boundaries of capability of the largest SMP configurations of the time to the present, when the appearance of cost savings by using Active dataguard without the need for one or more copies to create different vintages of the database to be used for varying durations has become vogue (within the limitations Steven has carefully noted). DISK IS CHEAP! The advantages to the accounting team of having a frozen reporting database are large as long as everyone understands what it is advantageous to run on the frozen copy.The ability to use standard concurrent manager reports of course requires an open writable copy. Of course the adopter of this topology needs to understand the difference between using entirely supported Oracle technology and the ability and (lack of) obligation of Oracle Support to help you make the ins and outs of the logistics of this sort of configuration work. Before Dataguard was developed into a product, I used to present a paper titled "Getting the most from your your standby recovery server." (Circa 1995). Since the commands and even syntax have drifted since then I hate to repost it, but the methodology and process stand the test of time.

    In summary, Steven is exactly correct about the impracticality of running the Ebusiness Suite against "active dataguard," but the alternative of making a copy is entirely workable and allows effective use of the horsepower left idle by the efficiency of roll forward on equipment sized to handle switchover or failover with no degradation in service.



  • Steven Chan Thursday, November 6, 2008

    Our High Availability team has elaborated on my reply to Sandra about the use of Discoverer with Active Data Guard:

    If the DR database is opened to be fully functional for Discoverer, it has to be opened read-write (to allow the log-in writes), and that in a Data Guard context typically means that the DR (i.e. the standby) database has been "activated" (or failed over to), at which point it ceases to be a DR database, and becomes a new primary database. In other words, a physical standby database can't be open read-write - whether in a regular Data Guard configuration, or Active Data Guard configuration, and hence Oracle Data Guard does NOT support the use of native EBS reporting tools (that require read/write access) against the standby environments.

    I hope that clarifies things further; feel free to let us know if you have additional questions about this.



  • Sandra Vucinic Thursday, November 6, 2008

    Thanks Steven. All comments posted clarify reporting options available for EBS Data Guard enabled (physical standby) database.


  • Chirag Tuesday, January 6, 2009

    Hi Steven,

    Can Snapshot Standby mode serve the purpose of reporting instance (with some limitation)?

    Snapshot standby database is an Oracle 11g new feature, which allows the use of a physical standby database in read write mode for a short period of time (Ref. Metalink Note 443720.1).

    Instead of opening 11g Physical Standby database in Read Only mode we can open it in Snapshot Standby mode during peak hours and allow user to run report on it.

    Major disadvantage:

    1) All local updates (including any report generated during this period) will be discarded when snapshot database is converted back to physical standby database.

    2) Once the snapshot standby is activated this database diverges from its primary database over a time because redo data from the primary database is not applied. But Data from the primary database is always protected, as the redo logs are being received and applied automatically once it is converted back into a physical standby database.



  • Daminda Wanasundera Wednesday, January 7, 2009

    Dear Steven,

    Please refer the comment made by Chirag above. Kindly let us know your thoughts.



  • Steven Chan Wednesday, January 7, 2009

    Chirag, Daminda,

    We haven't explicitly tested Snapshot Standby mode with the E-Business Suite, but it is assumed to work without any issues. Your observations about the feature's possible disadvantages are correct.

    If you encounter any issues with the use of this feature with EBS, please log a formal Service Request and drop me an email with the details. I'll ensure that our database architects in EBS Development work with Support on any critical issues.



  • Kam Chan Wednesday, April 22, 2009

    Hi Steven,

    Is R12 using 11g redo apply as physical standby database is certified configuration? In your certification page only and are certifed dataguard with EBS. However, I read quite a few articles about using EBS with 11g dataguard as standby. Can you please clarify?

  • Steven Chan Wednesday, April 22, 2009

    Hi, Kam,

    I'd presume that this would work, but our team hasn't had a chance to test this configuration yet. As a result, we haven't published any formal best practices recommendations on how to implement this in an EBS environment yet.

    My recommendation would be to wait until we've published some documentation for this. You're welcome to monitor or subscribe to this blog for updates.



  • Prakash Wednesday, May 6, 2009

    Hello Steve

    I have couple of suggestions for e-biz suite. Am sure this will take long time to implement.

    To make DR sites available for reporting for e-biz suite easiliy we can think of the following:

    1. Make the logical standby database as an option. I know this is not considered because of usage of ROWIDs etc in e-biz suite. But in the long term we should make sure that this restriction is removed. If we don't plan to remove this restriction then we should promote partner technology like GoldenGate to do that job for us. Ofcourse DataGuard will not be used in that case.

    2. Have a separate DB instance for user login's, roles/entitlements and audit logs. This might add some performance overhead but in a DR configuration, we can have this 'control' instance being updated via the "Real Time Apply" method of DataGuard. Oracle Streams could also be used to keep the this 'control' instance in sync with the master node.

    The other database which actually contains all the application specific tables etc can then be placed under "Active Data Guard" and thus be used for reporting.




  • Steven Chan Wednesday, May 20, 2009

    Hello, Prakash,

    Thanks for your suggestions. You're right: these would entail some rather significant architectural changes and would not likely be considered for either the Release 11i or 12 codelines at this point.

    Nonetheless, EBS customers wishing to use Active Data Guard still have other options for doing so, as described above.



  • Dave Bennett Thursday, May 21, 2009

    Would the following scenario work?

    The aim is to move Discoverer users from the EBS database to a standby database environment. We propose to use active standby database in the following way.

    1. Create active standby database

    2. Discoverer EUL remains in the production EBS database

    3. The Discoverer data source is configured as the active standby database.

  • Steven Chan Friday, May 22, 2009

    Hi, Dave,

    Yes, this would work. Remember that the active standby database will be read-only while it's being mirrored with your production database. EBS Discoverer users need to open that database in read-write mode to get access to the Disco EUL.

    You'll need to temporarily suspend the active standby process and open the standby database as a regular database to allow Discoverer users to perform their queries. Once the reporting window is done, you'll need to flip the database back into active standby mode and roll forward the transactions that took place while the mirror was suspended.



  • Dhanraj Pondicherry Tuesday, June 16, 2009


    Curious if we can "implement" around this limitation. How about implement Read Only responsibilities in eBiz Suite that are tied to the Active Dataguard instance?

    This way the authentication and hopefully all the (FND, etc..) writes happened in the regular primary database but the user switched to the Active Dataguard database by switching over to the Read Only responsibility.

    Appreciate the insights.

  • Steven Chan Wednesday, June 17, 2009

    Hi, Dhanraj,

    There are no workarounds to avoid this Active Data Guard limitation right now. We're investigating options with the Active Data Guard team; I'll post more details when we get further into this research.



  • Jeff Slavitz Wednesday, June 17, 2009

    We are on and have a requirement for a DR database that can also be used as a Disco 10G reporting database. The DR database will only have logs applied everyday at midnight. People reporting against the DR database will see the data from the day before. If failover is required the company is fine that it is failing over to data that is only current up through midnight.

    My plan was to open the database read/write after the logs have been applied at midnight. Just before the next midnight log apply I would flashback the database to the state it was in before opening it read/write and then let Data Guard update the logs files.

    Would this scenario work out?

    Thanks - Jeff

  • Steven Chan Thursday, June 18, 2009

    Hello, Jeff,

    Your proposed approach sounds like it would be very workable. This is the general approach that our architects have brainstormed internally (for which we'd like to be able to provide whitepapers or cookbook implementation guides). I've also heard anecdotal reports from a number of other customers have taken the same approach, too.

    The only practical consideration I'd add is about your current database level. You should note that that database version is no longer in Premier Support. In fact, the database version left Premier Support in February, 2009. So, your best bet for staying on a supported database version would be to move up to or

    I'd be very interested in hearing about your experiences in deploying this configuration.



  • Mahmoud Thursday, July 16, 2009

    dear Steven

    in my work we have this setup

    E-busine suite 11i with DB and data guard setup .

    as i know i cant access the standby becouse it is on mount stage . but also we have discover 4 using E business suite security on primary db . are ther why to connect to stanby db ?

  • Steven Chan Friday, July 17, 2009

    Hello, Mahmoud,

    I'm afraid that the only way to use the standby database for Discoverer reporting is to open it as a regular database first.

    By the way, Discoverer 4 has been desupported since October 2006. See this article for more details:

    Discoverer 4i To Be Desupported by October, 2006 - http://blogs.oracle.com/stevenChan/2006/04/discoverer_4i_to_be_desupporte.html

    I would strongly recommend that you upgrade to Discoverer 10g. See this article for details:

    Discoverer Certified with Apps 11i - http://blogs.oracle.com/stevenChan/2008/10/discoverer_10123_certified_with_apps_11i.html



  • Robin Chatterjee Monday, November 9, 2009

    Hi steven,

    of course one could combine flashback technology and oracle dataguard to have a reasonably accurate reporting database....stop managed recovery note scn open read write generate reports flashback to scn resume managed recovery...

  • Steven Chan Tuesday, November 10, 2009

    Hi, Robin,

    Thanks for your comment. You're quite right -- there are several ways of combining various Oracle technologies to achieve the goal of a reporting instance, and many customers already do this today.

    It was good to meet you at OpenWorld.



  • Yuling luke Xu Thursday, December 10, 2009

    Hi Steven,

    I really like to read your blog which I learn a lot for Apps tech and roadmap.

    Per your comment as followed


    Putting this together:

    Active Data Guard makes a read-only replication of a given database.

    Even the simple act of logging into an E-Business Suite database requires write access.

    Therefore, it may be possible to use Active Data Guard to replicate an E-Business Suite database, but there's not much benefit in doing so if your objective is to offload reporting functions from your production environment. After all, if you have an Apps read-only database that you can't access, it's not all that useful for creating standalone databases for reporting purposes.


    Will the following way be supported/certified with Oracle Apps 11i/12 on 11g database.

    (1). Configure proper Net Service Names

    (2). Create a dblink on primary database to link to itself

    (3). The created dblink is applied on active dataguard read-only database via redo-apply

    (4). Active dataguard read-only database has this dblink to primary database

    (5). Reconfigure few tables/views/synonyms which need write access on active dataguard read-only database to redirect to primary database via dblink(it has to be done on primary and then redo-apply to standby database)

    (6). Then the replica of E-Business Suite database will be useful for reporting purpose.


    Yuling luke Xu

  • Steven Chan Friday, December 11, 2009

    Hi, Yuling,

    We're working with the Active Data Guard team on an approach that will allow ADG standby databases to be used for EBS reporting purposes. This may involve new ADG enhancements and some special configuration steps for E-Business Suite environments, too.

    We wouldn't be able to provide support for your own customized approach. I would recommend that you wait for this project to conclude before attempting your own custom method for enabling writes to ADG standby databases.

    I don't have firm schedules for this certification yet, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.



  • John Stouffer Tuesday, December 15, 2009


    A lot more comments now that OpenWorld has come and gone....:-)

    While I understand the limitations of Active Data Guard and EBS and, also, that disk is cheap (thanks Mark!:-), the challenge here is that we have a 14TB Prod db which is replicated to the DR site. When you get your disks from a Systems Integrator, they say that the disk is cheap but when you get right down to it, the services provided are extremely costly. And I don't see us changing this SI for several more years....:-(

    I'm going to point some folks to this blog trail and look at some of the viable options proposed especially since we will probably only be using this for OBIEE ETL loads to the Reporting database.

    Thanks, as always, for the great information.


  • Jeff Slavitz Tuesday, January 12, 2010


    We implemented Data Guard + Flashback on It works really well. Metalink note 452056.1 guided me through the process. It's a very well written note about the mechanics of setting up, switching over and scripting the process. It misses out a few steps need for the Application when doing a switch or failover but otherwise a very complete document.

    One problem we've run into that Oracle Support hasn't been able to figure out is that XML PDF output created when we switch to the standby is not viewable when we switch back to primary even after copying the log and out files in APPLCSF and setting fnd_concurrent_requests logfile_node_name and outfile_node_name to point to the correct node. The error we get is "An error occurred while attempting to estable an Applications File Server connection with the node FNDFS_..." Any thoughts on what could be causing that?

    I am so jazzed about the possibilities of Data Guard + Flashback that I am doing a presentation at Northern California OAUG. Thanks for your help - Jeff

  • Steven Chan Wednesday, January 13, 2010

    Hi, Jeff,

    I'm very pleased that you've had success with Data Guard and Flashback. Congratulations on getting that working.

    I don't have any insight into what might be going on with the XML PDF output. Send me your Service Request number and I'll have someone in Development look at it.

    I'd be interested in seeing a your OAUG Norcal presentation; these types of things are very helpful for us to understand the issues you encountered (such as the EBS-specific steps that were missing from Note 452056.1). Mind sending me a copy?



  • Jeff Slavitz Wednesday, January 13, 2010

    Steve -

    I will email you a copy of the presentation. The Applications specific switchover steps that I follow that aren't in the note are:

    - Run cmclean.sql (note 134007.1) to avoid Output Post Processing manager not starting (this could just be happening at our site but I don't know why we would be different from others)

    - Update fnd_concurrent_requests. Change logfile_name and outfile_name to new APPLCSF path and change logfile_node_name and outfile_node_name to new host name

    - Problems viewing XML report output generated on other system. No solution found yet.

    - Update wf_notification_attributes.text_value with new node name

    - Update wf_item_attribute_values.text value with new node name

    - Check for any other profile values that contain old node name

    I appreciate your help!


  • Jeff Slavitz Wednesday, January 13, 2010

    Thanks for your help - Support came back with an answer on the problem viewing XML output created on the standby when attempting to later view it on the primary. In addition to updating fnd_concurrent_requests with the updated APPLCSF path and node name, you need to do the same to fnd_conc_req_outputs.

  • TimC Friday, January 29, 2010


    Building a new EBS R12 / 11G environment now. We will be using Oracle BI Applications also. The ETL process reads out of the EBS instance. In terms of "off-loading" this EBS instance, we are considering Active Data Guard. As we see it, this totally avoids the whole "can't access the Standby DB because access involves writes" argument, as the ETL process should do a simple read access of the underlying DB tables.

    - Is this correct?


  • Steven Chan Monday, February 1, 2010

    Hi, Tim,

    We haven't experimented with this configuration and I don't know enough about how the OBIA ETL works to comment authoritatively on what might happen here. I'd be interested in hearing more about your experiences with this particular combination of technologies.



  • Anuj Madan Thursday, March 4, 2010

    Ref - Using ADG with Oracle BI Applications.

    Hi Steve-

    Has anybody successfully implemented BI Applications with a ADG database as the source for the BI Apps ETL (Informatica)?

    And can the ADG database be subsequently used for the drill-down queries from the BI Apps data warehouse? Will it be able to provide access to the transactional Financials 11i data?

    This does not seem possible based on your blog entry dated from Oct 2008 above regarding session creation requiring write access?



  • Steven Chan Friday, March 5, 2010

    Hi, Anuj,

    I'm afraid that I don't have a lot of visibility into BI Applications + ADG configurations. Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our OBIA specialists engaged.



  • Gopal Wednesday, May 26, 2010

    Hi Steven,

    We have EBS on and DB on

    We want to take up a project to make the environment as zero downtime capable.

    We are planning to upgrade to 11gr2 for active guard feature(ofcouse for other benifits it brings in aswell) to take the benifit of highavailability feature from database perspective.

    However is RSYNC is the only solution for webtier or do we have any better solution for this?

    We want to make sure users doesnot see any system downtime during planned outages and so we want to take up this project.

    please provide your recommendations on this.

    Your response will be highly appreciated.

    Thanks in Advance!!


  • Steven Chan Wednesday, May 26, 2010

    Hi, Gopal,

    I would recommend taking a look at the whitepapers posted here:


    The ones you're looking for are in the "HA Best Practices for Oracle Applications" section.

    Good luck with your project.



  • Ramneek Sahota Thursday, August 5, 2010


    Is there any effort going on to certify Golden Gate with Oracle ERP or above from the perspective of ERP Reporting offloading?



  • Steven Chan Friday, August 6, 2010

    Hi, Ramneek,

    Yes, we're looking into the feasibility of using GoldenGate for that. An article on GoldenGate implications in on my list of topics to cover here; stay tuned.



  • guest Sunday, July 3, 2011

    We have implemented Real Time Apply Data Guard for our eBusiness environment. We would like to use our Physical Standby for reporting purpose.

    Could you please explain further or recommend any document, which includes steps and might be fruitful in order to achieve the required goal?


    Rawish Siddiqui

  • guest Monday, July 4, 2011

    Dear Steven

    Could you please advice that How many CPUs (Cores) are supported by Oracle eBusiness Applications(R12.1)?

    Actually, we would like to know something relating MultiProcessing Technology, implemented in eBusiness R12.1 during Development.

    Would appreciate your immediate response.

    Thanx in Anticipation.

    Rawish Siddiqui

  • Steven Chan Tuesday, July 5, 2011

    Hi, Rawish,

    See this externally-published article for pointers to documentation:

    Business Continuity for EBS Using Oracle 11g Physical Standby DB (Oracle E-Business Suite Technology)




  • Steven Chan Tuesday, July 5, 2011

    Hi, Rawish,

    I don't think I understand your questions.

    The E-Business Suite does not arbitrarily restrict the number of cores that can be used. Our applications tier and database tier code takes advantage of whatever server resources are available.



  • guest Wednesday, July 6, 2011

    See, I believe you already know that if you are running TAR command in Linux environment, it just uses one CPU while there are dozen number of CPUs are available. Same thing, we noticed with RMAN.

    Actually, since a long time, we were observing that one of our eBusiness environments, is using 4 to 12 CPUs though there are 16 CPUs (Dual Core) installed.

    System goes slow down despite of sufficient resources in terms of CPUs and RAM etc.

    That's why we were thinking to force eBusiness (JDBC Thin Client, FNDCPOPP etc) to Use maximum available resources.

    Now, I hope my concern would be clear.

    Need your kind comments.


    Rawish Siddiqui

  • Steven Chan Wednesday, July 6, 2011


    I'm sorry to hear that you may be having a performance issue with your environment.

    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.



  • Stephen Tuesday, October 4, 2011

    Hello Steve,

    We are on EBS and planning to have Oracle Application Express to run reports on a dedicated server (reporting server). As Oracle APEX read/writes to the database, I believe database has to be on read-write mode. What is the best way to replicate data from Production/Primary DB? Can we apply redo logs on timely intervals and open the DB for read write access? Your help is highly appreciated.



  • Steven Chan Saturday, October 8, 2011

    Hello, Stephen,

    I've heard that some companies use Data Guard and then temporarily suspend the mirror while they mount the reporting database in read-write mode. After reporting is complete, they then flashback to the pre-reporting state and restart the mirror.

    I don't have experience with this approach, myself, but it seems technically feasible to me. It also seems like a lot of work. If it were up to me, I'd take all of the resources required to support that workaround and simply beef up my production instance so that I could run reports against the primary, without all this hassle.



  • Rino Sunday, December 18, 2011

    Hi Steve,

    Is it mandatory to subscribe to DB Enterprise Edition in order to have "real application cluster" and "active data guard"? Or can I buy those separately?

    We are EBS v11.5.10.2 users. Appreciate any help.

  • Steven Chan Monday, December 19, 2011

    Hi, Rino,

    Oracle E-Business Suite Release 11i has a mandatory technical requirement for Database Enterprise Edition.



  • guest Wednesday, January 25, 2012

    Very good information Steven.

    We are on 12.0.6 with DB configured with physical stand by database. We are using Primary DB for reporting (discoverer). After going through all the information above, i want to know if this works :

    1. Setup another Physical stand by database with active Dataguard

    2. Use this standby database for reporting

    ( Open the db in read write during reporting and use flash back option to get the logs applied when reporting is done)

    3. We can use the first standby database (with out active dataguard) to continue applying the logs so that if there is any issue with Active dataguard stby db, we will have another standy db avaiable.

    Is it correct?

    I dont understand one thing here is when we using dataguard+flash back, what about the changes which we do while we are in reporting mode. Are they lost ?



  • Elke Phelps (Oracle Development) Thursday, January 26, 2012


    Thank you for your inquiry.

    1. Yes, this is possible.

    2. Yes, this is possible. Note that you do not need Active Dataguard to perform this function as described. This may be achieved with a physical standby (regular dataguard).

    With versions 11g and greater of the database, Snapshot Standby Databases are an option. Snapsthot Standby Databases are created from physical standby databases. Snapshot Standby Databases are fully updatable and can be converted back into a physical standby database. For additional details regarding Snapshot Standby Databases, please refer to the Oracle Data Guard Concepts and Administration Guide.

    3. Yes, you can use the first standby as described.

    Yes, the changes made in reporting mode are lost.

    Thanks again and good luck with your deployment.



  • zach Monday, July 30, 2012

    Hi Steve,

    You have said "We do not support the use of this feature with logical standby databases due to the lack of Oracle LogMiner support for certain datatypes used in the E-Business Suite."

    I wonder what those data types that the LogMiner is/was not supporting are.

  • Steven Chan Monday, July 30, 2012
  • guest Thursday, August 23, 2012

    Hi Steve,

    Can you comment on this proposed solution?

    EBS version 12.1.x

    Database version 11.2.x

    We would like to use Data Guard (Active or "Standard" whichever version would be appropriate) to create a replica of our production eBS database. We would then like to use Streams to populate a different instance for reporting purposes. Would this work?



  • Elke Phelps (Oracle Development) Thursday, August 30, 2012


    Thanks for your inquiry.

    Using Data Guard or Active Data Guard in conjuction with Streams is an option for EBS customers.

    Documentation for using Data Guard or Active Data Guard with E-Business Suite does not include how to use Streams to replicate data to another database. You will need to determine which objects to replicate.

    There are also datatype limitations when replicating with Streams. As such, you will need to assess if all of the E-Business Suite objects you wish to replicate are fully supported by Streams.

    Good luck with your project!




  • Prasad Wednesday, April 24, 2013

    Hi All,

    We are using Active Data Guard for OBIEE 11g -EBS R12 security intergratiom.. but we are not able to intitialize EBS sessions, so reports are not working..becuase some of the reports using oracle global temp because global temp tables are for each session and APPS security initialize are for only that session..Also is the OBIEE scheduling will not work on Active data guard for EBS security.

    Please help ..any qorkaround for OBIEE 11g with EBS integration on ADG.



  • Steven Chan Wednesday, April 24, 2013

    Hello, Prasad,

    I'm sorry to hear that you've encountered an issue with this. I'm told that OBIEE is certified with Active Data Guard running against an EBS instance. That certification is produced by the OBIEE team. I'm part of the E-Business Suite division and afraid that I don't have sufficient expertise in that area to provide any help here.

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



  • guest Thursday, December 19, 2013

    Dear Steven,

    I need a very simple understanding from your-side.

    Active Data Guard, is only support for EBS reporting purpose ?

    Is there any other purpose and/or feature of it ?



  • Steven Chan Thursday, December 19, 2013

    Hello, Asif,

    Its primary use in EBS environments is to allow reporting while serving as a failover database. Active Data Guard has other features listed here:




  • Nikhil Tuesday, March 29, 2016


    Does 12c DB along with Physical standby supported with ERP on IBM AIX 6.1 TL 7 supported?

    Currently we are on 11g( DB.



  • Elke Phelps (Oracle Development) Tuesday, March 29, 2016


    Oracle E-Business Suite Release is certified with Database 12c. Data Guard is not certified with EBS 11i and Database 12c.

    We concentrated our resources and efforts on certifying Oracle E-Business Suite 12.1 and 12.2 with Database and and additional database features (TDE, DG, ADG, etc) for these version combinations.

    Currently, we are working on additional optional certifications for Oracle E-Business Suite 12.1 and 12.2. We are not currently planning to certify any additional database features with Oracle E-Business Suite

    Given the support timeline for Oracle E-Business Suite 11i, we highly recommend that you and other customers that may still be running 11i, upgrade to Oracle E-Business Suite Release 12.2.



  • guest Tuesday, August 9, 2016

    Hi. Elke Phelps

    is 12c DB along with Physical standby supported with EBS 12.1.3 or, to achieve this (use the resource @ DR) what are the new ways???

  • rajesh Tuesday, August 9, 2016

    Hi elke

    what are the new methods to achieve this, our environment ebs r12.1.3 running on exadata x/4, planing for a DR with the same config. need to use the hardware for at least reporting.



  • Elke Phelps (Oracle Development) Tuesday, August 23, 2016


    Yes, Oracle E-Business Suite 12.1.3 is certified with Physical Standby Database 12c. Please refer to the following MOS Note for instructions and options:

    Business Continuity for Oracle E-Business Suite Release 12.1 Using Oracle 12c Physical Standby Database (Doc ID 1900663.1)



  • guest Tuesday, August 23, 2016


    Thanks for the inquiry. Please refer to the following for details and options:

    1. Business Continuity for Oracle E-Business Suite Release 12.1 Using Oracle 12c Physical Standby Database (Doc ID 1900663.1)

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

    3. Oracle E-Business Suite and Oracle Maximum Availability Architecture Best Practices (February 2014) available here:




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