Re: Deactivating Redo Logs on 9i?

You seem to have misunderstood... the Instance runs generating redo 99% of the time. Once a month, a cold backup is taken, redo is switched off, a massive load performed, another backup, and redo is re-enabled. As I said, "It's obviously not something anyone in their right mind would consider running in for any length of time."

They don't (and the Instance isn't mine in the first place, no nerves of steel required!)

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
news:Bgjf8.4960$106.290588_at_bgtnsc05-news.ops.worldnet.att.net...


> Howard, if I had an instance going for years with redo inhibited, I think

> I'd be on Valium the whole time until the blessed day came to restart and

> turn it back on.

>

> You must have nerves of steel.

>

> RSH

>

> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message

> news:a5hpvg$n60$1_at_lust.ihug.co.nz...

> > I didn't exactly recommend it, did I?  I said: "be warned... it's hidden

> for

> > a reason."

> >

> > On the other hand, I've had reports of it doing its job perfectly for

> years

> > (prior to bulk loads it's switched on, and switched off immediately

> > afterwards).  It's obviously not something anyone in their right mind

> would

> > consider running in for any length of time.

> >

> > HJR

> > --

> > ----------------------------------------------

> > Resources for Oracle: http://www.hjrdba.com

> > ===============================

> >

> >

> > "RFre465789" <rfre465789_at_aol.com> wrote in message

> > news:20020227000829.01289.00000668_at_mb-de.aol.com...

> > > Do NOT recommend _disable_logging... tried it, worked for a while, and

> > then we

> > > ran into some corruption (not shutdown related)....

> > >

> > > Stay away!!!!

> > >

> > > RF

> > >

> > >

> > > Robert G. Freeman

> > > Author

> > > Oracle Press's Oracle9i New Features

> > > Sybex's Mastering Oracle9i

> > > Coriolis' Oracle8 to 8i Upgrade Exam Cram

> > > Coriolis' Oracle 7.3 to 8 Upgrade Exam Cram

> >

> >

>

>