Quantcast
OracleBrains.Com header image 2

Error ORA-03113: end-of-file on communication channel when opening database

February 19th, 2011 by Rajender Singh · 1 Comment

Today I faced following problem while starting the database.

SQL> connect /  as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 3891630080 bytes
Fixed Size                  2181664 bytes
Variable Size            2835351008 bytes
Database Buffers         1040187392 bytes
Redo Buffers               13910016 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 4656
Session ID: 178 Serial number: 5

After that I checked the alert file and found that there is not enough space in FLASH RECOVERY AREA

Following is the log extract from it

ARC0: Error 19809 Creating archive log file to ‘F:\ORACLE\FLASH_RECOVERY_AREA\BIZWIZDB\ARCHIVELOG\2011_02_12\O1_MF_1_6105_%U_.ARC’
Errors in file c:\app\administrator\diag\rdbms\bizwizdb\bizwizdb\trace\bizwizdb_ora_2108.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 32212254720 bytes is 100.00% used, and has 0 remaining bytes available

ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 39100928 bytes disk space from 32212254720 limit
ARCH: Error 19809 Creating archive log file to ‘F:\ORACLE\FLASH_RECOVERY_AREA\BIZWIZDB\ARCHIVELOG\2011_02_12\O1_MF_1_6104_%U_.ARC’

So I increase the FLASH RECOVERY AREA using following command.

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 50G SCOPE=BOTH SID=’*';

System altered.

Then I tried starting the database but again oracle instance crash with same error (ORA-03113: end-of-file on communication channel)

I again checked the alert log and to my surprise I found that Oracle again crashing due to same issue. To my surprise it is showing 50G full.

Following is the log extract from it

ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 43803648 bytes disk space from 64424509440 limit
*** 2011-02-12 11:17:17.438 4132 krsh.c
ARC1: Error 19809 Creating archive log file to ‘F:\ORACLE\FLASH_RECOVERY_AREA\BIZWIZDB\ARCHIVELOG\2011_02_12\O1_MF_1_6105_%U_.ARC’
*** 2011-02-12 11:17:17.439 2747 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1

Then I tried increasing/decreasing the space but again and again it giving me same error.

This really got me worried :(

I then tried recovering the database as follows:

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

But didn’t work.

I then mount the database using RMAN and deleted the archive log.

But still it didn’t work :(

Then I thought of moving the archive log out of FLASH RECOVER AREA.

So I did it as follows:

SQL> alter system set LOG_ARCHIVE_DEST_1=’LOCATION=F:\oracle\archive\bizwizdb’;

System altered.

SQL> ALTER SYSTEM ARCHIVE LOG STOP;

System altered.

SQL> ALTER SYSTEM ARCHIVE LOG START;

System altered.

Then I tried opening the database as follows:

SQL> ALTER DATABASE OPEN;

Database altered.

and I saw magic words “Database altered” :)

Tags: Oracle Administration

1 response so far ↓

  • 1 sagar // Jan 2, 2012 at 10:29 pm

    Good one ! Needs more explanation as to what went wrong with 50G ?

Leave a Comment