양쪽 이전 판
이전 판
다음 판
|
이전 판
|
dbms:oracle:blockdump [2016/06/17 10:41] starlits [Oracke Data Block Layout] |
dbms:oracle:blockdump [2016/06/17 11:00] (현재) starlits |
{{:dbms:oracle:concept:oracle_data_block_layout.gif|}} | {{:dbms:oracle:concept:oracle_data_block_layout.gif|}} |
| |
===== decoding ===== | ===== decoding an Oracle Binary Dump ===== |
- 오라클 binary dump 에서 decoding 한 예제 <code> | - 오라클 binary dump 에서 decoding 한 예제 <code> |
File: /opt/app/oracle/oradata/ORCL2/users01.dbf (4) | |
Block: 32 Offsets: 7864 to 8191 Dba:0x01000020 | |
------------------------------------------------------------------------ | |
53434f54 5407414e 414c5953 5403c24c 430777bb 04130101 0102c21f ff02c115 | |
2c010803 c24e5305 434c4152 4b074d41 4e414745 5203c24f 280777b5 06090101 | |
0103c219 33ff02c1 0b2c0108 03c24d63 05424c41 4b45074d 414e4147 455203c2 | |
4f280777 b5050101 010103c2 1d33ff02 c11f2c01 0803c24d 37064d41 5254494e | |
0853414c 45534d41 4e03c24d 630777b5 091c0101 0103c20d 3302c20f 02c11f2c | |
010803c2 4c43054a 4f4e4553 074d414e 41474552 03c24f28 0777b504 02010101 | |
03c21e4c ff02c115 2c010803 c24c1604 57415244 0853414c 45534d41 4e03c24d | |
630777b5 02160101 0103c20d 3302c206 02c11f2c 010803c2 4b640541 4c4c454e | |
0853414c 45534d41 4e03c24d 630777b5 02140101 0102c211 02c20402 c11f2c01 | |
0803c24a 4605534d 49544805 434c4552 4b03c250 030777b4 0c110101 0102c209 | |
ff02c115 1006dbbf | |
</code> | </code> |
| |
| ===== Decoding Oracle Blocks ===== |
| |
| ===== Oracle Formatted Block Dumps ===== |
| |
| ===== Oracle Data Block Internal ===== |
| {{:dbms:oracle:data:slide53.png|}} |
| |
===== 참고자료 ===== | ===== 참고자료 ===== |
- {{:dbms:oracle:data:oracle_forensics_part_1._dissecting_the_redo_logs.pdf|}} | - {{:dbms:oracle:data:oracle_forensics_part_1._dissecting_the_redo_logs.pdf|}} |
| - {{:dbms:oracle:data:dissassembling_the_data_block.pdf|}} |