I have been using dataguard. Version is 18.3.0.0.0.0. I have some shipped but not applied archivelogs in standby database
select thread#, sequence# from v$archived_log where applied='YES' order by 2;
thread# sequence#
-------- ------------
1 188
1 189
1 190
1 191
1 192
1 193
1 194
When i look at the alert log I can see this log :
FAL: Failed to request gap sequence
GAP - thread 1 sequence 190 - 192
First question: Why does oracle states that applied archived log files are missing?
I configured my dataguard environment like that:
primary.db :
configure archivelog deletion policy to shipped to all standby;
standby.db
configure archivelog deletion policy to applied on standby;
Second question: Daily build have deleted these archivelog logs on both standby and primary servers. I cannot re-apply or re-ship these files. How can i get it work?