Why does a restore fail with error message 'LogAnd... - SAP Community
source link: https://community.sap.com/t5/technology-blogs-by-members/why-does-a-restore-fail-with-error-message-loganddataincompatible/ba-p/13245989
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
07-23-2013 3:11 PM
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK