Re: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against
- From: Jared Still <jkstill@xxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 22:04:56 +0100
On 8/22/05, Mercadante, Thomas F (LABOR) <
Thomas.Mercadante@xxxxxxxxxxxxxxxxx> 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
Other related posts:
