Here we will configure the data Guard Broker
. Here are the steps :
Primary Databse
= Prod
Standby Database = Prodstd
Step 1 : Check the Data Guard Broker process
SQL> sho parameter dg_broker
NAME
TYPE
VALUE
-----------------
---------- ----------
dg_broker_start boolean
FALSE
Step 2 : Start the Data Guard Broker Process on Primary database
SQL>alter system set dg_broker_start=true scope=both;
System altered.
Step 3 : Check DG_BROKER on standby database and start it
SQL> sho parameter dg_broker
NAME
TYPE
VALUE
-----------------
---------- ----------
dg_broker_start
boolean FALSE
SQL>alter system set dg_broker_start=true scope=both ;
System altered.