Boa tarde Pessoal,
Tenho um Data Guard Configurado, e funcionando perfeitamente.
Nesse momento estou na tentativa de configurar o Data Broker, porem estou com
um problema no momento de adicionar as configurações do STANDBY.
O que esta me retornando é esse:
Error: ORA-16532: Oracle Data Guard broker configuration does not exist
DGMGRL> ADD DATABASE ’seniorstby' AS CONNECT IDENTIFIER IS seniorstby
MAINTAINED AS PHYSICAL;
Error: ORA-16532: Oracle Data Guard broker configuration does not exist
Failed.
olhando o arquivo doc<DB_UNIQUE_NAME>.log ele me retorna somente o erro abaixo:
2020-06-05 12:09:45.809 00000000 24572709 DMON: ADD_DATABASE will be retired
2020-06-05 12:09:45.809 00000000 24572709 severity = ORA-16501, status
= ORA-16532
2020-06-05 12:09:45.809 00000000 24572709 DMON: ADD_DATABASE operation
completed
Abaixo estou postando algumas informações da minha configuração.
PRIMARIO
ORACLE_SID = SENIORPRD
DGMGRL> CREATE CONFIGURATION 'dg_config' AS PRIMARY DATABASE IS 'seniorprd'
CONNECT IDENTIFIER IS seniorprd;
Configuration "dg_config" created with primary database "seniorprd"
Parametros
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string
/opt/oracle/product/12cR2/db/dbs/dr1seniorprd.dat
dg_broker_config_file2 string
/opt/oracle/product/12cR2/db/dbs/dr2seniorprd.dat
dg_broker_start boolean TRUE
use_dedicated_broker boolean FALSE
Listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = seniorprd_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/12cR2/db)
(SID_NAME = seniorprd)
)
)
ADR_BASE_LISTENER = /opt/oracle
TNSNAMES
SENIORPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
)
)
SENIORSTBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
)
)
STANDBY
ORACLE_SID = SENIORPRD
DGMGRL> ADD DATABASE ’seniorstby' AS CONNECT IDENTIFIER IS seniorstby
MAINTAINED AS PHYSICAL;
Error: ORA-16532: Oracle Data Guard broker configuration does not exist
Parametros
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string
/opt/oracle/product/12cR2/db/dbs/dr1seniorstby.dat
dg_broker_config_file2 string
/opt/oracle/product/12cR2/db/dbs/dr2seniorstby.dat
dg_broker_start boolean TRUE
use_dedicated_broker boolean FALSE
Listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SENIORSTBY_DGMGRL)
(ORACLE_HOME = /opt/oracle/product/12cR2/db)
(SID_NAME = seniorprd)
)
)
ADR_BASE_LISTENER = /opt/oracle
TNANAMES
SENIORPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
(UR = A)
)
)
SENIORSTBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orarman)(PORT = 1521))
)
(CONNECT_DATA =
(SID = seniorprd)
(UR = A)
)
)
