环境:oracle 11g 11.2.0.4 r2 RAC
ORALCE启动时报如下错误:
[oracle@racnode2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 30 22:58:07 2021
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 675285024 bytes
Database Buffers 150994944 bytes
Redo Buffers 6606848 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10991
Session ID: 7 Serial number: 5
解决思路(ORACLE 11g):
查看orcle启动日志,确定具体是什么原因引起的错误。
1、查看orcle启动日志,确定具体是什么原因引起的错误。
cd $ORACLE_HOME/diag/rdbms/实例名/实例名/trace/
查看日志位置
[root@racnode2 /]# locate trace|grep 'racdb'|more
/u01/app/oracle/diag/rdbms/racdb/racdb2/trace
/u01/app/oracle/diag/rdbms/racdb/racdb2/trace/alert_racdb2.log
ls -alcr | grep alert (c时间排序、r倒序) 定位启动日志。
[root@racnode2 ~]# cd /u01/app/oracle/diag/rdbms/racdb/racdb2/trace
[root@racnode2 trace]# ls -alcr | grep alert
-rw-r----- 1 oracle asmadmin 78259096 04-30 22:59 alert_racdb2.log
2.tail -f -n 500 alert_ncdbemu.log
然后重启运行startup命令:得到oracle提示如下:
************************************************************************
************************************************************************
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc0_11801.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 42991616 字节磁盘空间 (从 139586437120 限制中)
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc1_11803.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 42991616 字节磁盘空间 (从 139586437120 限制中)
ARC0: Error 19809 Creating archive log file to '+FRA'
ARC1: Error 19809 Creating archive log file to '+FRA'
Errors in file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_arc0_11801.trc:
ORA-16038: 日志 2 sequence# 23