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

Error:

We see the error ORA-16795: the standby database needs to be re-created" while querying DGMGRL. But the data synchronization was working.

DGMGRL> show configuration verbose;

Configuration – failover

Protection Mode: MaxPerformance

Members:

BEEDB- Primary database

BEESTDY – Physical standby database (disabled)

Since the data is being synchronized from Primary to Standby and no lag has been observed.

I used below to solve the issue.

Steps:

1. Stop broker in both of primary and standby databases

ALTER SYSTEM SET DG_BROKER_START=FALSE scope=both sid='*';

2. 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 same

3. Start broker in both of primary and standby

ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid='*';

4. Connect to DGMGRL on primary:

DGMGRL> connect sys/xxxxxx as sysdba

Connected to "BEEDB"

Connected as SYSDBA.

DGMGRL> create configuration 'BEEDB' as primary database is 'BEEDB' connect identifier is BEEDB;

Configuration "BEEDB" created with primary database "BEEDB"

DGMGRL> ADD DATABASE 'BEESTDY' AS CONNECT IDENTIFIER IS BEESTDY MAINTAINED AS PHYSICAL;

Database "BEESTDY" added

DGMGRL> ENABLE CONFIGURATION;

Enabled.

DGMGRL> ENABLE DATABASE 'BEEDB';

Enabled.

DGMGRL> ENABLE DATABASE 'BEESTDY';

Enabled.

DGMGRL> SHOW CONFIGURATION verbose;

Configuration – BEEDB

Protection Mode: MaxPerformance

Members:

BEEDB- Primary database

BEESTDY – 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 = 'BEEDB'

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

If you like please follow and comment

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