Oracle 11g startup时报ora-03113通信通道的文件结尾

数据库启动报错ora-03113通信通道的文件结尾

 

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size            2253664 bytes
Variable Size         1023413408 bytes
Database Buffers      570425344 bytes
Redo Buffers            7319552 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 41026
Session ID: 16 Serial number: 3

查看数据库日志

/u01/app/oracle/diag/rdbms/noap/noap1/trace

Trace file /u01/app/oracle/diag/rdbms/noap/noap1/trace/noap1_ora_41026.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:    Linux
Node name:      rac1
Release:        2.6.32-431.el6.x86_64
Version:        #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine:        x86_64
VM name:        VMWare Version: 6
Instance name: noap1
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 41026, image: oracle@rac1 (TNS V1-V3)

*** 2019-01-08 21:52:35.305
*** SESSION ID:(16.3) 2019-01-08 21:52:35.305
*** CLIENT ID:() 2019-01-08 21:52:35.305
*** SERVICE NAME:() 2019-01-08 21:52:35.305
*** MODULE NAME:(sqlplus@rac1 (TNS V1-V3)) 2019-01-08 21:52:35.305
*** ACTION NAME:() 2019-01-08 21:52:35.305

Initial buffer sizes: read 1024K, overflow 832K, change 805K
ORA-19815: WARNING: db_recovery_file_dest_size of 4621074432 bytes is 100.00% used, and has 0 remaining bytes available.

是db_recovery_file_dest_size也叫归档日志空间不足导致的

解决方案

增大空间

sqlplus / as sysdba
shutdown abort     —-关闭进程
startup mount       —- 装载数据库

show  parameter db_recovery;   —-查看目前归档日志设置大小

NAME                     TYPE     VALUE
———————————— ———– ——————————
db_recovery_file_dest             string     +ARCH
db_recovery_file_dest_size         big integer 4407M

目前我设置的是4G ,较小修改大小为8G
alter system set db_recovery_file_dest_size=8G; –设置归档日志空间为8G

select * from v$recovery_file_dest; —查询归档日志

NAME
——————————————————————————–
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
———– ———- —————– —————
+ARCH
8589934592 4839178240                 0             148
Exit —到这里空间大小已经设置完成

关闭重新测试重新启动

SQL>shutdown immediate;

SQL>startup;

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size            1023413408 bytes
Database Buffers          570425344 bytes
Redo Buffers                7319552 bytes
Database mounted.
Database opened.

发表评论