强制关机导致ORA-03113

         数据库启动报错：无法打开数据库。

[oracle@localhost ORCL]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 2 16:00:59 2016   Copyright (c) 1982, 2013, Oracle.  All rights reserved.   Connected to an idle instance.   SQL> startup ORACLE instance started.   Total System Global Area  705662976 bytes Fixed Size              2256592 bytes Variable Size                373293360 bytes Database Buffers       322961408 bytes Redo Buffers                 7151616 bytes Database mounted. alter database open * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 5113 Session ID: 580 Serial number: 47

         警告日志信息如下：通过警告信息我们知道当前我们的闪回恢复区满了，删除闪回恢复区数据库重新启动数据库报告同样的错误。

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4187.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 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/app/oracle/fast_recovery_area/ORCL/archivelog/2016_06_02/o1_mf_1_231_%u_.arc' Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4187.trc: ORA-16038: log 3 sequence# 231 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 3 thread 1: '/data/oradata/orcl/orcl/redo03.log' USER (ospid: 4187): terminating the instance due to error 16038 System state dump requested by (instance=1, osid=4187), summary=[abnormal instance termination]. System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_4157_20160602154925.trc Dumping diagnostic data in directory=[cdmp_20160602154925], requested by (instance=1, osid=4187), summary=[abnormal instance termination]. Instance terminated by USER, pid = 4187

         再往下看，我们看到这个错误ORA-00312: online log 3 thread 1: '/data/oradata/orcl/orcl/redo03.log'

                                           USER (ospid: 4187): terminating the instance due to error 16038

         这个错误导致instance被关闭。可能是因为强制断电，导致redo03.log文件损坏，我们通过sqlplus进行recover后以resetlogs方式打开数据库试试：

[oracle@localhost ORCL]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 2 16:03:54 2016   Copyright (c) 1982, 2013, Oracle.  All rights reserved.   Connected to an idle instance.   SQL> startup mount ORACLE instance started.   Total System Global Area  705662976 bytes Fixed Size              2256592 bytes Variable Size                373293360 bytes Database Buffers       322961408 bytes Redo Buffers                 7151616 bytes Database mounted. SQL> recover database until cancel; Media recovery complete. SQL> SQL> alter database open resetlogs;   Database altered.   SQL> select instance_name,status from v$instance;   INSTANCE_NAME             STATUS ------------------------------------------------------------------------------------ Orcl                        OPEN SQL>

         数据库至此恢复完毕。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29612373/viewspace-2113019/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29612373/viewspace-2113019/