Datenbankfehler nach Netzteildefekt

Jürgen · 27. Oktober 2006

sorry Jens, aber da muss ich dir widersprechen.

Es ist richtig dass beim Repair eine neue DB angelegt wird.

ABER. der Repair geht dabei über die DB wie ein Panzer in der Fusgängerzone mit demKopfsteinpflaster.

Und der eseutil /d kannst Du dir dann vorstellen wie der Städtische Bauhof der die ganzen Steine wieder einbaut.

Auch ist isinteg wichtig, da die logische Struktur der DB wieder überprüft und ggf. repariert werden muss.

u.U. ist es notwendig isinteg mehrfach durchlaufen zu lassen, zumindest solange bis die Anzahl der Errors nicht mehr kleiner wird oder 0 ist. Wobei mehr als drei Durchläufe keinen Sinn macht.

Berlin142 · 27. Oktober 2006

Da würde ich wetten, dass ein eseutil /d keinen weiteren Sinn macht. Aber sei es drum.

Jens

microsaft · 27. Oktober 2006

Ok, ok - ich mache das mit dem Defragmentieren. Und wenn es nichts nützt, dann schadet es zumindest nicht.

Puh - ich hoffe nur, das klappt! :-?

Gruss,
Benni

ullifichte · 27. Oktober 2006

Lass und wissen, ob es funktioniert hat!!!

Gruss

Ulli

microsaft · 28. Oktober 2006

Moin moin,

So - ist erledigt!

Ich habe zuerst den Konsistenzcheck mit isinteg (mit und ohne fix) probiert (Fehler), dann eine Defragmentierung mit eseutil (Fehler), dann repariert (=> OK) und nochmal eseutil defrag (=> OK) und isinteg fix 2 mal laufen lassen (=> 1. Mal repariert, 2. Mal dann OK):

Code

D:\Exchsrvr\MDBDATA>..\bin\isinteg -s exchange -test alltests
Databases for server exchange:
Only databases marked as Offline can be checked


Index  Status       Database-Name
Storage Group Name: Erste Speichergruppe
  1    Online       Informationsspeicher f³r Íffentliche Ordner (exchange)
  2    Offline      Postfachspeicher (exchange)
Enter a number to select a database or press Return to exit.
2
You have selected Erste Speichergruppe / Postfachspeicher (exchange).
Continue?(Y/N)y
Test Search Folder Links result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s);
time: 0h:0m:12s
Test Global result: 0 error(s); 0 warning(s); 0 fix(es); 1 row(s); time: 0h:0m:0
s
Test Delivered To result: 0 error(s); 0 warning(s); 0 fix(es); 20 row(s); time:
0h:0m:0s
Test Repl Schedule result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time:
0h:0m:0s
Test Timed Events result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0
h:0m:0s
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.
Now in test   6(reference table construction) of total  19 tests; 100% complete.


Isinteg: the request to cancel verification process failed.
Isinteg: the request to stop verification process failed.
  The verification has probably been interrupted.
  Please review the log file for more information.


D:\Exchsrvr\MDBDATA>..\bin\isinteg -s exchange -fix -test alltests
Databases for server exchange:
Only databases marked as Offline can be checked


Index  Status       Database-Name
Storage Group Name: Erste Speichergruppe
  1    Online       Informationsspeicher f³r Íffentliche Ordner (exchange)
  2    Offline      Postfachspeicher (exchange)
Enter a number to select a database or press Return to exit.
2
You have selected Erste Speichergruppe / Postfachspeicher (exchange).
Continue?(Y/N)y
Test Categorization Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s)
; time: 0h:0m:5s
Test Restriction Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); t
ime: 0h:0m:20s
Test Search Folder Links result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s);
time: 0h:0m:0s
Test Global result: 0 error(s); 0 warning(s); 0 fix(es); 1 row(s); time: 0h:0m:0
s
Test Delivered To result: 0 error(s); 0 warning(s); 0 fix(es); 20 row(s); time:
0h:0m:0s
Test Repl Schedule result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time:
0h:0m:0s
Test Timed Events result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0
h:0m:0s
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.
Now in test   8(reference table construction) of total  21 tests; 100% complete.


Isinteg: the request to cancel verification process failed.
Isinteg: the request to stop verification process failed.
  The verification has probably been interrupted.
  Please review the log file for more information.


D:\Exchsrvr\MDBDATA>..\bin\eseutil /d priv1.edb


Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.


Initiating DEFRAGMENTATION mode...
            Database: priv1.edb
      Streaming File: priv1.STM
      Temp. Database: TEMPDFRG4380.EDB
