Re: Oracle parameter

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 26 Apr 1999 09:31:08 -0700
Message-ID: <372494CC.E66E44A@us.oracle.com>

Ross

No fine points about it. It turns off redo logging TOTALLY. As with all the underscore parameters, it should never be used without Oracle Support telling you to use it. This one is particularly dangerous, as you mention. Any failure is simply not recoverable from, so it should never be used in a Production database.

HTH. Pete

Ross Mohan wrote:

> turns off "most" logging. ( Fine points escape me, but likely someone
> else will have these on the tip of their tongue)
>
> speeds up the database, sometimes significantly.
>
> makes database UTTERLY USELESS if you have to recover in ANY WAY
> whatsoever ( including simple instance recovery ) while instance is in this
> mode.
> If you do it, can do a shutdown NORMAL, remove the parameter, and restart,
> you've survived.
>
> I'll assume you're an adult like everybody else on the list and leave the
> threats, warnings,
> and remonstrations to somebody else. You've got enough information to decide
> for
> yourself whether or not to use it.
>
> good luck to you.
>
> hth
>
> Ross
>
> Paolo Collu wrote in message <7fvf89$cio$1_at_nslave1.tin.it>...
> >Hello Everybody,
> >Who know the parameter _disable_logging and used it
> >
> >
> >

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Apr 26 1999 - 11:31:08 CDT