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

##########################
## Error
##########################

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

### Full Error

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

##########################
#  Error Occurred
##########################

Error occured while trying to check archive log destination status and its modes in 11.2.0.3.0 version

##########################
## Command Executed
##########################

set lines 200
col dest_name for a20
col db_unique_name for a15

select dest_name,db_unique_name,database_mode,recovery_mode,gap_status,error from v$archive_Dest_Status;

##########################
## Issue Description.
##########################

### 11.2.0.3.0

#########################################
# 1) check the Log archive destination and its status
#########################################

set lines 200
col dest_name for a20
col db_unique_name for a15

select dest_name,db_unique_name,database_mode,recovery_mode,gap_status,error from v$archive_Dest_Status;

DEST_NAME            DB_UNIQUE_NAME  DATABASE_MODE   RECOVERY_MODE           GAP_STATUS               ERROR
-------------------- --------------- --------------- ----------------------- ------------------------ -----------------------------------------------------------------
LOG_ARCHIVE_DEST_1   oralin_prim    OPEN            IDLE
LOG_ARCHIVE_DEST_2   oralin_std    MOUNTED-STANDBY MANAGED REAL TIME APPLY
LOG_ARCHIVE_DEST_3   oralin_prim    OPEN            IDLE                                             ORA-19502: write error on file "", block number  (block size=)

LOG_ARCHIVE_DEST_3 has been set as an alternate destination.


sho parameter LOG_ARCHIVE_DEST_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=USE_DB_RECOVERY_FILE_
                                                 DEST VALID_FOR=(ALL_LOGFILES,A
                                                 LL_ROLES) DB_UNIQUE_NAME=oralin_prim noreopen max_failure=0
                                                  mandatory alternate=log_archi
                                                 ve_dest_3

sho parameter LOG_ARCHIVE_DEST_3

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      location=/u01/app/oracle/exp/oralin/arch02 VALID_FOR=(ALL_
                                                 LOGFILES,ALL_ROLES) DB_UNIQUE_
                                                 NAME=oralin_prim

sho parameter LOG_ARCHIVE_DEST_state_3

SQL> sho parameter LOG_ARCHIVE_DEST_state_3

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_3             string      ALTERNATE

No Errors has been recorded in Alert log file.

##########################
## Solution
##########################


Tried reset the parameter back to its same value again and it worked like a charm,

Alter system set log_archive_Dest_3='location=/u01/app/oracle/exp/oralin/arch02 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oralin_prim';

SQL> Alter system set log_archive_Dest_3='location=/u01/app/oracle/exp/oralin/arch02 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oralin_prim';

System altered.

SQL> sho parameter log_archive_dest_3

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      location=/u01/app/oracle/exp/oralin/arch02 VALID_FOR=(ALL_
                                                 LOGFILES,ALL_ROLES) DB_UNIQUE_
                                                 NAME=oralin_prim


DEST_NAME            DB_UNIQUE_NAME  DATABASE_MODE   RECOVERY_MODE           GAP_STATUS               ERROR
-------------------- --------------- --------------- ----------------------- ------------------------ -----------------------------------------------------------------
LOG_ARCHIVE_DEST_1   oralin_prim    OPEN            IDLE
LOG_ARCHIVE_DEST_2   oralin_std    MOUNTED-STANDBY MANAGED REAL TIME APPLY NO GAP
LOG_ARCHIVE_DEST_3   oralin_prim    OPEN            IDLE