当前位置:Gxlcms > 数据库问题 > 学习笔记:Oracle 12C 数据非常规恢复工具bbed的使用说明

学习笔记:Oracle 12C 数据非常规恢复工具bbed的使用说明

时间:2021-07-01 10:21:17 帮助过:1人阅读

ORACLE 12C 依然支持 bbed,ORACLE 12C的测试版出来了,对于习惯了使用bbed(ORACLE 手术刀)的人来说,12C是否继续被支持是一个很让人关注的问题,通过本实验测试,12C继续支持bbed,很多艰难的数据库恢复依然可以通过bbed来实现,也从侧面说明,ORACLE 12C在块的结构上还依然和以往版本相似

数据库信息

  1. [oracle@oracleplus ~]$ sqlplus / as sysdba
  2. SQL*Plus: Release 12.1.0.0.2 Beta on Thu Dec 13 09:55:35 2012
  3. Copyright (c) 1982, 2012, Oracle. All rights reserved.
  4. Connected to:
  5. Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit
  6. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  7. SQL> select name from v$datafile where rownum=1;
  8. NAME
  9. --------------------------------------------------------------------------------
  10. /u01/app/oracle/oradata/oracleplus/system01.dbf
  11. SQL> select * from v$version;
  12. BANNER CON_ID
  13. -------------------------------------------------------------------------------- ----------
  14. Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit 0
  15. PL/SQL Release 12.1.0.0.2 0
  16. CORE 12.1.0.0.2 0
  17. TNS for Linux: Version 12.1.0.0.2 0
  18. NLSRTL Version 12.1.0.0.2 0
  19. SQL> exit
  20. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit
  21. With the Partitioning, OLAP, Data Mining and Real Application Testing options

1.Oracle 12C中编译bbed

  1. [oracle@oracleplus bbed_64]$ ls -l
  2. total 32
  3. -rw-r--r-- 1 oracle oinstall 8704 Apr 20 2010 bbedus.msb
  4. -rw-r--r-- 1 oracle oinstall 10270 Jul 25 2000 bbedus.msg
  5. -rw-r--r-- 1 oracle oinstall 3976 Apr 20 2010 sbbdpt.o
  6. -rw-r--r-- 1 oracle oinstall 3306 Apr 20 2010 ssbbded.o
  7. [oracle@oracleplus ~]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/lib
  8. [oracle@oracleplus lib]$ cp ~/bbed_64/s* ./
  9. [oracle@oracleplus lib]$ cd ../
  10. [oracle@oracleplus rdbms]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/mesg
  11. [oracle@oracleplus mesg]$ cp ~/bbed_64/bbedus.ms* ./
  12. [oracle@oracleplus ~]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/lib
  13. [oracle@oracleplus lib]$ make -f ins_rdbms.mk /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
  14. Linking BBED utility (bbed)
  15. rm -f /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
  16. /u01/app/oracle/product/12.1/db_1/bin/orald -o /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
  17. …………
  18. /u01/app/oracle/product/12.1/db_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/12.1/db_1/lib
  19. [oracle@oracleplus lib]$ mv bbed /u01/app/oracle/product/12.1/db_1/bin/

2.测试12C中bbed

  1. [oracle@oracleplus ~]$ bbed
  2. Password:
  3. BBED: Release 2.0.0.0.0 - Limited Production on Thu Dec 13 09:58:16 2012
  4. Copyright (c) 1982, 2012, Oracle and/or its affiliates. All rights reserved.
  5. ************* !!! For Oracle Internal Use only !!! ***************
  6. BBED> set filename ‘/u01/app/oracle/oradata/oracleplus/system01.dbf‘
  7. FILENAME /u01/app/oracle/oradata/oracleplus/system01.dbf
  8. BBED> show
  9. FILE# 0
  10. BLOCK# 1
  11. OFFSET 0
  12. DBA 0x00000000 (0 0,1)
  13. FILENAME /u01/app/oracle/oradata/oracleplus/system01.dbf
  14. BIFILE bifile.bbd
  15. LISTFILE
  16. BLOCKSIZE 8192
  17. MODE Browse
  18. EDIT Unrecoverable
  19. IBASE Dec
  20. OBASE Dec
  21. WIDTH 80
  22. COUNT 512
  23. LOGFILE log.bbd
  24. SPOOL No
  25. BBED> map
  26. File: /u01/app/oracle/oradata/oracleplus/system01.dbf (0)
  27. Block: 1 Dba:0x00000000
  28. ------------------------------------------------------------
  29. Data File Header
  30. struct kcvfh, 1112 bytes @0
  31. ub4 tailchk @8188
  32. BBED> p kcvfhbfh
  33. struct kcvfhbfh, 20 bytes @0
  34. ub1 type_kcbh @0 0x0b
  35. ub1 frmt_kcbh @1 0xa2
  36. ub1 spare1_kcbh @2 0x00
  37. ub1 spare2_kcbh @3 0x00
  38. ub4 rdba_kcbh @4 0x00400001
  39. ub4 bas_kcbh @8 0x00000000
  40. ub2 wrp_kcbh @12 0x0000
  41. ub1 seq_kcbh @14 0x01
  42. ub1 flg_kcbh @15 0x04 (KCBHFCKV)
  43. ub2 chkval_kcbh @16 0x21a8
  44. ub2 spare3_kcbh @18 0x0000
  45. BBED> set block 1233
  46. BLOCK# 1233
  47. BBED> map
  48. File: /u01/app/oracle/oradata/oracleplus/system01.dbf (0)
  49. Block: 1233 Dba:0x00000000
  50. ------------------------------------------------------------
  51. KTB Data Block (Index Leaf)
  52. struct kcbh, 20 bytes @0
  53. struct ktbbh, 72 bytes @20
  54. struct kdxle, 32 bytes @92
  55. sb2 kd_off[517] @124
  56. ub1 freespace[302] @1158
  57. ub1 rowdata[6660] @1460
  58. ub4 tailchk @8188

 

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之学习笔记:Oracle 12C 数据非常规恢复工具bbed的使用说明

原文唯一网址:http://www.oracleplus.net/arch/oracle-20160617-416.html

Oracle研究中心

关键词:

Oracle 12C

 

 

数据库12C数据非常规恢复工具bbed的使用说明

学习笔记:Oracle 12C 数据非常规恢复工具bbed的使用说明

标签:

人气教程排行