Home » Server Options » Data Guard » Data Guard Broker warning
Data Guard Broker warning [message #626765] Sun, 02 November 2014 03:57 Go to next message
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,
Re: ORA-01507: database not mounted [message #626766 is a reply to message #626765] Sun, 02 November 2014 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.
Re: ORA-01507: database not mounted [message #626767 is a reply to message #626766] Sun, 02 November 2014 04:16 Go to previous messageGo to next message
oracle11
Messages: 29
Registered: October 2014
Location: India
Junior Member
Hi Michel,
Thanks for your information

Regards,
Re: ORA-01507: database not mounted [message #626782 is a reply to message #626767] Sun, 02 November 2014 20:01 Go to previous messageGo to next message
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,
Data Guard Broker warning [message #626800 is a reply to message #626782] Mon, 03 November 2014 02:16 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous message
Michel Cadot
Messages: 68625
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:
  


Current Time: Thu Mar 28 13:12:14 CDT 2024