《非常规恢复使用BBED跳过归档》由会员分享，可在线阅读，更多相关《非常规恢复使用BBED跳过归档（25页珍藏版）》请在金锄头文库上搜索。
1、在线培训尖峰 ORACLE 非非常规恢复使用常规恢复使用BBED跳过归档跳过归档-深入块格式http:/ Me网名GuoyJoe ITPUB论坛认证版版主 Oracle 10g OCM Oracle OCT Senior OraceDBA Email:dbathinkH Blog:http:/ 备份恢复的概述 数据库的恢复机制 Oracle物理存储结构 解密检查点 深入块格式 BBED之恢复神器 使用BBED跳过归档恢复案例3勤奋成就人生http:/ 备份重于一切！ 1、高可用性 DATA GUARD Real Application Clusters Oracle Replication R
2、AID 和镜像驱动器2、备份和恢复收集备份与恢复策略需求 精心设计备份与恢复计划4勤奋成就人生http:/ NOMOUNT Reads the parameter file MOUNT Reads the control files OPEN Data files are opened Crash/thread recovery if needed Dictionary operations Rollback phase started in background5勤奋成就人生http:/ 什么是检查点？ A checkpoint is a point (SCN) in the redo st
3、ream which all blocks that were dirtied at or before that time have been written to disk 。 检查点的组成 SCN - SCN wrap+SCN base (SCN: 0x0000.001de916) RBA - Sequence+block+offsetRBA: 0x00002d.00000016.0010 检查点的发生ckpt 、dbwr 、lgwr8勤奋成就人生http:/ 数据文件头块 (今天的重点)alter session set events immediate trace name file
4、_hdrs level 10; 数据块 （dbms_rowid）alter system dump datafile 3 block 23; UNDO段头块(v$transaction、v$rollname)alter system dump undo header _SYSSMU1$; UNDO数据块(v$transaction)alter system dump undo header _SYSSMU1$; 段头块(dba_segments)alter system dump undo header _SYSSMU1$;9勤奋成就人生http:/ set file 1 block 1 FI
5、LE# 1 BLOCK# 1BBED map File: /u01/app/oracle/oradata/ocp/system01.dbf (1) Block: 1 Dba:0x00400001 - Data File Headerstruct kcvfh, 860 bytes 0 (9i 608 bytes,10g 676bytes)ub4 tailchk8188 10勤奋成就人生http:/ map /v File: /u01/app/oracle/oradata/ocp/system01.dbf (1) Block: 1 Dba:0x00400001 - Data File Header
6、struct kcvfh, 860 bytes 0 struct kcvfhbfh, 20 bytes 0 struct kcvfhhdr, 76 bytes 20 ub4 kcvfhrdb96 struct kcvfhcrs, 8 bytes 100 ub4 kcvfhcrt108 ub4 kcvfhrlc112 struct kcvfhrls, 8 bytes 116 11勤奋成就人生http:/ p kcvfh struct kcvfh, 860 bytes 0 struct kcvfhbfh, 20 bytes 0 ub1 type_kcbh0 0x0b ub1 frmt_kcbh1
7、0xa2 ub1 spare1_kcbh 2 0x00 ub1 spare2_kcbh 3 0x00 ub4 rdba_kcbh4 0x00400001 ub4 bas_kcbh8 0x00000000 ub2 wrp_kcbh12 0x0000 ub1 seq_kcbh14 0x01 ub1 flg_kcbh15 0x04 (KCBHFCKV) ub2 chkval_kcbh16 0x483b ub2 spare3_kcbh 18 0x000012勤奋成就人生http:/ kcvfhckp, 36 bytes 484 （oracle 9i 140） struct kcvcpscn, 8 by
8、tes 484 ub4 kscnbas484 0x00378250 ub2 kscnwrp488 0x0000 ub4 kcvcptim492 0x30dd110a ub2 kcvcpthr496 0x0001 union u, 12 bytes 500 struct kcvcprba, 12 bytes 500 ub4 kcrbaseq500 0x00000007 ub4 kcrbabno504 0x00000002 ub2 kcrbabof508 0x0010 ub1 kcvcpetb0 512 0x02 ub1 kcvcpetb1 513 0x00 省略显示部分内容 ub1 kcvcpe
9、tb6 518 0x00 ub1 kcvcpetb7 519 0x0013勤奋成就人生http:/ BBED全称Block Browser and Editor BBED的安装非常简单 BBED的使用14勤奋成就人生http:/ dump File: /u01/app/oracle/oradata/ocp/system01.dbf (1) Block: 1 Offsets: 0 to 511 Dba:0x00400001 - 0ba20000 01004000 00000000 00000104 3b480000 00000000 0000200b 37a181a1 4f435000 0000
10、0000 5e700100 00fa0000 00200000 01000300 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 08024000 08000000 00000000 bf617a30 402ddb30 62653500 00000000 00000000 00000000 00000000 00000420 cd010000 ee10dd30 cc010000 00000000 00000000 00000000 00000000 0000000
11、0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
