Forum Stats

  • 3,724,389 Users
  • 2,244,744 Discussions
  • 7,850,988 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How to convert DBA from DBVERIFY to file and block_id for bigfile

Bobby Durrett
Bobby Durrett Member Posts: 140 Blue Ribbon

This is on 10.2.0.4 on HP-UX. I have DBVERIFY output like this on a bigfile data file:

DBV-00201: Block, DBA 18121156, marked corrupt for invalid redo application

I would like to query DBA_EXTENTS to find out what segment 18121156 is in. I know the file number because I have the datafile name from my dbv command. But how do I get the block_id?

Oracle's support site says that I cannot use dbms_utility.data_block_address_block for bigfiles but I cannot find the alternative.

Can anyone point me in the right direction?

Thanks!

Bobby

Best Answer

  • Bobby Durrett
    Bobby Durrett Member Posts: 140 Blue Ribbon
    edited March 3 Accepted Answer

    It seems that the DBVERIFY (dbv) DBA value for bigfiles is the same as block_id within DBA_EXTENTS.

    So my query would be:

    SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id = 29 and 18121156 between block_id AND block_id + blocks - 1;

    Bobby

Answers

  • Bobby Durrett
    Bobby Durrett Member Posts: 140 Blue Ribbon
    edited March 3 Accepted Answer

    It seems that the DBVERIFY (dbv) DBA value for bigfiles is the same as block_id within DBA_EXTENTS.

    So my query would be:

    SELECT tablespace_name, segment_type, owner, segment_name FROM dba_extents WHERE file_id = 29 and 18121156 between block_id AND block_id + blocks - 1;

    Bobby

Sign In or Register to comment.