Re: Data Guard Issue

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 16 Sep 2021 15:54:14 -0500
Message-ID: <CAJvnOJa=vEZJUFqXLL76e0mWTgBOF-Er4k0DszEGmv=QW+BK9w_at_mail.gmail.com>



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> 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 <oracle-l-bounce_at_freelists.org> on
> behalf of Scott Canaan <srcdco_at_rit.edu>
> *Sent:* Thursday, September 16, 2021 3:53 PM
> *To:* 'oracle-l_at_freelists.org' <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 <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 Thu Sep 16 2021 - 22:54:14 CEST

Original text of this message