Chinaunix首页 | 论坛 | 博客

吕途的ChinaUnix博客

首页　| 　博文目录　| 　关于我

lvchangxin1987

  • 博客访问： 96785
  • 博文数量： 20
  • 博客积分： 0
  • 博客等级： 民兵
  • 技术积分： 202
  • 用 户 组： 普通用户
  • 注册时间： 2013-09-07 01:56
个人简介

数据库技术爱好者

文章分类

全部博文（20）

文章存档

2016年（11）

2015年（9）

我的朋友
最近访客
推荐博文
相关博文
Oracle BBED工具的使用

分类： Oracle

2016-10-23 22:12:07

1.prepare

点击(此处)折叠或打开

  1. [oracle@master ~]$ cat par.txt
  2. blocksize=8192
  3. listfile=filelist.txt
  4. mode=edit
  5. [oracle@master ~]$ cat filelist.txt
  6. 1 /u01/oracle/oradata/edus/system01.dbf 1121976320
  7. 2 /u01/oracle/oradata/edus/sysaux01.dbf 1698693120
  8. 3 /u01/oracle/oradata/edus/undotbs01.dbf 1048576000
  9. 4 /u01/oracle/oradata/edus/users01.dbf 5242880
  10. 5 /u01/oracle/oradata/edus/edus01.dbf 532283392
  11. [oracle@master ~]$ bbed parfile=par.txt
  12. Password:
  14. BBED: Release 2.0.0.0.0 - Limited Production on Sun Oct 23 07:09:40 2016
  16. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
  18. ************* !!! For Oracle Internal Use only !!! ***************

2.利用BBED查看第1号文第520块，bootstrap$段头块内容

