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@xxxxxxx<mailto:srcdco@xxxxxxx> | 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Andrew Kerber
Sent: Tuesday, May 11, 2021 4:01 PM
To: Scott Canaan <srcdco@xxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx<mailto:srcdco@xxxxxxx>> 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@xxxxxxx<mailto:srcdco@xxxxxxx> | 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.'
