Re: Datafile Size
Date: Tue, 10 Feb 2009 12:18:07 -0800
Message-ID: <bf46380902101218n2370e52am3cb2c6d24b54281f_at_mail.gmail.com>
Was dbv run while the file was online?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Tue, Feb 10, 2009 at 9:16 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
> dbv output
>
> Page 191980 is marked corrupt
> Corrupt block relative dba: 0x00c2edec (file 3, block 191980)
> Completely zero block found during dbv:
> Page 191981 is marked corrupt
> Corrupt block relative dba: 0x00c2eded (file 3, block 191981)
> ...
> Page 192000 is marked corrupt
> Corrupt block relative dba: 0x00c2ee00 (file 3, block 192000)
> Completely zero block found during dbv:
>
> DBVERIFY - Verification complete
> Total Pages Examined : 192000
> Total Pages Processed (Data) : 13253
> Total Pages Failing (Data) : 0
> Total Pages Processed (Index): 20673
> Total Pages Failing (Index): 0
> Total Pages Processed (Other): 2606
> Total Pages Processed (Seg) : 0
> Total Pages Failing (Seg) : 0
> Total Pages Empty : 69675
> Total Pages Marked Corrupt : 85793
> Total Pages Influx : 0
> Highest block SCN : 968309588 (1263.968309588)
>
> On Tue, Feb 10, 2009 at 10:20 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com> wrote:
>
>> dbv might also be worthwhile running on it it seems to me.
>>
>> On Tue, Feb 10, 2009 at 3:40 PM, Jared Still <jkstill_at_gmail.com> wrote:
>>
>>> On Tue, Feb 10, 2009 at 6:45 AM, Tim Gorman <tim_at_evdbt.com> wrote:
>>>
>>>> By the way, what about my guess? Were the datafiles in this database
>>>> created atop datafiles from a previous database using the REUSE clause
>>>> during the CREATE DATABASE command? Inquiring minds want to know....
>>>>
>>>
>>>
>>> In addition, have you tried resizing the file from Oracle?
>>>
>>> Jared Still
>>> Certifiable Oracle DBA and Part Time Perl Evangelist
>>>
>>>
>>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 10 2009 - 14:18:07 CST