Re: Insert /* +append */ always ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 3 Jun 2002 21:53:38 +1000
Message-ID: <adflck$nnu$1@lust.ihug.co.nz>

Of course it will not get them. Standby databases only get anything because the 'anything' first gets into the redo stream. If it doesn't get into the redo stream, the standby database doesn't get it.

Do any nologgin operation, the standby is stuffed.

HJR "Saikat Chakraborty" <saikatchak_at_hotmail.com> wrote in message news:ce53c312828ba02c6f9286612fdfbb6e.16981_at_mygate.mailgate.org...
> "Thomas Kyte" <tkyte_at_oracle.com> wrote in message
> news:addtbq02m2j_at_drn.newsguy.com
>
> >
> > What that means is that the data need no be protected by REDO in
noarchivelog
> > mode. We don't need to redo the operation since the operation is done
directly
> > to disk. Since media recovery is not possible in noarch mode -- no redo
is
> > needed (we don't need the redo for instance recover in these cases since
the
> > blocks are already safely on disk)
> >
> > In archivelog mode, we do need the redo and the operations would have to
be
> > performed on NOLOGGING tables in order to bypass redo generation....
> >
>
> Hi Tom,
>
> I tested that rows inserted by append hint does appear after
> a database recovery. But I have a question:
> If we have a hot standby database,
> does the standby database also gets those records? If not the standby
> will silently gets corrupted.
> I am talking of Oracle 8i and above versions.
> Thanks for guiding us,
> Saikat
> http://saikatchak.tripod.com
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Jun 03 2002 - 06:53:38 CDT