Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-16724: cannot resolve gap for one or more standby databases

datsun80Feb 5 2014 — edited Feb 7 2014

I came in to work today with the following error displayed:

Feb 5, 2014 1:27:19 AM Error ORA-16778: redo transport error for one or more databases.


It looks like that error went away but now I have the following error:

Feb 5, 2014 11:52:40 AM Error ORA-16724: cannot resolve gap for one or more standby databases

I did some research on the forums and I think I need to backup and restore but I am not sure.

Here are some queries I saw other people asking for in the forums:

PRIMARY:

select max(sequence#)  from v$archived_log; ---- 24589

select current_scn from v$database; ----- 871568619

SECONDARY:

select max(sequence#)  from v$archived_log; ----- 24589

select max(sequence#)  from v$archived_log where applied = 'YES'; ----- 24562

select current_scn from v$database; ----- 870987797

select * from v$archive_gap;

Thread# Low_Sequence# High_Sequence#

1    24563    24563

It looks like everything is working yet the error is still showing up in OEM on the primary.

This post has been answered by datsun80 on Feb 6 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2014
Added on Feb 5 2014
6 comments
6,445 views