- 最后登录
- 2012-6-18
- 在线时间
- 17 小时
- 威望
- 82
- 金钱
- 2659
- 注册时间
- 2012-3-4
- 阅读权限
- 50
- 帖子
- 49
- 精华
- 1
- 积分
- 82
- UID
- 275
|
1#
发表于 2012-4-19 16:03:26
|
查看: 6904 |
回复: 4
SQL> select rowid,dbms_rowid.rowid_relative_fno(rowid) rel_fno,
2 dbms_rowid.rowid_block_number(rowid) blockno,
3 dbms_rowid.rowid_row_number(rowid) rowno from dvd;
ROWID REL_FNO BLOCKNO ROWNO
------------------ ---------- ---------- ----------
AAAR9IAAHAAAACDAAA 7 131 0
AAAR9IAAHAAAACDAAB 7 131 1
上面这个是我的表的记录使用的block情况,想用bbed来做block corruption 试验
[oracle@primary_db ~]$ bbed parfile=bbed.par
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Apr 9 02:13:56 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> set dba 7,131
DBA 0x01c00083 (29360259 7,131)
BBED> map
File: /oradata1/daixuej.dbf (7)
Block: 131 Dba:0x01c00083
------------------------------------------------------------
KTB Data Block (Table/Cluster)
struct kcbh, 20 bytes @0
struct ktbbh, 96 bytes @20
struct kdbh, 14 bytes @124
struct kdbt[1], 4 bytes @138
sb2 kdbr[2] @142
ub1 freespace[8005] @146
ub1 rowdata[37] @8151
ub4 tailchk @8188
BBED>
但下一步要BBED> d /v offset 0 count 128 时却不知这个offset和count的值是怎么的来的?
非常感谢老大的帮助 |
|