Hello,
I had to shutdown physical standby db for 4 hours for shifting to another location.
After restart It seems there are 4 missing archive logs and I think because of them other archive logs are not being applied.
SYS@standbydb AS SYSDBA> select * from V$ARCHIVE_GAP; -- on Primary there are no rows selected.
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 36226 36230
Standby: SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG where applied='NO';
1 36231 NO
- - -
1 36247 NO
36226 is the last one with the APPLIED: YES
I have following errors in the GRID CONTROL DATA GUARD STATUS option
ORA-16783: cannot resolve gap for database standby_db
ORA-16629: database reports a different protection level from the protection mode
Please help to resolve this archive gap...
Thanks a lot
Best Regards