Failed to start the Master Database in liveCache HotStandby setup!

[Former Member]

Hi all,

A failed attempt to start liveCache Master in HotStandby setup (Standby server is offline) giving the following ERROR. Does anyone know how to recover it?

bash-2.05b# /sapdb/programs/bin/dbmcli -d LC5 -u control,vcs12345 db_online

ERR

-24988,ERR_SQL: Sql error

-9407,System error: unexpected error

3,Database state: OFFLINE

8,Log- and Data are not compatible because 'Restart position not found'.

7,IOSequence 13657 not in intervall of 0 - 12908.

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

bash-2.05b#

Thanks & Regards,

Venkat

[Former Member · Accepted solution]

Hello Venkat,

the message means in effect that the logvolume is older than the data in your database.

The savepoint has a so called log-io-sequencenumber of 13657 while on your logvolume the greatest (say youngest) log-io-sequencenumber is 12908.

One possible reason for this is that you copied an old logvolume onto the exisiting one.

A possible solution for this is to clear the log using the dbmcli command "util_execute clear log" in admin-mode. Afterwards you can restart the database. The content of the database is that one of the last savepoint.

If you are not sure if you may miss modifications which made after the savepoint then you should <b>not choose this way</b> but search for either logbackups to recover or the original logvolume for a restart.

Kind regards, Martin

[Former Member · Accepted solution]

hi Martin,

Thanks for your reply. It solved my problem. I have assigned you the points as well.

Thanks,

Venkat