Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Bobby DurrettFeb 23 2021

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

This post has been answered by Bobby Durrett on Mar 3 2021
Jump to Answer

Comments

Bobby Durrett Mar 3 2021 — edited on Mar 3 2021
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

Marked as Answer by Bobby Durrett · Mar 3 2021
1 - 1

Post Details

Added on Feb 23 2021
1 comment
437 views