共计 3970 个字符，预计需要花费 10 分钟才能阅读完成。
这篇文章主要为大家展示了“Oracle 12C 数据非常规恢复工具 bbed 怎么用”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让丸趣 TV 小编带领大家一起研究并学习一下“Oracle 12C 数据非常规恢复工具 bbed 怎么用”这篇文章吧。
ORACLE 12C 依然支持 bbed，ORACLE 12C 的测试版出来了, 对于习惯了使用 bbed(ORACLE 手术刀) 的人来说,12C 是否继续被支持是一个很让人关注的问题, 通过本实验测试,12C 继续支持 bbed, 很多艰难的数据库恢复依然可以通过 bbed 来实现, 也从侧面说明,ORACLE 12C 在块的结构上还依然和以往版本相似
数据库信息
[oracle@oracleplus ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.0.2 Beta on Thu Dec 13 09:55:35 2012
Copyright (c) 1982, 2012, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL select name from v$datafile where rownum=1;
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/oracleplus/system01.dbf
SQL select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit 0
PL/SQL Release 12.1.0.0.2 0
CORE 12.1.0.0.2 0
TNS for Linux: Version 12.1.0.0.2 0
NLSRTL Version 12.1.0.0.2 0
SQL exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options1.Oracle 12C 中编译 bbed
[oracle@oracleplus bbed_64]$ ls -l
total 32
-rw-r--r-- 1 oracle oinstall 8704 Apr 20 2010 bbedus.msb
-rw-r--r-- 1 oracle oinstall 10270 Jul 25 2000 bbedus.msg
-rw-r--r-- 1 oracle oinstall 3976 Apr 20 2010 sbbdpt.o
-rw-r--r-- 1 oracle oinstall 3306 Apr 20 2010 ssbbded.o
[oracle@oracleplus ~]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/lib
[oracle@oracleplus lib]$ cp ~/bbed_64/s* ./
[oracle@oracleplus lib]$ cd ../
[oracle@oracleplus rdbms]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/mesg
[oracle@oracleplus mesg]$ cp ~/bbed_64/bbedus.ms* ./
[oracle@oracleplus ~]$ cd /u01/app/oracle/product/12.1/db_1/rdbms/lib
[oracle@oracleplus lib]$ make -f ins_rdbms.mk /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
/u01/app/oracle/product/12.1/db_1/bin/orald -o /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbed
/u01/app/oracle/product/12.1/db_1/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/12.1/db_1/lib
[oracle@oracleplus lib]$ mv bbed /u01/app/oracle/product/12.1/db_1/bin/2. 测试 12C 中 bbed
[oracle@oracleplus ~]$ bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Thu Dec 13 09:58:16 2012
Copyright (c) 1982, 2012, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED set filename /u01/app/oracle/oradata/oracleplus/system01.dbf
FILENAME /u01/app/oracle/oradata/oracleplus/system01.dbf
BBED show
FILE# 0
BLOCK# 1
OFFSET 0
DBA 0x00000000 (0 0,1)
FILENAME /u01/app/oracle/oradata/oracleplus/system01.dbf
BIFILE bifile.bbd
LISTFILE
BLOCKSIZE 8192
MODE Browse
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
BBED map
File: /u01/app/oracle/oradata/oracleplus/system01.dbf (0)
Block: 1 Dba:0x00000000
------------------------------------------------------------
Data File Header
struct kcvfh, 1112 bytes @0
ub4 tailchk @8188
BBED p kcvfhbfh
struct kcvfhbfh, 20 bytes @0
ub1 type_kcbh @0 0x0b
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x00400001
ub4 bas_kcbh @8 0x00000000
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0x01
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x21a8
ub2 spare3_kcbh @18 0x0000
BBED set block 1233
BLOCK# 1233
BBED map
File: /u01/app/oracle/oradata/oracleplus/system01.dbf (0)
Block: 1233 Dba:0x00000000
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[517] @124
ub1 freespace[302] @1158
ub1 rowdata[6660] @1460
ub4 tailchk @8188以上是“Oracle 12C 数据非常规恢复工具 bbed 怎么用”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注丸趣 TV 行业资讯频道！
正文完
