Re: log question

A copy of this was sent to j_barbe_at_hotmail.com (John) (if that email address didn't require changing) On 29 May 2001 04:22:13 -0700, you wrote:

>> If you think you can really do without redolog files (which is just a Career
>> Limiting Move), set the hidden init.ora parameter _nologging to true.
>> Of course, if anything does go wrong, you can't recover your database and
>> you are on your own.
>
>
>WOW
>what is this parameter?
>Does it really unables the redo log?
>DO people really use this?

that is not the name of the parameter.

yes there is such a parameter.

no, no one would use this.

if your database was to have this set AND the database was shutdown in any fashion other then NORMAL or IMMEDIATE, your database would be toast. It would be totally unrecoverable. You would never open that instance again.

A power failure = no database.
A shutdown abort = no database.
A casual reboot of an NT server = no database. A software failure = no database.
and so on.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp