Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

dataguard error

Hello,

We have dataguard transport lag from primary to standby.

We had archive backup error in primary yesterday due to which we increased space and take 1-2 manual archive backups.

Dataguard has errors from then.

--------------------------------------

ARC3: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/SID/oraarch/SIDarch1_1970_869748602.dbf' (error 19502) (SID)
ARCH: Archival stopped, error occurred. Will continue retrying

--------------------------------------

------------------------------------------------------------------------------------------

Thu Aug 13 07:23:56 2015

ARC5: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/SID/oraarch/SIDarch1_2062_869748602.dbf' (error 19502) (SID)

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance BV5 - Archival Error

ORA-16038: log 17 sequence# 2062 cannot be archived

ORA-19502: write error on file "", block number  (block size=)

ORA-00312: online log 17 thread 1: '/oracle/BV5/standbylog/srl1.dbf'

Archiver process freed from errors. No longer stopped

Thu Aug 13 07:23:56 2015

ARCH: Archival stopped, error occurred. Will continue retrying

----------------------------------------------------------------------------------------

DGMGRL> show configuration

Configuration - sid

  Protection Mode: MaxAvailability

  Databases:

    sid_hostname - Primary database

      Error: ORA-16810: multiple errors or warnings detected for the database

    sid_hostname - Physical standby database

      Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

Fast-Start Failover: DISABLED

Configuration Status:

ERROR

DGMGRL> show database sid_hostname

Database - sid_hostname

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   1 day(s) 6 hours 22 minutes 4 seconds (computed 215 seconds ago)

  Apply Lag:       1 day(s) 6 hours 22 minutes 4 seconds (computed 215 seconds ago)

  Apply Rate:      51.00 MByte/s

  Real Time Query: OFF

  Instance(s):

    BV5

  Database Warning(s):

    ORA-16857: standby disconnected from redo source for longer than specified threshold

Database Status:

WARNING

---------------------------------------------------------

What can be done to resolve this issue.

Thanks and regards,

Uday

Not what you were looking for? View more on this topic or Ask a question