Home » RDBMS Server » Backup & Recovery » Datafile recovery not repairing corrupted block (oracle 11g, OS-Linux)
| Datafile recovery not repairing corrupted block [message #460507] |
Fri, 11 June 2010 09:57  |
nadvi
Messages: 46
Registered: May 2006
Location: Canada
|
Member |
|
|
Hi,
Two of the datafiles are experiencing data block corruption and recovery of the files not repairing the block corruption.
sql 'alter database datafile 2, 8 offline';
restore datafile 2, 8;
recover datafile 2, 8;
sql 'alter database datafile 2, 8 online';
The media recovery finishes succesfully with no warnings.
But, after recovery when I try :
validate check logical datafile 8,2;
it shows again the block corruptions. I've tried recovery several times, and the same appears when I query V$database_block_corruption.
I also tried the same with and the result is still the same.
I tried RMAN incremental and full after this and both of them failed
ORA-00600: internal error code, arguments: [17114], [0x2B58288E0BB8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x2B58288E0BB8], [], [], [], [], [], []
It seems the datafiles are not recovered and the block corruption exists after restore and recovery.
One of these datafile is from sysaux. and the DB version is 11g standard edition.
BANNER
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
Thanks
[Updated on: Fri, 11 June 2010 09:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Datafile recovery not repairing corrupted block [message #460526 is a reply to message #460525] |
Fri, 11 June 2010 11:24  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
run dbv against "corrupt" file as shown below
bcm@bcm-laptop:~$ dbv USERID=dbadmin/admindb file='/u01/app/oracle/oradata/v112/sysaux01.dbf'
DBVERIFY: Release 11.2.0.1.0 - Production on Fri Jun 11 09:23:25 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/v112/sysaux01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 128000
Total Pages Processed (Data) : 34636
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 39996
Total Pages Failing (Index): 0
Total Pages Processed (Lob) : 9558
Total Pages Failing (Lob) : 0
Total Pages Processed (Other): 16206
Total Pages Processed (Seg) : 4181
Total Pages Failing (Seg) : 0
Total Pages Empty : 23423
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 7286348 (0.7286348)
bcm@bcm-laptop:~$ dbv -help
DBVERIFY: Release 11.2.0.1.0 - Production on Fri Jun 11 09:23:55 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Keyword Description (Default)
----------------------------------------------------
FILE File to Verify (NONE)
START Start Block (First Block of File)
END End Block (Last Block of File)
BLOCKSIZE Logical Block Size (8192)
LOGFILE Output Log (NONE)
FEEDBACK Display Progress (0)
PARFILE Parameter File (NONE)
USERID Username/Password (NONE)
SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN Highest Block SCN To Verify (NONE)
(scn_wrap.scn_base OR scn)
a couple of points
1) DBV can identify the specific bad blocks within the datafile.
2) if you have the block number of a bad block you can determine which object, if any, uses that block
3) After knowing the object name, owner & type, in some cases that single object can be reconstructed manually.
4) AFAIK with V11 the SYSAUX tablespace is integral to the DBs operation.
5) do not believe you can remove all objects from it, drop it, & then rebuild SYSAUX
[Updated on: Fri, 11 June 2010 12:25] Report message to a moderator |
|
|
|
| Re: Datafile recovery not repairing corrupted block [message #460529 is a reply to message #460526] |
Fri, 11 June 2010 12:35 |
nadvi
Messages: 46
Registered: May 2006
Location: Canada
|
Member |
|
|
Block Checking: DBA = 8429678, Block Type = KTB-managed data block
**** row 0: row length 8031 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 41070 failed with check code 6401
Block Checking: DBA = 8429679, Block Type = KTB-managed data block
**** row 0: row length 32 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 41071 failed with check code 6401
Block Checking: DBA = 8429680, Block Type = KTB-managed data block
**** row 0: row length 32 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 41072 failed with check code 6401
Block Checking: DBA = 8434585, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 45977 failed with check code 6401
Block Checking: DBA = 8434972, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46364 failed with check code 6401
Block Checking: DBA = 8435409, Block Type = KTB-managed data block
**** row 0: row length 22 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46801 failed with check code 6401
Block Checking: DBA = 8435410, Block Type = KTB-managed data block
**** row 0: row length 34 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46802 failed with check code 6401
Block Checking: DBA = 8435411, Block Type = KTB-managed data block
**** row 0: row length 8790 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46803 failed with check code 6401
Block Checking: DBA = 8435412, Block Type = KTB-managed data block
**** row 0: row length 654 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46804 failed with check code 6401
Block Checking: DBA = 8435415, Block Type = KTB-managed data block
**** row 0: row length 4808 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46807 failed with check code 6401
Block Checking: DBA = 8435416, Block Type = KTB-managed data block
**** row 0: row length 601 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 46808 failed with check code 6401
Block Checking: DBA = 8435871, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47263 failed with check code 6401
Block Checking: DBA = 8435917, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47309 failed with check code 6401
Block Checking: DBA = 8435919, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47311 failed with check code 6401
Block Checking: DBA = 8435943, Block Type = KTB-managed data block
**** row 0: row length 26 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47335 failed with check code 6401
Block Checking: DBA = 8435945, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47337 failed with check code 6401
Block Checking: DBA = 8435959, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47351 failed with check code 6401
Block Checking: DBA = 8435962, Block Type = KTB-managed data block
**** row 0: row length 1606 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47354 failed with check code 6401
Block Checking: DBA = 8435963, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47355 failed with check code 6401
Block Checking: DBA = 8435969, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47361 failed with check code 6401
Block Checking: DBA = 8435970, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47362 failed with check code 6401
Block Checking: DBA = 8435971, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47363 failed with check code 6401
Block Checking: DBA = 8435975, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47367 failed with check code 6401
Block Checking: DBA = 8436554, Block Type = KTB-managed data block
**** row 0: row length 658 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47946 failed with check code 6401
Block Checking: DBA = 8436566, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47958 failed with check code 6401
Block Checking: DBA = 8436576, Block Type = KTB-managed data block
**** row 0: row length 481 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47968 failed with check code 6401
Block Checking: DBA = 8436597, Block Type = KTB-managed data block
**** row 0: row length 732 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 47989 failed with check code 6401
Block Checking: DBA = 8436613, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48005 failed with check code 6401
Block Checking: DBA = 8436616, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48008 failed with check code 6401
Block Checking: DBA = 8436625, Block Type = KTB-managed data block
**** row 0: row length 391 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48017 failed with check code 6401
Block Checking: DBA = 8436629, Block Type = KTB-managed data block
**** row 0: row length 66 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48021 failed with check code 6401
Block Checking: DBA = 8436633, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48025 failed with check code 6401
Block Checking: DBA = 8436636, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48028 failed with check code 6401
Block Checking: DBA = 8436640, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48032 failed with check code 6401
Block Checking: DBA = 8436644, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48036 failed with check code 6401
Block Checking: DBA = 8436648, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48040 failed with check code 6401
Block Checking: DBA = 8436655, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48047 failed with check code 6401
Block Checking: DBA = 8436656, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48048 failed with check code 6401
Block Checking: DBA = 8436660, Block Type = KTB-managed data block
**** row 0: row length 390 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48052 failed with check code 6401
Block Checking: DBA = 8436664, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48056 failed with check code 6401
Block Checking: DBA = 8436675, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48067 failed with check code 6401
Block Checking: DBA = 8436676, Block Type = KTB-managed data block
**** row 0: row length 811 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48068 failed with check code 6401
Block Checking: DBA = 8436680, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48072 failed with check code 6401
Block Checking: DBA = 8436682, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48074 failed with check code 6401
Block Checking: DBA = 8436683, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48075 failed with check code 6401
Block Checking: DBA = 8436684, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48076 failed with check code 6401
Block Checking: DBA = 8436686, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48078 failed with check code 6401
Block Checking: DBA = 8436687, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48079 failed with check code 6401
Block Checking: DBA = 8436691, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48083 failed with check code 6401
Block Checking: DBA = 8436693, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48085 failed with check code 6401
Block Checking: DBA = 8436695, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48087 failed with check code 6401
Block Checking: DBA = 8436701, Block Type = KTB-managed data block
**** row 0: row length 736 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48093 failed with check code 6401
Block Checking: DBA = 8436702, Block Type = KTB-managed data block
**** row 0: row length 368 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48094 failed with check code 6401
Block Checking: DBA = 8436705, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48097 failed with check code 6401
Block Checking: DBA = 8436706, Block Type = KTB-managed data block
**** row 0: row length 66 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48098 failed with check code 6401
Block Checking: DBA = 8436707, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48099 failed with check code 6401
Block Checking: DBA = 8436708, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48100 failed with check code 6401
Block Checking: DBA = 8436709, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48101 failed with check code 6401
Block Checking: DBA = 8436711, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48103 failed with check code 6401
Block Checking: DBA = 8436712, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48104 failed with check code 6401
Block Checking: DBA = 8436713, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48105 failed with check code 6401
Block Checking: DBA = 8436715, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48107 failed with check code 6401
Block Checking: DBA = 8436716, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48108 failed with check code 6401
Block Checking: DBA = 8436717, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48109 failed with check code 6401
Block Checking: DBA = 8436719, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48111 failed with check code 6401
Block Checking: DBA = 8436725, Block Type = KTB-managed data block
**** row 0: row length 95 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48117 failed with check code 6401
Block Checking: DBA = 8436727, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48119 failed with check code 6401
Block Checking: DBA = 8436729, Block Type = KTB-managed data block
**** row 0: row length 520 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48121 failed with check code 6401
Block Checking: DBA = 8436733, Block Type = KTB-managed data block
**** row 0: row length 66 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48125 failed with check code 6401
Block Checking: DBA = 8436737, Block Type = KTB-managed data block
**** row 0: row length 12 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48129 failed with check code 6401
Block Checking: DBA = 8436741, Block Type = KTB-managed data block
**** row 0: row length 605 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 48133 failed with check code 6401
Block Checking: DBA = 8476061, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 87453 failed with check code 6401
Block Checking: DBA = 8476062, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 87454 failed with check code 6401
Block Checking: DBA = 8476064, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 87456 failed with check code 6401
Block Checking: DBA = 8476421, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 87813 failed with check code 6401
Block Checking: DBA = 8476422, Block Type = KTB-managed data block
**** row 0: row length 632 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 87814 failed with check code 6401
Block Checking: DBA = 8476926, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 88318 failed with check code 6401
Block Checking: DBA = 8477109, Block Type = KTB-managed data block
**** row 0: row length 19 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 88501 failed with check code 6401
Block Checking: DBA = 8477111, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 88503 failed with check code 6401
Block Checking: DBA = 8489060, Block Type = KTB-managed data block
**** row 0: row length 21 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 100452 failed with check code 6401
Block Checking: DBA = 8489061, Block Type = KTB-managed data block
**** row 0: row length 7924 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 100453 failed with check code 6401
Block Checking: DBA = 8489062, Block Type = KTB-managed data block
**** row 0: row length 4182 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 100454 failed with check code 6401
Block Checking: DBA = 8489063, Block Type = KTB-managed data block
**** row 0: row length 34 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 100455 failed with check code 6401
Block Checking: DBA = 8489064, Block Type = KTB-managed data block
**** row 0: row length 196 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 100456 failed with check code 6401
Block Checking: DBA = 8495743, Block Type = KTB-managed data block
**** row 0: row length 14 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 107135 failed with check code 6401
Block Checking: DBA = 8496689, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108081 failed with check code 6401
Block Checking: DBA = 8496690, Block Type = KTB-managed data block
**** row 0: row length 28 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108082 failed with check code 6401
Block Checking: DBA = 8496691, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108083 failed with check code 6401
Block Checking: DBA = 8496692, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108084 failed with check code 6401
Block Checking: DBA = 8496693, Block Type = KTB-managed data block
**** row 0: row length 29 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108085 failed with check code 6401
Block Checking: DBA = 8496694, Block Type = KTB-managed data block
**** row 0: row length 41 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108086 failed with check code 6401
Block Checking: DBA = 8496695, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108087 failed with check code 6401
Block Checking: DBA = 8496696, Block Type = KTB-managed data block
**** row 0: row length 29 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 108088 failed with check code 6401
Block Checking: DBA = 8512092, Block Type = KTB-managed data block
**** row 0: row length 29 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 123484 failed with check code 6401
Block Checking: DBA = 8512093, Block Type = KTB-managed data block
**** row 0: row length 34 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 123485 failed with check code 6401
Block Checking: DBA = 8512094, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 123486 failed with check code 6401
Block Checking: DBA = 8512095, Block Type = KTB-managed data block
**** row 0: row length 8565 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 123487 failed with check code 6401
Block Checking: DBA = 8512096, Block Type = KTB-managed data block
**** row 0: row length 41 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 123488 failed with check code 6401
Block Checking: DBA = 8518146, Block Type = KTB-managed data block
**** row 0: row length 29 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129538 failed with check code 6401
Block Checking: DBA = 8518147, Block Type = KTB-managed data block
**** row 0: row length 41 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129539 failed with check code 6401
Block Checking: DBA = 8518148, Block Type = KTB-managed data block
**** row 0: row length 28 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129540 failed with check code 6401
Block Checking: DBA = 8518149, Block Type = KTB-managed data block
**** row 0: row length 41 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129541 failed with check code 6401
Block Checking: DBA = 8518150, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129542 failed with check code 6401
Block Checking: DBA = 8518151, Block Type = KTB-managed data block
**** row 0: row length 39 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129543 failed with check code 6401
Block Checking: DBA = 8518152, Block Type = KTB-managed data block
**** row 0: row length 29 past end of block
**** row 0: row skipped so other stats may be wrong
---- end index block validation
Page 129544 failed with check code 6401
DBVERIFY - Verification complete
Total Pages Examined : 256000
Total Pages Processed (Data) : 57850
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 68218
Total Pages Failing (Index): 105
Total Pages Processed (Lob) : 2864
Total Pages Failing (Lob) : 0
Total Pages Processed (Other): 100967
Total Pages Processed (Seg) : 5865
Total Pages Failing (Seg) : 0
Total Pages Empty : 20236
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 2181152757 (2.2181152757)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Nov 21 21:06:49 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
