数据库启动失败 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.