re NOLOGGING/LOGGING

The "until 9iR2 of course when you can set the database to FORCE logging even if
someone tries NOLOGGING"
is good.

A DBA might want everything in the RedoLogs but some smart developer writes a job NoLogging and the DBA is not aware of it. What happens when the data doesn't go to the standby or the DBA has to recover from a backup ? Who's neck is on the block when the data is "gone, disappeared, missing" ?

Hemant K Chitale

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:adgkjv02ejp_at_drn.newsguy.com...
> In article <adflck$nnu$1_at_lust.ihug.co.nz>, "Howard says...
> >
> >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.
>
> until 9iR2 of course when you can set the database to FORCE logging even
if
> someone tries NOLOGGING
>
>
> >
> >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
> >
> >
>
> --
> Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Tue Jun 04 2002 - 09:51:09 CDT