块损坏修复练习-bbed1.pdf

牛仔宅

402

5页

3次

2021-10-15

10墨值下载

块损坏修复练习-bbed1.txt

1、编辑数据库结构文件

$ more dbfile.lst

5 /home/oracle/oracle/product/10.2.0/oradata/cuug/example01.dbf

4 /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.dbf

3 /home/oracle/oracle/product/10.2.0/oradata/cuug/sysaux01.dbf

2 /home/oracle/oracle/product/10.2.0/oradata/cuug/undotbs01.dbf

1 /home/oracle/oracle/product/10.2.0/oradata/cuug/system01.dbf

9 /home/oracle/oracle/product/10.2.0/oradata/cuug/undotbs02.dbf

7 /home/oracle/oracle/product/10.2.0/oradata/cuug/sp01.dbf

6 /home/oracle/oracle/product/10.2.0/oradata/cuug/users02.dbf

8 /home/oracle/oracle/product/10.2.0/oradata/cuug/new01.dbf

10 /home/oracle/oracle/product/10.2.0/oradata/cuug/rbs01.dbf

11 /home/oracle/oracle/product/10.2.0/oradata/cuug/rbs02.dbf

2、编辑bbed参数文件

$ more par.bbd

blocksize=8192

listfile=filelist.txt

mode=edit

3、登录bbed

$ bbed parfile=par.bbd

4、查询scott用户下emp10的数据块位置

SQL> select FILE_ID,BLOCK_ID,BYTES from dba_extents where owner='SCOTT' and

segment_NAME='EMP10';

FILE_ID BLOCK_ID BYTES

---------- ---------- ----------

6 4769 65536

5、在bbed下查看数据库的信息：

BBED> info

File# Name Size(blks)

----- ---- ----------

1 /home/oracle/oracle/product/10.2.0/oradata/cuug/system01.d 0

2 /home/oracle/oracle/product/10.2.0/oradata/cuug/undotbs01. 0

3 /home/oracle/oracle/product/10.2.0/oradata/cuug/sysaux01.d 0

第 1 页

Tel：010-88589826 Fax：010-88587520 网址: http://www.cuug.com

块损坏修复练习-bbed1.txt

4 /home/oracle/oracle/product/10.2.0/oradata/cuug/users01.db 0

5 /home/oracle/oracle/product/10.2.0/oradata/cuug/example01. 0

6 /home/oracle/oracle/product/10.2.0/oradata/cuug/users02.db 0

7 /home/oracle/oracle/product/10.2.0/oradata/cuug/sp01.dbf 0

8 /home/oracle/oracle/product/10.2.0/oradata/cuug/new01.dbf 0

9 /home/oracle/oracle/product/10.2.0/oradata/cuug/undotbs02. 0

10 /home/oracle/oracle/product/10.2.0/oradata/cuug/rbs01.dbf 0

11 /home/oracle/oracle/product/10.2.0/oradata/cuug/rbs02.dbf 0

6、设置需要破坏的数据块：

BBED> set file 6 block 4769

7、查看该数据块的内容：

BBED> d

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users02.dbf (6)

Block: 4769 Offsets: 0 to 511 Dba:0x018012a1

------------------------------------------------------------------------

20000000 a1128001 00000000 0000ff04 e9c60000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 04000000 ffffffff 00000000 03000000 08000000

8、破坏该数据块：

BBED> m /x 7ccc

File: /home/oracle/oracle/product/10.2.0/oradata/cuug/users02.dbf (6)

Block: 4769 Offsets: 0 to 511 Dba:0x018012a1

------------------------------------------------------------------------

7ccc0000 a1128001 00000000 0000ff04 e9c60000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

00000000 00000000 00000000 04000000 ffffffff 00000000 03000000 08000000

01000100 00000000 00000000 00000000 04000000 03000000 4d863250 4d863250

9、使变化生效：

BBED> sum apply

Check value for File 6, Block 4769:

current = 0xba05, required = 0xba05

10、查看emp10表的数据：

SQL> select * from emp10;

select * from emp10

ERROR at line 1:

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [1], [0],

[5], [], [], [], []

11、回滚操作：

BBED> revert

All changes made in this session will be rolled back. Proceed? (Y/N) y

第 2 页