Hi,
use dbmcli command
param_directgetall
and grep for 'hot standby node entries' like 'HS_NODE_001'.
If you remove these with
param_directdel HS_NODE_001
param_directdel HS_NODE_002
...
and restart your database, it will not try to get your mapping information anymore...
CU
jrg
> -----Original Message-----
> From: gollum sss [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 10. Juni 2004 11:24
> To: Mensing, Joerg
> Subject: RE: Database instance not starting after a crash ... log
> corrupt?
>
>
>
> Hi Joerg,
>
> Yes i have hotstandby turned on but not using it now. Do u
> mean that turning
> it off i could recover the logs? how can it be done?
>
> Thanks,
> Josu.
>
>
>
>
>
>
> >From: "Mensing, Joerg" <[EMAIL PROTECTED]>
> >To: "'gollum sss'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: RE: Database instance not starting after a crash
> ... log corrupt?
> >Date: Thu, 10 Jun 2004 11:18:34 +0200
> >MIME-Version: 1.0
> >Received: from smtpde01.sap-ag.de ([155.56.68.140]) by
> mc1-f25.hotmail.com
> >with Microsoft SMTPSVC(5.0.2195.6824); Thu, 10 Jun 2004
> 02:18:46 -0700
> >Received: from sap-ag.de (smtpde01) by smtpde01.sap-ag.de
> (out) with ESMTP
> >id LAA05533; Thu, 10 Jun 2004 11:18:43 +0200 (MESZ)
> >X-Message-Info: JGTYoYF78jGSeth7CJDLvghphqolCOHJ
> >Message-ID:
> <[EMAIL PROTECTED]>
> >X-Mailer: Internet Mail Service (5.5.2657.72)
> >X-SAP: out
> >Return-Path: [EMAIL PROTECTED]
> >X-OriginalArrivalTime: 10 Jun 2004 09:18:47.0084 (UTC)
> >FILETIME=[EF26C6C0:01C44ECB]
> >
> >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]
>
> _________________________________________________________________
> Descarga gratis la Barra de Herramientas de MSN
> http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU
> =http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
