Thursday, 27 June 2013

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

Hi All,

My flash recovery area was full so i did shutdown immediate but it takes about 1 hr so i did shutdown abort and remove some files from flash_recovery_area now I ran the cmd startup but database is not going to up it is now mount mode and error comes:

SQL> alter database open;
alter database open
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 9174
Session ID: 191 Serial number: 3

The solution is Here under.

you have removed files from the fast recovery area, so now you have to tell Oracle that you have removed them. From an RMAN prompt:

crosscheck archivelog all;
crosscheck backupset;
crosscheck copy;
delete expired;

I would strongly advise you to shutdown your database immediately, put it back into archivelog mode, do the above, and perform a backup

Thanking you
Mohammad Shahnawaz
oracle's passion

No comments:

Post a Comment