200
<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