DB version: 12.1.0.2 on Oracle Linux 6.7
Type : Physical standby
I am trying to configure data guard broker for my Standalone DB . Both primary and phyical standby are standalone DBs.
As the first step , I tried to create broker configuration files in the following locations. But, It is not getting created at OS level.
Any idea why ?
SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE1 = '/oradata/DG_BROKER/dr1APGCMS.dat' scope=both;
System altered.
SQL> ALTER SYSTEM SET DG_BROKER_CONFIG_FILE2 = '/datastore/DG_BROKER/dr2APGCMS.dat' scope=both;
System altered.
--- The config files didn't get created at OS level
$ ls -l /oradata/DG_BROKER/dr1APGCMS.dat
ls: cannot access /oradata/DG_BROKER/dr1APGCMS.dat: No such file or directory
$
$
$ ls -l /datastore/DG_BROKER/dr2APGCMS.dat
ls: cannot access /datastore/DG_BROKER/dr2APGCMS.dat: No such file or directory
So, I thought the config files will be created only when dmon is started. So, I started it using
SQL> alter system set dg_broker_start=TRUE scope=both;
System altered.
But the config files are still not created. Both of these directories are empty. I can see that the dmon process being started in primary
$ ps -ef | grep dmon
oracle 7577 1 0 22:43 ? 00:00:00 ora_dmon_APGCMS
-- excerpt from alert log from primary
ALTER SYSTEM SET dg_broker_config_file1='/oradata/DG_BROKER/dr1APGCMS.dat' SCOPE=BOTH;
Sat Dec 26 22:41:49 2015
ALTER SYSTEM SET dg_broker_config_file2='/datastore/DG_BROKER/dr2APGCMS.dat' SCOPE=BOTH;
Sat Dec 26 22:43:39 2015
Starting background process DMON
Sat Dec 26 22:43:39 2015
ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;
Sat Dec 26 22:43:39 2015
DMON started with pid=40, OS id=7577
Sat Dec 26 22:43:42 2015
Starting Data Guard Broker (DMON)
Starting background process INSV
Sat Dec 26 22:43:47 2015
INSV started with pid=43, OS id=7579