Re: Data Guard Issue

ok. Interesting. That sounds like it lost connection and for some reason it couldnt reestablish connection without the instance bounce. I wonder if there is a bug involved.

On Tue, May 11, 2021 at 3:16 PM Scott Canaan <srcdco_at_rit.edu> wrote:

> Thank you for the link. I ended up bouncing both databases and they
> synced in about a minute after that.
>
>
>
> *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 *Andrew Kerber
> *Sent:* Tuesday, May 11, 2021 4:01 PM
> *To:* Scott Canaan <srcdco_at_rit.edu>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Data Guard Issue
>
>
>
> You can do an incremental recovery based on the scn if you do not have
> access to the missing archive logs. Its a fairly straightforward process.
>
>
>
>
> https://oracledbwr.com/oracle19c-using-rman-incremental-backups-to-refresh-standby-database/
>
>
>
> On Tue, May 11, 2021 at 2:57 PM Scott Canaan <srcdco_at_rit.edu> wrote:
>
> We have two Oracle 19c databases set up in a data guard configuration.
> One is the primary and the other is a physical standby. I was trying to do
> a schema refresh by copying the schema from another database. The physical
> standby ran out of disk space. The sys admins had trouble adding space and
> it took too long. Now I can’t get the two databases synced. The errors
> are:
>
>
>
> ORA-16853: apply lag has exceeded specified threshold
> <http://www.oracle.com/pls/db112/error_search?search=ORA-16853>
>
> ORA-16855: transport lag has exceeded specified threshold
> <http://www.oracle.com/pls/db112/error_search?search=ORA-16855>
>
> ORA-16857: member disconnected from redo source for longer than specified
> threshold <http://www.oracle.com/pls/db112/error_search?search=ORA-16857>
>
>
>
> That status shows that the current log on the primary is 64576. The last
> received log is 64569 and the last applied log is 64345. Those numbers
> haven’t changed in over an hour.
>
>
>
> If anyone has any idea of how to fix this, other than dropping the standby
> and rebuilding the data guard from scratch (which is where I’m headed), I’d
> appreciate it.
>
>
>
> Thank you,
>
>
>
>
> *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