Skip to Content
0
Former Member
Aug 13, 2015 at 06:08 AM

dataguard error

295 Views

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