解决ORACLE在将表空间设置成online时报ORA-1578错误

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]

适用于

Oracle数据库-企业版- 11.2.0.3版本及更高的版本
本文档的内容适用于各个平台

在尝试设置表空间为online时报ORA-1578错误

重新检查错误堆栈trace文件，可以看到ktundo(Kernel Transaction UNDO )函数

块不属于任何段

有一个inactive事务需要在回收站里清除这个块

这是最主要的原因

ORA-01578: ORACLE data block corrupted (file # 3241, block # 64066)
ORA-01110: data file 3241: ‘+DATA/trexprod/datafile/users.2148.852306913’

========= Dump for incident 1718151 (ORA 1578) ========

*** 2014-07-23 13:39:56.893
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
—– Current SQL Statement for this session (sql_id=g2sc9yx7t379a) —–
alter tablespace USERS online

—– Call Stack Trace —–
kcbgcur KCB: Get a block in current mode.
ktbgcur Kernel Transaction Block GET
kdoiur declare local objects */
kcoubk kcoubk – Kernel Cache Op Undo callBacK — invoke undo callback routine */
ktundo ktundo – Kernel Transaction UNDO
kttasu kttasu – Kernel Transaction Table Apply Save Undo
kttonl kttonl – Kernel Transaction Table ONLine
atsdrv add file list */
kcbgcur KCB: Get a block in current mode.
ktbgcur Kernel Transaction Block GET
kdoiur declare local objects */
kcoubk kcoubk – Kernel Cache Op Undo callBacK — invoke undo callback routine */
ktundo ktundo – Kernel Transaction UNDO
kttasu kttasu – Kernel Transaction Table Apply Save Undo
kttonl kttonl – Kernel Transaction Table ONLine
atsdrv add file list */

BH (0x8cf9c6188) file#: 3241 rdba: 0x2b00fa42 (172/64066) class: 1 ba: 0x8c54dc000
set: 400 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 15 obj: 41612848 objn: -1 tsn: 7 afn: 3241 hint: f
hash: [0x1766a27d00,0x1766a27d00] lru: [0xcffcdecf0,0xaef6b81c0]
ckptq: [NULL] fileq: [NULL] objq: [0x1620f39a60,0x1620f39a60] objaq: [0x1620f39a50,0x1620f39a50]
use: [0x17771ca878,0x17771ca878] wait: [NULL]
st: XCURRENT md: EXCL fpin: ‘kdowh01: kdoiur’ tch: 0
flags:
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
buffer tsn: 7 rdba: 0x2b00fa42 (172/64066)
scn: 0x0c17.57840563 seq: 0xff flg: 0x04 tail: 0x056306ff
frmt: 0x02 chkval: 0xcf9c type: 0x06=trans data

对象在回收站里

在回收站里清楚对象，解决问题