Offloading (Some) EBS 12 Reporting to Active Data Guard Instances
- by Steven Chan
For most Oracle Database users, Oracle Active Data Guard allows users to:Create a physical standby database for business continuity and disaster recoveryOffload reporting from the production database to the read-only physical standby databaseE-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.