Corrigindo.. Porem os botões de switchover, FailOver e Convert não estão Ativos "Enabled"
att, ________________________________ De: Welvis Moretto <[email protected]> Para: "[email protected]" <[email protected]> Enviadas: Terça-feira, 9 de Outubro de 2012 10:17 Assunto: [oracle_br] Data Guard Broker Olá pessoal, tudo bem? Na semana passada crieu um banco physical standby. Nesta semana estou configurando o Data Guard Broker.. A primcipio no OEM está dando as informações do dataguard tais como, taxas de transferencias, status da replicação, etc.. Porem os botes de switchover, FailOver e Convert não estão Ativos "Enabled" Banco 11.2.0.3 RAC 2 nodes, Rodando em Red Hat 6.3 Segue os comandos para configurar o dataguard broker; CREATE CONFIGURATION 'DGConfig' as PRIMARY DATABASE IS 'pfatdb' CONNECT IDENTIFIER IS pfatdb; show configuration enable configuration show configuration ## Add StandBy Database ADD DATABASE 'pfatdb_stdby' AS CONNECT IDENTIFIER IS pfatdb_stdby MAINTAINED AS PHYSICAL; show configuration 'pfatdb_stdby' enable database 'pfatdb_stdby'; DGMGRL> show configuration verbose; Configuration - DGConfig Protection Mode: MaxPerformance Databases: pfatdb - Primary database pfatdb_stdby - Physical standby database Properties: FastStartFailoverThreshold = '30' OperationTimeout = '30' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL> # Parameters control_files=+ASM_DATA/pfatdb/controlfile/current.260.789773837 compatible=11.2.0.0.0 log_archive_dest_1=location="+ASM_FRA", valid_for=(ALL_LOGFILES,ALL_ROLES) log_archive_dest_2=service="pfatdb_stdby", LGWR ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="pfatdb_stdby" net_timeout=30, valid_for=(all_logfiles,primary_role) log_archive_dest_state_1=ENABLE log_archive_dest_state_2=ENABLE log_archive_start=FALSE standby_archive_dest=+ASM_FRA fal_client=pfatdb fal_server=pfatdb_stdby log_archive_trace=0 log_archive_config=dg_config=(pfatdb,pfatdb_stdby) log_archive_local_first=TRUE log_archive_format=pfatdb_%t_%s_%r.arc parallel_server_instances=2 cluster_database_instances=2 db_create_file_dest=+ASM_DATA standby_file_management=AUTO local_listener=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.41.1.75)(PORT=1521))) remote_listener=rac-scan:1521 audit_trail=DB, EXTENDED db_name=pfatdb db_unique_name=pfatdb [As partes desta mensagem que não continham texto foram removidas] [As partes desta mensagem que não continham texto foram removidas]
