While starting database ORA-03113: end-of-file on communication channel

ERROR

While starting database ORA-03113: end-of-file on communication channel

Problem:

On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short

Solution:

Mount the database, increase the db_recovery_file_dest_size and then open the database

SQL> startup mount
ORACLE instance started.
Total System Global Area 8584982528 bytes
Fixed Size 2262088 bytes
Variable Size 4462742456 bytes
Database Buffers 4093640704 bytes
Redo Buffers 26337280 bytes
Database mounted.

SQL> alter system set db_recovery_file_dest_size=100G scope=both;

SQL> alter database open;

Recent Posts