Re: Data Guard Question

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 19 Jun 2019 14:04:11 -0500
Message-ID: <CAJvnOJbShEXj1ezNY6u3uhBwy6rtQtd2LkNw3KCShpObAp_H0w_at_mail.gmail.com>



Did you go into dgmgrl and drop and re-create the configuration? What does the log for the cc agent say? Can you see anything in the alert log for the primary or standby database that shows anything? Is there anything in the data guard broker log on either the primary or standby? Does the data guard configuration work without using the broker?

On Wed, Jun 19, 2019 at 1:50 PM Scott Canaan <srcdco_at_rit.edu> wrote:

> I just created a new database and use Cloud Control 13c to create a data
> guard database and configuration. All seemed to work until the data guard
> job completed and now my primary database is messed up in CC. It is giving
> the error:
>
> Metric evaluation error start - Get dynamic property error,Computation of
> a critical dynamic property failed. Retries Completed.
>
>
>
> And I can’t get the data guard configuration to work in dgmgrl. It says
> that it has a stale configuration. I’ve tried everything I can find online
> to fix these issues (I believe they are related), with no success.
>
>
>
> On the server that houses CC, I tried using:
>
> emctl reload agent dynamicproperties <dbname>:oracle_database
>
>
>
> and it just comes back with a message saying the database doesn’t exist.
>
>
>
> How can adding a standby database screw this up? I can’t figure out how
> to fix it without starting over. This is the sixth attempt at doing this
> and each time something goes wrong – I’ve run across two bugs and have the
> workarounds for those. It’s getting very frustrating.
>
>
>
> The database version is 12.1.0.2 on Linux.
>
>
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 19 2019 - 21:04:11 CEST

Original text of this message