Re: Datafile Size
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Tue, 10 Feb 2009 22:46:16 +0530
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)
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
>> On Tue, Feb 10, 2009 at 6:45 AM, Tim Gorman <tim@xxxxxxxxx> 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
>
Other related posts:
