In the previous post we created a standby database using the dbca in silent mode
In this post we will do the necessary to put this configuration in a broker config
On the primary
alter system set standy_file_management=’AUTO’;
alter system set dg_broker_config_file1=’+DATA2/c20v02t1/DATAGUARDCONFIG/dr1.dat’ ;
alter system set dg_broker_config_file2=’+RECO2/c20v02t1/DATAGUARDCONFIG/dr2.dat’ ;
alter system set dg_broker_start= true;
alter database flashback on;
On the Standby
alter system set standby_file_management=’AUTO’;
alter system set dg_broker_config_file1=’+DATA1/c20v01t1/DATAGUARDCONFIG/dr1.dat’ ;
alter system set dg_broker_config_file2=’+RECO1/c20v01t1/DATAGUARDCONFIG/dr2.dat’ ;
alter system set dg_broker_start= true;
alter database flashback on;
What is left to do
Create static listener entries
Depending on the node ( node1 will have cdbt011 node2 cdbt012 ) add following to you SID_LIST_LISTENER
(SID_DESC =
(SID_NAME = cdbt011)
(ORACLE_HOME = /u01/app/oracle/product/19.5.0.0/dbhome_1)
(GLOBAL_DBNAME = c99v02t1_DGMGRL.acme.com)
)
Add the tnsnames entries specifically for DG
#——————–
#c99v01t1 on EXA22
#——————–
c99v01t1.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan1.acme.corp)(port=1500))
(connect_data=(service_name=c99v01t1.acme.com)))
c99v01t1_bck1.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan1.acme.corp)(port=1500))
(connect_data=(service_name=c99v01t1_bck1.acme.com)))
c99v01t1_bck2.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan1.acme.corp)(port=1500))
(connect_data=(service_name=c99v01t1_bck2.acme.com)))
c99v01t1_dgmgrl.acme.com = (description = (address = (protocol=tcp)(host=exa99db01vm01-vip.acme.corp)
(port=1500))(connect_data=(service_name=c99v01t1_dgmgrl.acme.com)))
c99v01t1_dgmgrl.acme.com = (description = (address = (protocol=tcp)(host=exa99db02vm01-vip.acme.corp)
(port=1500))(connect_data=(service_name=c99v01t1_dgmgrl.acme.com)))
c99v02t1.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan2.acme.corp)(port=1500))
(connect_data=(service_name=c99v02t1.acme.com)))
c99v02t1_bck1.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan2.acme.corp)(port=1500))
(connect_data=(service_name=c99v02t1_bck1.acme.com)))
c99v02t1_bck2.acme.com = (description = (address = (protocol=tcp)(host=exa99-scan2.acme.corp)(port=1500))
(connect_data=(service_name=c99v02t1_bck2.acme.com)))
c99v02t1_dgmgrl.acme.com = (description = (address = (protocol=tcp)(host=exa99db01vm02-vip.acme.corp)
(port=1500))(connect_data=(service_name=c99v02t1_dgmgrl.acme.com)))
c99v02t1_dgmgrl.acme.com = (description = (address = (protocol=tcp)(host=exa99db02vm02-vip.acme.corp)
(port=1500))(connect_data=(service_name=c99v02t1_dgmgrl.acme.com)))
We are ready to create the Data Guard Broker Configuration
–connect to the primary
dgmgrl sys/@C99V02T1
CREATE CONFIGURATION dgconfig AS PRIMARY DATABASE IS C20V02T1 CONNECT IDENTIFIER IS C20V02T1.ACME.COM;
ADD DATABASE C20V01T1 AS CONNECT IDENTIFIER IS C20V01T1.ACME.COM;
ENABLE CONFIGURATION;
dgmgrl sys/@c99v02t1.acme.com
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Apr 27 09:43:12 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "c20v02t1"
Connected as SYSDBA.
DGMGRL> show configuration verbose
Configuration - dgconfig
Protection Mode: MaxPerformance
Members:
c20v02t1 - Primary database
c20v01t1 - 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 = 'cdbt01_CFG'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
