Skip to Main Content

FAL: Failed to request gap sequence

aliyagmurMay 8 2021

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?

Comments
Post Details
Added on May 8 2021
4 comments
1,738 views