Hello,
We recently added disk capacity to our liveCache server and when we were adding data volumes one of the devices that was assigned to a log volume was also assigned to a new data volume.
When we stopped the database and re-started it, we started getting the following errors:
2006-02-21 10:25:05 364 ERR 11000 page0io_ Illegal file format
2006-02-21 10:25:05 364 ERR 11000 page0io_ blocksize wanted: 8192, blocksize found: 0
2006-02-21 10:25:05 148 ERR 11000 vattach dev0_vattach returned FALSE
2006-02-21 10:25:05 148 ERR 13 IOMan Attach error on Log volume 1: Could not open volume
2006-02-21 10:37:59 148 ERR 27 IOMan DevNo from Log volume in configuration and info page are different: 2 vs 31
2006-02-21 10:54:50 148 ERR 27 IOMan DevNo from Log volume in configuration and info page are different: 2 vs 31
2006-02-21 11:08:54 148 ERR 27 IOMan DevNo from Log volume in configuration and info page are different: 2 vs 31
2006-02-21 11:08:54 148 ERR 51080 SYSERROR -9209 Message not available
2006-02-21 11:20:44 148 ERR 27 IOMan DevNo from Log volume in configuration and info page are different: 2 vs 31
2006-02-21 11:20:44 148 ERR 51080 SYSERROR -9209 Message not available
2006-02-21 11:22:36 148 ERR 27 IOMan DevNo from Log volume in configuration and info page are different: 2 vs 31
2006-02-21 11:22:36 148 ERR 51080 SYSERROR -9209 Message not available
It appears that we've either corrupted or destroyed one of our log volumes so the database will not start. Our recovery method of choice would be to re-initailize our database and restore from a good backup, but recently found out our backups are no good.
We've also tried to clear the logs using the 'util_execute clear log' command, but that is not working either:
dbmcli on LCT>util_execute clear log
ERR
-24988,ERR_SQL: sql error
-902,Message not available
Does anyone have any ideas on how we might be able to fix the issue and save our database?
Thanks.
Matthew