How To Set Up Database Failover using DataGuard for FMW Infrastructure 12c RCU Created Metadata Repository Schemas
(Doc ID 2142417.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Fusion Middleware - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
It has already been determined that you wish to use Database Failover using DataGuard (or already have this setup and working at the Database level).
The question asked to prompt this document is: "How do we configure the Oracle Fusion Middleware RCU created schemas to failover to a backup Oracle Database where Dataguard is 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 backup host server, there is a tolerated delay in this case. Once the switch is made, data access resumes. This is the nature of the DataGuard Failover (as opposed to a RAC Database which would be more continually seamless by its nature).
- FMW connections do not use tnsnames.ora, such as used on other DataGuard use cases. For Fusion Middleware using WebLogic Server, connections are made through JDBC datasource configurations, following configuration will allow FMW RCU created schema to switch over.
The question is if this Dataguard feature may be used for the FMW Metadata Repository schemas and if so, how?
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