ORA-03113 解决办法

34rfdw

有个数据库，好久没碰了，今天临时需要用一下，发现instance挂了，启动时候报如下错误：
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 27 13:42:46 2013  

Copyright (c) 1982, 2009, Oracle.  All rights reserved.  

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

Total System Global Area 6747725824 bytes  
Fixed Size          2213976 bytes  
Variable Size        5234493352 bytes  
Database Buffers     1476395008 bytes  
Redo Buffers           34623488 bytes  
Database mounted.  
ORA-03113: end-of-file on communication channel  
Process ID: 19925  
Session ID: 96 Serial number: 3  

报了03113错误
[oracle@yoo ~]$ oerr ora 03113  
03113, 00000, "end-of-file on communication channel"  
// *Cause: The connection between Client and Server process was broken.  
// *Action: There was a communication error that requires further investigation.  
//          First, check for network problems and review the SQL*Net setup.   
//          Also, look in the alert.log file for any errors. Finally, test to   
//          see whether the server process is dead and whether a trace file  
//          was generated at failure time.  
就查了下日志，有如下关键信息：
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes avail  
able.  
<txt>Errors in file /usr/local/oracle/diag/rdbms/hiboxbi/hiboxBI/trace/hiboxBI_arc1_19938.trc:  
ORA-16038: log 2 sequence# 5651 cannot be archived  
ORA-19809: limit exceeded for recovery files  
ORA-00312: online log 2 thread 1: '/usr/local/oracle/oradata/HIBOXBI/onlinelog/o1_mf_2_71qg20vh_.log'  
ORA-00312: online log 2 thread 1: '/usr/local/oracle/flash_recovery_area/HIBOXBI/onlinelog/o1_mf_2_71qg21kq_.l  
og'  
</txt>  
</msg>  
<msg time='2013-11-27T13:43:03.116+08:00' org_id='oracle' comp_id='rdbms'  
很明显了，db_recovery空间满了，解决办法有2个（增加空间大小或者清理过期的归档日志），这里采用了前者，问题解决。
SQL> startup mount;  
ORACLE instance started.  

Total System Global Area 6747725824 bytes  
Fixed Size          2213976 bytes  
Variable Size        5234493352 bytes  
Database Buffers     1476395008 bytes  
Redo Buffers           34623488 bytes  
Database mounted.  
SQL> show parameter db_recovery_file_dest_size;  

NAME                     TYPE    VALUE  
------------------------------------ ----------- ------------------------------  
db_recovery_file_dest_size       big integer 3882M  
SQL> alter system set db_recovery_file_dest_size=8G scope=both;  

System altered.  

SQL> start^H^H^H^H^H  
SP2-0310: unable to open f.sql"  
SQL> alter database open;  

Database altered.  
-----------------------------------------------------------------------------------------------------------------------------

ukula

没看完~~~~~~先顶，好同志