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


-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


dbmcli on R03>util_execute clear log


dbmcli on R03>db_online


Assigned Tags

      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,


      Author's profile photo Shama Sunder
      Shama Sunder

      Thank You. It is cleared.


      Author's profile photo Basavaraj Kundaragi
      Basavaraj Kundaragi

      Thank you worked for me as well

      Author's profile photo Jaime Rodriguez
      Jaime Rodriguez

      For me it didn't work, the database was to OFFLine status.