insert /*+append, nologging */ into aaa a
select * from bbb b
ORA-08103: 对象不再存在
1. 表bbb上面语句前后的DATA_OBJECT_ID 都没有变化。
OBJECT_NAME DATA_OBJECT_ID
-------------------------------------------------------------------------------- --------------
BBB 243839
2. BBB 所在的表空间的所有数据文件使用dbv file='file full path' blocksize=16384 都显示没有corrupt pages=0.
3. 怀疑是LMT的extend 的 map 出了问题。因为上述操作报错,但是 BBB 的 dba_segments 中 extents=146 了。
上传跟踪的trace 文件:请各位帮我分析一下,来自于 alter session set events '10024 trace name context, level 12'
分析文件: 我标出了怀疑有问题的地方,要是大家能帮我详细解释一下这个trace 文件,不胜感激!
PARSING IN CURSOR #9 len=67 dep=1 uid=0 oct=3 lid=0 tim=12847568802056 hv=785625969 ad='3b5b12ce0' sqlid='at1ygf4rd7cvj'
select file#, block#, blocks from seg$ where type# = 3 and ts# = :1
END OF STMT
PARSE #9:c=0,e=1793,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=12847568802054
BINDS #9:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=ffffffff7dfe4818 bln=22 avl=02 flg=05
value=41
EXEC #9:c=0,e=2233,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=167961705,tim=12847568804442
FETCH #9:c=50000,e=41615,p=0,cr=11005,cu=0,mis=0,r=1,dep=1,og=4,plh=167961705,tim=12847568846111
WAIT #3: nam='db file sequential read' ela= 10379 file#=66 block#=1586015 blocks=1 obj#=-1 tim=12847568856661 ( 此处后怀疑出错了)
kcbzib: dump suspect bufferbuffer tsn: 41 rdba: 0x1098335f (66/1586015)
scn: 0x0002.0f41450f seq: 0x01 flg: 0x04 tail: 0x450f2301
frmt: 0x02 chkval: 0x1b9c type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
....................
Dump of buffer cache at level 8 for tsn=41, rdba=278410079
BH (0x3913f16e8) file#: 66 rdba: 0x1098335f (66/1586015) class: 4 ba: 0x391200000
set: 5 pool 3 bsz: 16384 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 0 obj: 496054 objn: -1 tsn: 41 afn: 66 hint: f
hash: [0x3923f4128,0x3bd524e90] lru: [0x38dbf8510,0x3b37ecf60]
ckptq: [NULL] fileq: [NULL] objq: [NULL]
use: [0x3bd67c480,0x3bd67c480] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
cr pin refcnt: 0 sh pin refcnt: 0
.................
2011-9-16 15:04 上传
点击文件名下载附件
471.38 KB, 下载次数: 1