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

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

oracle@rtgs ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 24 13:00:49 2016

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1.6034E+10 bytes

Fixed Size                  2269072 bytes

Variable Size            1.1442E+10 bytes

Database Buffers         4563402752 bytes

Redo Buffers               26480640 bytes

Database mounted.

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

Process ID: 3988

Session ID: 66 Serial number: 3

SOLUTION:

[oracle@rtgs trace]$ tail -f -n 500 alert_rtgsdb.log

shows last 500 row in alert log file, which tells that

ORA-19815: WARNING: db_recovery_file_dest_size of 42949672960 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.

************************************************************************

>>  Check db_recovery_file_dest_size 

SQL> show parameter db_recovery_file_dest_size;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest_size           big integer 40G

>>  Increase the size of db_recovery_file_dest_size

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 45G sCOPE=BOTH 

SID='*';

System altered.

SQL> show parameter db_recovery_file_dest_size;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest_size           big integer 45G

SQL>

SQL>

>>  database open

SQL> alter database open;

Database altered.

SQL>

>>  Use crosscheck and delete expired archive log. 

SQL> !rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jan 24 13:05:16 2016

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

connected to target database: RTGSDB (DBID=1759447511)

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;