How to create a broker configuration in Oracle database 11g.
1- Create Data Guard broker configuration (Connect in primary database server)
bash-4.1$ dgmgrl sys/*******
DGMGRL for Solaris: Version 11.2.0.2.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL>
2- Check if configuration exists (So, we'll need to create the configuration with broker between Primary and stand by server) :
DGMGRL> show configuration;
ORA-16532: Data Guard broker configuration does not exist
Configuration details cannot be determined by DGMGRL
DGMGRL>
3- Create configuration :
3.1 DGMGRL> CREATE CONFIGURATION 'tst_pr' AS PRIMARY DATABASE IS 'tst_pri' CONNECT IDENTIFIER IS 'tst_pri';
Configuration "tst" created with primary database "tst_pri"
DGMGRL>
3.2 DGMGRL> enable configuration;
Enabled.
DGMGRL>
3.3 DGMGRL> ADD DATABASE 'tst_drp' AS CONNECT IDENTIFIER IS tst_drp MAINTAINED AS PHYSICAL;
Database "tst_drp" added
DGMGRL>
3.4 DGMGRL> enable database tst_drp;
Enabled.
DGMGRL>
Comments