oracle无法启动ora03113,Oracle启动失败：ORA-03113

今天遇到Oracle无法启动，报"ORA-03113: end-of-file on communication channel"错误

解决过程如下

一. 查找原因

1. 运行"adrci"命令，用于查看错误日志

$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Wed May 27 05:24:30 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

ADR base = "/home/oracle11/app/oracle11"

adrci>

2. 查看并设置目录

adrci> show homes

ADR Homes:

diag/tnslsnr/RDRedHat/listener

diag/rdbms/orcl/orcl

adrci>

adrci> set home diag/rdbms/orcl/orcl

3.

adrci> show alert -tail 100显示错误如下

Errors in file /home/oracle11/app/oracle11/diag/rdbms/orcl/orcl/trace/orcl_arc1_4542.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 34422784 bytes disk space from 4039114752 limit

ARC1: Error 19809 Creating archive log file to '/home/oracle11/app/oracle11/flash_recovery_area/ORCL/archivelog/2015_05_27/o1_mf_1_230_%u_.arc'

至此查找出问题原因：

归档日志满了

二. 解决方法

通过rman删除归档日志

使用的命令如下

$ rman target /

RMAN> startup mount

RMAN> delete noprompt archivelog all;

RMAN> crosscheck archivelog all;

RMAN> alter database open;

database opened