Skip to Content
Former Member
Jun 17, 2011 at 07:53 AM

Is there a way to reset USED LOG PAGE?


Hi Guys

Im running SapDB/MAXDB

We had a power outage on our standy server and it appears to have lost the position of wher it last retored its logs, so it refuses to continue to allow me to restore logs

Used LOG Page 394

First LOG Page 2147483647

Restartable 1

Id Restart Record

Id LOG Info

Consistent 1

Log Volume Enabled 1

Log Auto Overwrite 0

Master Servernode

Converter Version 7

Oldest Compatible Version

Queue Count 1

Repository Imports NO

The used log page is supposed to be a much larger value 36441923 which is compatible with the last log file it(LOG53722) restored

When i do a check of the last log file restore to this standy server this is what i get

backup_history_list -c label,action,stamp1,stamp2,start,stop,firstlog,lastlog -Inverted



2011-06-16 07:32:07

2011-06-16 07:32:07

LOG_000053722|RESTORE |2011-06-14 15:57:48|2011-06-14 22:17:10|2011-06-15 10:09:20|2011-06-15 10:09:24| 36441606| 36441923|

LOG_000053721|RESTORE |2011-06-14 15:42:24|2011-06-14 15:57:48|2011-06-15 10:08:20|2011-06-15 10:09:20| 36440924| 36441605|

Is there a way for me to set the logs to continue restoring to this database. or do i have to restore the database entirely and restart the logs from scratch, I hope not as this is quite tedious as the Database is Huge.

Please assist