Re: Monitoring Hot Standby

get in touch with Rdb support directly. I think that they can
probably help guide you. I think that there may be some RMU
commands that define logicals to indicate the state of the
standby.

palmipede wrote:
>
> Hello
>
> I have setup a Rdb Hot Standby at a customer's site. It works fine.
>
> In order to monitor that the replication is still active, I looked in
> the docs, but failed to find a procedure to do the job.
>
> I ended with the following dirty hack, which may be late to detect the
> problem
>
> $ !'f$ver(1)
> $ set noon
> $ if F$TRNLNM("wait_hot","LNM$SYSTEM",0,"SUPERVISOR",,).eqs.""
> $ then
> $ define/sys wait_hot "0 00:01:00.00"
> $ endif
> $ def tcpip$smtp_from "Admin Vms"
> $ node == f$getsyi("nodename")
> $ boucle:
> $ pipe rmu/dump citox$db | sea sys$pipe -
> "Database is currently being replicated","Master"/match=and
> $ if $severity.eq.1
> $ then
> $ def/group surv_hot ok
> $ else
> $ def/sys wait_hot "0 01:00:00.00"
> $ endif
> $ log = F$TRNLNM("surv_hot","LNM$GROUP",0,"SUPERVISOR",,)
> $ if log.eqs.""
> $ then
> $ ti == f$time()
> $ mail nl: dupont@xxxxxxxxxx -
> /subj=" replication base xx stopped on ''node' at ''ti' "
> $ endif
> $ wait 'F$TRNLNM("wait_hot","LNM$SYSTEM",0,"SUPERVISOR",,)
> $ deas/group surv_hot
> $ goto boucle
> $ exit
>
> I then thought about having all Rdb Hot standby messages go to OPERn,
> and use a program like opcom_catcher to intercept that.
>
> I think there must be a much better way ?
>
> Regards
>
> Gérard

--
- - - - -
opinions expressed here are mine and mine alone
and certainly are not intended in any way to
express or represent any opinions or commitment
of oracle corporation.

norman lastovica / oracle rdb engineering
.

Relevant Pages

  • Re: -COSI-I-NOTSYSCONCEAL, error
    ... we are exploring Rdb for possible use within our organization. ... In my opinion, ... are common to all cluster members are placed in cluster wide tables. ... norman lastovica / oracle rdb engineering ...
    (comp.databases.rdb)
  • Re: Datatrieve/CDD protection
    ... Norman Lastovica wrote: ... dependent on Rdb and this sounds like you have Rdb permission issues ... norman lastovica / oracle rdb engineering ...
    (comp.os.vms)