Re: log file format

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 29 May 2001 22:32:32 +1000
Message-ID: <3b1396fa$1@news.iprimus.com.au>

"John" <j_barbe_at_hotmail.com> wrote in message news:8bc78dd8.0105280541.4c2b8b56_at_posting.google.com... [Snip]
>
> I've read somewhere that it is possible to unable the logging in the
active log file. Is it true?

There's a hidden parameter "_disable_logging" which turns of ALL redo generation -nothing is logged at all. It is of course guaranteed to render your database unrecoverable (you'd have to restore from the last complete cold backup). And its use is totally unsupported by Oracle. I've successfully ruined a training database by inadvertently doing a shutdown abort after having set it on (aborts *require* subsequent Instance Recovery -only if there's no redo, then SMON can't perform the recovery.....)

So yes, you can do what you suggest, but at *enormous* risk.

In certain circumstances (like a load of 10 million rows to a just-backed up system), I can see a use for it. But not otherwise.

Regards
HJR Received on Tue May 29 2001 - 07:32:32 CDT