亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

  免費(fèi)注冊(cè) 查看新帖 |

Chinaunix

  平臺(tái) 論壇 博客 文庫(kù)
最近訪(fǎng)問(wèn)板塊 發(fā)新帖
查看: 7375 | 回復(fù): 5
打印 上一主題 下一主題

求助:關(guān)于oracle報(bào)警，麻煩大家?guī)兔饨獯�，謝謝 [復(fù)制鏈接]

論壇徽章:
0
跳轉(zhuǎn)到指定樓層
1樓 [收藏(0)] [報(bào)告]
發(fā)表于 2007-03-07 13:41 |只看該作者 |倒序?yàn)g覽
環(huán)境：SunOS 5.9  Oracle9i
突然有一天數(shù)據(jù)庫(kù)的log報(bào)以下信息：
ORA-3297 signalled during: /* OracleOEM */ ALTER DATABASE DATAFILE '/mdbdata/...
ORA-02068: 以下嚴(yán)重錯(cuò)誤源于CNOSSLINK
ORA-03113: 通信通道的文件結(jié)束
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
個(gè) 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...




關(guān)于ORA-02068：其實(shí)在該臺(tái)上做的dblink早已drop掉，不知為啥還報(bào)，后來(lái)我又重建了一遍，查詢(xún)都o(jì)k，但log里還是報(bào)這個(gè)信息？

關(guān)于ORA-959：其實(shí)數(shù)據(jù)庫(kù)就一個(gè)臨時(shí)表空間TEMP01，可不知為啥又報(bào)TEMP和TEMP2的信息？

關(guān)于ORA-01110：'/mdbsys/drm04.dbf'是表空間DRM的一個(gè)文件，是空的文件，現(xiàn)在我已經(jīng)把這個(gè)文件脫機(jī)掉，可為啥還在報(bào)警？

論壇徽章:
0
2樓 [報(bào)告]
發(fā)表于 2007-03-07 16:19 |只看該作者
跪求哪位大蝦指條明路~~~~

論壇徽章:
0
3樓 [報(bào)告]
發(fā)表于 2007-03-07 22:22 |只看該作者
跪求。。。。

論壇徽章:
0
4樓 [報(bào)告]
發(fā)表于 2007-03-07 23:20 |只看該作者
1.現(xiàn)在數(shù)據(jù)庫(kù)是什么狀態(tài)，正常open工作？
2.數(shù)據(jù)庫(kù)有沒(méi)有重啟過(guò)？
3.把最新的alert_sid.log傳上來(lái)看看（內(nèi)容截?cái)嘁幌拢?/td>

論壇徽章:
0
5樓 [報(bào)告]
發(fā)表于 2007-03-08 09:34 |只看該作者
謝謝numenhuang支持。
1。數(shù)據(jù)庫(kù)目前工作正常。
2。數(shù)據(jù)庫(kù)一般情況下不敢冒然重起，涉及應(yīng)用太多。
3。log粘上最新的紀(jì)錄，由于不是很多，未做刪減
如下：
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

論壇徽章:
0
6樓 [報(bào)告]
發(fā)表于 2007-03-08 11:12 |只看該作者
問(wèn)題已經(jīng)解決，是我們自己的報(bào)警腳步設(shè)置有問(wèn)題，報(bào)警信息其實(shí)是log中很早以前的數(shù)據(jù)。
您需要登錄后才可以回帖 登錄 | 注冊(cè)

本版積分規(guī)則 發(fā)表回復(fù)

  

北京盛拓優(yōu)訊信息技術(shù)有限公司. 版權(quán)所有 京ICP備16024965號(hào)-6 北京市公安局海淀分局網(wǎng)監(jiān)中心備案編號(hào)：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年舉報(bào)專(zhuān)區(qū)
中國(guó)互聯(lián)網(wǎng)協(xié)會(huì)會(huì)員  聯(lián)系我們：huangweiwei@itpub.net
感謝所有關(guān)心和支持過(guò)ChinaUnix的朋友們 轉(zhuǎn)載本站內(nèi)容請(qǐng)注明原作者名及出處

清除 Cookies - ChinaUnix - Archiver - WAP - TOP