- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 16:01:43
|
查看: 1740 |
回复: 0
一个数据仓库数据库,前端ETL job近期总是遭遇这个报错。每次报错后,analyze相关表,会复现报错。flush buffer_cache之后,analyze恢复正常,ETL job也恢复。
dbv查了相关的datafile,都是没问题的。
------------------------------------------------------------------------------
Errors in file e:\oracle\product\10.2.0\admin\cdw\bdump\cdw_j001_5912.trc:
ORA-08103: object no longer exists
GATHER_STATS_JOB: GATHER_TABLE_STATS('"XXXXX"','"table"','""', ...)
ORA-08103: object no longer exists
------------------------------------------------------------------------------
在analyze时,生成一个8103 trace file,里面有unknown ,corrupt字段。有人遇到过类似的吗?
BH (0000000ACAFEDDE8) file#: 11 rdba: 0x02d57c59 (11/1408089) class: 1 ba: 0000000ACAE1A000
set: 50 blksize: 8192 bsi: 0 set-flg: 2 pwbcnt: 12266
dbwrid: 1 obj: 55828 objn: 55828 tsn: 6 afn: 11
hash: [ebab3dd0,ebab3dd0] lru: [fdfbb088,4afc1138]
ckptq: [NULL] fileq: [NULL] objq: [fdfbb0f8,4afc11a8]
use: [dbf28a78,dbf28a78] wait: [NULL]
st: XCURRENT md: SHR tch: 0
flags:
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
Using State Objects
----------------------------------------
SO: 00000011DBF28A38, type: 24, owner: 0000001209378EA0, flag: INIT/-/-/0x00
(buffer) (CR) PR: 000000120425E0D8 FLG: 0x100002
class bit: 0000000000000000
kcbbfbp: [BH: 0000000ACAFEDDE8, LINK: 00000011DBF28A78]
where: kdgwh01: kdgpnb, why: 0
buffer tsn: 6 rdba: 0x02d57c59 (11/1408089)
scn: 0x090a.9a521117 seq: 0x01 flg: 0x06 tail: 0x11170601
frmt: 0x01 chkval: 0xda4f type: 0x2b=unknown
Hex dump of corrupt header 4 = CORRUPT
Dump of memory from 0x0000000ACAE1A000 to 0x0000000ACAE1A014
ACAE1A000 7F87312B 02D57C59 9A521117 0601090A [+1..Y|....R.....]
ACAE1A010 0000DA4F [O...]
Hex dump of block: st=4, typ_found=0
Dump of memory from 0x0000000ACAE1A000 to 0x0000000ACAE1C000
//
很头疼,每次都是flush buffer也不是办法啊。上次出现类似情况,5个月之前。
|
|