[ORACLE]ORA-03113: end-of-file on communication channel

数据库启动失败 ORA-03113: end-of-file on communication channel

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294964360 bytes
Fixed Size            9143432 bytes
Variable Size         2231369728 bytes
Database Buffers      973078528 bytes
Redo Buffers            7630848 bytes
In-Memory Area         1073741824 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4945
Session ID: 2 Serial number: 54140

查询FLASH back 使用情况

原来是大批量的数据插入导致闪回空间不足, 最常用的办法删除不需要的归档日志文件或者增加闪回空间大小(db_recovery_file_dest_size)

SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294964360 bytes
Fixed Size            9143432 bytes
Variable Size         2231369728 bytes
Database Buffers      973078528 bytes
Redo Buffers            7630848 bytes
In-Memory Area         1073741824 bytes
Database mounted.
SQL> col name for A50
SQL> select name,(space_used/1024/1024),(space_limit/1024/1024) from v$recovery_file_dest;

NAME                           (SPACE_USED/1024/1024) (SPACE_LIMIT/1024/1024)
-------------------------------------------------- ---------------------- -----------------------
/oracle/D4C/recovery_area                       12662.4673             3000

增加闪回空间

SQL> alter system set db_recovery_file_dest_size=20000M;

System altered.

SQL> select name,(space_used/1024/1024),(space_limit/1024/1024) from v$recovery_file_dest;

NAME                           (SPACE_USED/1024/1024) (SPACE_LIMIT/1024/1024)
-------------------------------------------------- ---------------------- -----------------------
/oracle/D4C/recovery_area                       13036.3516            20000

重新启动

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294964360 bytes
Fixed Size            9143432 bytes
Variable Size         2231369728 bytes
Database Buffers      973078528 bytes
Redo Buffers            7630848 bytes
In-Memory Area         1073741824 bytes
Database mounted.
Database opened.