Re: Block Corruption in empty pages in Oracle 11g

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Thu, 5 Aug 2010 10:03:51 -0700 (PDT)
Message-ID: <f21c5ae7-8bd5-4314-8f66-3d94819c7497_at_h28g2000yqd.googlegroups.com>

On Aug 5, 7:54 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 04 Aug 2010 20:08:15 -0700, zigzagdna wrote:
> > Another strange thing I noticed:
> > 1. When doing export backup, export backup reports about corrupted
> > blocks.
>
> Export is not a backup.
>
> > 2. When I do expdp no errors are reported. So question is why is exp
> > command checking empty blocks?
>
> Because it's doing full table scans. Full table scan stops at HWM, not
> before. Also, exp utility is deprecated in 11.2. Do not use it.
>
> --http://mgogala.byethost5.com

exp has been deprecatd in 11g; but expdp is way too slow in 11.1.0.7. I have not used it in 11.2 so not sure slowness problems got fixed. It takes me 3 hours to do a ful export; but 10 hours to do expdp. Most of time expdp seems to be waiting doing data dictionary backup or so. Severl people have reported slowness problem. expdp has lots of nice features but its slowness as well as some bugs at least in 11.1 make me not use it in production. Received on Thu Aug 05 2010 - 12:03:51 CDT