Data Broker Logs

This question is Not Answered.

883218 Sep 15, 2011 2:55 PM

Hi,

Where can i see the DG Broker logs? Oracle Docs says its here
http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/troubleshooting.htm#i1009720

$ORACLE_HOME/rdbms/log/drc*.log
but i don't see anything in that folder.

While i was trying to configure my DG Broker manually. I keep getting the following errors while trying to show configuration or show database target db.

Warning: ORA-16610: command "Broker automatic health check" in progress
Warning: ORA-16607: one or more databases have failed
Error: ORA-16662: network timeout when contacting a database

What exactly is going on and how to get this error resolved? I am trying to do this to setup FFS but i am getting stuck here. Really appreciate any help in this regard.

Average User Rating: No ratings (0 ratings)

Average User Rating

No ratings

(0 ratings)

1. Re: Data Broker Logs
Uwehesse-Oracle Sep 15, 2011 3:49 PM (in response to 883218)
The Broker Log is in the BACKGROUND_DUMP_DEST directory - where the alert.log is also.
Just connect with SQL*Plus and say show parameter dump to see the location at your site.

Kind regards
Uwe Hesse

http://uhesse.wordpress.com
Like Show 0 Likes(0)
Actions

2. Re: Data Broker Logs

mseberg Sep 15, 2011 4:05 PM (in response to 883218)

Hello;

If I remember correctly you are running 11.1.0.6.0. I see Uwe has answered the log question.

You should consider removing you setup and starting over using this note :

How to Safely Remove a Data Guard Broker Configuration [ID 261336.1]

My quick setup is :

On both Primary and Standby sites, change the initialization parameter in the spfile to enable the Data guard broker.

SQL> Alter system set dg_broker_start=True scope=both;

System altered.

/home/oracle:PRIMARY >dgmgrl

DGMGRL> connect sys/password@PRIMARY

Connected.
DGMGRL> 

DGMGRL> create configuration 'broker1' as
 primary database is 'PRIMARY'
 connect identifier is 'PRIMARY';
Configuration "broker1" created with primary database "PRIMARY"
DGMGRL> 

(‘primary’ in Connect identifier is the service name through which the broker is connected to the PRIMARY database)

Add Standby Database to the above configuration.

DGMGRL> add database 'STANDBY' as
 connect identifier is 'STANDBY'
 maintained as physical;
Database "STANDBY" added


The next step is to ENABLE the configuration ‘broker1’.

DGMGRL> enable configuration;
Enabled.
DGMGRL> 


DGMGRL> show configuration

DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration

Configuration - broker1

  Protection Mode: MaxPerformance
  Databases:
    PRIMARY - Primary database
    STANDBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

For this error :

Warning: ORA-16610: command 'Broker automatic health check' in progress

Make sure that the /etc/hosts files have entries of all other servers, with name and IP address.

I'm think ORA-16607 and ORA-16662 might be caused by the first error.

I hope this helps.

Best Regards

mseberg

本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请点击举报。