ORACLE 12C 依然支持 bbed-cuug博客
ORACLE 12C的测试版出来了,对于习惯了使用bbed(ORACLE 手术刀)的人来说,12C是否继续被支持是一个很让人关注的问题,通过本实验测试,12C继续支持bbed,很多艰难的数据库恢复依然可以通过bbed来实现,也从侧面说明,ORACLE 12C在块的结构上还依然和以往版本相似。本文由cuug发布。数据库信息
$ sqlplus / assysdbaSQL*Plus:>onThu Dec13 09:55:35 2012Copyright (c) 1982, 2012, Oracle.Allrights reserved.Connected to:Oracle Database12c Enterprise Edition>Withthe Partitioning, OLAP, Data Mining andRealApplication Testing optionsSQL> selectnamefromv$datafile whererownum=1;NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/xifenfei/system01.dbfSQL> select* fromv$version;BANNER CON_ID-------------------------------------------------------------------------------- ----------Oracle Database12c Enterprise Edition>PL/SQL>CORE 12.1.0.0.2 Beta 0TNS forLinux: Version 12.1.0.0.2 - Beta 0NLSRTL Version 12.1.0.0.2 - Beta 0SQL> exitDisconnected fromOracle Database12c Enterprise Edition>Withthe Partitioning, OLAP, Data Mining andRealApplication Testing options 12C中编译bbed
$ ls-ltotal 32-rw-r--r-- 1 oracle oinstall8704 Apr 202010 bbedus.msb-rw-r--r-- 1 oracle oinstall 10270 Jul 252000 bbedus.msg-rw-r--r-- 1 oracle oinstall3976 Apr 202010 sbbdpt.o-rw-r--r-- 1 oracle oinstall3306 Apr 202010 ssbbded.o$ cd/u01/app/oracle/product/12.1/db_1/rdbms/lib$ cp~/bbed_64/s* ./$ cd../$ cd/u01/app/oracle/product/12.1/db_1/rdbms/mesg$ cp~/bbed_64/bbedus.ms* ./$ cd/u01/app/oracle/product/12.1/db_1/rdbms/lib$ make-f ins_rdbms.mk /u01/app/oracle/product/12.1/db_1/rdbms/lib/bbedLinking 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$ mvbbed /u01/app/oracle/product/12.1/db_1/bin/ 测试12C中bbed
$ bbedPassword: BBED:>Copyright (c) 1982, 2012, Oracle and/orits affiliates.All rights reserved.************* !!! For Oracle Internal Use only !!! ***************BBED> setfilename '/u01/app/oracle/oradata/xifenfei/system01.dbf'FILENAME /u01/app/oracle/oradata/xifenfei/system01.dbfBBED> showFILE# 0BLOCK# 1OFFSET 0DBA 0x00000000 (0 0,1)FILENAME /u01/app/oracle/oradata/xifenfei/system01.dbfBIFILE bifile.bbdLISTFILE BLOCKSIZE 8192MODE BrowseEDIT UnrecoverableIBASE DecOBASE DecWIDTH 80COUNT 512LOGFILE log.bbdSPOOL NoBBED> mapFile: /u01/app/oracle/oradata/xifenfei/system01.dbf (0)Block: 1 Dba:0x00000000------------------------------------------------------------Data File Headerstruct kcvfh, 1112 bytes @0 ub4 tailchk @8188 BBED> p kcvfhbfhstruct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0bub1 frmt_kcbh @1 0xa2ub1 spare1_kcbh @2 0x00ub1 spare2_kcbh @3 0x00ub4 rdba_kcbh @4 0x00400001ub4 bas_kcbh @8 0x00000000ub2 wrp_kcbh @12 0x0000ub1 seq_kcbh @14 0x01ub1 flg_kcbh @15 0x04 (KCBHFCKV)ub2 chkval_kcbh @16 0x21a8ub2 spare3_kcbh @18 0x0000BBED> setblock 1233BLOCK# 1233BBED> mapFile: /u01/app/oracle/oradata/xifenfei/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 @124 ub1 freespace @1158 ub1 rowdata @1460 ub4 tailchk @8188
页:
[1]