Hi, do you experiment with your own HotStandby solution? The messages you see are only possible if you have a configuration for a HotStandby Instance. I fear the log volume is not just bad, but the database trys to interpret it as a hot standby log volume because it is not accessible...
On Linux some file systems do not cache directory information. The can produce SEVERE problems on power failure. In such a case it good to have a COMPLETE backup of the COMPLETE machine... Sorry i have no better news for you. CU jrg > -----Original Message----- > From: gollum sss [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 10. Juni 2004 11:02 > To: [EMAIL PROTECTED] > Subject: Database instance not starting after a crash ... log corrupt? > > > > Hi, > > i'm getting this errors in knldiag after getting up the > machine/db after a > power line crash: > > 2004-06-10 08:44:42 29427 ERR 13900 RTEHSS RTEHSS_API > [RTEHSS_API(COPY):RTEHSS_GetMapping] > 2004-06-10 08:44:42 29427 ERR 13900 RTEHSS RTEHSS_API > [ValidateOrCreateShare cannot stat volume directory symlink > /var/opt/sdb/data/wrk/SGAZ3E0Z3E�Z3E`]3Eo\3E > 2004-06-10 08:44:42 29427 ERR 13900 RTEHSS `�^]@(] > 2004-06-10 08:44:42 29427 ERR 13900 RTEHSS RTEHSS_API > [Failed to create or > validate share for volume DAT_0001 entry 0 ] > > The data volumes seems to be ok as i can backup and restore > it to another > instance but i loss data as the logs isnt restored .......... the log > volumes must be bad because if i backup and then restore the > log the server > gives me an error restoring them .............. > > Is it common to loss data after a crash? The DB have been > running flawlessly > for months until now with no problem. Also we have data and > log volumes in > files using Debian Linux with ext3 so maybe it has been an > issue in the > recovering fs that may be corrected using raw volumes? > > There isnt any procedure to parse/recover/repair the data and > log volumes > from bad data so only a small part of data would be lost in the > reconstruction, will it be implemented as in other databases? > > And no, we havent any log backup done as we were using > overwrite mode :( > Loose just hours of work not important data anyway. > > Thanks in advance for the replies, > Josu. > Primero se llevaron a los negros, > pero a mi no me import� porque yo no lo era. > Enseguida se llevaron a los judios, > pero a mi no me import�, porque yo no lo era. > Despu�s detuvieron a los curas, > pero como yo no soy religioso tampoco me import�. > Luego apresaron a los comunistas, > pero como yo no era comunista tampoco me import�. > Ahora me llevan a mi, pero ya es tarde. > > (Bertolt Brecht) > > _________________________________________________________________ > Acepta el reto MSN Premium: Protecci�n para tus hijos en internet. > Desc�rgalo y pru�balo 2 meses gratis. > http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados _proteccioninfantil -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
