请高手分析sybase日志中的问题

[tianyc]

日志中的问题描述，如何解决啊？
......
00:00000:00001:2005/06/09 21:24:19.44 server Database 'sybsystemprocs' is now online.
00:00000:00001:2005/06/09 21:24:19.44 server
*** Bypassing recovery of database id 4

00:00000:00002:2005/06/09 21:24:19.47 kernel network name 10.176.124.28, type ether, port 4100, filter NONE
00:00000:00001:2005/06/09 21:24:19.73 server Starting diagnostics for read failure:
00:00000:00001:2005/06/09 21:24:19.74 server Device Information:
Device number = 3
Phyname = /dev/rsybgd_lv
00:00000:00001:2005/06/09 21:24:19.74 server Buffer Information:
Buf addr = 0x19d3b38d8, Mass addr = 0x19d3b38d8
Buf pageno = 3, Mass pageno = 3, dbid = 4
00:00000:00001:2005/06/09 21:24:19.74 server
Buf virtpg = 50331653, Mass virtpg = 50331653
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2005/06/09 21:24:19.74 server Page Information from first read attempt: Page read from disk ppageno = 0, pobjid = 1, pindid = 0 pnextpg = 0, pprevpg = 16384 plevel = 0, pstat = 0x0 pts_hi = 0, pts_lo = 0
00:00000:00001:2005/06/09 21:24:19.74 server Page Information from second read attempt: Page read from disk ppageno = 0, pobjid = 1, pindid = 0 pnextpg = 0, pprevpg = 16384 plevel = 0, pstat = 0x0 pts_hi = 0, pts_lo = 0
00:00000:00001:2005/06/09 21:24:19.74 server SDES Information:
dbid = 4, objid = 1, scur.pageid = 3
sstat = 0x2000041, sstat2 = 0x20000
suid = 1, cacheid = 0
00:00000:00001:2005/06/09 21:24:19.74 server PSS Information:
pstat = 0x1000, pcurdb = 2, pspid = 1
p2stat = 0x110, p3stat = 0x1000091e
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2005/06/09 21:24:19.74 server End diagnostics for read failure:
00:00000:00001:2005/06/09 21:24:19.75 server Error: 695, Severity: 21, State: 1
00:00000:00001:2005/06/09 21:24:19.75 server An attempt was made to read logical page '3' for object '1' in database '4' from disk. Wrong logical page '0' was brought into cache 'default data cache'.
00:00000:00001:2005/06/09 21:24:19.81 server Error: 834, Severity: 20, State: 4
00:00000:00001:2005/06/09 21:24:19.81 server Illegal attempt to clean buffer: BUF pointer = '0x19d3b7d98', MASS pointer = '0x19d3b7d98', (Buf#: '0'), page ptr = '0x198f35800', dbid = '4', Mass virtpage = '50331678', Buffer page = '28', Mass status = '0x44001008', Buffer status = '0x1', size = '2048', cache (id: 0) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.
00:00000:00001:2005/06/09 21:24:19.81 server Error: 3413, Severity: 21, State: 2
00:00000:00001:2005/06/09 21:24:19.81 server Database 0. Attempt to mark database as suspect failed. Getnext NC scan on sysdatabases.dbid failed.
00:00000:00001:2005/06/09 21:24:19.81 server SQL Server's default unicode sort order is 'binary'.
......

[tianyc]

和以前的启动记录比较，发现这块是最集中的出错描述。
另有个地方也不对为：
　Recovering database 'master'.
Redo pass of recovery has processed 1 committed and 0 aborted transactions.


在此之前，为了恢复数据库挂起问题，执行了以下操作：
　sp_configure "allow update",1
go
reconfigure with override
go
update master..sysdatabases
set status=-32768
where name="xxxx"
go
shutdown with nowait
go
重启系统后就不能启动、访问数据库了：（

[j9dai]

头都大了
帮顶

[princelily]

你一定改动过master数据库了，master数据库是MS SQLServer的最重要的数据库文件，你可以从别的地方拷贝master.mdf master.ldf两个文件，覆盖原先的文件，试试。

[tianyc]

princelily(百合):
就是啊！改了MASTER的值：
　sp_configure "allow update",1
go
reconfigure with override
go
update master..sysdatabases
set status=-32768
where name="xxxx"
go

如果我从别的地方拷贝master.mdf master.ldf两个文件，覆盖原先的文件，在SYBASE中已有的的应用程序数据库会丢吗？
还有，库装在小型机AIX UNIX 中，数据保存在磁盘阵列里。

[tianyc]

顶！

[peixun]

up

[hygougou]

试试:

设置master库无法恢复允许修改系统表

　　1>sp_configure "allow updates",0
　　2>go

重启服务

[tianyc]

系统进程中看到SYBASE服务已经启动，但isql却登录不进去，无法执行命令

[tianyc]

别沉了

[吹雪风]

DING

[tianyc]

继续期待您的点子。谢谢！