Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

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”;

 

 

Related Posts
Write a comment