cancel
Showing results for 
Search instead for 
Did you mean: 

Initialization of log for 'restart' failed with 'LogAndDataIncompatible'

Former Member
0 Kudos

Dear SAP colleagues,

I do have a problem to restart my MaxDB database (version 7.7.06.10).

I wanted to deactivated the "redo log management".

I did it, then, I have stopped my database and when I wanted to restart, I get this error :

SQL error 9407, System error: unexpected error 3,

Database state : OFFLINE

Internal errorcode, Error code 6433 "system error"

Log - and data area are not compatible because 'Restart position not found'.

IOSequence 12092997 not in interval of 11503142 - 12091086 on the Log_Partition 1.

20028, Initialization of log for 'restart' failed with 'LogAndDataIncompatible'

It seems to miss one redo log file in my /sapdb/SID/saplog filesystem.

Do you have any idea how to fix this issue ?

I just want to restart my database, I do not want to restore or recover it.

It should be possible to restart it - now, the redo logs management is de-activated.

Thanks in advance for you input.

Best regards

SAP NetWeaverAdmin

Accepted Solutions (1)

Accepted Solutions (1)

former_member229109
Active Contributor

Hello SAP NetWeaverAdmin,

1. If you are SAP customer =>

u2022 I recommend you to create the SAP message so we could check the database logs

before to give you solution steps for the reported problem.

u2022 Please review the SAP note:

869267 FAQ: SAP MaxDB LOG area

2. To fix the issue you could try the following steps:

    • Create the complete databackup in admin state first!

    • Connect to the database as dbm user, default u2013 control for SAP installations.

dbmcli -d <SID> -u control,<PWD>

dbmcli on <SID>>db_admin

dbmcli on <SID>>db_connect

dbmcli on <SID>>db_execute clear log

( when it will be done -> please run)

>exit

Try to restart the database online after that.

Thank you and best regards, Natalia Khlopina

Sir,

Thank you very much for this solution. It solved my problem instantly.

But I just wanted to know the logic behind clearing log. Can you please update.

Thanks,

Sarang.

Answers (0)