The use of oracle-BBED

Bbed is a tool used within oracle to view and modify data files directly. It can directly modify the contents of Oracle data file blocks, which is useful in some special recovery scenarios.

Byte order

The CPU Power series corresponding to AIX is called Big end.

Intel's corresponding CPU is called Xiao Duan.

The former rule, in which the least significant byte comes first, is called the small end method (little endian).

The latter rule, in which the most significant byte comes first, is called big endian.

SQL > desc v$database

SQL > select dbid,name from v$database

DBID NAME

--

2826565105 MYDB

SQL >

View machine type

SQL > select d.PLATFORMAN name, v$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME

PLATFORM_NAME

ENDIAN_FORMAT

-

Linux x86 64-bit

Little

A short paragraph is a flashback. We need to convert the f1f579a8 into two.

Parse dbid and dbname through BBED

SQL > select to_number ('a879f5f1') from dual

TO_NUMBER ('A879F5F1', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXX')

-

2826565105

SQL > select chr (to_number (substr ('4d59444200000000)) (substr (' 4d5944420000000)) from dba_objects where rownum