Reset Log Sequence Number
Hi,
Is it possible to reset the db log sequence number for a fresh start?
I accidentally deleted the innodb logfiles during reconfiguration of the database storage. The Datafiles are not touched and should be ok.
After starting with the new logfiles i'm getting error messages like:
InnoDB: is in the future! Current system log sequence number 0 8424.
InnoDB: Your database may be corrupt.
051019 17:29:13 InnoDB: Error: page 1189291 log sequence number 15 3702051443
What is the best way to handle this situation, there is no backup of the logfiles because it's a new db which is not in production yet.
However i'd rather not import all the data (60gb) again, so any help is appreciated.
regards
Subject
Views
Written By
Posted
Reset Log Sequence Number
19524
October 19, 2005 09:32AM
10955
October 19, 2005 11:24AM
9476
October 25, 2005 07:20AM
8546
October 25, 2005 11:37AM
5991
January 26, 2009 10:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.