0 0 0

+15

ORACLE Instance nsndb – Archival Error. Archiver continuing.
Wed Nov 28 05:56:16 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-19502: write error on file "", blockno  (blocksize=)
Wed Nov 28 05:56:17 2012
FAL[server, ARC0]: FAL archive failed, see trace file.
Wed Nov 28 05:56:17 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing

Wed Nov 28 05:56:17 2012
ORACLE Instance nsndb – Archival Error. Archiver continuing.
Wed Nov 28 05:56:19 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-19502: write error on file "", blockno  (blocksize=)
FAL[server, ARC0]: FAL archive failed, see trace file.

Sol:
1 check file system space at os level on standby:
df -h

2. archival area will be 100% full then free some space free.

–Check whether Managed Recovery Process (MRP) is running on the standby and delay for the target standby :

SQL> SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS,DELAY_MINS FROM V$MANAGED_STANDBY;

PROCESS   CLIENT_P  SEQUENCE# STATUS       DELAY_MINS
——— ——– ———- ———— ———-
ARCH      ARCH           7422 OPENING               0
ARCH      ARCH           7422 OPENING               0
RFS       UNKNOWN           0 IDLE                  0

–Perform recovery on standby:
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

3. check all the archived are appllied or not ,if not then let it apply.

4. when apllied then remove applied archived logs from os level.

0 0 0