<aside> 💡 The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the standby database needs to be re-created” while querying DGMGRL.
</aside>
DGMGRL> show configuration verbose;
Configuration – failover
Protection Mode: MaxPerformance
Members:
PRODDB- Primary database
STANDBYDB – Physical standby database (disabled)
ORA-16795: the standby database needs to be re-createdStop broker in both of primary and standby databases
Cause::
Since the data is being synchronized from Primary to Standby and no lag has been observed; this issue could be related to DG Broker.
Resolution:
Stop broker in both of primary and standby databases
ALTER SYSTEM SET DG_BROKER_START=FALSE scope=both sid='*';
Drop old broker configuration files from both primary and standby:
SQL> show parameter dg_broker_config_file
Get the values of the DB Broker files from Standby and Primary, take a backup and delete the sameStart broker in both of primary and standby
Start broker in both of primary and standby
ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid='*';
Connect to DGMGRL on primary:
DGMGRL> connect sys/xxxxxx as sysdba
Connected to “PRODDB”
Connected as SYSDBA.
DGMGRL> create configuration ‘PRODDB’ as primary database is ‘PRODDB’ connect identifier is PRODDB;
Configuration “PRODDB” created with primary database “PRODDB”
DGMGRL> ADD DATABASE ‘STANDBYDB’ AS CONNECT IDENTIFIER IS STANDBYDB MAINTAINED AS PHYSICAL;
Database “STANDBYDB” added
DGMGRL> ENABLE CONFIGURATION;
Enabled.
DGMGRL> ENABLE DATABASE ‘PRODDB’;
Enabled.
DGMGRL> ENABLE DATABASE ‘STANDBYDB’;
Enabled.
DGMGRL> SHOW CONFIGURATION verbose;
Configuration – PRODDB
Protection Mode: MaxPerformance
Members:
PRODDB- Primary database
STANDBYDB – Physical standby database
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ’30’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘PRODDB’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS