数据库启动报错：无法打开数据库。
| [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> |
数据库至此恢复完毕。