kwx970125774 发表于 2014-4-12 20:06:35

ORA-00600: internal error code, arguments: [krbrbmrs_clear_open]

# su - oracle
$ bbed
-bash: bbed: command not found
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
$ cp bbed $ORACLE_HOME/bin                        
$ bbed
Password: blockedit
BBED-00113: Invalid password. Please rerun utility with the correct password.

$ 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,
2dbms_rowid.rowid_relative_fno(rowid) rel_fno,
3dbms_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.

$ 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)


$ more par.bbd
blocksize=8192
listfile=file.list
mode=edit
$ more file.list
7 /u01/app/oracle/oradata/PROD/Disk6/users01.dbf 79691776
$ bbed parfile=par.bbd
Password:
BBED-00113: Invalid password. Please rerun utility with the correct password.

$ 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

$ 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: , [], [], [], [], [], [], []

我按如上步骤模拟数据库坏块,请问报哪上错误是什么原因导致的了呢?


xifenfei 发表于 2014-4-17 21:09:57

你的block应该没有问题,很可能是10.2.0.1版本对rman的clear命令的支持不好(注意clear是internal 命令)
页: [1]
查看完整版本: ORA-00600: internal error code, arguments: [krbrbmrs_clear_open]