求助:关于oracle报警，麻烦大家帮忙解解答，谢谢

kingnowok

环境：SunOS 5.9  Oracle9i
突然有一天数据库的log报以下信息：
ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbdata/...
ORA-02068: 以下严重错误源于CNOSSLINK
ORA-03113: 通信通道的文件结束
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP01
ORA-12901 signalled during: /* OracleOEM */ ALTER DATABASE DEFAULT TEMPORARY T...
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP01
个 signalled during: Alter tablespace TEMP coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-959 signalled during: Alter tablespace TEMP coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-959 signalled during: Alter tablespace TEMP coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-959 signalled during: Alter tablespace TEMP coalesce
ORA-959 signalled during: Alter tablespace TEMP2 coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-3217 signalled during: Alter tablespace TEMP01 offline
ORA-3217 signalled during: alter tablespace temp01
ORA-959 signalled during: alter tablespace temp2
ORA-959 signalled during: alter   database   default   temporary   tablespac...
ORA-12907 signalled during: alter   database   default   temporary   tablespac...
ORA-3217 signalled during: alter tablespace temp01 offline
ORA-959 signalled during: alter tablespace temporary offline
ORA-959 signalled during: alter tablespace temp offline
ORA-959 signalled during: alter tablespace temp2 offline
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-3217 signalled during: Alter tablespace TEMP01 coalesce
ORA-1511 signalled during: /* OracleOEM */ ALTER DATABASE RENAME FILE '/mback...
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbsys/d...
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbsys/d...
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbsys/d...
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
ORA-1157 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbsys/d...




关于ORA-02068：其实在该台上做的dblink早已drop掉，不知为啥还报，后来我又重建了一遍，查询都ok，但log里还是报这个信息？

关于ORA-959：其实数据库就一个临时表空间TEMP01，可不知为啥又报TEMP和TEMP2的信息？

关于ORA-01110：'/mdbsys/drm04.dbf'是表空间DRM的一个文件，是空的文件，现在我已经把这个文件脱机掉，可为啥还在报警？

kingnowok

跪求哪位大虾指条明路~~~~

kingnowok

跪求。。。。

numenhuang

1.现在数据库是什么状态，正常open工作？
2.数据库有没有重启过？
3.把最新的alert_sid.log传上来看看（内容截断一下）

kingnowok

谢谢numenhuang支持。
1。数据库目前工作正常。
2。数据库一般情况下不敢冒然重起，涉及应用太多。
3。log粘上最新的纪录，由于不是很多，未做删减
如下：
Thu Mar  8 00:00:40 2007
Thread 1 advanced to log sequence 4032
  Current log# 1 seq# 4032 mem# 0: /mdbdata/redo11.log
  Current log# 1 seq# 4032 mem# 1: /mdbsys/redo12.log
Thu Mar  8 00:00:40 2007
ARC1: Evaluating archive   log 2 thread 1 sequence 4031
ARC1: Beginning to archive log 2 thread 1 sequence 4031
Creating archive destination LOG_ARCHIVE_DEST_1: '/mdbarch/1_4031.arc'
ARC1: Completed archiving  log 2 thread 1 sequence 4031
Thu Mar  8 01:10:04 2007
Errors in file /oracle/admin/mediadb/bdump/mediadb_dbw0_1988.trc:
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Thu Mar  8 01:10:05 2007
Errors in file /oracle/admin/mediadb/bdump/mediadb_dbw0_1988.trc:
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01110: data file 36: '/mdbsys/drm04.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Thu Mar  8 01:24:15 2007
Thread 1 advanced to log sequence 4033
Thu Mar  8 01:24:15 2007
  Current log# 3 seq# 4033 mem# 0: /mdbdata/redo31.log
Thu Mar  8 01:24:15 2007
ARCH: Evaluating archive   log 1 thread 1 sequence 4032
  Current log# 3 seq# 4033 mem# 1: /mdbsys/redo32.log
Thu Mar  8 01:24:15 2007
ARCH: Beginning to archive log 1 thread 1 sequence 4032
Thu Mar  8 01:24:15 2007
ARC0: Evaluating archive   log 1 thread 1 sequence 4032
ARC0: Unable to archive log 1 thread 1 sequence 4032
      Log actively being archived by another process
Thu Mar  8 01:24:15 2007
Creating archive destination LOG_ARCHIVE_DEST_1: '/mdbarch/1_4032.arc'
ARCH: Completed archiving  log 1 thread 1 sequence 4032
Thu Mar  8 01:24:20 2007
Thread 1 advanced to log sequence 4034
  Current log# 2 seq# 4034 mem# 0: /mdbdata/redo21.log
  Current log# 2 seq# 4034 mem# 1: /mdbsys/redo22.log
Thu Mar  8 01:24:20 2007
ARCH: Evaluating archive   log 3 thread 1 sequence 4033
Thu Mar  8 01:24:20 2007
ARC0: Evaluating archive   log 3 thread 1 sequence 4033
ARC0: Unable to archive log 3 thread 1 sequence 4033
      Log actively being archived by another process
Thu Mar  8 01:24:20 2007
ARCH: Beginning to archive log 3 thread 1 sequence 4033
Creating archive destination LOG_ARCHIVE_DEST_1: '/mdbarch/1_4033.arc'
ARCH: Completed archiving  log 3 thread 1 sequence 4033

kingnowok

问题已经解决，是我们自己的报警脚步设置有问题，报警信息其实是log中很早以前的数据。