Temp. Streaming File: TEMPDFRG4380.STM


                  Defragmentation Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          .






Operation terminated with error -1018 (JET_errReadVerifyFailure, Checksum error
on a database page) after 118.94 seconds.








D:\Exchsrvr\MDBDATA>..\bin\eseutil /p priv1.edb


Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.


Initiating REPAIR mode...
        Database: priv1.edb
  Streaming File: priv1.STM
  Temp. Database: TEMPREPAIR4532.EDB


Checking database integrity.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|


Scanning the database catalog.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Rebuilding MSysObjects.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Rebuilding MSysObjectsShadow from MSysObjects.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Checking the database.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Scanning the database.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Repairing damaged tables.


                     Scanning Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          .........................
Deleting unicode fixup table.
..........................




Repair completed. Database corruption has been repaired!


Note:
  It is recommended that you immediately perform a full backup
  of this database. If you restore a backup made before the
  repair, the database will be rolled back to the state
  it was in at the time of that backup.






Operation completed successfully with 595 (JET_wrnDatabaseRepaired, Database cor
ruption has been repaired) after 4616.219 seconds.


D:\Exchsrvr\MDBDATA>..\bin\eseutil /d priv1.edb


Microsoft(R) Exchange Server Database Utilities
Version 6.5
Copyright (C) Microsoft Corporation. All Rights Reserved.


Initiating DEFRAGMENTATION mode...
            Database: priv1.edb
      Streaming File: priv1.STM
      Temp. Database: TEMPDFRG5548.EDB
Temp. Streaming File: TEMPDFRG5548.STM


                  Defragmentation Status (% complete)


          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................




Moving 'TEMPDFRG5548.EDB' to 'priv1.edb'... DONE!


Moving 'TEMPDFRG5548.STM' to 'priv1.stm'... DONE!


Note:
  It is recommended that you immediately perform a full backup
  of this database. If you restore a backup made before the
  defragmentation, the database will be rolled back to the state
  it was in at the time of that backup.


Operation completed successfully in 5346.438 seconds.


D:\Exchsrvr\MDBDATA>..\bin\isinteg -s exchange -fix -test alltests
Databases for server exchange:
Only databases marked as Offline can be checked


Index  Status       Database-Name
Storage Group Name: Erste Speichergruppe
  1    Online       Informationsspeicher f³r Íffentliche Ordner (exchange)
  2    Offline      Postfachspeicher (exchange)
Enter a number to select a database or press Return to exit.
2
You have selected Erste Speichergruppe / Postfachspeicher (exchange).
Continue?(Y/N)y
Test Categorization Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s)
; time: 0h:0m:0s
Test Restriction Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); t
ime: 0h:0m:0s
Test Search Folder Links result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s);
time: 0h:0m:0s
Test Global result: 0 error(s); 0 warning(s); 0 fix(es); 1 row(s); time: 0h:0m:0
s
Test Delivered To result: 0 error(s); 0 warning(s); 0 fix(es); 20 row(s); time:
0h:0m:0s
Test Repl Schedule result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time:
0h:0m:0s
Test Timed Events result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0
h:0m:0s
Test reference table construction result: 0 error(s); 0 warning(s); 0 fix(es); 0
 row(s); time: 0h:0m:22s
Test Folder result: 0 error(s); 3 warning(s); 174 fix(es); 6850 row(s); time: 0h
:9m:26s
Test Deleted Messages result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); tim
e: 0h:0m:0s
Test Message result: 0 error(s); 0 warning(s); 0 fix(es); 313972 row(s); time: 0
h:3m:47s
Test Attachment result: 0 error(s); 1 warning(s); 0 fix(es); 71537 row(s); time:
 0h:0m:7s
Test Mailbox result: 0 error(s); 0 warning(s); 0 fix(es); 193 row(s); time: 0h:0
m:3s
Test Sites result: 0 error(s); 0 warning(s); 0 fix(es); 770 row(s); time: 0h:0m:
0s
Test Categories result: 0 error(s); 0 warning(s); 0 fix(es); 1206 row(s); time:
0h:0m:0s
Test Per-User Read result: 0 error(s); 0 warning(s); 0 fix(es); 263 row(s); time
: 0h:0m:0s
Test special folders result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time
: 0h:0m:0s
Test Message Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 30 row(s); t
ime: 0h:0m:0s
Test Folder Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); tim
e: 0h:0m:0s
Test reference count verification result: 0 error(s); 0 warning(s); 60 fix(es);
0 row(s); time: 0h:0m:28s
Now in test  21(Row Count/Dumpster Count) of total  21 tests; 100% complete.


