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;
