http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 11:42:45 +0000 http://www.forum.askdba.org/topic/easy-conversion-of-datablock-addressdba-to-file-and-block#post-83 Sat, 29 Aug 2009 07:28:16 +0000 Amit Bansal 83@http://www.forum.askdba.org/ <p>I was getting following errors while using Dbverify on a file</p> <pre> &gt;dbv file=dc_users_01.dbf blocksize=8192 DBVERIFY: Release 10.2.0.2.0 - Production on Thu Aug 27 11:09:04 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = dc_users_01.dbf <strong>Block Checking: DBA = 96495368, Block Type = KTB-managed data block data header at 0x10020aa7c</strong> <strong>kdbchk: bad row offset slot 16 offs 58 fseo 1683 dtl 8168 bhs 104 Page 26376 failed with check code 6135</strong> DBVERIFY - Verification complete Total Pages Examined : 256000 Total Pages Processed (Data) : 25740 Total Pages Failing (Data) : 1 Total Pages Processed (Index): 1 Total Pages Failing (Index): 0 Total Pages Processed (Other): 664 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 229595 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 3211169690 (1408.3211169690) </pre> <p>To find file# and block# I used dbms_utility package</p> <pre> select dbms_utility.data_block_address_file(&amp;&amp;rdba) RFN, dbms_utility.data_block_address_block(&amp;&amp;rdba) BL from dual; 2 3 Enter value for rdba: 96495368 old 1: select dbms_utility.data_block_address_file(&amp;&amp;rdba) RFN, new 1: select dbms_utility.data_block_address_file(96495368) RFN, old 2: dbms_utility.data_block_address_block(&amp;&amp;rdba) BL new 2: dbms_utility.data_block_address_block(96495368) BL RFN BL ---------- ---------- 23 26376 </pre> <p>On further analysis , found that the block number 26376 did not contain any object and maximum block used was 25225</p> <pre> SQL&gt; select max(block_id) from dba_extents where file_id=23; MAX(BLOCK_ID) ------------- 25225 select (25225*8192)/1024/1024 from dual; (25225*8192)/1024/1024 ---------------------- 197.070313 SQL&gt; alter database datafile '/lmsdb/lms01/dc_users_axlmsdb_tblspc_01.dbf' resize 200m; Database altered. </pre> <p>Running dbv again, gave a clean output. </p>