Configuring Oracle Data Guard for IBM Business Process Manager
When IBM Business Process Manager is configured to use Oracle Data Guard, you typically have one production database, which is your primary database, and several standby databases. Then Oracle Data Guard automatically maintains each standby database by transmitting redo data from the primary database and applying the redo data to the standby database. If your production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard enables you to switch any standby database to the production role, minimizing the downtime that is associated with the outage.
Oracle Data Guard automatically maintains each standby database by transmitting redo data from the primary database and then applying the redo to the standby database.
A Typical Data Guard Configuration
Procedure
What to do next
IBM Business Process Manager creates the JDBC URL in the following default format:
jdbc:oracle:thin:@//LISTENER_HOST:LISTENER_PORT/SERVICE_NAME
To use the Net connection descriptor URL, specify it in a format similar to the following example (but in a single input line) using the bpm.de.db.#.url property:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host_A)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host_B)(PORT=1521))
(LOAD_BALANCE=off)(FAILOVER=on))
(CONNECT_DATA=(SERVICE_NAME=service_name)))