OraFAQ Forum: Data Guard » Data Guard Broker warning

Home » Server Options » Data Guard » Data Guard Broker warning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Guard Broker warning [message #626765]

Sun, 02 November 2014 03:57

oracle11
Messages: 29
Registered: October 2014
Location: India

Junior Member

Hi,

When i check database using data guard broker,i get warning error.Please guide me to fix this error.

[oracle@server01 admin]$ dgmgrl
DGMGRL for Linux: Version 10.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
 Connected.
DGMGRL> show configuration

Configuration
  Name:                DB02
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: DISABLED
  Databases:
    DB02_SALO - Primary database
    DB02_OULU - Physical standby database

Current status for "DB02":
Warning: ORA-16610: command 'Broker automatic health check' in progress


DGMGRL> show configuration

Configuration
  Name:                DB02
  Enabled:             YES
  Protection Mode:     MaxAvailability
  Fast-Start Failover: DISABLED
  Databases:
    DB02_SALO - Primary database
    DB02_OULU - Physical standby database

Current status for "DB02":
Warning: ORA-16610: command 'Broker automatic health check' in progress

Regards,

Report message to a moderator

Re: ORA-01507: database not mounted [message #626766 is a reply to message #626765]

Sun, 02 November 2014 04:07

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-16610: command \"%s\" in progress
 *Cause:  The specified broker command was already running and the
          command issued could not be completed.
 *Action: Wait for the specified command to finish and then retry the
          command.

Report message to a moderator

Re: ORA-01507: database not mounted [message #626767 is a reply to message #626766]

Sun, 02 November 2014 04:16

oracle11
Messages: 29
Registered: October 2014
Location: India

Junior Member

Hi Michel,
Thanks for your information

Regards,

Report message to a moderator

Re: ORA-01507: database not mounted [message #626782 is a reply to message #626767]

Sun, 02 November 2014 20:01

oracle11
Messages: 29
Registered: October 2014
Location: India

Junior Member

Hi Michel,
I am still getting same error .

Current status for "DB02":
Warning: ORA-16610: command 'Broker automatic health check' in progress

I found below note on MOS.Is this something i need to follow to fix this warning error?If so how to Locate the resource(s)
with a warning status and correct it
Quote:

Error: ORA-16610 (ORA-16610)
Text: one or more resources have warnings
---------------------------------------------------------------------------
Cause: The Data Guard broker detected a warning status on one or more
resources on a site.
Action: Locate the resource(s) with a warning status and correct it.

Regards,

Report message to a moderator

Data Guard Broker warning [message #626800 is a reply to message #626782]

Mon, 03 November 2014 02:16

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

I've split this from previous unrelated topic, http://www.orafaq.com/forum/mv/msg/195066/626718/#msg_626718

[Updated on: Mon, 03 November 2014 02:26]

Report message to a moderator

Data Guard Broker warning [message #626802 is a reply to message #626782]

Mon, 03 November 2014 02:24

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

You could try to follow the instructions in the message. First, use the SHOW DATABASE command to check the status of each database.

But in gerneral, you need to talk to a more senior DBA. Consider:
First, your production databases was down for days, even though you had a physical standby. You should have failed over to the standby immediately. That is what it is for.
Second, right now your database is unprotected. Your client has bought Enterprise Edition licences for that standby server, and configured maximum availability. He must consider this database to be very important. He is not getting what he has paid for.
Third, have you backed up that database yet?

[Updated on: Mon, 03 November 2014 02:26]

Report message to a moderator

Re: Data Guard Broker warning [message #626806 is a reply to message #626802]

Mon, 03 November 2014 02:42

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe this will answer your questions, John. Wink

[Updated on: Mon, 03 November 2014 02:42]

Report message to a moderator

Previous Topic:	Valid objects found invalid in ODS (OLTP & ODS are in SYNC)
Next Topic:	Logical stand by log apply - ORA-01031

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 07:30:42 CDT 2023