ORA-16088:archive log has not been completely archived

Problem: Database was not coming into sync. It was waiting for an archive log sequence 178914 while sequence file was there in /arch folder.



Solution: When I executed "select sequence#, archived, applied from v$archived_log order by sequence#;", that particular sequence number 178914 was missing.

So I tried to register manually that file using "alter database register logfile '/archivelog/arch/1_178914_801574742.dbf';"
But I received an error like "ORA-16088:archive log has not been completely archived"

So, I just renamed that file using " mv /archivelog/arch/1_178914_801574742.dbf /archivelog/arch/1_178914_801574742_bkp.dbf

Then I stopped MRP process and started it again using

Alter database recover managed standby database cancel;

Alter database recover managed standby database disconnect from session;