ORA-00270 ORA-16401

Wed Nov 28 06:34:37 2012
LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'nsnstd' (error 1950                                             2)
 (nsndb)
Wed Nov 28 06:34:37 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_lns1_24654.trc:
ORA-00270: error creating archive log
LNS: Failed to archive log 4 thread 1 sequence 7457 (270)


Wed Nov 28 06:39:58 2012
Errors in file /export/home/oracle/admin/nsndb/bdump/nsndb_arc0_998.trc:
ORA-16401: archivelog rejected by RFS
Wed Nov 28 06:39:58 2012

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.

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply