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

[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.

DGOverview.gif

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

Comments:

Steve,

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?

Thanks.
Naveen Garg

Posted by Naveen on October 11, 2008 at 03:08 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 13, 2008 at 05:20 AM PDT #

Steven,

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

Posted by Jay Weinshenker on October 13, 2008 at 10:40 PM PDT #

Steven,

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?

thx,
John

Posted by John Stouffer on October 14, 2008 at 12:30 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 14, 2008 at 02:31 AM PDT #

John,

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.

Regards,
Steven

Posted by Steven Chan on October 14, 2008 at 02:37 AM PDT #

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

Posted by Sandra Vucinic on October 27, 2008 at 05:22 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 28, 2008 at 07:17 AM PDT #

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.

Regards,

mwf

Posted by Mark W. Farnham on November 04, 2008 at 05:29 PM PST #

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.

Regards,
Steven

Posted by Steven Chan on November 06, 2008 at 05:44 AM PST #

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

Sandra

Posted by Sandra Vucinic on November 06, 2008 at 12:04 PM PST #

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.

Regards
Chirag

Posted by Chirag on January 05, 2009 at 11:16 PM PST #

Dear Steven,

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

Regards
Daminda

Posted by Daminda Wanasundera on January 06, 2009 at 06:16 PM PST #

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.

Regards,
Steven

Posted by Steven Chan on January 07, 2009 at 05:25 AM PST #

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

Posted by Kam Chan on April 21, 2009 at 11:05 PM PDT #

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.

Regards,
Steven

Posted by Steven Chan on April 22, 2009 at 02:25 AM PDT #

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.

Regards

Prakash

.

Posted by Prakash on May 06, 2009 at 12:31 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on May 20, 2009 at 02:12 AM PDT #

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.

Posted by Dave Bennett on May 21, 2009 at 12:01 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on May 22, 2009 at 05:00 AM PDT #

Steve,
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.

Posted by Dhanraj Pondicherry on June 16, 2009 at 08:38 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on June 17, 2009 at 01:39 AM PDT #

We are on 11.5.10.2/10.2.0.2 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

Posted by Jeff Slavitz on June 17, 2009 at 02:44 AM PDT #

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 10.2.0.2 database level. You should note that that database version is no longer in Premier Support. In fact, the 10.2.0.3 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 10.2.0.4 or 11.1.0.7.

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

Regards,
Steven

Posted by Steven Chan on June 18, 2009 at 06:36 AM PDT #

dear Steven
in my work we have this setup

E-busine suite 11i with DB 9.2.0.6.0 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 ?

Posted by Mahmoud on July 15, 2009 at 08:38 PM PDT #

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 10.1.2.3 Certified with Apps 11i - http://blogs.oracle.com/stevenChan/2008/10/discoverer_10123_certified_with_apps_11i.html

Regards,
Steven

Posted by Steven Chan on July 17, 2009 at 03:57 AM PDT #

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

Posted by Robin Chatterjee on November 09, 2009 at 11:12 AM PST #

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.

Regards,
Steven

Posted by Steven Chan on November 10, 2009 at 02:50 AM PST #

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.

Regards,
Yuling luke Xu

Posted by Yuling luke Xu on December 10, 2009 at 09:16 AM PST #

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.

Regards,
Steven

Posted by Steven Chan on December 11, 2009 at 05:38 AM PST #

Steven,

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.

John

Posted by John Stouffer on December 15, 2009 at 12:23 AM PST #

Steve,
We implemented Data Guard + Flashback on 10.2.0.4/11.5.10. 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

Posted by Jeff Slavitz on January 12, 2010 at 08:16 AM PST #

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?

Regards,
Steven

Posted by Steven Chan on January 13, 2010 at 02:33 AM PST #

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

Posted by Jeff Slavitz on January 13, 2010 at 04:19 AM PST #

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.

Posted by Jeff Slavitz on January 13, 2010 at 11:37 AM PST #

Greetings,
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?

Thanks

Posted by TimC on January 29, 2010 at 05:52 AM PST #

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.

Regards,
Steven

Posted by Steven Chan on February 01, 2010 at 02:44 AM PST #

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?

Regards.
Anuj.

Posted by Anuj Madan on March 03, 2010 at 10:28 PM PST #

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.

Regards,
Steven

Posted by Steven Chan on March 05, 2010 at 03:41 AM PST #

Hi Steven,

We have EBS on 11.5.10.2 and DB on 10.2.0.4.

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!!

Gopal

Posted by Gopal on May 25, 2010 at 11:52 PM PDT #

Hi, Gopal,

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

http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

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

Good luck with your project.

Regards,
Steven

Posted by Steven Chan on May 26, 2010 at 05:47 AM PDT #

Steven,

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

Regards,
Ramneek

Posted by Ramneek Sahota on August 05, 2010 at 02:27 PM PDT #

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.

Regards,
Steven

Posted by Steven Chan on August 06, 2010 at 02:04 AM PDT #

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?

Regard.
Rawish Siddiqui

Posted by guest on July 02, 2011 at 05:40 PM PDT #

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

Posted by guest on July 03, 2011 at 07:53 PM PDT #

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)
http://blogs.oracle.com/stevenChan/entry/oracle_data_guard_11g_ebs

Regards,
Steven

Posted by Steven Chan on July 05, 2011 at 03:37 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on July 05, 2011 at 03:45 AM PDT #

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.

Thanx.
Rawish Siddiqui

Posted by guest on July 05, 2011 at 07:42 PM PDT #

Rawish,

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.

Regards,
Steven

Posted by Steven Chan on July 06, 2011 at 04:10 AM PDT #

Hello Steve,

We are on EBS 11.5.10.2 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.

Thanks,
Stephen.

Posted by Stephen on October 04, 2011 at 10:47 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on October 08, 2011 at 06:15 AM PDT #

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.

Posted by Rino on December 17, 2011 at 06:55 PM PST #

Hi, Rino,

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

Regards,
Steven

Posted by Steven Chan on December 19, 2011 at 04:01 AM PST #

Very good information Steven.

We are on 12.0.6 with 11.2.0.2 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 ?

Thanks,
KK

Posted by guest on January 25, 2012 at 06:26 AM PST #

KK,

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.

Regards,
~ep

Posted by Elke Phelps (Oracle Development) on January 26, 2012 at 10:37 AM PST #

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.

Posted by zach on July 30, 2012 at 12:11 PM PDT #

Hi, Zach,

See:

http://docs.oracle.com/cd/B28359_01/server.111/b28319/logminer.htm#i1031090

Regards,
Steven

Posted by Steven Chan on July 30, 2012 at 12:26 PM PDT #

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?

Regards,
Tom

Posted by guest on August 23, 2012 at 09:07 AM PDT #

Tom,

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!
Regards,
Elke

Regards,

Posted by Elke Phelps (Oracle Development) on August 30, 2012 at 07:23 AM PDT #

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.

Thanks,
Prasad

Posted by Prasad on April 24, 2013 at 06:37 AM PDT #

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.

Regards,
Steven

Posted by Steven Chan on April 24, 2013 at 07:38 AM PDT #

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 ?

Thanks
Asif

Posted by guest on December 18, 2013 at 11:54 PM PST #

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:

http://www.oracle.com/us/products/database/options/active-data-guard/overview/index.html

Regards,
Steven

Posted by Steven Chan on December 19, 2013 at 09:36 AM PST #

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
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today