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

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

Process ID: 3294

Session ID: 237 Serial number: 5

解决办法：

1.查看alert日志

2.执行下面操作

SQL> show parameter recovery

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /opt/oracle11g/flash_recovery_

area

db_recovery_file_dest_size big integer 20G

recovery_parallelism integer 0

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

System altered.

Elapsed: 00:00:00.06

SQL> alter database open;

Database altered.

Elapsed: 00:00:22.48

SQL>

3.使用RMAN清除过期归档日志。

crosscheck archivelog all;

DELETE EXPIRED archivelog all;