D:\Exchsrvr\MDBDATA>..\bin\isinteg -s exchange -fix -test alltests
Databases for server exchange:
Only databases marked as Offline can be checked


Index  Status       Database-Name
Storage Group Name: Erste Speichergruppe
  1    Online       Informationsspeicher f³r Íffentliche Ordner (exchange)
  2    Offline      Postfachspeicher (exchange)
Enter a number to select a database or press Return to exit.
2
You have selected Erste Speichergruppe / Postfachspeicher (exchange).
Continue?(Y/N)y
Test Categorization Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s)
; time: 0h:0m:0s
Test Restriction Tables result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); t
ime: 0h:0m:0s
Test Search Folder Links result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s);
time: 0h:0m:1s
Test Global result: 0 error(s); 0 warning(s); 0 fix(es); 1 row(s); time: 0h:0m:0
s
Test Delivered To result: 0 error(s); 0 warning(s); 0 fix(es); 20 row(s); time:
0h:0m:0s
Test Repl Schedule result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time:
0h:0m:0s
Test Timed Events result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0
h:0m:0s
Test reference table construction result: 0 error(s); 0 warning(s); 0 fix(es); 0
 row(s); time: 0h:0m:24s
Test Folder result: 0 error(s); 0 warning(s); 0 fix(es); 6850 row(s); time: 0h:9
m:38s
Test Deleted Messages result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); tim
e: 0h:0m:0s
Test Message result: 0 error(s); 0 warning(s); 0 fix(es); 313972 row(s); time: 0
h:3m:34s
Test Attachment result: 0 error(s); 1 warning(s); 0 fix(es); 71537 row(s); time:
 0h:0m:5s
Test Mailbox result: 0 error(s); 0 warning(s); 0 fix(es); 193 row(s); time: 0h:0
m:3s
Test Sites result: 0 error(s); 0 warning(s); 0 fix(es); 770 row(s); time: 0h:0m:
0s
Test Categories result: 0 error(s); 0 warning(s); 0 fix(es); 1206 row(s); time:
0h:0m:0s
Test Per-User Read result: 0 error(s); 0 warning(s); 0 fix(es); 263 row(s); time
: 0h:0m:0s
Test special folders result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time
: 0h:0m:0s
Test Message Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 30 row(s); t
ime: 0h:0m:0s
Test Folder Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); tim
e: 0h:0m:0s
Now in test  20(reference count verification) of total  20 tests; 100% complete.

Alles anzeigen

Und hier das Ergebnis des Backups

Code

Auftrag beendet am Samstag, 28. Oktober 2006 um 08:29:07
Abschlussstatus: Erfolgreich

Ich habe ein paar Mailboxen geöffnet mit Outlook und OWA. Bisher ist alles klar.
Und auch keine Fehlermeldungen im Event-Log!

Sieht doch alles ziemlich gut aus! Fällt euch noch was ein, was ich testen/überprüfen könnte?

Gruss,
Benni

Jürgen · 28. Oktober 2006

Ja, Du solltest auf alle Fälle deine Hardware checken. HDDs, Controller etc.

Denn die -1018 Feher entstehen zu 98% aus Hardwaredefekten.

Wenn es bei dir durch einen HW Defekt ausgelöst wurde, dann ist es durchaus möglich, dass der Fehler wieder auftritt.

Wenn die Korruption dann im DB Header zuschlägt, kannst die DB in der Regel wegwerfen.

NobbyausHB · 28. Oktober 2006

Hi Benni,

pflichte Jürgen da voll und ganz bei.

Du solltest sehr kritisch deine Hardware unter die Lupe nehmen.

Vielleicht ist durch den Defekt an der Backplane noch was hinüber gegangen.

microsaft · 11. November 2006

Hi,

Ich wollte zwei Wochen nach der Datenbankreparatur noch mal ein Feedback geben:

Bisher sind keine Fehler mehr aufgetreten! Das Backup läuft 1a. Die Datenbank ist noch konstistent. Der Check der ganzen Platten, RAM, CPU, Netzteilspannungen, Temperatur, Lüfterdrehzahlen etc. haben keine Probleme ergeben.

Code

Denn die -1018 Feher entstehen zu 98% aus Hardwaredefekten.

2% Wobei: Eigentlich war es ja ein Hardwaredefekt: Das Netzteil. Und durch das harte Abschalten hat es dann die Datenbank in einem inkonsistenten Zustand zurück gelassen.

Noch mal 1000-Dank für eure ganzen Tipps!!!

Gruss,
Benni

Datenbankfehler nach Netzteildefekt

Teilen

Benutzer online in diesem Thema