Primary : PRIMDB
Standby : primdb_std
On primary :
12:14:55 SYSTEM@PRIMDB >sho parameter broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /opt/oracle/product/19.3.0/dbs
/dr1primdb.dat
dg_broker_config_file2 string /opt/oracle/product/19.3.0/dbs
/dr2primdb.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE
12:15:05
SYSTEM@PRIMDB > show parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
oraclehost:PRIMDB:/home/oracle
$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jul 27 11:45:14 2023
Version 19.17.0.0.0
Copyright (c)
1982, 2019, Oracle and/or its affiliates.
All rights reserved.
Welcome to
DGMGRL, type "help" for information.
Connected to "PRIMDB"
Connected as SYSDG.
DGMGRL> show configuration
ORA-16525: The Oracle Data Guard broker is not yet available.
Configuration
details cannot be determined by DGMGRL
SYNTAX:
DGMGRL> CREATE CONFIGURATION '<configuration name>' AS PRIMARY DATABASE IS '<primary db_unique_name>' CONNECT IDENTIFIER IS <primary connect string>;
DGMGRL> create configuration Primdb_dg as primary
database is 'PRIMDB' connect identifier is PRIMDB ;
Error:
ORA-16525: The Oracle Data Guard broker is not yet available.
Fix : set “dg_broker_start” to TRUE
11:50:11
SYSTEM@PRIMDB > alter system set
dg_broker_start=true sid='*';
System
altered.
Standby : primdb_std
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /opt/oracle/product/19.3.0/dbs
/dr1primdb.dat
dg_broker_config_file2 string /opt/oracle/product/19.3.0/dbs
/dr2primdb.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE
------------------------------------ ----------- ------------------------------
log_archive_config string
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Thu Jul 27 11:45:14 2023
Version 19.17.0.0.0
Connected to "PRIMDB"
Connected as SYSDG.
DGMGRL> show configuration
ORA-16525: The Oracle Data Guard broker is not yet available.
DGMGRL> CREATE CONFIGURATION '<configuration name>' AS PRIMARY DATABASE IS '<primary db_unique_name>' CONNECT IDENTIFIER IS <primary connect string>;
Error:
ORA-16525: The Oracle Data Guard broker is not yet available.
alter system set dg_broker_config_file1='+<path>/DATAGUARDCONFIG/primdb_dg1.dat' scope=both sid='*';
alter system set dg_broker_config_file2='+<path>/DATAGUARDCONFIG/primdb_dg2.dat' scope=both sid='*';
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /opt/oracle/product/19.3.0/dbs/dr1PRIMDB.dat
dg_broker_config_file2 string /opt/oracle/product/19.3.0/dbs/dr2PRIMDB.dat
dg_broker_start boolean TRUE
use_dedicated_broker boolean FALSE
Members:
PRIMDB - Primary database
DISABLED
-rw-r----- 1 oracle oinstall 8192 Jul 27 11:58 /opt/oracle/product/19.3.0/dbs/dr1PRIMDB.dat
-rw-r----- 1 oracle oinstall 8192 Jul 27 11:58 /opt/oracle/product/19.3.0/dbs/dr2PRIMDB.dat
Enabled.
Members:
PRIMDB - Primary database
Warning: ORA-16905: The member was not enabled yet.
WARNING (status updated 246 seconds ago)
Doc:
12c Create Dataguard Broker Configuration - DGMGRL (Doc ID 1583588.1)
12c Create Dataguard Broker Configuration - DGMGRL (Doc ID 1583588.1)
0 comments:
Post a Comment