數(shù)據(jù)庫(kù)日志文件丟失，怎么能讀取數(shù)據(jù)

sl0325

安裝Eisen兄的方法做了測(cè)試，但用-32768啟動(dòng)，不能rebuild log,還是報(bào)錯(cuò)：
wrong logical page'28025968' was brought into cache 'default data cache'.
做了很多測(cè)試，一直是與這個(gè)頁(yè)面錯(cuò)誤有關(guān),請(qǐng)教版主和高手們還可以怎么去嘗試修復(fù)這個(gè)錯(cuò)誤。

Eisen

這個(gè)28025968真的是在syslogs上嗎?

sl0325

查看sysusages表，發(fā)現(xiàn)28025968頁(yè)是分配給了數(shù)據(jù)設(shè)備，日志設(shè)備的邏輯頁(yè)都分配到了最后。
我建數(shù)據(jù)庫(kù)時(shí)，是按照以前建立設(shè)備的順序來(lái)創(chuàng)建的，是不是應(yīng)該建庫(kù)時(shí)只分配幾個(gè)設(shè)備，建好庫(kù)在增加其它設(shè)備，就可以使邏輯頁(yè)分配的頁(yè)號(hào)28025968能對(duì)應(yīng)上syslogs。

Eisen

那當(dāng)然要嚴(yán)格按照以前segment的順序一段段建上去阿

sl0325

謝謝Eisen兄提醒，我下午再重新測(cè)試

sl0325

下午重建修復(fù)庫(kù)后可以用-32768正常啟動(dòng)了，但還是不能dbcc rebuild_log。
我只做了dump tran db with no_log，也成功了。
然后set status=0后重啟數(shù)據(jù)庫(kù)服務(wù)，恢復(fù)到我建的庫(kù)時(shí)，就一直不停報(bào)warning。不知道是否有問(wèn)題？

sl0325

請(qǐng)樓主和高手們看看是什么問(wèn)題，能有辦法處理嗎？
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1347747840 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 11).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1162104653 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 12).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1347747840 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 11).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1162104653 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 12).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.

andkylee

回復(fù) 26# sl0325


    能啟動(dòng)了就將數(shù)據(jù)bcp導(dǎo)出吧。
估計(jì)你們的庫(kù)損壞的是數(shù)據(jù)設(shè)備上的頁(yè)面。

sl0325

請(qǐng)版主和高手們看看報(bào)錯(cuò)，能有辦法修復(fù)嗎？

10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1347747840 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 11).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1162104653 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 12).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1347747840 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 11).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1162104653 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 12).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.

sl0325

現(xiàn)在set status=0啟動(dòng)服務(wù)，報(bào)錯(cuò)如下：
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1347747840 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 11).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1162104653 while doing the extents accounting for OAM page 4, object ID 5, index ID 0, database ID 4 (OAM entry 12).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page -1130363945 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 2).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 115343360 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 3).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 1268252672 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 5).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 983040000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 9).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 819200000 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 17).
10:00000:00001:2011/12/27 17:14:59.07 server  *** WARNING ******************
10:00000:00001:2011/12/27 17:14:59.07 server  Unable to find the sysusages row that controls the allocation page 343965293 while doing the extents accounting for OAM page 6, object ID 5, index ID 0, database ID 4 (OAM entry 1.
請(qǐng)版主和高手們幫忙看看，有什么辦法恢復(fù)嗎？