数据库启动open报错:ORA-03113: end-of-file on communication channel

来源:互联网 发布:泗阳网络问政123456 编辑:程序博客网 时间:2024/06/05 08:35

数据库启动open报错:ORA-03113: end-of-file on communication channel



SQL> startup
ORACLE instance started.


Total System Global Area  413372416 bytes
Fixed Size                  2228904 bytes
Variable Size             314576216 bytes
Database Buffers           92274688 bytes
Redo Buffers                4292608 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2425
Session ID: 1 Serial number: 5


alert 如下:



Errors in file /u01/oracle/diag/rdbms/qing/qing/trace/qing_ora_2716.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 314572800 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
ARCH: Error 19809 Creating archive log file to '/u01/flashback/QING/archivelog/2013_09_16/o1_mf_1_21_%u_.arc'
Errors in file /u01/oracle/diag/rdbms/qing/qing/trace/qing_ora_2716.trc:
ORA-16038: log 5 sequence# 21 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 5 thread 1: '/u01/oracle/oradata/qing/redo05.log'
USER (ospid: 2716): terminating the instance due to error 16038
System state dump requested by (instance=1, osid=2716), summary=[abnormal instance termination].
System State dumped to trace file /u01/oracle/diag/rdbms/qing/qing/trace/qing_diag_2664.trc
Dumping diagnostic data in directory=[cdmp_20130916033718], requested by (instance=1, osid=2716), summary=[abnormal instance termination].
Instance terminated by USER, pid = 2716


解决办法 :





SQL> startup mount
[oracle@OEL63 ~]$ rman target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
SQL> alter database open;