none
exchange 2016 数据库故障 RRS feed

  • 问题

  • 您好

        请教下exchange 2016 是两台mailbox做的DAG,其中一台数据库出问题,无法启动,另外一台正常,但是数据库有故障,如下所示:针对此种情况该如何处理,谢谢

    [PS] C:\Windows\system32>Test-MAPIConnectivity

    MailboxServer      Database           Result    Error
    -------------      --------           ------    -----
    EXH-MDB01             EXHDB01          *故障*    数据库已卸除。
    EXH-MDB01             EXHDB02          *故障*    数据库已卸除。

    查看2个数据库状态如下:

    [PS] C:\Windows\system32>eseutil.exe /mh "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259\Mailbox Database 1630159259.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating FILE DUMP mode...
             Database: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259\Mailbox Database 1630159259.edb


    DATABASE HEADER:
    Checksum Information:
    Expected Checksum: 0x43cc8ac9
      Actual Checksum: 0x43cc8ac9

    Fields:
            File Type: Database
             Checksum: 0x43cc8ac9
       Format ulMagic: 0x89abcdef
       Engine ulMagic: 0x89abcdef
     Format ulVersion: 0x620,20,0  (attached by 0)
     Engine ulVersion: 0x620,60,120  (efvCurrent = 9040)
    Created ulVersion: 0x620,20
         DB Signature: Create time:09/16/2020 12:44:45.597 Rand:628643311 Computer:
             cbDbPage: 32768
               dbtime: 16088679 (0xf57e67)
                State: Dirty Shutdown
         Log Required: 18005-18098 (0x4655-0x46b2)
        Log Committed: 0-18099 (0x0-0x46b3)
       Log Recovering: 0 (0x0)
       Log Consistent: 18005 (0x4655)
      GenMax Creation: 05/05/2021 04:11:46.294 UTC
             Shadowed: Yes
           Last Objid: 101157
         Scrub Dbtime: 0 (0x0)
           Scrub Date: 00/00/1900 00:00:00.000 LOC
         Repair Count: 0
          Repair Date: 00/00/1900 00:00:00.000 LOC
     Old Repair Count: 0
      Last Consistent: (0x4349,25,FF)  04/26/2021 02:56:28.352 UTC
          Last Attach: (0x434A,2,268)  04/26/2021 02:57:45.933 UTC
          Last Detach: (0x0,0,0)  00/00/1900 00:00:00.000 LOC
        Last ReAttach: (0x4437,2,268)  04/28/2021 10:12:55.490 UTC
                 Dbid: 1
        Log Signature: Create time:09/16/2020 12:44:45.472 Rand:3278815987 Computer:
           OS Version: (6.2.9200 SP 0 NLS ffffffff.ffffffff)

    Previous Full Backup:
            Log Gen: 3248-3291 (0xcb0-0xcdb) - OSSnapshot
               Mark: (0xCDC,1,0)
               Mark: 10/22/2020 15:03:06.163 UTC

    Previous Incremental Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Copy Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Differential Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Full Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Shadow copy backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

         cpgUpgrade55Format: 0
        cpgUpgradeFreePages: 0
    cpgUpgradeSpaceMapPages: 0

           ECC Fix Success Count: none
       Old ECC Fix Success Count: none
             ECC Fix Error Count: none
         Old ECC Fix Error Count: none
        Bad Checksum Error Count: none
    Old bad Checksum Error Count: none

      Last Database Maintenance Finish Date: 04/28/2021 04:49:42.621 UTC
    Current Database Maintenance Start Date: 04/28/2021 09:27:36.037 UTC
          Highest Continuous Database Maintenance Page: 0
          Highest Database Maintenance Page: 0

      Database Header Flush Signature: Create time:05/05/2021 04:11:46.366 Rand:2785027612 Computer:
     Flush Map Header Flush Signature: Create time:00/00/1900 00:00:00.000 Rand:0 Computer:


    Operation completed successfully in 2.250 seconds.

    [PS] C:\Windows\system32>

    [PS] C:\Windows\system32>eseutil.exe /mh "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating FILE DUMP mode...
             Database: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb


    DATABASE HEADER:
    Checksum Information:
    Expected Checksum: 0xbd3f9cc9
      Actual Checksum: 0xbd3f9cc9

    Fields:
            File Type: Database
             Checksum: 0xbd3f9cc9
       Format ulMagic: 0x89abcdef
       Engine ulMagic: 0x89abcdef
     Format ulVersion: 0x620,20,0  (attached by 0)
     Engine ulVersion: 0x620,60,120  (efvCurrent = 9040)
    Created ulVersion: 0x620,20
         DB Signature: Create time:11/25/2020 23:51:34.890 Rand:4080501465 Computer:
             cbDbPage: 32768
               dbtime: 7536557 (0x72ffad)
                State: Dirty Shutdown
         Log Required: 12911-12988 (0x326f-0x32bc)
        Log Committed: 0-12989 (0x0-0x32bd)
       Log Recovering: 12989 (0x32bd)
       Log Consistent: 12911 (0x326f)
      GenMax Creation: 05/05/2021 03:52:00.853 UTC
             Shadowed: Yes
           Last Objid: 54300
         Scrub Dbtime: 0 (0x0)
           Scrub Date: 00/00/1900 00:00:00.000 LOC
         Repair Count: 0
          Repair Date: 00/00/1900 00:00:00.000 LOC
     Old Repair Count: 0
      Last Consistent: (0x2261,62,0)  03/10/2021 00:34:06.843 UTC
          Last Attach: (0x2262,2,268)  03/10/2021 00:34:08.215 UTC
          Last Detach: (0x0,0,0)  00/00/1900 00:00:00.000 LOC
        Last ReAttach: (0x2F19,2,268)  04/26/2021 09:30:44.486 UTC
                 Dbid: 1
        Log Signature: Create time:11/25/2020 23:51:34.733 Rand:1790368099 Computer:
           OS Version: (6.2.9200 SP 0 NLS ffffffff.ffffffff)

    Previous Full Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Incremental Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Copy Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Differential Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Full Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Shadow copy backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

         cpgUpgrade55Format: 0
        cpgUpgradeFreePages: 0
    cpgUpgradeSpaceMapPages: 0

           ECC Fix Success Count: none
       Old ECC Fix Success Count: none
             ECC Fix Error Count: none
         Old ECC Fix Error Count: none
        Bad Checksum Error Count: none
    Old bad Checksum Error Count: none

      Last Database Maintenance Finish Date: 04/25/2021 08:16:59.054 UTC
    Current Database Maintenance Start Date: 04/28/2021 04:14:33.393 UTC
          Highest Continuous Database Maintenance Page: 0
          Highest Database Maintenance Page: 0

      Database Header Flush Signature: Create time:05/05/2021 04:09:05.661 Rand:3303610026 Computer:
     Flush Map Header Flush Signature: Create time:00/00/1900 00:00:00.000 Rand:0 Computer:


    Operation completed successfully in 0.531 seconds.

    [PS] C:\Windows\system32>eseutil.exe /r "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating RECOVERY mode...
        Logfile base name: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb
                Log files: <current directory>
             System files: <current directory>

    Operation terminated with error -1003 (JET_errInvalidParameter, Invalid API parameter) after 0.31 seconds.


    [PS] C:\Windows\system32>eseutil.exe /p "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating REPAIR mode...
            Database: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb
      Temp. Database: TEMPREPAIR12884.EDB

    Checking database integrity.

    The database is not up-to-date. This operation may find that
    this database is corrupt because data from the log files has
    yet to be placed in the database.

    To ensure the database is up-to-date please use the 'Recovery' operation.


                         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
              |----|----|----|----|----|----|----|----|----|----|
              ...................................................


    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 corruption has been repaired) after 15.265 seconds.


    • 已编辑 Tony Mu 2021年5月10日 10:45
    2021年5月10日 10:26

