- 论坛徽章:
- 0
|
1、我在建立好裸设备中系统没有出问题。
2、我在sybase中执行下面sql语句
se master
go
declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3
disk init
name='simudatadb',
physname='/sybase/data/simudatadb',
vdevno=@vdevno,
size=204800
go
declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3
disk init
name='simuindexdb',
physname='/sybase/data/simuindexdb',
vdevno=@vdevno,
size=51200
go
declare @vdevno int
select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3
disk init
name='simudblog',
physname='/sybase/data/simudblog',
vdevno=@vdevno,
size=102400
go
3、然后在unixware7.11中的sybase日志中发现下面信息
00:00000:00008:2006/02/15 14:59:38.31 kernel Initializing virtual device 28, '/sybase/simu/simudatadb'
00:00000:00008:2006/02/15 14:59:38.31 kernel Virtual device 28 started using standard unix i/o.
00:00000:00008:2006/02/15 14:59:38.64 kernel Initializing virtual device 29, '/sybase/simu/simuindexdb'
00:00000:00008:2006/02/15 14:59:38.64 kernel Virtual device 29 started using standard unix i/o.
00:00000:00008:2006/02/15 14:59:38.75 kernel Initializing virtual device 30, '/sybase/simu/simudblog'
00:00000:00008:2006/02/15 14:59:38.75 kernel Virtual device 30 started using standard unix i/o.
00:00000:00001:2006/02/15 15:10:23.23 server Starting diagnostics for read failure:
00:00000:00001:2006/02/15 15:10:23.24 server Device Information: Device number = 0
Phyname = /sybase/data/master
00:00000:00001:2006/02/15 15:10:23.24 server Buffer Information evice number = 0
Phyname = /sybase/data/master
00:00000:00001:2006/02/15 15:10:23.24 server Buffer Information:
Buf addr = 0xbf9b7f88, Mass addr = 0xbf9b7f88
Buf pageno = 337, Mass pageno = 337, dbid = 3
00:00000:00001:2006/02/15 15:10:23.24 server
Buf virtpg = 1877, Mass virtpg = 1877
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from first read attempt:
Page read from disk
ppageno = 65536, pobjid = 10682368, pindid = 0
pnextpg = 1460535314, pprevpg = 9764864
plevel = 0, pstat = 0x800
pts_hi = 7680, pts_lo = 134217744
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from second read
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from second readattempt:
Page read from disk
ppageno = 65536, pobjid = 10682368, pindid = 0
pnextpg = 1460535314, pprevpg = 9764864
plevel = 0, pstat = 0x800
pts_hi = 7680, pts_lo = 134217744
00:00000:00001:2006/02/15 15:10:23.24 server SDES Information:
dbid = 3, objid = 18, scur.pageid = 337
sstat = 0x20000c1, sstat2 = 0x20000
suid = 1, cacheid = 0
00:00000:00001:2006/02/15 15:10:23.24 server PSS Information:
pstat = 0x10000, pcurdb = 3, pspid = 1
p2stat = 0x1000, p3stat = 0x1089a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2006/02/15 15:10:23.24 server End diagnostics for read failure:
00:00000:00001:2006/02/15 15:10:23.24 server Starting diagnostics for read fail
00:00000:00001:2006/02/15 15:10:23.24 server Starting diagnostics for read failure:
00:00000:00001:2006/02/15 15:10:23.24 server Device Information:
Device number = 0
Phyname = /sybase/data/master
00:00000:00001:2006/02/15 15:10:23.24 server Buffer Information:
Buf addr = 0xbf9b7f14, Mass addr = 0xbf9b7f14
Buf pageno = 780, Mass pageno = 780, dbid = 1
00:00000:00001:2006/02/15 15:10:23.24 server
Buf virtpg = 784, Mass virtpg = 784
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from first read a
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from first read attempt:
Page read from disk
ppageno = 1025, pobjid = 6856, pindid = 0
pnextpg = 6850, pprevpg = 2049
plevel = 0, pstat = 0x1ae7
pts_hi = 1025, pts_lo = 513
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from second read
00:00000:00001:2006/02/15 15:10:23.24 server Page Information from second readattempt:
Page read from disk
ppageno = 1025, pobjid = 6856, pindid = 0
pnextpg = 6850, pprevpg = 2049
plevel = 0, pstat = 0x1ae7
pts_hi = 1025, pts_lo = 513
4、然后再重新启动机器,系统就再也不能启动了
5、我试过使用裸设备和文件系统两种方式,发现都失败,请大家帮忙诊断一下原因 |
|