RE: Data Guard Issue
Date: Fri, 17 Sep 2021 11:35:44 +0000
Message-ID: <ab265344642b45c99b675c6c03bd1200_at_ex04test91d.ad.rit.edu>
There is nothing related to this error in either alert log.
The error being reported in Cloud Control is:
ORA-16857: member disconnected from redo source for longer than specified threshold
This error won’t go away even when I manually catch it up.
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<mailto: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: Thursday, September 16, 2021 4:54 PM
To: nupendra_at_hotmail.com
Cc: oracle-l_at_freelists.org; Scott Canaan <srcdco_at_rit.edu>
Subject: Re: Data Guard Issue
CAUTION: This message came from outside RIT. If you are unsure about the source or content of this message, please contact the RIT Service Center at 585-475-5000 or help.rit.edu before clicking links, opening attachments or responding.
It would be good to see what is showing up in the alert logs, but sometimes you can fix issues by cancelling and restarting managed standby or by setting the log_archive_dest to defer, then enable.
On Thu, Sep 16, 2021 at 3:32 PM Upendra nerilla <nupendra_at_hotmail.com<mailto:nupendra_at_hotmail.com>> wrote: On your primary db, you could disable and enable the standby arch dest.. that might fix it.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> Sent: Thursday, September 16, 2021 3:53 PM To: 'oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>' <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Data Guard Issue
Earlier today, I had the sysadmins add disk space to the physical standby server. Apparently the interruption to do that was longer than data guard liked. It stopped sending the logs from the primary to the standby. I have manually caught up by copying the missing logs and registering them with the standby. It applies them as soon as I do that, but any newer logs are not being shipped from the primary to the standby. I can’t figure out why and how to fix it.
This is Oracle 19c on Red Hat 7.
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<mailto: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 Fri Sep 17 2021 - 13:35:44 CEST