Power by


Oracle DBMS UTILITY.MAKE DATA BLOCK ADDRESS

A data block address is the internal structure used to identify a block in the database. This function is useful when accessing certain fixed tables that contain data block addresses.

Can be used for investigate corruption of oracle internal structure for find actual data block address (DBA)

Check oracle segment for actual data block address
SQL> select segment_name,segment_type,header_file,header_block from dba_segments where segment_name like 'USR02' ;

SEGMENT_NAME                   SEGMEN HEADER_FILE HEADER_BLOCK
------------------------------ ------ ----------- ------------
USR02                           TABLE                 195075

SQL> select dbms_utility.make_data_block_address (5,195075) from dual;
dbms_utility.make_data_block_address (5,195075)
--------------------------------------------------------------
                                                                         21166595

## convert 21166595(DEC)=0x0142fa03(HEX)
## rdba: 0x0142fa03 (file 5, block 195075)

AIX error 554 after clone rootvg on difference machine model

** Myself
Boot from CD
  1. Import rootvg and mount filesystems
  2. unmount /dev/cd0
  3. cfgmgr –i /dev/cd0
  4. bosboot –ad hdisk0
  5. savebase
  6. reboot
Loading