ORA-03113: end-of-file on communication channel

Problem : - 

Database SID=orcl

1.

SQL> startup 
ORACLE instance started. 

Total System Global Area 6530596864 bytes 
Fixed Size 2219048 bytes 
Variable Size 3556770776 bytes 
Database Buffers 2952790016 bytes 
Redo Buffers 18817024 bytes 
Database mounted. 
ORA-03113: end-of-file on communication channel 
Process ID: 753668 
Session ID: 96 Serial number: 3 

2.
alert_orcl.log

Tue Aug 12 17:52:37 2014 
Starting ORACLE instance (normal) 
sskgpgetexecname failed to get name 
LICENSE_MAX_SESSION = 0 
LICENSE_SESSIONS_WARNING = 0 
Picked latch-free SCN scheme 3 
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST 
Autotune of undo retention is turned on. 
IMODE=BR 
ILAT =27 
LICENSE_MAX_USERS = 0 
SYS auditing is disabled 
Starting up: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options. 
Using parameter settings in server-side spfile /d01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora 
System parameters with non-default values: 
processes = 150 
sessions = 248 
memory_target = 6256M 
control_files = "/d01/app/oracle/oradata/orcl/control01.ctl" 
control_files = "/d01/app/oracle/flash_recovery_area/orcl/control02.ctl" 
db_block_size = 8192 
compatible = "11.2.0.0.0" 
log_archive_format = "%t_%s_%r.dbf" 
db_recovery_file_dest = "/d01/app/oracle/flash_recovery_area" 
db_recovery_file_dest_size= 3852M 
undo_tablespace = "UNDOTBS1" 
remote_login_passwordfile= "EXCLUSIVE" 
db_domain = "" 
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" 
audit_file_dest = "/d01/app/oracle/admin/orcl/adump" 
audit_trail = "DB" 
db_name = "orcl" 
open_cursors = 300 
diagnostic_dest = "/d01/app/oracle" 
Tue Aug 12 17:52:37 2014 
PMON started with pid=2, OS id=860670 
Tue Aug 12 17:52:38 2014 
VKTM started with pid=3, OS id=700672 at elevated priority 
VKTM running at (10)millisec precision with DBRM quantum (100)ms 
Tue Aug 12 17:52:38 2014 
GEN0 started with pid=4, OS id=491846 
Tue Aug 12 17:52:38 2014 
DIAG started with pid=5, OS id=647324 
Tue Aug 12 17:52:38 2014 
DBRM started with pid=6, OS id=557196 
Tue Aug 12 17:52:38 2014 
PSP0 started with pid=7, OS id=553438 
Tue Aug 12 17:52:38 2014 
DIA0 started with pid=8, OS id=434638 
Tue Aug 12 17:52:38 2014 
MMAN started with pid=9, OS id=696514 
Tue Aug 12 17:52:38 2014 
DBW0 started with pid=10, OS id=385046 
Tue Aug 12 17:52:38 2014 
LGWR started with pid=11, OS id=311750 
Tue Aug 12 17:52:39 2014 
CKPT started with pid=12, OS id=180302 
Tue Aug 12 17:52:39 2014 
SMON started with pid=13, OS id=422120 
Tue Aug 12 17:52:39 2014 
RECO started with pid=14, OS id=590094 
Tue Aug 12 17:52:39 2014 
MMON started with pid=15, OS id=843842 
Tue Aug 12 17:52:39 2014 
MMNL started with pid=16, OS id=667850 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... 
starting up 1 shared server(s) ... 
ORACLE_BASE from environment = /d01/app/oracle 
Tue Aug 12 17:52:39 2014 
ALTER DATABASE MOUNT 
Successful mount of redo thread 1, with mount id 1383189735 
Database mounted in Exclusive Mode 
Lost write protection disabled 
Completed: ALTER DATABASE MOUNT 
Tue Aug 12 17:52:44 2014 
ALTER DATABASE OPEN 
LGWR: STARTING ARCH PROCESSES 
Tue Aug 12 17:52:44 2014 
ARC0 started with pid=20, OS id=643416 
ARC0: Archival started 
LGWR: STARTING ARCH PROCESSES COMPLETE 
ARC0: STARTING ARCH PROCESSES 
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc: 
ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available. 
************************************************************************ 
You have following choices to free up space from recovery area: 
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, 
then consider changing RMAN ARCHIVELOG DELETION POLICY. 
2. Back up files to tertiary device such as tape using RMAN 
BACKUP RECOVERY AREA command. 
3. Add disk space and increase db_recovery_file_dest_size parameter to 
reflect the new space. 
4. Delete unnecessary files using RMAN DELETE command. If an operating 
system command was used to delete files, then use RMAN CROSSCHECK and 
DELETE EXPIRED commands. 
************************************************************************ 
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc: 
ORA-19809: limit exceeded for recovery files 
ORA-19804: cannot reclaim 34288640 bytes disk space from 4039114752 limit 
ARCH: Error 19809 Creating archive log file to '/d01/app/oracle/flash_recovery_area/ORCL/archivelog/2014_08_12/o1_mf_1_126_%u_.arc' 
Tue Aug 12 17:52:45 2014 
ARC1 started with pid=21, OS id=451010 
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc: 
ORA-16038: log 3 sequence# 126 cannot be archived 
ORA-19809: limit exceeded for recovery files 
ORA-00312: online log 3 thread 1: '/d01/app/oracle/oradata/orcl/redo03.log' 
USER (ospid: 377118): terminating the instance due to error 16038 
Instance terminated by USER, pid = 377118 


Solution : -

1. $ export ORACLE_SID=orcl
2. $ sqlplus / as sysdba 
3. SQL> startup mount
    ORACLE instance started.

    Total System Global Area 6530596864 bytes
    Fixed Size                  2219048 bytes
    Variable Size            3556770776 bytes
    Database Buffers         2952790016 bytes
    Redo Buffers               18817024 bytes
    Database mounted.

    SQL> show parameter db_recovery_file_dest_size

    NAME                                      TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_recovery_file_dest_size           big integer 3072M

4. SQL> alter system set db_recovery_file_dest_size=5050M;

    System altered.

5. SQL> shut immediate
    ORA-01109: database not open


    Database dismounted.
    ORACLE instance shut down.

6. SQL> startup
    ORACLE instance started.

    Total System Global Area 6530596864 bytes
    Fixed Size                  2219048 bytes
    Variable Size            3556770776 bytes
    Database Buffers         2952790016 bytes
    Redo Buffers               18817024 bytes
    Database mounted.
    Database opened.

7. have coffee.