Re: re NOLOGGING

Standby is problematic with nologging.

I am going to rebuild a 400 gig table/index via CTAS with nologging and MV's.

Doing this with logging on would require a very robust backup system, one more robust than we currently have.

A job like that can generate 500m of redo log in a few seconds.

Jared

On 8/24/05, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
>
>
> On 08/24/2005 09:11:48 AM, Hemant K Chitale wrote:
> >
> > For those nervous about NOLOGGING, note that Oracle Apps (eBusiness
> Suite)
> > 11i
> > does use NOLOGGING in a number of operations -- eg when applying Patches
> and
> > in a number of Business Intelligence reports.
> > Of course, the DBA can still FORCE LOGGING.
>
> I am nervous about nologging because I have a standby database which has
> to work
> in case of failover. As a DBA, I don't normally allow anybody but another
> DBA to
> perform DDL. There is no "NOLOGGING" stuff in my database.
>
> --
> Mladen Gogala
> http://www.mgogala.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l