ORA-16795: the standby database needs to be re-created, Recreate DB Broker

 <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

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log