The Data Guard status of is Error ORA-19502: write error on file "", block number (block size=).

Error:  The Data Guard status of STLBAST is Error ORA-19502: write error on file "", block number (block size=).

Reason: Archive Destination become full in Standby Database server location.

Solution:

Step1: Check alert log both primary and standby database server.





Step2: Check Data Guard status log in primary Database server using following query


2015-DEC-01 09:58:18   ARC8: Completed archiving thread 1 sequence 57395 (10616070471665-10616070713099)
2015-DEC-01 09:58:51   LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502)
2015-DEC-01 09:58:51   LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2015-DEC-01 09:58:51   Error 19502 for archive log file 4 to 'STLBAST'
2015-DEC-01 09:58:51   LNS: Failed to archive log 4 thread 1 sequence 57396 (19502)
2015-DEC-01 10:02:22   ARC9: Beginning to archive thread 1 sequence 57396 (10616070713099-10616070916651)
2015-DEC-01 10:02:23   ARC9: Completed archiving thread 1 sequence 57396 (10616070713099-10616070916651)
2015-DEC-01 10:04:48   ARCa: Beginning to archive thread 1 sequence 57397 (10616070916651-10616070982261)
2015-DEC-01 10:04:48   LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
2015-DEC-01 10:04:48   LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2015-DEC-01 10:04:48   Error 270 for archive log file 6 to 'STLBAST'
2015-DEC-01 10:04:48   ARCa: Completed archiving thread 1 sequence 57397 (10616070916651-10616070982261)
2015-DEC-01 10:04:49   ARCb: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
2015-DEC-01 10:04:49   ARCb: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
2015-DEC-01 10:04:49   FAL[server, ARCb]: Error 270 creating remote archivelog file 'STLBAST'
2015-DEC-01 10:10:49   LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)

Step3: Login to Standby Database server and check the maximum archive log sequence that have already applied in Standby Database using following query

SELECT max(sequence#) AS "STANDBY", applied
FROM v$archived_log GROUP BY applied; 

or

SELECT THREAD#, SEQUENCE#, APPLIED
FROM V$ARCHIVED_LOG;

1 57405 YES
1 57404 YES
1 57403 YES
1 57402 YES
1 57401 YES
1 57400 YES

Step4: Purge old archive log that already applied in standby Database. Now check alert log in both primary and standby Database servers.


Thanks......Cheer