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