Re: Data Guard Question

Yes, I have seen that one before. You can put in a bad value for the broker files, and Oracle wont say anything until the broker tries to create them. And even in RAC, they will default to a local file system location despite the fact that they need to be in shared storage for RAC data guard.

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

> Ok, I got it. I had to do the “alter system set dg_broker_start = FALSE”
> first. Then I could change the parameter and change it back to true. Once
> I did that, I could enable the configuration and all is good again.
>
>
>
> *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.
>
>
>
> *From:* Scott Canaan <srcdco_at_rit.edu>
> *Sent:* Wednesday, June 19, 2019 3:31 PM
> *To:* Scott Canaan <srcdco_at_rit.edu>; Andrew Kerber <
> andrew.kerber_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: Data Guard Question
>
>
>
> I think I found my problem. We don’t want the data guard configuration
> files in their default location, so we move them. In changing the
> dg_broker_config_file2 setting, I had a typo for the standby.
> Unfortunately, it won’t let me fix it. It keeps telling me:
>
> ORA-02097: parameter cannot be modified because specified value is invalid
>
> ORA-16573: attempt to change or access configuration file for an enabled
> broker configuration
>
>
>
> When I try to disable the broker configuration, I get:
>
> ORA-16525: The Oracle Data Guard broker is not yet available.
>
>
>
> Configuration details cannot be determined by DGMGRL
>
>
>
> How do I fix this?
>
>
>
> *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.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Scott Canaan
> *Sent:* Wednesday, June 19, 2019 3:24 PM
> *To:* Andrew Kerber <andrew.kerber_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: Data Guard Question
>
>
>
> I have not tried to drop and recreate the configuration.
>
>
>
> I got the database to be recognized by CC by deleting it from CC and
> re-adding it. At least now it knows it’s up. When I go to Availability,
> It only displays “Add Standby Database”. If I click on that, then hit
> cancel on the next page, it will take me to the Data Guard status page,
> which shows it is in error.
>
>
>
> The DG log file on the primary node has rows and rows of: Site DGRDTSTB
> returned ORA-16733.
>
> I looked that error up and all I can find is to “install logical standby
> packages and re-issue the request”. Not exactly helpful.
>
>
>
> *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.
>
>
>
> *From:* Andrew Kerber <andrew.kerber_at_gmail.com>
> *Sent:* Wednesday, June 19, 2019 3:04 PM
> *To:* Scott Canaan <srcdco_at_rit.edu>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Data Guard Question
>
>
>
> 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.'
>

-- 
Andrew W. Kerber

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

--
http://www.freelists.org/webpage/oracle-l