Primary database deleted archivelogs even when needed by the Data Gaurd(DG)
742854Apr 13 2010 — edited Apr 27 2010HI,
I have a physical standby database. And Primary database on RAC node 1 and node 2.
We have logs getting shipped from both node 1 and node 2 to the DG.
The logs are getting shipped in correct order w.r.t each thread.
I saw this error which is showing the GAP.
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 22690-22739
I have resolved the gap issue, by restoring the logs that got deleted after backup from Primary.
When i investigated, i found the primary node 1 backed up the logs and after couple of more archive log backup jobs, went ahead and deleted the archive logs even when they were needed.
But the below is the error i saw just before the needed logs thread 1 sequence 22690-22739 got deleted
RMAN-08118: WARNING: could not delete the following archived redo log
archive log filename=+DATA/afcp/archivelog/2010_04_12/thread_1_seq_22689.1771.716095593 thread=1 sequence=22689
error from target database:
ORA-15028: ASM file '+DATA/afcp/archivelog/2010_04_12/thread_1_seq_22689.1771.716095593' not dropped; currently being accessed
I dont know why the primary deleted the archivelogs even when they were still needed by the DG.
Can someone help me understand this and how to resolve this problem, so the GAPS can be avoided in the future.
Thanks.