点击(此处)折叠或打开

  1. BBED> show all
  2. FILE# 1
  3. BLOCK# 520
  4. OFFSET 20
  5. DBA 0x00400208 (4194824 1,520)
  6. FILENAME /u01/oracle/oradata/edus/system01.dbf
  7. BIFILE bifile.bbd
  8. LISTFILE filelist.txt
  9. BLOCKSIZE 8192
  10. MODE Edit
  11. EDIT Unrecoverable
  12. IBASE Dec
  13. OBASE Dec
  14. WIDTH 80
  15. COUNT 512
  16. LOGFILE log.bbd
  17. SPOOL No
  18. BBED> map /v
  19. File: /u01/oracle/oradata/edus/system01.dbf (1)
  20. Block: 520 Dba:0x00400208
  21. ------------------------------------------------------------
  22. Unlimited Data Segment Header
  24. struct kcbh, 20 bytes @0
  25. ub1 type_kcbh @0
  26. ub1 frmt_kcbh @1
  27. ub1 spare1_kcbh @2
  28. ub1 spare2_kcbh @3
  29. ub4 rdba_kcbh @4
  30. ub4 bas_kcbh @8
  31. ub2 wrp_kcbh @12
  32. ub1 seq_kcbh @14
  33. ub1 flg_kcbh @15
  34. ub2 chkval_kcbh @16
  35. ub2 spare3_kcbh @18
  37. struct ktech, 72 bytes @20
  38. ub4 spare1_ktech @20
  39. sword tsn_ktech @24
  40. ub4 lastmap_ktech @28
  41. ub4 mapcount_ktech @32
  42. ub4 extents_ktech @36
  43. ub4 blocks_ktech @40
  44. ub2 mapend_ktech @44
  45. struct hwmark_ktech, 32 bytes @48
  46. struct locker_ktech, 8 bytes @80
  47. ub4 flag_ktech @88
  49. struct ktemh, 16 bytes @92
  50. ub4 count_ktemh @92
  51. ub4 next_ktemh @96
  52. ub4 obj_ktemh @100
  53. ub4 flag_ktemh @104
  55. struct ktetb[1], 8 bytes @108
  56. ub4 ktetbdba @108
  57. ub4 ktetbnbk @112
  59. struct ktshc, 8 bytes @4148
  60. ub2 ktshcnxf @4148
  61. ub2 ktshcnfl @4150
  62. ub2 ktshcnfb @4152
  63. ub1 ktshctyp @4154
  65. struct ktsfs_seg[1], 20 bytes @4156
  66. ub2 ktsfsflg @4156
  67. struct ktsfsxid, 8 bytes @4160
  68. ub4 ktsfslhd @4168
  69. ub4 ktsfsltl @4172
  71. struct ktsfs_txn[16], 320 bytes @4176
  72. ub2 ktsfsflg @4176
  73. struct ktsfsxid, 8 bytes @4180
  74. ub4 ktsfslhd @4188
  75. ub4 ktsfsltl @4192
  77. ub4 tailchk @8188
  80. BBED> p ktech
  81. struct ktech, 72 bytes @20
  82. ub4 spare1_ktech @20 0x00000000
  83. sword tsn_ktech @24 0
  84. ub4 lastmap_ktech @28 0x00000000
  85. ub4 mapcount_ktech @32 0x00000000
  86. ub4 extents_ktech @36 0x00000001
  87. ub4 blocks_ktech @40 0x00000007
  88. ub2 mapend_ktech @44 0x1020
  89. struct hwmark_ktech, 32 bytes @48
  90. ub4 extno_ktehw @48 0x00000000
  91. ub4 blkno_ktehw @52 0x00000003
  92. ub4 extsize_ktehw @56 0x00000007
  93. ub4 blkaddr_ktehw @60 0x0040020c
  94. ub4 mapblk_ktehw @64 0x00000000
  95. ub4 offset_ktehw @68 0x00000000
  96. ub4 flblks_ktehw @72 0x00000001
  97. ub4 blkcnt_ktehw @76 0x00000003
  98. struct locker_ktech, 8 bytes @80
  99. ub2 kxidusn @80 0x0000
  100. ub2 kxidslt @82 0x0000
  101. ub4 kxidsqn @84 0x00000000
  102. ub4 flag_ktech @88 0x00000000 (NONE)
  106. BBED> set file 1 block 521;
  107. FILE# 1
  108. BLOCK# 521
  110. BBED> map /v
  111. File: /u01/oracle/oradata/edus/system01.dbf (1)
  112. Block: 521 Dba:0x00400209
  113. ------------------------------------------------------------
  114. KTB Data Block (Table/Cluster)
  116. struct kcbh, 20 bytes @0
  117. ub1 type_kcbh @0
  118. ub1 frmt_kcbh @1
  119. ub1 spare1_kcbh @2
  120. ub1 spare2_kcbh @3
  121. ub4 rdba_kcbh @4
  122. ub4 bas_kcbh @8
  123. ub2 wrp_kcbh @12
  124. ub1 seq_kcbh @14
  125. ub1 flg_kcbh @15
  126. ub2 chkval_kcbh @16
  127. ub2 spare3_kcbh @18
  129. struct ktbbh, 48 bytes @20
  130. ub1 ktbbhtyp @20
  131. union ktbbhsid, 4 bytes @24
  132. struct ktbbhcsc, 8 bytes @28
  133. sb2 ktbbhict @36
  134. ub1 ktbbhflg @38
  135. ub1 ktbbhfsl @39
  136. ub4 ktbbhfnx @40
  137. struct ktbbhitl[1], 24 bytes @44
  139. struct kdbh, 14 bytes @68
  140. ub1 kdbhflag @68
  141. sb1 kdbhntab @69
  142. sb2 kdbhnrow @70
  143. sb2 kdbhfrre @72
  144. sb2 kdbhfsbo @74
  145. sb2 kdbhfseo @76
  146. sb2 kdbhavsp @78
  147. sb2 kdbhtosp @80
  149. struct kdbt[1], 4 bytes @82
  150. sb2 kdbtoffs @82
  151. sb2 kdbtnrow @84
  153. sb2 kdbr[24] @86
  155. ub1 freespace[1156] @134
  157. ub1 rowdata[6898] @1290
  159. ub4 tailchk @8188
  162. BBED> p kdbr
  163. sb2 kdbr[0] @86 8099
  164. sb2 kdbr[1] @88 7962
  165. sb2 kdbr[2] @90 7573
  166. sb2 kdbr[3] @92 7373
  167. sb2 kdbr[4] @94 6990
  168. sb2 kdbr[5] @96 6778
  169. sb2 kdbr[6] @98 6573
  170. sb2 kdbr[7] @100 5961
  171. sb2 kdbr[8] @102 5755
  172. sb2 kdbr[9] @104 5555
  173. sb2 kdbr[10] @106 5334
  174. sb2 kdbr[11] @108 5130
  175. sb2 kdbr[12] @110 4847
  176. sb2 kdbr[13] @112 4613
  177. sb2 kdbr[14] @114 4366
  178. sb2 kdbr[15] @116 3896
  179. sb2 kdbr[16] @118 3688
  180. sb2 kdbr[17] @120 3473
  181. sb2 kdbr[18] @122 3193
  182. sb2 kdbr[19] @124 2409
  183. sb2 kdbr[20] @126 2204
  184. sb2 kdbr[21] @128 1630
  185. sb2 kdbr[22] @130 1421
  186. sb2 kdbr[23] @132 1222
  188. BBED> p *kdbr[0]
  189. rowdata[6877]
  190. -------------
  191. ub1 rowdata[6877] @8167 0x2c
  193. BBED> x /rnnccccccccccccccccccccccccccc
  194. rowdata[6877] @8167
  195. -------------
  196. flag@8167: 0x2c (KDRHFL, KDRHFF, KDRHFH)
  197. lock@8168: 0x01
  198. cols@8169: 3
  200. col 0[3] @8170: -1
  201. col 1[3] @8174: -1
  202. col 2[9] @8178: 8.0.0.0.0
  205. BBED> p *kdbr[1]
  206. rowdata[6740]
  207. -------------
  208. ub1 rowdata[6740] @8030 0x2c
  210. BBED> x /rnnccccccccccccccccccccccccccc
  211. rowdata[6740] @8030
  212. -------------
  213. flag@8030: 0x2c (KDRHFL, KDRHFF, KDRHFH)
  214. lock@8031: 0x01
  215. cols@8032: 3
  217. col 0[1] @8033: 0
  218. col 1[1] @8035: 0
  219. col 2[129] @8037: CREATE ROLLBACK SEGMENT SYSTEM STORAGE ( INITIAL 112K
  220. NEXT 56K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 128))

