Skip to Content
avatar image
Former Member

RESTORE - Kernel Bad page - header and trailer not matching

Hello,

I have a Problem with the recover of my backup.

When i want to make a restore of the Database this error is shown in Logfile KNLDIAGERR

2008-11-26 21:20:38 --- Starting GMT 2008-11-26 20:20:38 7.5.0 Build 032-123-111-699

2008-11-26 21:26:57 0xE0C ERR 20005 Kernel Bad page - header and trailer not matching

2008-11-26 21:26:57 0xE0C ERR 20006 Kernel Header [ 5277032 - data - tab - checksumData - empty ]

2008-11-26 21:26:57 0xE0C ERR 20007 Kernel Trailer[ 0 - data - nil - chckNil - empty ]

2008-11-26 21:26:57 0xE0C ERR 52015 RESTORE write/check count mismatch 5277032

2008-11-26 21:26:57 0xDFC ERR 52012 RESTORE error occured, basis_err 300

2008-11-26 21:26:57 0xDFC ERR 51080 SYSERROR -9026 BD Bad datapage

any Help ?

thanks a lot

Steven

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 27, 2008 at 09:28 AM

    Hi Steven,

    so it looks like the error happened during write the page to your backup medium.

    The error is in the backup - so this backup cannot be used for recovery.

    Is it possible to create a backup into a local file first. You can try to zip the file and copy it to the target system.

    I know it depends on the size of the database.

    But is it possible to work with remote pipes? One idea is to create a remote pipe start the backup of the source system and on the target system start a recovery reading from this remote pipe. I do not know if this will work, it's just an idea.

    Regards, Christiane Hienger

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2008 at 08:37 AM

    Hello again,

    i test the restore with several backups, but everytime the same error apperars.

    The Source System is Ok, and i can´t find any errors (Structure test etc.)

    Thanks a lot

    Steven

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2008 at 08:49 AM

    Hi Steven,

    the database kernel checks with every read the header trailer. If it got a mismatch during read the error message you got is logged.

    The same checkes will be executed when you create a backup. You told us that the backup could be executed without any errors and that the system where you created the backup is ok as well -> you executed a Check data?

    Now everything looks like the error is in the backup and happened during writies to the external backup medium. Or the backup is ok and then the error happens during read from the external medium.

    To get closer to the reason where the problem is located I need to have some more information.

    1. You did the restore several times?

    2. Did the bad Data Page shappens always on the same page -> Check knldiag.err

    3. Did you do your backup on tape?

    4. Did you try to create a backup into a file?

    5. Does the restore from file got the error as well?

    Regards, Christiane Hienger

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Christiane,

      tahnks for the answer.

      Yes I do the restore Serveral time

      Yes the Bad Datapage is on the same page.

      No i do not backup to tape a did a backup to disk

      No backup into file

      Perhaps the Probelm is that i copy the backp to an external USB device and than i copied it back

      to the other server ?

      I shoud test to zip the backup an copy it via a networkshare unzip it and try to make the restore again.

      Thanks

      Steven