- 论坛徽章:
- 0
|
请问各位老大：如何进入jsbwdb数据库，555555我没有备份，数据有相当重要。请各位出手相助！谢了！！
数据库平台：syabse 11 for scounix505
故障现象：
$isql -Usa -P
>;use jsbwdb
>;go
Msg 921 ,Level 14 ,state 1
Line 1:
Database "jsbwdb" has not been recovered yet - Please wait and try again.
>;
下面是errorlog文件的出错片断：
00:04/09/27 12:08:37.35 server Recovering database 'jsbwdb'.
00:04/09/27 12:08:37.41 server Recovery dbid 5 ckpt (16389,0)
00:04/09/27 12:08:37.41 server Recovery no active transactions before ckpt.
00:04/09/27 12:08:38.01 server Error: 625, Severity: 21, State: 1
00:04/09/27 12:08:38.01 server Could not retrieve row from logical page 16412 via RID because the entry in the offset table for that RID is less than or equal to 0.
00:04/09/27 12:08:38.01 server Error while undoing log row in database 'jsbwdb'. Rid pageid = 0x0; row num = 0x0.
LOG SCAN DEFINTION:
Database id : 5
Forward scan: starting at begining of log
log records for object id 1
LOG RECORDS:
INSERT (10250,0)
attcnt=1 rno=0 op=4 padlen=0 sessionid = (10249,21) len=132
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=2 pageno=1 offset=1736 status=0x00 cid=0
old ts=0x0001 0x00000586 new ts=0x0001 0x00000653
xrow:
80944850: 02150100 1030f400 00004300 00000000 00000000 .....0....C.........
80944864: 00000000 0e950000 d0748400 0e950000 d0748400 .........t.......t..
80944878: 00000000 00000000 00000000 00000000 00000000 ....................
8094488c: 55200000 54006a73 62775f6a 7a746b62 00000000 U ..T.jsbw_jztkb....
809448a0: 03504c42 .PLB.
IINSERT (10250,1)
attcnt=1 rno=1 op=7 padlen=0 sessionid = (10249,21) len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
oampg=2 pageno=16 offset=32 status=0x00 cid=0
old ts=0x0001 0x0000051f new ts=0x0001 0x00000654
xrow:
809448d4: 01010001 00000015 0018006a 7362775f 6a7a746b ...........jsbw_jztk
809448e8: 6202150b b....
00:04/09/27 12:08:38.19 kernel current process (0x30003) infected with 11
00:04/09/27 12:08:38.22 kernel Address 0x2ef8f (bufsearch___1+0x1ab), siginfo (code, address) = (2, 0x40154)
00:04/09/27 12:08:38.22 kernel curdb = 5 pstat = 0x1000 lasterror = 625
00:04/09/27 12:08:38.22 kernel preverror = 0 transtate = 1
00:04/09/27 12:08:38.22 kernel curcmd = 0 program =
00:04/09/27 12:08:38.34 kernel pc: 0x2e4b85 ucbacktrace+0x55(0x0,0x1,0x80029f54,0x40154,0xb)
00:04/09/27 12:08:38.35 kernel pc: 0x27bf terminate_process+0x33f(0x0,0xffffffff,0x0,0x4014c,0x803a94d
00:04/09/27 12:08:38.36 kernel pc: 0x2fb95f kisignal+0x9f(0xb,0x8002a14c,0x80029f4c,0x0,0x0)
00:04/09/27 12:08:38.38 kernel pc: 0x351a7c sigismember+0x64(0x803a94d8,0x809448e8,0x803a94d8,0x0,0x1)
00:04/09/27 12:08:38.39 kernel pc: 0x1c90aa getcachedpage___1+0x16(0x803a94d8,0x0,0x1,0x1,0x8002a2bc)
00:04/09/27 12:08:38.39 kernel pc: 0x1c936e getpage_nicetocache___1+0x16(0x8002a544,0xffffffff,0x8002a564,0x803a0000,0x8002a564)
00:04/09/27 12:08:38.39 kernel pc: 0x1c94f6 getpage_ns_nicetocache+0x86(0x803a94d8,0x80998860,0x8002a544,0x8002a534,0x0)
00:04/09/27 12:08:38.40 kernel [Handler pc: 0xf0c50 hdl_backout(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.41 kernel pc: 0x1f0c7c d_log+0x6fc(0x5,0x1,0x0,0x0,0x0)
00:04/09/27 12:08:38.42 kernel [Handler pc: 0x1c29d0 getdoerr(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.42 kernel pc: 0x1bff86 undo+0x2d6(0x802c69d0,0x8066efac,0x8066efac,0x8002b218,0x1)
00:04/09/27 12:08:38.43 kernel [Handler pc: 0x16a2a0 rec_handle(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.43 kernel pc: 0x169ae0 rec_complete+0x1d0(0x80519be0,0x1,0x8066efac,0x8066efac,0x0)
00:04/09/27 12:08:38.44 kernel pc: 0x16b924 undo_tran_list___1+0x68(0x802c69d0,0x169785,0x8002af84,0x8002b218,0x803a8e2
00:04/09/27 12:08:38.44 kernel [Handler pc: 0x16a2a0 rec_handle(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.44 kernel pc: 0x1697d9 rec_transactions+0xf39(0x80519be0,0x803a8e28,0x8066eb7c,0x8002b218,0x1)
00:04/09/27 12:08:38.44 kernel [Handler pc: 0x16a2a0 rec_handle(num=3605, sev=25) installed by the following function]
00:04/09/27 12:08:38.44 kernel [Handler pc: 0x16a2a0 rec_handle(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.44 kernel pc: 0x1680cf recovery+0x32f(0x1,0x1674bc,0x0,0x86e0,0x8002b2eb)
00:04/09/27 12:08:38.44 kernel [Handler pc: 0x16a2a0 rec_handle(num=0, sev=0) installed by the following function]
00:04/09/27 12:08:38.44 kernel pc: 0x1674ce dorecover+0x46e(0x0,0x0,0x0,0x0,0x5f6f7369)
00:04/09/27 12:08:38.44 kernel [Handler pc: 0x3ca0 ds_handle(num=800, sev=0) installed by the following function]
00:04/09/27 12:08:38.44 kernel pc: 0x1774 dsinit+0x9f4(0x0,0x8002b460,0x6a006a,0x0,0x0)
00:04/09/27 12:08:38.44 kernel pc: 0x2f8e30 kpexit(0x0,0x0,0x5374616b,0x0,0x0)
00:04/09/27 12:08:38.44 kernel pc: 0x6a006a frexp+0x346236(0x5374616b,0x0,0x0,0x0,0x0)
00:04/09/27 12:08:38.44 kernel end of stack trace, spid 1, kpid 196611, suid 0
00:04/09/27 13:13:58.20 kernel Using config area from primary master device.
00:04/09/27 13:13:58.46 kernel Warning: Using default file '/usr/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:04/09/27 13:13:58.73 kernel Using 110 file descriptors.
00:04/09/27 13:13:58.77 kernel SQL Server/11.0.3/P/SCO/SCO_SV r3.2v5.0.2/2/OPT/Fri Jul 18 19:10:23 PDT 1997
00:04/09/27 13:13:58.79 kernel Confidential property of Sybase, Inc.
00:04/09/27 13:13:58.79 kernel (c) Copyright Sybase Inc., 1987, 1997. |
|
免费注册
发表于 2004-09-28 11:28
