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@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
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.
Certifiable Oracle DBA and Part Time Perl Evangelist