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 MARCH 12, 2021

Applies to:

Oracle Fusion Middleware - Version 12.2.1.0.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Goal

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).

Note: In other words, you are not using an Oracle RAC Database for the Metadata Repository. The discussion comparing DataGuard vs RAC for High Availability options is not the scope of this document. It does include Oracle Documentation references, if interested. The assumption here is that you already have an Oracle Database using DatabGuard setup and working. You want to know how to use this with Fusion Middleware.


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?"

Detailed explanation:

Oracle Fusion Middleware 12c Infrastructure installs following schemas in the database:

<prefix>_IAU_APPEND
<prefix>_OPSS
<prefix>_WLS_RUNTIME
<prefix>_IAU
<prefix>_WLS
<prefix>_STB
<prefix>_IAU_VIEWER

If the database is configured for failover using DataGuard, the failover entries in the tnsnames.ora may look like following:

(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=XXXX))
(ADDRESS=(PROTOCOL=TCP)(HOST=backuphost.domain.com))(PORT=XXXX)))
(load_balance=no)(failover=on)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=my_db.doman.com)))

Notes:

 The question is if this Dataguard feature may be used for the FMW Metadata Repository schemas and if so, how?

Solution

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
Goal
Solution
References


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