Why does a restore fail with error message 'LogAndDataIncompatible'?

[former_member188065]

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

[BBB]

Worked for me.

[Former Member]

Worked like a charm.

Thank you,

Theo

[former_member319104]

Thank You. It is cleared.

Gopi

[basuec85]

Thank you worked for me as well

[jaime_rodriguez_jr]

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

[AJ1305]

Thanks!!!!

[kunika_082019]

Hi,

Thank You for your solution 

It worked for me