ORA-01578 Sat Mar 22 15:01:37 2008 Errors in file d:\oracle\admin\orcl\udump\xxxx.trc: ORA-01578: ORACLE 数据块损坏(文件号14,块号96085) ORA-01110: 数据文件 14: 'Z:\ORACLE\ORADATA\xxxx.ORA' 文档的说明: ORA-01578 ORACLE data block corrupted (file # string, block # string) Cause: The data block indicated was corrupted, probably due to program errors. Action: Determine which object was corrupted using a command like the following: SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTSWHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1; where values for file and block are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services. 说明数据块有损坏。 利用dbv 进行数据库块检查: C:\>dbv file=Z:\ORACLE\ORADATA\xxxxx.ORA blocksize=8192 DBVERIFY: Release 9.2.0.1.0 - Production on 星期六 3月 22 19:47:42 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. DBVERIFY - 验证正在开始 : FILE = Z:\ORACLE\ORADATA\xxxxx.ORA *** Corrupt block relative dba: 0x03817755 (file 14, block 96085) Fractured block found during buffer read Data in bad block - type: 6 format: 2 rdba: 0x03817755 last change scn: 0x0000.0bcc65ab seq: 0x1 flg: 0x04 consistency value in tail: 0x835f0601 check value in block header: 0x2132, computed block checksum: 0xcfbf spare1: 0x0, spare2: 0x0, spare3: 0x0 *** DBVERIFY - 验证完成 检查的页总数 :262144 处理的页总数(数据):109398 失败的页总数(数据):0 处理的页总数(索引):2242 失败的页总数(索引):0 处理的页总数(其它):1713 处理的总页数 (段) : 0 失败的总页数 (段) : 1 空的页总数 :148791 标记为损坏的总页数:0 汇入的页总数 :0 利用rman 进行 数据块恢复, 注意要有上次完全备份和归档日志 C:\>rman target / 恢复管理器: 版本9.2.0.1.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. 连接到目标数据库: xxxx (DBID=4185130888) RMAN> blockrecover datafile 14 block 96085; 启动 blockrecover 于 22-3月 -08 正在使用目标数据库控制文件替代恢复目录 分配的通道: ORA_DISK_1 通道 ORA_DISK_1: sid=355 devtype=DISK 通道 ORA_DISK_1: 正在恢复块 通道 ORA_DISK_1: 正在指定要从备份集恢复的块 正在恢复数据文件 00014 的块 通道 ORA_DISK_1: 已从备份段 1 恢复块 段 handle=E:\DB_BACKUP\DBFULL_NTJBKIL3_1789_1 tag=DBFULL params=NULL 通道 ORA_DISK_1: 块恢复已完成 正在开始介质的恢复 完成介质的恢复 完成 blockrecover 于 22-3月 -08 RMAN> |
ORA-01578 数据库块损坏 恢复过程
最新推荐文章于 2024-04-10 10:14:10 发布