Shulou(Shulou.com)05/31 Report--

This article mainly shows you "Oracle 12C data unconventional recovery tool bbed how to use", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "Oracle 12C data unconventional recovery tool bbed how to use" this article.

The beta version of ORACLE 12C still supports bbed,ORACLE 12C. For those who are used to using bbed (ORACLE scalpel), whether 12C will continue to be supported is a matter of concern. Through this experimental test, 12C continues to support bbed, and many difficult database recoveries can still be achieved through bbed. It also shows from the side that the block structure of ORACLE 12C is still similar to that of previous versions.

Database information

[oracle@oracleplus] $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.0.2 Beta on Thu Dec 13 09:55:35 2012Copyright (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 optionsSQL > select name from v$datafile where rownum=1 NAME----/u01/app/oracle/oradata/oracleplus/system01.dbfSQL > select * from v$version BANNER CON_ID -Oracle Database 12c Enterprise Edition Release 12.1.0.0.2-64bit 0PL/SQL Release 12.1.0.0.2 0CORE 12.1.0.0.2 0TNS for Linux: Version 12.1.0.0.2 0NLSRTL Version 12.1.0.0.2 0SQL > exitDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.0.2-64bit With the Partitioning OLAP Compiling bbed [oracle@oracleplus bbed_64] $ls-ltotal 32 in Data Mining and Real Application Testing options1.Oracle 12C RW bbedus.msg-rw-r--r-- [oracle@oracleplus] $cd / u01/app/oracle/product/-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 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/ grid [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/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 [oracle @ oracleplus lib] $mv bbed / u01/app/oracle/product/12.1/db_1/bin/2. Test 12C bbed [oracle@oracleplus] $bbedPassword: BBED: Release 2.0.0.0.0-Limited Production on Thu Dec 13 09:58:16 2012Copyright (c) 1982, 2012, Oracle and/or its affiliates. All rights reserved.*! For Oracle Internal Use only!! * BBED > set filename'/ u01 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 NoBBED > 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 kcvfhbfhstruct 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 0x0000BBED > set block 1233 BLOCK# 1233BBED > 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 @ 124ub1 freespace [302] @ 1158 ub1 rowdata [6660] @ 1460 ub4 tailchk @ 8188 and above are "Oracle 12C data unconventional recovery workers" All the contents of this article with how to use bbed Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.