- 论坛徽章:
- 0
|
可能与网络突然中断有关,系统重启后名为‘RSPOS’的数据库无法进入,错误日志如下,请各位大侠出手,解答下一步如何处理。谢谢!
00001:2009/05/04 10:20:20.17 server Database 'sybsystemprocs' is now online.
00:00000:00002:2009/05/04 10:20:20.18 kernel network name 192.168.4.8, type ether, port 5000, filter NONE
00:00000:00001:2009/05/04 10:20:20.28 server Recovering database 'rspos'.
00:00000:00001:2009/05/04 10:20:20.82 server Recovering last page of log (was 4352591, now 4352590)
00:00000:00001:2009/05/04 10:21:55.09 server Redo pass: 33668 records done (5%); 634341 records left.
00:00000:00001:2009/05/04 10:22:18.35 server Redo pass: 67068 records done (10%); 600941 records left.
00:00000:00001:2009/05/04 10:22:47.71 server Redo pass: 100468 records done (15%); 567541 records left.
00:00000:00001:2009/05/04 10:23:11.12 server Redo pass: 133868 records done (20%); 534141 records left.
00:00000:00001:2009/05/04 10:23:35.26 server Redo pass: 167494 records done (25%); 500515 records left.
00:00000:00001:2009/05/04 10:23:38.10 server Starting diagnostics for read failure:
00:00000:00001:2009/05/04 10:23:38.10 server Device Information:
Device number = 10
Phyname = D:\tydata\rsposdata4.dat
00:00000:00001:2009/05/04 10:23:38.10 server Buffer Information:
Buf addr = 0x29963B00, Mass addr = 0x29963B00
Buf pageno = 7140726, Mass pageno = 7140726, dbid = 4
00:00000:00001:2009/05/04 10:23:38.10 server
Buf virtpg = 168097142, Mass virtpg = 168097142
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2009/05/04 10:23:38.10 server Page Information from first read attempt: Page read from disk ppageno = 7140726, pobjid = 508525814, pindid = 4 pnextpg = 1848252, pprevpg = 8634980 plevel = 0, pstat = 0x802 pts_hi = 1, pts_lo = -402337036
00:00000:00001:2009/05/04 10:23:38.10 server SDES Information:
dbid = 4, objid = 1, scur.pageid = 7140726
sstat = 0x4, sstat2 = 0x0
suid = 1, cacheid = 0
00:00000:00001:2009/05/04 10:23:38.10 server PSS Information:
pstat = 0x1000, pcurdb = 4, pspid = 1
p2stat = 0x110, p3stat = 0x1000081e
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2009/05/04 10:23:38.10 server End diagnostics for read failure:
00:00000:00001:2009/05/04 10:23:38.12 server Error: 12315, Severity: 21, State: 1
00:00000:00001:2009/05/04 10:23:38.12 server Corrupt page, Internal error: Mismatch between tail timestamp '93a1' and the low two bytes of timestamp in the page header 'd2f4' while accessing page '7140726' of object '1' in database '4'. Please contact Sybase Technical Support.
00:00000:00001:2009/05/04 10:23:38.15 server Error: 3414, Severity: 21, State: 1
00:00000:00001:2009/05/04 10:23:38.15 server Database 'rspos' (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause.
00:00000:00001:2009/05/04 10:23:47.54 server Error: 921, Severity: 14, State: 1
00:00000:00001:2009/05/04 10:23:47.54 server Database 'rspos' has not been recovered yet - please wait and try again.
[ 本帖最后由 52husky 于 2009-5-4 12:30 编辑 ] |
|