Is there a way to reset USED LOG PAGE?

49 Views

Hi Guys

Im running SapDB/MAXDB 7.8.0.2.21

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 sunflower.pha.co.za:P01_20110617_092956

Id LOG Info

Consistent 1

Log Volume Enabled 1

Log Auto Overwrite 0

Master Servernode

Converter Version 7

Oldest Compatible Version 7.8.02.21

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

CONTINUE

HISTLOST

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

Thanks

Stuart