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.