Learning Note: Oracle 12C Data Recovery Tool bbed instructions for use

Oracle 12C still supports the beta version of Bbed,oracle 12C, and for those accustomed to using bbed (Oracle scalpel), whether 12C continues to be supported is a matter of great concern, through this experimental test, 12C continues to support bbed, Many difficult database restores can still be achieved through bbed, and also from the side, ORACLE 12C is still similar to the previous version of the block structure

Database Information

[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 12.1.0.0.2 Beta on Thu Dec 09:55:35 2012Copyright (c)  1982, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.0.2-64bit with the partitioning, OLAP, Data Minin G 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 forLinux:version 12.1.0.0.2 0NLSRTL Version 12.1.0.0.2 0sql> exitdisconnected from Oracle Database 12c Enterprise Edition R Elease 12.1.0.0.2-64bit with the partitioning, OLAP, Data Mining and Real application testing options

compiling bbed in 1.Oracle 12C

[[email protected] bbed_64]$ ls-ltotal 32-rw-r--r--1 Oracle oinstall 8704 APR bbedus.msb-rw-r--r--1 ORAC Le oinstall 10270 Jul bbedus.msg-rw-r--r--1 Oracle oinstall 3976 APR sbbdpt.o-rw-r--r--1 Oracle Oinst All 3306 Apr ssbbded.o[[email protected] ~]$ cd/u01/app/oracle/product/12.1/db_1/rdbms/lib[[email  Protected] lib]$ CP ~/bbed_64/s*./[[email protected] lib]$ CD. /[[email protected] rdbms]$ cd/u01/app/oracle/product/12.1/db_1/rdbms/mesg[[email protected] mesg]$ CP ~/ bbed_64/bbedus.ms*./[[email protected] ~]$ cd/u01/app/oracle/product/12.1/db_1/rdbms/lib[[email  Protected] 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/orac, ...Le/product/12.1/db_1/lib[[email protected] lib]$ MV bbed/u01/app/oracle/product/12.1/db_1/bin/ 

2. Test bbed in 12C

[[email protected] ~]$ bbedPassword:BBED:Release 2.0.0.0.0-limited Production on Thu Dec 09:58:16 2012Copyrigh  T (c) 1982, Oracle and/or its affiliates. All Rights reserved.*************!!! For Oracle Internal with only!!! bbed> set filename '/u01/app/oracle/oradata/oracleplus/system01.dbf ' Filename/u01/app/ora          Cle/oradata/oracleplus/system01.dbfbbed> 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 COUNT LOGFILE LOG.BBD SPOOL nobbed> map File:/u01/app/oracle/oradata/oracleplus/syst     EM01.DBF (0) block:1                                dba:0x00000000------------------------------------------------------------Data File Heade R struct KCVFH, 1112 bytes @0 ub4 tailchk @8188 bbed> p KCVF Hbfhstruct kcvfhbfh, 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_KC BH @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, Bytes @0 struct KTBBH, the bytes @20 struct kdxle, bytes                         @92 SB2 kd_off[517] @124 ub1 freespace[302]     @1158 ub1 rowdata[6660] @1460 ub4 tailchk @8188

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

The most authoritative and professional Oracle Case Resource Summary Study NOTE: Instructions for using Oracle 12C Data bbed Recovery Tool

Original URL: http://www.oracleplus.net/arch/oracle-20160617-416.html

Oracle Research Center Key Words:Oracle 12C Database 12C Data Recovery Tool bbed instructions for use

Learning Note: Oracle 12C Data Recovery Tool bbed instructions for use