Re: Datafile Size

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) Completely zero block found during dbv:
Page 191982 is marked corrupt
Corrupt block relative dba: 0x00c2edee (file 3, block 191982) Completely zero block found during dbv:
Page 191983 is marked corrupt
Corrupt block relative dba: 0x00c2edef (file 3, block 191983) Completely zero block found during dbv:
Page 191984 is marked corrupt
Corrupt block relative dba: 0x00c2edf0 (file 3, block 191984) Completely zero block found during dbv:
Page 191985 is marked corrupt
Corrupt block relative dba: 0x00c2edf1 (file 3, block 191985) Completely zero block found during dbv:
Page 191986 is marked corrupt
Corrupt block relative dba: 0x00c2edf2 (file 3, block 191986) Completely zero block found during dbv:
Page 191987 is marked corrupt
Corrupt block relative dba: 0x00c2edf3 (file 3, block 191987) Completely zero block found during dbv:
Page 191988 is marked corrupt
Corrupt block relative dba: 0x00c2edf4 (file 3, block 191988) Completely zero block found during dbv:
Page 191989 is marked corrupt
Corrupt block relative dba: 0x00c2edf5 (file 3, block 191989) Completely zero block found during dbv:
Page 191990 is marked corrupt
Corrupt block relative dba: 0x00c2edf6 (file 3, block 191990) Completely zero block found during dbv:
Page 191991 is marked corrupt
Corrupt block relative dba: 0x00c2edf7 (file 3, block 191991) Completely zero block found during dbv:
Page 191992 is marked corrupt
Corrupt block relative dba: 0x00c2edf8 (file 3, block 191992) Completely zero block found during dbv:
Page 191993 is marked corrupt
Corrupt block relative dba: 0x00c2edf9 (file 3, block 191993) Completely zero block found during dbv:
Page 191994 is marked corrupt
Corrupt block relative dba: 0x00c2edfa (file 3, block 191994) Completely zero block found during dbv:
Page 191995 is marked corrupt
Corrupt block relative dba: 0x00c2edfb (file 3, block 191995) Completely zero block found during dbv:
Page 191996 is marked corrupt
Corrupt block relative dba: 0x00c2edfc (file 3, block 191996) Completely zero block found during dbv:
Page 191997 is marked corrupt
Corrupt block relative dba: 0x00c2edfd (file 3, block 191997) Completely zero block found during dbv:
Page 191998 is marked corrupt
Corrupt block relative dba: 0x00c2edfe (file 3, block 191998) Completely zero block found during dbv:
Page 191999 is marked corrupt
Corrupt block relative dba: 0x00c2edff (file 3, block 191999) Completely zero block found during dbv:
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-l