答案

  • 您好,

    是的,用administrator即可。

    我简单测试了一下,将数据库dismount以后,访问所有邮箱的OWA都是不行的,但用来登录ECP是可以的。

    此致,

    Eric Yin


    如果以上回复对您有所帮助,建议您将其“标记为答复”. 如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

    • 已标记为答案 Tony Mu 2021年5月13日 6:41
    2021年5月13日 5:30

全部回复

  • 您好,

    我注意到您运行Eseutil /r时失败了,主要原因是您的命令格式不对,正确的应该是:

    ESEUTIL /r <log_prefix> /l <path_to_the_folder_with_log_files> /d <path_to_the_folder_with_the_database>
    

    log_prefix 即存储组号,您可以看下数据库文件里的日志文件名,默认第一个数据库为E00

    path_to_the_folder_with_log_files 为日志文件位置

    path_to_the_folder_with_the_database 为edb文件位置

    这两个值可以一样,以下为一个正确命令的例子:

    ESEUTIL /r E00 /l “C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1643455454” /d “C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1643455454”
    

    您在运行ESEUTIL /P前是否做了备份?这个命令可能会造成一定的数据丢失,没做备份的话,您现在运行ESEUTIL/MH的state显示什么?

    做了备份的话,我建议您恢复到备份文件的状态,先运行ESEUTIL/R 后观察ESEUTIL/MH的state是否为clean shutdown。

    此致,

    Eric Yin


    如果以上回复对您有所帮助,建议您将其“标记为答复”. 如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

    2021年5月11日 6:34
  • 您好之前没做备份,做完之后有一个数据库是正常了,另外数据库还是报错,报错的这个刚好所有的系统邮箱还有administrator管理账户邮箱都在这个有问题的里面,通过ecp还是打不开,接下来该如何处理? [PS] 




    [PS] C:\Windows\system32>ESEUTIL /r E00 /l "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259" /d "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating RECOVERY mode...
        Logfile base name: E00
                Log files: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259
             System files: <current directory>
       Database Directory: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259

    Performing soft recovery...
                          Restore Status (% complete)

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


    Operation completed successfully in 21.687 seconds.

    [PS] C:\Windows\system32>ESEUTIL /r E00 /l "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227" /d "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating RECOVERY mode...
        Logfile base name: E00
                Log files: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227
             System files: <current directory>
       Database Directory: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227

    Performing soft recovery...
                          Restore Status (% complete)

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



    Operation terminated with error -1216 (JET_errAttachedDatabaseMismatch, An outstanding database attachment has been detected at the start or end of recovery, but database is missing or does not match attachment info) after 4.375 seconds

    [PS] C:\Windows\system32>eseutil.exe /mh "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating FILE DUMP mode...
             Database: C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\Mailbox Database 1933372227.edb


    DATABASE HEADER:
    Checksum Information:
    Expected Checksum: 0x2a59acd0
      Actual Checksum: 0x2a59acd0

    Fields:
            File Type: Database
             Checksum: 0x2a59acd0
       Format ulMagic: 0x89abcdef
       Engine ulMagic: 0x89abcdef
     Format ulVersion: 0x620,60,120  (attached by 9040)
     Engine ulVersion: 0x620,60,120  (efvCurrent = 9040)
    Created ulVersion: 0x620,20
         DB Signature: Create time:05/10/2021 10:38:16.216 Rand:2280249318 Computer:
             cbDbPage: 32768
               dbtime: 11143394 (0xaa08e2)
                State: Clean Shutdown
         Log Required: 0-0 (0x0-0x0)
        Log Committed: 0-0 (0x0-0x0)
       Log Recovering: 0 (0x0)
       Log Consistent: 0 (0x0)
      GenMax Creation: 00/00/1900 00:00:00.000 LOC
             Shadowed: Yes
           Last Objid: 79970
         Scrub Dbtime: 0 (0x0)
           Scrub Date: 00/00/1900 00:00:00.000 LOC
         Repair Count: 2
          Repair Date: 05/10/2021 10:38:15.768 UTC
     Old Repair Count: 0
      Last Consistent: (0x0,0,0)  05/10/2021 10:38:16.423 UTC
          Last Attach: (0x0,0,0)  05/10/2021 10:38:16.360 UTC
          Last Detach: (0x0,0,0)  05/10/2021 10:38:16.423 UTC
        Last ReAttach: (0x2F19,2,268)  04/26/2021 09:30:44.486 UTC
                 Dbid: 1
        Log Signature: Create time:00/00/1900 00:00:00.000 Rand:0 Computer:
           OS Version: (6.2.9200 SP 0 NLS ffffffff.ffffffff)

    Previous Full Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Incremental Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Copy Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Previous Differential Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Full Backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

    Current Shadow copy backup:
            Log Gen: 0-0 (0x0-0x0)
               Mark: (0x0,0,0)
               Mark: 00/00/1900 00:00:00.000 LOC

         cpgUpgrade55Format: 0
        cpgUpgradeFreePages: 0
    cpgUpgradeSpaceMapPages: 0

           ECC Fix Success Count: none
       Old ECC Fix Success Count: none
             ECC Fix Error Count: none
         Old ECC Fix Error Count: none
        Bad Checksum Error Count: none
    Old bad Checksum Error Count: none

      Last Database Maintenance Finish Date: 04/25/2021 08:16:59.054 UTC
    Current Database Maintenance Start Date: 04/28/2021 04:14:33.393 UTC
          Highest Continuous Database Maintenance Page: 0
          Highest Database Maintenance Page: 0

      Database Header Flush Signature: Create time:05/10/2021 10:38:16.423 Rand:1273330580 Computer:
     Flush Map Header Flush Signature: Create time:05/10/2021 10:38:16.423 Rand:4162960287 Computer:


    Operation completed successfully in 1.63 seconds.

    [PS] C:\Windows\system32>



    [PS] C:\Windows\system32>eseutil.exe /mh "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259\Mailbox Database 1630159259.edb"

    Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
    Version 15.01
    Copyright (C) Microsoft Corporation. All Rights Reserved.

    Initiating FILE DUMP mode...
    Error: Access to source database 'C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1630159259\Mailbox Database 1630159259.edb' failed with Jet error -1032.

    Operation terminated with error -1032 (JET_errFileAccessDenied, Cannot access file, the file is locked or in use) after 0.31 seconds.



    [PS] C:\Windows\system32>Test-MAPIConnectivity

    MailboxServer      Database           Result    Error
    -------------      --------           ------    -----
    EXH-MDB01             EXHDB01          成功
    EXH-MDB01             EXHDB02          成功
    EXH-MDB01             EXHDB04          成功
    EXH-MDB01             EXHDB05          成功


    [PS] C:\Windows\system32>

    • 已编辑 Tony Mu 2021年5月11日 8:21
    2021年5月11日 8:18
  • 您好,

    那如果可以的话先对另一个数据文件做下备份。

    注意运行所有ESEUTIL命令时都要将数据库dismount。

    现在先确认下日志是否缺少:

    ESEUTIL /ML "C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database 1933372227\E00"

    此致,

    Eric Yin


    如果以上回复对您有所帮助,建议您将其“标记为答复”. 如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

    2021年5月11日 8:47
  • 收到,假如所有数据库都打不开又没有备份的情况下,能重新创建数据库之后,然后创建相关的邮箱,不知道可行不可行?

    2021年5月12日 7:36
  • 您好,

    监控邮箱和仲裁邮箱是可以重建的:

    Exchange 2013/2016 Monitoring Mailboxes (How to re-create monitoring mailboxes 部分)

    重新创建缺少的仲裁邮箱

    但原有数据库里的用户邮箱数据 恐怕没法用正常手段迁移出来,要借助三方工具直接读取EDB文件才有可能。

    此致,

    Eric Yin


    如果以上回复对您有所帮助,建议您将其“标记为答复”. 如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

    2021年5月12日 8:52
  • 还有个小问题就是数据我可以全部不要,按您说重新创建这些系统邮箱和仲裁邮箱之后是可以通过eac再创建这些账户,那问题是登陆eac的账户是用默认的administrator吗?还是用哪个?
    2021年5月13日 3:26
  • 您好,

    是的,用administrator即可。

    我简单测试了一下,将数据库dismount以后,访问所有邮箱的OWA都是不行的,但用来登录ECP是可以的。

    此致,

    Eric Yin


    如果以上回复对您有所帮助,建议您将其“标记为答复”. 如果您对我们的论坛支持有任何的建议,可以通过此邮箱联系我们:tnsf@microsoft.com.

    • 已标记为答案 Tony Mu 2021年5月13日 6:41
    2021年5月13日 5:30
  • 非常感谢。
    2021年5月13日 6:41