|
|
[root@db ~]# su - oracle
[oracle@db ~]$ bbed
-bash: bbed: command not found
[oracle@db ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@db lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
[oracle@db lib]$ cp bbed $ORACLE_HOME/bin
[oracle@db lib]$ bbed
Password: blockedit
BBED-00113: Invalid password. Please rerun utility with the correct password.
[oracle@db lib]$ bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Tue Apr 8 08:17:46 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
JULIEN@PROD> create table test as select object_id ,object_name from dba_objects where rownum <10;
Table created.
JULIEN@PROD> select rowid,
2 dbms_rowid.rowid_relative_fno(rowid) rel_fno,
3 dbms_rowid.rowid_block_number(rowid) block from julien.test;
ROWID REL_FNO BLOCK
------------------ ---------- ----------
AAAMWrAAHAAACATAAA 7 8211
AAAMWrAAHAAACATAAB 7 8211
AAAMWrAAHAAACATAAC 7 8211
AAAMWrAAHAAACATAAD 7 8211
AAAMWrAAHAAACATAAE 7 8211
AAAMWrAAHAAACATAAF 7 8211
AAAMWrAAHAAACATAAG 7 8211
AAAMWrAAHAAACATAAH 7 8211
AAAMWrAAHAAACATAAI 7 8211
9 rows selected.
[oracle@db ~]$ dbv file=/u01/app/oracle/oradata/PROD/Disk6/users01.dbf
DBVERIFY: Release 10.2.0.1.0 - Production on Tue Apr 8 08:08:01 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/PROD/Disk6/users01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 9728
Total Pages Processed (Data) : 106
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 72
Total Pages Failing (Index): 0
Total Pages Processed (Other): 188
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 9362
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 984343 (0.984343)
[oracle@db lib]$ more par.bbd
blocksize=8192
listfile=file.list
mode=edit
[oracle@db lib]$ more file.list
7 /u01/app/oracle/oradata/PROD/Disk6/users01.dbf 79691776
[oracle@db lib]$ bbed parfile=par.bbd
Password:
BBED-00113: Invalid password. Please rerun utility with the correct password.
[oracle@db lib]$ bbed parfile=par.bbd
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Tue Apr 8 09:13:27 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> set block 171
BLOCK# 171
BBED> set block 8211
BLOCK# 8211
BBED> p kcbh
struct kcbh, 20 bytes @0
ub1 type_kcbh @0 0x06
ub1 frmt_kcbh @1 0xa2
ub1 spare1_kcbh @2 0x00
ub1 spare2_kcbh @3 0x00
ub4 rdba_kcbh @4 0x01c02013
ub4 bas_kcbh @8 0x000f0513
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0x02
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0xb47d
ub2 spare3_kcbh @18 0x0000
[oracle@db lib]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 8 09:16:23 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (DBID=254769982)
RMAN> blockrecover datafile 7 block 8211 clear;
Starting blockrecover at 2014-04-08 09:16:41
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=294 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=289 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of blockrecover command at 04/08/2014 09:16:43
ORA-00600: internal error code, arguments: [krbrbmrs_clear_open], [], [], [], [], [], [], []
我按如上步骤模拟数据库坏块，请问报哪上错误是什么原因导致的了呢？
|
|
发表于 2014-4-12 20:06:35
发表于 2014-4-17 21:09:57
