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
Worked for me.
Worked like a charm.
Thank you,
Theo
Thank You. It is cleared.
Gopi
Thank you worked for me as well
For me it didn't work, the database was to OFFLine status.