ORA-03113: end-of-file on communication channel Process ID: 1380 Session ID: 191 Serial number: 3 When archive destination is full

Delete Archivelog Using RMAN in Oracle

SQL> startup
ORACLE instance started.

Total System Global Area 1636814848 bytes
Fixed Size 2176248 bytes
Variable Size 1140853512 bytes
Database Buffers 486539264 bytes
Redo Buffers 7245824 bytes

Database mounted.

ORA-03113: end-of-file on communication channel
Process ID: 1380
Session ID: 191 Serial number: 3

Check in Alert Log file …….

NOTE: initiating MARK startup

Starting background process MARK

Mon Jan 06 16:41:54 2014

MARK started with pid=19, OS id=2952

NOTE: MARK has subscribed

Mon Jan 06 16:41:54 2014

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

ORACLE_BASE from environment = E:\app\Administrator

Mon Jan 06 16:41:56 2014

ALTER DATABASE MOUNT /* db agent *//* {0:1:28} */

NOTE: Loaded library: System

SUCCESS: diskgroup DATA was mounted

NOTE: dependency between database ASM and diskgroup resource ora.DATA.dg is established

Successful mount of redo thread 1, with mount id 3855157908

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT /* db agent *//* {0:1:28} */

ALTER DATABASE OPEN /* db agent *//* {0:1:28} */

LGWR: STARTING ARCH PROCESSES

Mon Jan 06 16:42:02 2014

ARC0 started with pid=26, OS id=8080

ARC0: Archival started

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

LGWR: STARTING ARCH PROCESSES COMPLETE

ARCH: Error 19504 Creating archive log file to 'E:\ARCHIVE\ARC0000003106_0832442370.0001'

ARC0: Error 19504 Creating archive log file to 'E:\ARCHIVE\ARC0000003107_0832442370.0001'

Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\asm\asm\trace\asm_ora_1500.trc:

ORA-16038: log 1 sequence# 3106 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 1 thread 1: '+DATA/asm/onlinelog/group_1.261.832442371'

USER (ospid: 1500): terminating the instance due to error 16038

Mon Jan 06 16:42:04 2014

System state dump requested by (instance=1, osid=1500), summary=[abnormal instance termination].

System State dumped to trace file E:\APP\ADMINISTRATOR\diag\rdbms\asm\asm\trace\asm_diag_1608.trc

Dumping diagnostic data in directory=[cdmp_20140106164204], requested by (instance=1, osid=1500), summary=[abnormal instance termination].

Mon Jan 06 16:42:11 2014

Instance terminated by USER, pid = 1500

SQL>Shutdown Immediate;

SQL> startup mount

Then follow the below steps….

SQL> HOST

E:\app\Administrator\product\11.2.0\dbhome_1\BIN>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Jan 6 17:36:48 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASM (DBID=1255844286)

RMAN>

Archivelog List Commands

RMAN>list archivelog all;
RMAN>list copy of archivelog until time ‘SYSDATE-10′;
RMAN>list copy of archivelog from time ‘SYSDATE-10′
RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>list copy of archivelog from sequence 1000;
RMAN>list copy of archivelog until sequence 1500;
RMAN>list copy of archivelog from sequence 1000 until sequence 1500;

Archivelog Delete Commands

RMAN>delete archivelog all;
RMAN>delete archivelog until time ‘SYSDATE-10′;
RMAN>delete archivelog from time ‘SYSDATE-10′
RMAN>delete archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>delete archivelog from sequence 1000;
RMAN>delete archivelog until sequence 1500;
RMAN>delete archivelog from sequence 1000 until sequence 1500;

Note : Also, you can use noprompt statement for do not yes-no question.
 
RMAN>delete noprompt archivelog until time ‘SYSDATE-10′;

RMAN> quit

Recovery Manager complete.

E:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 6 17:39:15 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL>alter database open;

Now Issue is solved…..

Please share your valuable feedback.