My Oracle Support Banner

Failover/Reinstate within Dataguard configuration fails with ORA-16653 /ORA-16795 (Doc ID 1161094.1)

Last updated on OCTOBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2012***
***Checked for relevance on 5-Aug-2014***
** checked for relevance '23-Nov-2015' **

Purpose

Physical standby database is managed by the broker.

After a successful failover with Dataguard Broker (dgmgrl) to a physical standby database
"dgmgrl > show configuration" returns ORA-16661 and other messages:



DGMGRL> show configuration;

Configuration - physDG112

Protection Mode: MaxPerformance
Databases:
db112 - Primary database
stdb112 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> failover to stdb112;
Performing failover NOW, please wait...
Failover succeeded, new primary is "stdb112"
DGMGRL> show configuration;

Configuration - physDG112

Protection Mode: MaxPerformance
Databases:
stdb112 - Primary database
db112 - Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> reinstate database db112
Reinstating database "db112", please wait...
Error: ORA-16653: failed to reinstate database

Failed.
Reinstatement of database "db112" failed


-> ORA- 16653 at first attempt to re-instate database


DGMGRL> reinstate database db112
Reinstating database "db112", please wait...
Error: ORA-16795: the standby database needs to be re-created

Failed.
Reinstatement of database "db112" failed


-> ORA-16795 at 2nd attempt to re-instate database

Troubleshooting Steps

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
Purpose
Troubleshooting Steps

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