Initialization of log for ‘restart’ failed with ‘LogAndDataIncompatible’



Share this article :

Symptom

You are performing backup & restore, system refresh for MaxDB database but during the MaxDB startup, you encountered with below error.

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

SYSERROR -9407 unexpected error
Database state: OFFLINE
Log- and data area are not compatible because 'Restart position not found'.
IOSequence 36272647 not in interval of 30723181 - 31000205.
Initialization of log for 'restart' failed with 'LogAndDataIncompatible'
DBCRASH  Kernel exited due to signal 0(Killed after timeout with state SERVER_KILL)
___ Stopping GMT 2013-04-28 17:28:33           7.6.06   Build 010-123-229-880

Solution

1. Execute below command.

> dbmcli -d DEV -u control,control
dbmcli> db_admin
dbmcli> db_connect
dbmcli> db_execute clear log
dbmcli> exit

2. Start the MaxDB database again!

Related posts

MaxDB Administration using DBM CLI
Accessing MaxDB SQL using SQL Studio
Change Password for DBM Operator, Database User in MaxDB
MaxDB Directory Structure in OS Level
© 2017 ITsiti. All Rights Reserved
Powered by KEEM