Oracle数据库关闭时出现ORA-03113错误

Oracle数据库关闭时，出现ORA-03113错误：SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
Process ID: 3437
Session ID: 125 Serial number: 5
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn"t exist
SQL>
SQL>
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn"t exist
SQL>
SQL>
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn"t exist
SQL>
SQL> alter datafile "/bk/ts5.2.dbf" offline
2 ;
ERROR:
ORA-03114: not connected to ORACLE 查看日志文件：
/u01/app/diag/rdbms/orcl/orcl/trace/alert_orcl.log16416 Errors in file /u01/app/diag/rdbms/orcl/orcl/trace/orcl_dbw0_4055.trc:
16417 ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
16418 ORA-01110: data file 6: "/bk/ts5.2.dbf"
16419 ORA-27037: unable to obtain file status
16420 Linux Error: 2: No such file or directory
16421 Additional information: 3
16422 Errors in file /u01/app/diag/rdbms/orcl/orcl/trace/orcl_ora_4097.trc:
16423 ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
16424 ORA-01110: data file 6: "/bk/ts5.2.dbf"
16425 ORA-1157 signalled during: ALTER DATABASE OPEN...
16426 Mon Oct 21 20:53:43 2013
16427 Checker run found 1 new persistent data failures
16428 Mon Oct 21 20:54:53 2013发现是因为刚刚创建的表空间文件丢失，导致的。
开始修复表空间文件。解决方法：
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> startup
ORACLE instance started.Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: "/bk/ts5.2.dbf"
SQL> alter database datafile "/bk/ts5.2.dbf" offline drop;Database altered.SQL>
SQL>
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
Database opened.
SQL>
由于是表空间文件丢失，最后查看一下表空间：
SQL>
SQL> select tablespace_name, file_name from dba_data_files;TABLESPACE_NAME FILE_NAME
-------------------- ----------------------------------------
EXAMPLE /u01/app/oradata/orcl/example01.dbf
UNDOTBS1 /u01/app/oradata/orcl/undotbs01.dbf
SYSAUX /u01/app/oradata/orcl/sysaux01.dbf
SYSTEM /u01/app/oradata/orcl/system01.dbf
USERS /u01/app/oradata/orcl/users01.dbf
TS5 /bk/ts5.2.dbf
TS5 /bk/ts5.dbf7 rows selected.SQL> select file#, name, status from v$datafile; FILE# NAME STATUS
---------- ---------------------------------------- -------
1 /u01/app/oradata/orcl/system01.dbf SYSTEM
2 /u01/app/oradata/orcl/sysaux01.dbf ONLINE
3 /u01/app/oradata/orcl/undotbs01.dbf ONLINE
4 /u01/app/oradata/orcl/users01.dbf ONLINE
5 /u01/app/oradata/orcl/example01.dbf ONLINE
6 /bk/ts5.2.dbf RECOVER
7 /bk/ts5.dbf ONLINE7 rows selected.SQL>更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12ORA-00119: invalid specification for system parameter LOCAL_LISTENEROracle 11G函数整理相关资讯 ORA-03113

误删重做日志文件组导致启动数据库（07/17/2015 11:53:45）
ORA-03113解决方法（10/16/2014 18:58:34）
ORA-03113:通信通道的文件结尾（04/15/2014 12:17:33）

Oracle启动报错ORA-03113解决（04/03/2015 09:35:35）
Oracle错误——ORA-03113:通信通道（09/29/2014 20:24:47）
Oracle 11g ORA-03113故障，重建控（02/12/2014 14:29:09）

本文评论查看全部评论（0）