ORA-03113: end-of-file on communication channel

来源：互联网发布：百度竞价账户如何优化编辑：程序博客网时间：2024/06/05 11:45

磁盘组满了

过程如下：

SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size 2212936 bytes
Variable Size 486542264 bytes
Database Buffers 754974720 bytes
Redo Buffers 8933376 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7844
Session ID: 1 Serial number: 5

查看日志可知磁盘组满
ARC3 started with pid=38, OS id=7852
Errors in file /u02/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_7844.trc:
ORA-19504: failed to create file "+FRA"
ORA-17502: ksfdcre:4 Failed to create file +FRA
ORA-15041: diskgroup "FRA" space exhausted
ARCH: Error 19504 Creating archive log file to '+FRA'

扩展磁盘组
[grid@up2 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 10 05:50:19 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup fra add disk '/u01/asm-disk/fra2' rebalance power 10;

Diskgroup altered.

0 0