oracle 11G ORA-03113 ORA-19815错误

oracle11.2.0.3 安装在linux 6.3上，发现数据库连不上。

通过sqlplus连接数据库，startup启动报ORA-03113错误

1 2 3 4 5 6 7 8 9 10 11

SQL> startup ORACLE instance started. Total System Global Area 3641094144 bytes Fixed Size                  2233680 bytes Variable Size            2013268656 bytes Database Buffers         1610612736 bytes Redo Buffers               14979072 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 4332 Session ID: 45 Serial number: 3

检查oracle错误日志alert.log（位置在oracl_base/diag/rdbms/orcl/orcl/trace）发现有很多ORA-19815错误

1 2 3 4 5 6 7 8 9 10 11 12 13

ARC0: Error 19809 Creating archive log file to'/opt/oracle/fast_recovery_area/ORCL/archivelog/2013_07_03/o1_mf_1_112_%u_.arc' Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc2_4393.trc: ORA-19815: : db_recovery_file_dest_size  (322230272 ) 00.00%,  0************************************************************************ 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.

报错信息很明显是因为db_recovery_file_dest_size太小了，增加其大小步骤如下：

1.首先要停止oracle进程，可以kill掉ora_*进程

2.使用mount方式启动数据库

SQL>startup mount;

3.增加恢复日志空间

SQL>alter system set db_recovery_file_dest_size= 10G;

4.正常重启数据库

SQL>shutdown immediate;

SQL>startup;