Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

Posted by Steven Chan on Oracle Blogs See other posts from Oracle Blogs or by Steven Chan
Published on Thu, 06 Jan 2011 11:15:22 -0800 Indexed on 2011/01/06 20:57 UTC
Read the original article Hit count: 799

Filed under: Error when finding categories...
For most Oracle Database users, Oracle Active Data Guard allows users to:
  1. Create a physical standby database for business continuity and disaster recovery
  2. Offload reporting from the production database to the read-only physical standby database
E-Business Suite customers have been able to use Active Data Guard to create physical standby databases for their EBS environments since the feature was introduced with the 11g Database.  EBS sysadmins can use the generic Active Data Guard documentation to take advantage of the Active Data Guard standby database capabilities. 

I am pleased to announce that it is now possible to offload a subset of some ReportWriter-based reports -- but not all -- from a production EBS environment to an Active Data Guard physical standby database.  But before I go into the details of this newly-certified configuration, it's necessary to understand some details about what happens whenever someone attempts to access the E-Business Suite.

adg_diagram.png

© Oracle Blogs or respective owner