Primary:
SQL> SELECT THREAD# "Thread",SEQUENCE# "Last Sequence Generated"
FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1;
Thread Last Sequence Generated
---------- -----------------------
1 7864
Standby:
SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 7860 7863 -3
Primary alert_<sid>.log file:
2020-09-03T10:32:24.849706+03:00
TT00: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
TT00: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2020-09-03T10:32:25.021343+03:00
Errors in file /u01/app/oracle/diag/rdbms/linprd/linprd/trace/linprd_tt00_20645.trc:
ORA-00270: error creating archive log
Primary trace file error:
Error 270 creating standby archive log file at host 'linstd'
*** 2020-09-03 10:32:24.849737 5634 krsh.c
TT00: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
*** 2020-09-03 10:32:24.850070 5634 krsh.c
TT00: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
ORA-00270: error creating archive log
*** 2020-09-03 10:32:25.021677 5634 krsh.c
Error 270 for archive log file 1 to 'linstd'
*** 2020-09-03T10:32:25.356675+03:00
*** 2020-09-03 10:32:25.356649 8506 krsi.c
krsi_dst_fail_caller: LAD:2 err:270 force:0 blast:1
krsd_multidest_clear: Clearing Multidest for LAD:2
*** 2020-09-03 10:32:25.380884 1440 krss.c
krss_req_xpt_async_dgrd: Downgraded LAD:2 to single destination
ORA-00270: error creating archive log
ORA-00270: error creating archive log
Standby alert<sid>.log file:
2020-09-03T10:42:56.656330+03:00
Unable to create archive log file '+FRA'
2020-09-03T10:42:56.663261+03:00
Errors in file /u01/app/oracle/diag/rdbms/linstd/linstd/trace/linstd_arc1_27129.trc:
ORA-19504: failed to create file "+FRA"
ORA-17502: ksfdcre:4 Failed to create file +FRA
ORA-15041: diskgroup "FRA" space exhausted
ARC1: Error 19504 Creating archive log file to '+FRA'
Standby Trace log file
*** 2020-09-03T13:14:36.238011+03:00
DDE: Problem Key 'ORA 15041' was flood controlled (0x6) (no incident)
ORA-15041: diskgroup "FRA" space exhausted
*** 2020-09-03 13:14:36.250415 5634 krsh.c
Unable to create archive log file '+FRA'
ORA-19504: failed to create file "+FRA"
ORA-17502: ksfdcre:4 Failed to create file +FRA
ORA-15041: diskgroup "FRA" space exhausted
*** 2020-09-03 13:14:36.251020 5634 krsh.c
ARC1: Error 19504 Creating archive log file to '+FRA'
Please assist on approaching the issue