Data Guard Failover fails with ORA-16472 for MAX AVAILABILITY + FASTSYNC Conf...

刘泽宇

现象：
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Primary Site:
DB_Name: chicago, DB_unique_name: chicago, Net Connection Alias: chicago

Standby Site:
DB_Name: chicago, DB_unique_name: boston, Net Connection_Alias: boston
DataGuard Broker FSFO configuration  fails with ORA-16472 where protection mode is MAX AVAILABILITY + FASTSYNC MODE

Observer log shows:

Initiating Fast-Start Failover to database "boston"...
[S010 2021-06-27T10:27:09.072+09:00] Initiating Fast-start Failover.
Performing failover NOW, please wait...
ORA-12543: TNS:destination host unreachable
Unable to connect to database using boston
Error: ORA-16472: failover failed due to data loss
Changes
Log Transport configured for MAX AVAILABILITY + FASTSYNC Mode.

LogXptMode = 'FASTSYNC'

log_archive_dest_2 = service="boston", SYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 reopen=300 db_unique_name="boston" net_timeout=30, valid_for=(online_logfile,all_roles)
原因：
The issue was investigated in unpublished Bug 33087116 - FAILOVER FAILED WITH ORA-16472 FOR MAX AVAILABILITY + FASTSYNC MODE

which is a duplicate of Bug 33028462 - FAILOVER FAILED FOR MAX AVAILABILITY + FAST SYNC MODE FOR ALL DB VERSIONS

处理方法：
Apply Patch  for Bug 33028462 at both Primary and Standby, if available for your version and platform.

To check for conflicting patches, please use the My Oracle Support (MOS) Patch Planner Tool.