My Oracle Support Banner

Configuring Multiple FSFO Targets - FastStartFailoverTarget (Doc ID 2951447.1)

Last updated on NOVEMBER 29, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

From 12.2 we have an option to configure multiple standby databases as a FSFO target in multi standby environment.

Upon setting multiple FastStartFailoverTarget broker will select target target on the order of standbys specified.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Primary database: PROD
Standby database: PROD_sb1
Standby database: PROD_sb2

 

 

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
  TEST CASE
 1. Shutdown the first standby PROD_sb1
 2. Shutdown PROD (this for testing purpose)
 3. FSFO triggered on PROD_sb2
 4. PROD_sb12 is now new PRIMARY
References


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