Steps to Configure DG Broker for physical Standby(Assume Prod as primary and Stan as standby Database in this Scenario).
The Data Guard command-line interface (DGMGRL) enables you to manage a Data Guard broker configuration and its databases
directly from the command line, or from batch programs or scripts.
Set up Primary and Standby Database - Use Spfile on both
Enable on P&S.
alter system set dg_broker_start="true" scope=both;
Make sure - Primary - db_unique_name=prod
Standby - db_unique_name=stan
Verify Protection Mode - performance mode.
#Connect to Primary from remote/local using DGMGRL.
DGMGRL> connect sys/sys123@prod;
DGMGRL>CREATE CONFIGURATION 'UNIDG' AS
> PRIMARY DATABASE IS 'prod'
> CONNECT IDENTIFIER IS prod;
#Output : Configuration "UNIDG" created with primary database "prod"
#Display Configuration :
DGMGRL> SHOW CONFIGURATION;
Configuration
Name: UNIDG
Enabled: NO
Protection Mode: MaxPerformance
Databases:
prod - Primary database
Current status for "UNIDG":
DISABLED
#Now add Standby to config
DGMGRL> ADD DATABASE 'stan' AS
> CONNECT IDENTIFIER IS stan
> MAINTAINED AS PHYSICAL;
Database "stan" added.
DGMGRL> SHOW CONFIGURATION;
Configuration
Name: UNIDG
Enabled: NO
Protection Mode: MaxPerformance
Databases:
prod - Primary database
stan - Physical standby database
Current status for "UNIDG":
DISABLED