3.例子：直接操作数据块，模拟数据块损坏

点击(此处)折叠或打开

  1. BBED> set file 1 block 520;
  2. FILE# 1
  3. BLOCK# 520
  5. BBED> show all;
  6. FILE# 1
  7. BLOCK# 520
  8. OFFSET 0
  9. DBA 0x00400208 (4194824 1,520)
  10. FILENAME /u01/oracle/oradata/edus/system01.dbf
  11. BIFILE bifile.bbd
  12. LISTFILE filelist.txt
  13. BLOCKSIZE 8192
  14. MODE Edit
  15. EDIT Unrecoverable
  16. IBASE Dec
  17. OBASE Dec
  18. WIDTH 80
  19. COUNT 512
  20. LOGFILE log.bbd
  21. SPOOL No
  23. BBED> copy file 2 block 20 to file 1 block 520;
  24. File: /u01/oracle/oradata/edus/system01.dbf (1)
  25. Block: 520 Offsets: 0 to 511 Dba:0x00400208
  26. ------------------------------------------------------------------------
  27. 1ea20000 14008000 81080000 00000104 8b800000 02000000 80c08300 00000000
  28. 00000000 00f80000 00000000 00000000 00000000 00000000 00000000 00000000
  29. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  30. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  31. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  32. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  33. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  34. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  35. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  36. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  37. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  38. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  39. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  40. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  41. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  42. 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  44. <32 bytes per line>
  46. 关闭数据库后，重新启动数据库，报错了
  47. SQL> shutdown
  48. Database closed.
  49. Database dismounted.
  50. ORACLE instance shut down.
  51. SQL> startup
  52. ORACLE instance started.
  54. Total System Global Area 1043886080 bytes
  55. Fixed Size 2219952 bytes
  56. Variable Size 788529232 bytes
  57. Database Buffers 247463936 bytes
  58. Redo Buffers 5672960 bytes
  59. Database mounted.
  60. ORA-01092: ORACLE instance terminated. Disconnection forced
  61. ORA-00704: bootstrap process failure
  62. ORA-01578: ORACLE data block corrupted (file # 1, block # 520)
  63. ORA-01110: data file 1: '/u01/oracle/oradata/edus/system01.dbf'
  64. Process ID: 5493
  65. Session ID: 1512 Serial number: 5
  67. SQL> shutdown abort
  68. ORA-24324: service handle not initialized
  69. ORA-01041: internal error. hostdef extension doesn't exist
  70. SQL> exit
  71. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  72. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  73. [oracle@master ~]$ sq
  75. SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 23 07:00:45 2016
  77. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  79. Connected to an idle instance.
  81. SQL> alter database mount;
  82. alter database mount
  83. *
  84. ERROR at line 1:
  85. ORA-01034: ORACLE not available
  86. Process ID: 0
  87. Session ID: 0 Serial number: 0
  90. SQL> exit
  91. Disconnected
  92. [oracle@master ~]$ sq
  94. SQL*Plus: Release 11.2.0.1.0 Production on Sun Oct 23 07:00:58 2016
  96. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  98. Connected to an idle instance.
  100. SQL> startup nomount; //之所以重新关闭启，在于RMAN RESTORE DATAFILE 分配CHANNEL报错
  101. ORACLE instance started.
  103. Total System Global Area 1043886080 bytes
  104. Fixed Size 2219952 bytes
  105. Variable Size 788529232 bytes
  106. Database Buffers 247463936 bytes
  107. Redo Buffers 5672960 bytes
  108. SQL> alter database mount;
  110. Database altered.
  112. RMAN恢复
  113. RMAN> restore datafile 1;
  115. Starting restore at 23-OCT-16
  116. released channel: ORA_DISK_1
  117. allocated channel: ORA_DISK_1
  118. channel ORA_DISK_1: SID=10 device type=DISK
  120. channel ORA_DISK_1: starting datafile backup set restore
  121. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  122. channel ORA_DISK_1: restoring datafile 00001 to /u01/oracle/oradata/edus/system01.dbf
  123. channel ORA_DISK_1: reading from backup piece /oraBackup/backupSet/EDUS/backupset/2016_10_23/o1_mf_nnndf_TAG20161023T063316_d0sh0x81_.bkp
  124. channel ORA_DISK_1: piece handle=/oraBackup/backupSet/EDUS/backupset/2016_10_23/o1_mf_nnndf_TAG20161023T063316_d0sh0x81_.bkp tag=TAG20161023T063316
  125. channel ORA_DISK_1: restored backup piece 1
  126. channel ORA_DISK_1: restore complete, elapsed time: 00:03:07
  127. Finished restore at 23-OCT-16
  129. RMAN> recover database;
  131. Starting recover at 23-OCT-16
  132. using channel ORA_DISK_1
  134. starting media recovery
  135. media recovery complete, elapsed time: 00:00:03
  137. Finished recover at 23-OCT-16
  139. 打开数据库：
  141. SQL> alter database open;
  143. Database altered.




阅读(1912) | 评论(0) | 转发(0) |
0

上一篇：promise的机制的使用

下一篇：REDO与UNDO几个实验

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6