How To Set Up Database Failover using DataGuard for FMW Infrastructure 12c RCU Created Metadata Repository Schemas
Last updated on NOVEMBER 16, 2017
Applies to:Oracle Fusion Middleware - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
How do we configure the Oracle Fusion Middleware RCU created schemas to failover to a backup Oracle Database where Dataguard was used?
Oracle Fusion Middleware 12c Infrastructure installs following schemas in the database:
If the database is configured for failover using DataGuard, the failover entries in the tnsnames.ora may look like following:
When the primary db goes down service switches to the backuphost server, so there is a tolerated delay in this case. Once the switch is made, data access resumes.
FMW connections do not use tnsnames.ora, connections are made through JDBC datasource configurations, following configuration will allow FMW RCU created schema to switch over.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms