Managing EBS 12 Physical Standby Databases with Oracle Data Guard Broker

allows you to create standby databases for disaster recovery.  Oracle Data Guard Broker provides an easy interface to configure standby databases and to perform role transitions with a single command for switchover and failover.  It logically groups the primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. Oracle Data Guard Broker can automate the following operations:

  • Creation of Data Guard configurations incorporating a primary database, a new or existing (physical or logical) standby database, log transport services, and log apply services, where any of the databases could be Real Application Clusters (RAC) databases.
  • Adding up to 8 additional new or existing (physical or logical, RAC, or non-RAC) standby databases to each existing Data Guard configuration, for a total of one primary database, and from 1 to 9 standby databases in the same configuration.
  • Managing an entire Data Guard configuration, including all databases, log transport services, and log apply services, through a client connection to any database in the configuration.
  • Invoking switchover or failover with a single command to initiate and control complex role changes across all databases in the configuration.
  • Monitoring the status of the entire configuration, capturing diagnostic information, reporting statistics such as the log apply rate and the redo generation rate, and detecting problems quickly with centralized monitoring, testing, and performance tools.

Oracle Data Guard architecture overview diagram

There are two interfaces to manage broker configurations:

  1. Oracle Enterprise Manager (Graphical User Interface)
  2. Data Guard command-line interface (DGMGRL).

If you've implemented standby databases as part of your EBS disaster recovery or business continuity strategy, we'd recommend that you consider using Data Guard Broker, too.  We've provided step-by-step configuration instructions to use the Data Guard Broker [DGMGRL]  tool to manage Physical Standby databases for E-Business Suite Release 12. For detailed instructions, see:

Failover with E-Business Suite environments is not automatic.  E-Business Suite environments must be failed over manually due to the need to run AutoConfig to reconfigure services on the failover site.

References

Related Articles

posted @ 2011-09-06 09:40  dbblog  阅读(495)  评论(0)  编辑  收藏  举报