查invalid rowid问题-凯发app官方网站

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

sql*plus: release 10.2.0.4.0 - production on sun may 15 08:17:50 2011

凯发app官方网站 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
看来相邻块是对的了。

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