Skip to Content
Author's profile photo SAP BASIS

Why does a restore fail with error message ‘LogAndDataIncompatible’?

It’s not failed, but in this case log doesn’t match the restored database

dbmcli on R03>db_online

ERR

-24988,ERR_SQL: SQL error

-9407,System error: unexpected error

3,Database state: OFFLINE

20028,DBIdentifier of DataVolume (myhost:R03_20131117_011716) and LogVolume (myhost:R03_20190902_147628) does not match

8,Log- and data area are not compatible because ‘The DB Identifiers are not equal’.

20028,Initialization of log for ‘restart’ failed with ‘LogAndDataIncompatible’

This can be fixed easily

dbmcli on R03>db_admin

OK

dbmcli on R03>util_execute clear log

OK

dbmcli on R03>db_online

OK

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Erick Kibunja
      Erick Kibunja

      Worked for me.

      Author's profile photo Former Member
      Former Member

      Worked like a charm.

      Thank you,

      Theo

      Author's profile photo Shama Sunder
      Shama Sunder

      Thank You. It is cleared.

      Gopi

      Author's profile photo Basavaraj Kundaragi
      Basavaraj Kundaragi

      Thank you worked for me as well