Home / Errors/Workarounds10g / ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL

ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL

ERROR

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

Total System Global Area 1987563520 bytes
Fixed Size 2214696 bytes
Variable Size 1040188632 bytes
Database Buffers 939524096 bytes
Redo Buffers 5636096 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5114
Session ID: 191 Serial number: 3

SOLUTION

Connect to the RMAN, and delete archive log older than a week.

$rman target /

RMAN> startup mount;

RMAN> delete archivelog until time “sysdate-7”;

OR

RMAN> delete force archivelog all;

OR

RMAN> delete backup completed before “sysdate-3”;

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old More from my siteHow To …

Leave a Reply