Re: "_disable_logging" parameter

Hi all, Rniemic, Michael, wim

wim is correct:

I had a corrupt roolback and support told that there is no other way than completely export the whole database and re-import it. If you use _allow_rollback_corruption you -will- get errors later.

kind regards,

Toni
In article <34C26E2C.4E04_at_pacbell.net>, wcoekaer_at_pacbell.net wrote:

> Rniemic wrote:
> >
> > I have tested _disable_logging on our crash and burn box ... and it crashed
> > and burned (corruption). I would stay away from this one until Oracle8.
> >
> > However, many of the undocumented init.ora's mentioned in the previous
 email by
> > Michael are useful (see one below)...
> >
> > If you do get a corrupted log with no way to recover:
> > _allow_resetlogs_corruption = true
> > ... this one is very helpful.
> Actually, the allow resetlogs corruption and offline rollback segments
> and all that parameters might make you bring up the database, but in
> many cases you end up with a total inconsistent system, also, once you
> do this, you do not have any chance to go back and try stuff. so if you
> have a support contract, play with these parameters first, then call,
> they will not be able to help you out, and this is not their fault
> then!!! so be REALLY REALLY careful using all those _ parameters. and
> always call support and ask what would be the best way to go about.
> it really isnt always necessary to use them...
>
> also, disable logging, yes in oracle 8 you can use the nologging option
> for your data which will help... at least you dont corrupt the whole
> database if some thing goes wrong that way so you are right... o8 allows
> for more unrecoverable options with respect to data.
>
> cheers
> wim
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  | Please remove            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.