Reinstate failed for Data Guard: Flashback Database is disabled

While you have an Oracle Data Guard replication, and for some reasons you cannot switchover to standby but you can failover, and in this case we are going to list the steps and the errors if you want to reinstate database.

Steps:

• Connect to the standby with DGMDRL
• Failover the Oracle database
• Reinstate the old Primary: Error: ORA-16827: Flashback Database is disabled

A. Connect to the standby with DGMDRL

$ dgmgrl sys/oracle_4U@wadodbsb
 DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat May 27 06:21:38 2023
 Version 19.19.0.0.0
 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 Welcome to DGMGRL, type "help" for information.
 Connected to "wadodbsb"
 Connected as SYSDBA.
 DGMGRL> show configuration;
 Configuration - wadohr
 Protection Mode: MaxPerformance
   Members:
   wadodb   - Primary database
     wadodbsb - Physical standby database
 Fast-Start Failover:  Disabled
 Configuration Status:
 SUCCESS   (status updated 14 seconds ago)

B. Failover the Oracle database

DGMGRL> failover to wadodbsb;
 Performing failover NOW, please wait…
 Failover succeeded, new primary is "wadodbsb"
 DGMGRL>

C. Reinstate the old Primary: Error: ORA-16827: Flashback Database is disabled

In our case the Flashback database is disabled, that’s why the reinstate not succeed.

DGMGRL> show configuration;
 Configuration - wadohr
 Protection Mode: MaxPerformance
   Members:
   wadodbsb - Primary database
     wadodb   - Physical standby database (disabled)
       ORA-16661: the standby database needs to be reinstated
 Fast-Start Failover:  Disabled
 Configuration Status:
 SUCCESS   (status updated 9 seconds ago)
 DGMGRL>
 DGMGRL> reinstate database wadodb;
 Reinstating database "wadodb", please wait…
 Operation requires shut down of instance "wadodb" on database "wadodb"
 Shutting down instance "wadodb"…
 Connected to "wadodb"
 ORACLE instance shut down.
 Operation requires start up of instance "wadodb" on database "wadodb"
 Starting instance "wadodb"…
 Connected to an idle instance.
 ORACLE instance started.
 Connected to "wadodb"
 Database mounted.
 Continuing to reinstate database "wadodb" …
 Error: ORA-16827: Flashback Database is disabled
 Failed.
 Reinstatement of database "wadodb" failed
 DGMGRL>

Conclusion:

To reinstate Oracle database after an failover, the flashback Oracle database should be enabled.

check this link.

Reinstate for Data Guard succeeded