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) ) )