查invalid ROWID问题

g_hk

[oracle@SXCHNLDB cyclog]$sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Sun May 15 08:17:50 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from  TRAIN.TIM_TMP_RPT_KPI_WAIQIN1;
select count(*) from  TRAIN.TIM_TMP_RPT_KPI_WAIQIN1
                            *
ERROR at line 1:
ORA-01410: invalid ROWID


SQL> alter session set max_dump_file_size=unlimited;

Session altered.

SQL> alter session set db_file_multiblock_read_count=1;

Session altered.

SQL> alter session set events '10200 trace name context forever, level 1';

Session altered.

SQL> select count(*) from  TRAIN.TIM_TMP_RPT_KPI_WAIQIN1;
select count(*) from  TRAIN.TIM_TMP_RPT_KPI_WAIQIN1
                            *
ERROR at line 1:
ORA-01410: invalid ROWID


SQL>

[oracle@SXCHNLDB udump]$tail -20 chnldb_ora_3904542.trc
Consistent read started for block 130 : b2003a95
  env: (scn: 0x083c.ef72616d  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00  statement num=0  parent xid: xid: 0x0000.000.00000000  scn: 0x0000.00000000 8sch: scn: 0x0000.00000000)
Consistent read finished for block 130 : b2003a95
Consistent read finished for block 130 : b2003a95
Consistent read started for block 130 : b2003a96
  env: (scn: 0x083c.ef72616d  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00  statement num=0  parent xid: xid: 0x0000.000.00000000  scn: 0x0000.00000000 8sch: scn: 0x0000.00000000)
Consistent read finished for block 130 : b2003a96
Consistent read finished for block 130 : b2003a96
Consistent read started for block 130 : b2003a97
  env: (scn: 0x083c.ef72616d  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00  statement num=0  parent xid: xid: 0x0000.000.00000000  scn: 0x0000.00000000 8sch: scn: 0x0000.00000000)
Consistent read finished for block 130 : b2003a97
Consistent read finished for block 130 : b2003a97
Consistent read started for block 130 : b2003a98
  env: (scn: 0x083c.ef72616d  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00  statement num=0  parent xid: xid: 0x0000.000.00000000  scn: 0x0000.00000000 8sch: scn: 0x0000.00000000)
Consistent read finished for block 130 : b2003a98
Consistent read finished for block 130 : b2003a98
Consistent read started for block 130 : b2003a99
  env: (scn: 0x083c.ef72616d  xid: 0x0000.000.00000000  uba: 0x00000000.0000.00  statement num=0  parent xid: xid: 0x0000.000.00000000  scn: 0x0000.00000000 8sch: scn: 0x0000.00000000)
*** SESSION ID:(2120.533) 2011-05-15 08:23:14.798
OBJD MISMATCH typ=6, seg.obj=5348061, diskobj=6084462, dsflg=100001, dsobj=5348061, tid=5348061, cls=1

---------
SQL> /

DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(2986359449) DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(2986359449)
------------------------------------------------ -------------------------------------------------
                                             712                                             15001

SQL> l
  1* SELECT DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(2986359449), DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(2986359449) FROM DUAL


alter system dump datafile 712 block 15001;


*** 2011-05-15 08:30:00.238
Start dump data blocks tsn: 130 file#: 712 minblk 15001 maxblk 15001
buffer tsn: 130 rdba: 0xb2003a99 (712/15001)
scn: 0x083c.ec5e56bd seq: 0x01 flg: 0x06 tail: 0x56bd0601
frmt: 0x02 chkval: 0x1e7e type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000110444000 to 0x0000000110446000
XXXXXXXXXXXXx
......
Block header dump:  0xb2003a99
 Object id on Block? Y
 seg/obj: 0x5cd76e  csc: 0x83c.ec5e5697  itc: 2  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0xb200240e ver: 0x01 opc: 0
     inc: 0  exflg: 0

 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0038.009.004ce550  0x0300efb7.8f94.14  --U-   34  fsc 0x0000.ec5e56bd
0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

SQL> SELECT * FROM DBA_OBJECTS WHERE DATA_OBJECT_ID =6084462;

no rows selected
实际对象是不存在的，也就这块错了。但为什么错了呢？目前还不知道为什么。


查查相邻块是否正确:
*** 2011-05-15 08:33:48.051
Start dump data blocks tsn: 130 file#: 712 minblk 15002 maxblk 15002
buffer tsn: 130 rdba: 0xb2003a9a (712/15002)
scn: 0x0839.c41ed70c seq: 0x01 flg: 0x06 tail: 0xd70c0601
frmt: 0x02 chkval: 0xc1ab type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000110444000 to 0x0000000110446000

.........
Block header dump:  0xb2003a9a
 Object id on Block? Y
 seg/obj: 0x519add  csc: 0x839.c41e5c00  itc: 3  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0xb200240e ver: 0x01 opc: 0
     inc: 0  exflg: 0

 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0222.002.0001f599  0x00000000.0000.00  C-U-    0  scn 0x0839.c417b8e5
0x02   0x0207.013.0003cc3a  0x5208dfe2.0ce5.05  C---    0  scn 0x0839.baf002de
0x03   0x000e.001.008b0a39  0x6dc4118d.1a9c.06  --U-   27  fsc 0x1c76.c41ed70c

SQL> SELECT * FROM DBA_OBJECTS WHERE DATA_OBJECT_ID = 5348061;

OWNER
------------------------------------------------------------
OBJECT_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
SUBOBJECT_NAME                                                OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE                            CREATED
------------------------------------------------------------ ---------- -------------- -------------------------------------- -------------------
LAST_DDL_TIME       TIMESTAMP                              STATUS         TE GE SE
------------------- -------------------------------------- -------------- -- -- --
TRAIN
TIM_TMP_RPT_KPI_WAIQIN1
                                                                4285314        5348061 TABLE                                  2010-03-05 20:18:58
2011-05-11 17:40:51 2010-08-24:18:21:02                    VALID          N  N  N
看来相邻块是对的了。

这里面关键是怎么定位具体是那块数据错了。只有对位了问题然后才可以想办法解决这个问题了。