丟失了設(shè)備文件如何用系統(tǒng)表來(lái)修復(fù)（在線等）

pepsion

昨天shutdown數(shù)據(jù)庫(kù)后，不知道怎么回事啟動(dòng)不了應(yīng)用的庫(kù)了
報(bào)下面的錯(cuò)
00:00000:00001:2005/08/17 09:20:44.68 server  Error: 3414, Severity: 17, State: 3
00:00000:00001:2005/08/17 09:20:44.68 server  Database 'fmdb' (dbid 5): Recovery failed. Check the SQL Server errorlog for further i
nformation as to the cause.
00:00000:00001:2005/08/17 09:20:44.75 server  Recovering database 'pmdb'.
00:00000:00001:2005/08/17 09:20:44.75 server  Error: 840, Severity: 17, State: 2
00:00000:00001:2005/08/17 09:20:44.75 server  Device 'pmdb_log' (with physical name '/data/pmdb.log', and virtual device number 15)
has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
00:00000:00001:2005/08/17 09:20:44.75 server  Error: 3414, Severity: 17, State: 3
00:00000:00001:2005/08/17 09:20:44.75 server  Database 'pmdb' (dbid 6): Recovery failed. Check the SQL Server errorlog for further i
nformation as to the cause.
00:00000:00001:2005/08/17 09:20:44.80 server  Recovering database 'sysmdb'.
00:00000:00001:2005/08/17 09:20:44.80 server  Error: 840, Severity: 17, State: 2
00:00000:00001:2005/08/17 09:20:44.80 server  Device 'sysmdb_log' (with physical name '/data/sysmdb.log', and virtual device number
17) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
00:00000:00001:2005/08/17 09:20:44.80 server  Error: 3414, Severity: 17, State: 3
00:00000:00001:2005/08/17 09:20:44.80 server  Database 'sysmdb' (dbid 7): Recovery failed. Check the SQL Server errorlog for further
information as to the cause.

hejiajun

要有備份才能恢復(fù)吧,用系統(tǒng)表咋恢復(fù),你都不見了那些設(shè)備文件,日志太少,是好多貼點(diǎn)出來(lái)

RS9000

設(shè)備怎么會(huì)無(wú)緣無(wú)故的不能用呢？？環(huán)境說(shuō)清楚。。。
'/data/pmdb.log'。。先確定設(shè)備能找到。。。

pepsion

沒(méi)有pmdb.log,sysmdb.log這些文件了
昨天把數(shù)據(jù)庫(kù)shutdown關(guān)機(jī)后，今天啟動(dòng)就報(bào)錯(cuò)了sybase版本是12.0.0.8運(yùn)行在solaris下

RS9000

暈。。你到該目錄下檢查該文件是否存在，文件系統(tǒng)是否mount，所在pv是否正常

pepsion

data目錄是掛接的本地磁盤，里面的pmdb.data，sysmdb.data這些就是沒(méi)有sysmdb.log