数据库启动报错

fbirds

00:00000:00001:2010/01/08 00:32:07.20 server  Recovering database 'test'.
00:00000:00001:2010/01/08 00:32:07.66 server  Error: 1142, Severity: 22, State: 1
00:00000:00001:2010/01/08 00:32:07.66 server  Invalid OAM Page 25272. Found pstat=0x101, object=1805246455, database=0, indid=25272.
00:00000:00001:2010/01/08 00:32:07.66 server  Error: 3414, Severity: 21, State: 1
00:00000:00001:2010/01/08 00:32:07.66 server  Database 'test' (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause.

查了资料，提示做DBCC，全部做过了，还是启动的时候报错。。。
扫描页面的信息。。。

1> dbcc page (test,25272)
2> go
Page 25272 is currently unallocated.
Performing search for page in all caches.

Page not found in any cache.
Page read from disk.

BUFFER:
Buffer header for buffer 0x1ba46b800 (Mass head)
    page=0x1ba46c000 bdnew=0x0 bdold=0x0 bhash=0x0
    bmass_next=0x0 bmass_prev=0x0 bvirtpg=50356922 bdbid=4
    bmass_head=0x1ba46b800 bmass_tail=0x1ba46b800 bcache_desc=0x161079bd0
    bpool_desc=0x0 bdbtable=0x0
    Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0
    bmass_size=2048 (2K pool) bunref_cnt=0
    bmass_stat=0x0800 (0x00000800 (MASS_NOTHASHED))
    bbuf_stat=0x0 (0x00000000)
    Buffer blpageno=25272 bpg_size=2k Mass blpageno=25272 (Buffer slot #: 0)
    bxls_pin=0x0 bxls_next=0x0 bspid=0
    bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x0
Latch and the wait queue:
Latch (address: 0x1ba46b830)
        latchmode: 0x0 (FREE_LATCH)
        latchowner: 0
        latchnoofowners: 0
        latchwaitq: 0x0 latchwaitqt: 0x0

Latch wait queue:

PAGE HEADER:
Page header for page 0x1ba46c000
pageno=25272 nextpg=25273 prevpg=12009 objid=1805246455 timestamp=0029 a67cba98
nextrno=10 level=0 indid=0 freeoff=1963 minlen=173
page status bits: 0x101 (0x0100 (PG_ADDEND), 0x0001 (PG_DATA))

DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
红色字部分好象有问题了。。请各位看看什么问题。。。

andkylee

pstat:0x101没有问题啊！0x101 = 0x100+0x001  (0x0100 (PG_ADDEND), 0x0001 (PG_DATA)) !

database=0, indid=25272是问题所在，
请发dbcc page (test,25272,2)，一起研究一下！

fbirds

[quote]原帖由 andkylee 于 2010-1-8 13:21 发表
pstat:0x101没有问题啊！0x101 = 0x100+0x001  (0x0100 (PG_ADDEND), 0x0001 (PG_DATA)) !

database=0, indid=25272是问题所在，
请发dbcc page (test,25272,2)，这个操作什么意思？有没有危险？

andkylee

dbcc page的第三个参数:printopt
printopt:可选的输出选项；选用其中一个值：
0:默认值，输出缓冲区的标题和页面标题
1:输出缓冲区的标题、页面标题(分别输出每一行)，以及行偏移量表
2:输出缓冲区的标题、页面标题(整体输出页面)，以及行偏移量表
3:输出缓冲区的标题、页面标题(分别输出每一行)，以及行偏移量表；每一行后跟分别列出的它的列值


仅仅读取数据，一般没有危险！

fbirds

Page 25272 is currently unallocated.
Performing search for page in all caches.

Page not found in any cache.
Page read from disk.

BUFFER:
Buffer header for buffer 0x1ba46b800 (Mass head)
    page=0x1ba46c000 bdnew=0x0 bdold=0x0 bhash=0x0
    bmass_next=0x0 bmass_prev=0x0 bvirtpg=50356922 bdbid=4
    bmass_head=0x1ba46b800 bmass_tail=0x1ba46b800 bcache_desc=0x161079bd0
    bpool_desc=0x0 bdbtable=0x0
    Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0
    bmass_size=2048 (2K pool) bunref_cnt=0
    bmass_stat=0x0800 (0x00000800 (MASS_NOTHASHED))
    bbuf_stat=0x0 (0x00000000)
    Buffer blpageno=25272 bpg_size=2k Mass blpageno=25272 (Buffer slot #: 0)
    bxls_pin=0x0 bxls_next=0x0 bspid=0
    bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x0
Latch and the wait queue:
Latch (address: 0x1ba46b830)
        latchmode: 0x0 (FREE_LATCH)
        latchowner: 0
        latchnoofowners: 0
        latchwaitq: 0x0 latchwaitqt: 0x0

Latch wait queue:

PAGE HEADER:
Page header for page 0x1ba46c000
pageno=25272 nextpg=25273 prevpg=12009 objid=1805246455 timestamp=0029 a67cba98
nextrno=10 level=0 indid=0 freeoff=1963 minlen=173
page status bits: 0x101 (0x0100 (PG_ADDEND), 0x0001 (PG_DATA))

WHOLE PAGE:
1ba46c000 (     0):  000062b8 000062b9 00002ee9 6b99dff7  ..b...b.....k...
1ba46c010 (    16):  a67cba98 000a0000 002907ab 010100ad  .|.......)......
1ba46c020 (    32):  02003031 30312020 20202020 20203030  ..0101        00
1ba46c030 (    4:  32202020 20202020 20203031 30313030  2         010100
1ba46c040 (    64):  33393420 20202020 20202020 20200000  394           ..
1ba46c050 (    80):  00000000 0000009a 13000000 0000009a  ................
1ba46c060 (    96):  54000000 0000009b 81000000 0000009c  T...............
1ba46c070 (   112):  ed000000 00000000 00ffffff ff000000  ................
1ba46c080 (   12:  09dac132 00000000 00000000 00000000  ...2............
1ba46c090 (   144):  00000000 00000000 00000000 00000000  ................
1ba46c0a0 (   160):  00000000 00000000 00000000 00000000  ................
1ba46c0b0 (   176):  00000000 00000000 00000000 00000000  ................
1ba46c0c0 (   192):  00000000 00000000 00000000 0000c231  ...............1
1ba46c0d0 (   20:  c9eec4cf d0c7d6ae b5bcc4ea bbf503be  ................
1ba46c0e0 (   224):  b0af0201 30313031 20202020 20202020  ....0101        
1ba46c0f0 (   240):  30303220 20202020 20202020 30313031  002         0101
1ba46c100 (   256):  30303339 35202020 20202020 20202020  00395           
1ba46c110 (   272):  00000000 00000000 009a1300 00000000  ................
1ba46c120 (   28:  009a5400 00000000 009b8100 00000000  ..T.............
1ba46c130 (   304):  009ced00 00000000 000000ff ffffff00  ................
1ba46c140 (   320):  000017aa faa20000 00000000 00000000  ................
1ba46c150 (   336):  00000000 00000000 00000000 00000000  ................
1ba46c160 (   352):  00000000 00000000 00000000 00000000  ................
1ba46c170 (   36:  00000000 00000000 00000000 00000000  ................
1ba46c180 (   384):  00000000 00000000 00000000 00000000  ................
1ba46c190 (   400):  c031c9ee c4cfc7ed b1f2c4ea bbf503bc  .1..............
1ba46c1a0 (   416):  b0af0202 30313031 20202020 20202020  ....0101        
1ba46c1b0 (   432):  30303120 20202020 20202020 30313031  001         0101
1ba46c1c0 (   44:  31303030 33202020 20202020 20202020  10003           
1ba46c1d0 (   464):  00000000 003a9800 009a1300 00000000  .....:..........
1ba46c1e0 (   480):  009abd00 00000000 009b8100 00000000  ................
1ba46c1f0 (   496):  009ced00 00000000 000000ff ffffff00  ................
1ba46c200 (   512):  00005c71 b9e74000 00000000 00000000  ..\q..@.........
1ba46c210 (   52:  00000000 00000000 00000000 00000000  ................
1ba46c220 (   544):  00000000 00000000 00000000 00000000  ................
1ba46c230 (   560):  00000000 00000000 00000000 00000000  ................
1ba46c240 (   576):  00000000 00000000 00000000 00000000  ................
1ba46c250 (   592):  c431c9ee c4cfd2c1 c5b5d7cb bbafd7b1  .1..............
1ba46c260 (   60:  c6b703c0 b0af0203 30313031 20202020  ........0101   
1ba46c270 (   624):  20202020 30303120 20202020 20202020      001         
1ba46c280 (   640):  30313031 31303030 34202020 20202020  010110004      
1ba46c290 (   656):  20202020 00000000 001af400 009a1300      ............
1ba46c2a0 (   672):  00000000 009abd00 00000000 009b8100  ................
1ba46c2b0 (   68:  00000000 009ced00 00000000 000000ff  ................
1ba46c2c0 (   704):  ffffff00 00004c85 99977000 00000000  ......L...p.....
1ba46c2d0 (   720):  00000000 00000000 00000000 00000000  ................
1ba46c2e0 (   736):  00000000 00000000 00000000 00000000  ................
1ba46c2f0 (   752):  00000000 00000000 00000000 00000000  ................
1ba46c300 (   76:  00000000 00000000 00000000 00000000  ................
1ba46c310 (   784):  00000000 c231c9ee c4cfc0bc cda4bbaf  .....1..........
1ba46c320 (   800):  d7b1c6b7 03beb0af 02043031 30312020  ..........0101  
1ba46c330 (   816):  20202020 20203030 31202020 20202020        001      
1ba46c340 (   832):  20203031 30313130 30313220 20202020    010110012     
1ba46c350 (   848):  20202020 20200000 00000023 2800009a        .....#(...
1ba46c360 (   864):  13000000 0000009a bd000000 0000009b  ................
1ba46c370 (   880):  81000000 0000009c ed000000 00000000  ................
1ba46c380 (   896):  00ffffff ff000000 2d8c9679 40000000  ........-..y@...
1ba46c390 (   912):  00000000 00000000 00000000 00000000  ................
1ba46c3a0 (   928):  00000000 00000000 00000000 00000000  ................
1ba46c3b0 (   944):  00000000 00000000 00000000 00000000  ................
1ba46c3c0 (   960):  00000000 00000000 00000000 00000000  ................
1ba46c3d0 (   976):  00000000 0000c031 c9eec4cf b1a6d2b5  .......1........
1ba46c3e0 (   992):  cad7cace 03bcb0af 02053031 30312020  ..........0101  
1ba46c3f0 (  1008):  20202020 20203030 31202020 20202020        001      
1ba46c400 (  1024):  20203031 30313130 30313720 20202020    010110017     
1ba46c410 (  1040):  20202020 20200000 00000024 b800009a        .....$....
1ba46c420 (  1056):  000000 0000009a bd000000 0000009b  ................
1ba46c430 (  1072):  81000000 0000009c ed000000 00000000  ................
1ba46c440 (  1088):  00ffffff ff000000 1b1467bd 60000000  ..........g.`...
1ba46c450 (  1104):  00000000 00000000 00000000 00000000  ................
1ba46c460 (  1120):  00000000 00000000 00000000 00000000  ................
1ba46c470 (  1136):  00000000 00000000 00000000 00000000  ................
1ba46c480 (  1152):  00000000 00000000 00000000 00000000  ................
1ba46c490 (  1168):  00000000 0000c131 c9eec4cf 422646bb  .......1....B&F.
1ba46c4a0 (  1184):  afd7b1c6 b703bdb0 af020630 31303120  ...........0101
1ba46c4b0 (  1200):  20202020 20202030 30312020 20202020         001      
1ba46c4c0 (  1216):  20202030 31303131 30303138 20202020     010110018   
1ba46c4d0 (  1232):  20202020 20202000 00000000 4e200000         .....N ..
1ba46c4e0 (  1248):  9a130000 00000000 9abd0000 00000000  ................
1ba46c4f0 (  1264):  9b810000 00000000 9ced0000 00000000  ................
1ba46c500 (  1280):  0000ffff ffff0000 0043b5f1 51a00000  .........C..Q...
1ba46c510 (  1296):  00000000 00000000 00000000 00000000  ................
1ba46c520 (  1312):  00000000 00000000 00000000 00000000  ................
1ba46c530 (  1328):  00000000 00000000 00000000 00000000  ................
1ba46c540 (  1344):  00000000 00000000 00000000 00000000  ................
1ba46c550 (  1360):  00000000 000000c0 31c9eec4 cfd0c7bb  ........1.......
1ba46c560 (  1376):  cad6d3b1 ed03bcb0 af020730 31303120  ...........0101
1ba46c570 (  1392):  20202020 20202030 30312020 20202020         001      
1ba46c580 (  1408):  20202030 31303131 30303230 20202020     010110020   
1ba46c590 (  1424):  20202020 20202000 00000000 1b940000         .........
1ba46c5a0 (  1440):  9a130000 00000000 9abd0000 00000000  ................
1ba46c5b0 (  1456):  9b810000 00000000 9ced0000 00000000  ................
1ba46c5c0 (  1472):  0000ffff ffff0000 001e65cb 48400000  ..........e.H@..
1ba46c5d0 (  1488):  00000000 00000000 00000000 00000000  ................
1ba46c5e0 (  1504):  00000000 00000000 00000000 00000000  ................
1ba46c5f0 (  1520):  00000000 00000000 00000000 00000000  ................
1ba46c600 (  1536):  00000000 00000000 00000000 00000000  ................
1ba46c610 (  1552):  00000000 000000c0 31c9eec4 cfb5dbcd  ........1.......
1ba46c620 (  1568):  f5d6d3b1 ed03bcb0 af020830 31303120  ...........0101
1ba46c630 (  1584):  20202020 20202030 30312020 20202020         001      
1ba46c640 (  1600):  20202030 31303131 30303233 20202020     010110023   
1ba46c650 (  1616):  20202020 20202000 00000000 1e780000         ......x..
1ba46c660 (  1632):  9a130000 00000000 9abd0000 00000000  ................
1ba46c670 (  1648):  9b810000 00000000 9ced0000 00000000  ................
1ba46c680 (  1664):  0000ffff ffff0000 00128b24 dc200000  ...........$. ..
1ba46c690 (  1680):  00000000 00000000 00000000 00000000  ................
1ba46c6a0 (  1696):  00000000 00000000 00000000 00000000  ................
1ba46c6b0 (  1712):  00000000 00000000 00000000 00000000  ................
1ba46c6c0 (  1728):  00000000 00000000 00000000 00000000  ................
1ba46c6d0 (  1744):  00000000 000000c2 31c9eec4 cfbeabcc  ........1.......
1ba46c6e0 (  1760):  facab1d6 d3b1ed03 beb0af02 09303130  .............010
1ba46c6f0 (  1776):  31202020 20202020 20303031 20202020  1        001   
1ba46c700 (  1792):  20202020 20303130 31313030 32372020       010110027  
1ba46c710 (  1808):  20202020 20202020 20000000 00000000           .......
1ba46c720 (  1824):  00009a13 00000000 00009abd 00000000  ................
1ba46c730 (  1840):  00009b81 00000000 00009ced 00000000  ................
1ba46c740 (  1856):  00000000 ffffffff 00000016 251b8100  ............%...
1ba46c750 (  1872):  00000000 00000000 00000000 00000000  ................
1ba46c760 (  1888):  00000000 00000000 00000000 00000000  ................
1ba46c770 (  1904):  00000000 00000000 00000000 00000000  ................
1ba46c780 (  1920):  00000000 00000000 00000000 00000000  ................
1ba46c790 (  1936):  00000000 00000000 00c031c9 eec4cfc2  ..........1.....
1ba46c7a0 (  1952):  dec4c9d6 d3b1ed03 bcb0af00 00000000  ................
1ba46c7b0 (  1968):  00000000 00000000 00000000 00000000  ................
1ba46c7c0 (  1984):  00000000 00000000 00000000 00000000  ................
1ba46c7d0 (  2000):  00000000 00000000 00000000 00000000  ................
1ba46c7e0 (  2016):  ff0000ff 00ffff00 ffffffff 06eb0629  ...............)
1ba46c7f0 (  2032):  056904a9 03e80328 026601a2 00e20020  .i.....(.f.....
1ba46c800 (  2048):

fbirds

报第１楼的错误时，数据库一直无法正常启动。。。
Error: 921, Severity: 14, State: 1
07:00000:00001:2010/01/08 01:11:29.65 server  Database 'test' has not been recovered yet - please wait and try again.

后来没办法，在数据库选项里面加了'no free space acctg',false ，正常启动数据库后在把该选项改为true了。。。目前问题应该没有完全处理好。。。：（

andkylee

数据页面有问题，通过dbcc page(test,25272,2)，可以看出该页面是一个正常的数据页面。可以数出有10行记录（或者nextrno=10 也是这个意思）。sybase错误得将页面25272认为是OAM分配页了。
这涉及到对象分配的问题，不解决该问题应该不能正常启动数据库！

wfcjz

BCP这个表出来，然后建重不以吗？

hobbylu

Error: 1142, Severity: 22, State: 1
00:00000:00001:2010/01/08 00:32:07.66 server  Invalid OAM Page 25272. Found pstat=0x101, object=1805246455, database=0, indid=25272.
这个是一个很严重的问题，具体做法很难赘述，可以跟我联系

fbirds

楼上的兄弟，最近MSN没上啊。。加了你的QQ了。。谢谢啦。。。