My Oracle Support Banner

How To Set Up Database Failover using DataGuard for FMW Infrastructure 12c RCU Created Metadata Repository Schemas (Doc ID 2142417.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Middleware - Version and later
Oracle Forms - Version and later
Business Intelligence Server Enterprise Edition - Version 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?

Detailed explanation:

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 backup host 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.