Skip to Main Content

Redo Apply Fails In Standby (Data Guard)

Noname123Sep 3 2020 — edited Sep 16 2020

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

Comments
Post Details
Added on Sep 3 2020
4 comments
893 views