Re: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

On 8/22/05, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> I was thinking about this whole topic over the weekend. It just affirms
> my feeling that using the NOLOGGING option needs to be used judiciously. And
> I question how much time we are saving here.
>

Quite a bit of time actually. Try timing a bulk load operation with and without logging.

If the total time to reload using NOLOGGING and a total backup is less than
> a reload with LOGGING and no backup, then don't use it.
>

You don't need a complete database backup, just the datafiles containing the nologging objects.

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

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