ALLSTARS_ORACLE 发表于 2017-4-14 17:35:10

AIX系统上oracle 数据文件损坏

操作系统版本:AIX 5.3
Oracle 版本:10gR1
掉电导致磁盘故障,重启服务器后文件系统有问题,检查结果如下;进目录后ls -l 看不到损坏的文件了,oracle 无备份、无归档,
有没办法修复database, 虽然数据库是个临时库来的,如果恢复不了,用户有很多工作需重做,大侠帮忙啊?
文件系统检查结果:
==========
** Checking /dev/rfslv03 (/u03)
** Phase 0 - Check Log
log redo processing for /dev/rfslv03
** Phase 1 - Check Blocks and Sizes        
File size error Inode=1164291
File size error Inode=1164292
File size error Inode=1164293
File size error Inode=1164295
File size error Inode=1164301
File size error Inode=1164305
File size error Inode=1164307
** Phase 2 - Check Pathnames
Duplicate or invalid I=1164291  owner=oracle mode=100640
size=12138323968 mtime=Sep 10 02:09 2013
file=/oradata/UAT3/ifsapp_data01.dbf; REMOVE? n
Duplicate or invalid I=1164292  owner=oracle mode=100640
size=11963211776 mtime=Sep 10 08:50 2013
file=/oradata/UAT3/ifsapp_data07.dbf; REMOVE? n
Duplicate or invalid I=1164293  owner=oracle mode=100640
size=12059680768 mtime=Sep 10 02:09 2013
file=/oradata/UAT3/ifsapp_data02.dbf; REMOVE? n
Duplicate or invalid I=1164295  owner=oracle mode=100640
size=12107915264 mtime=Sep 10 02:09 2013
file=/oradata/UAT3/ifsapp_data03.dbf; REMOVE? n
Duplicate or invalid I=1164301  owner=oracle mode=100640
size=12129935360 mtime=Sep 10 04:59 2013
file=/oradata/UAT3/ifsapp_data06.dbf; REMOVE? n
Duplicate or invalid I=1164305  owner=oracle mode=100640
size=8141152256 mtime=Sep 10 09:10 2013
file=/oradata/UAT3/ifsapp_index03.dbf; REMOVE? n
Duplicate or invalid I=1164307  owner=oracle mode=100640
size=8105500672 mtime=Sep 10 02:09 2013
file=/oradata/UAT3/ifsapp_index05.dbf; REMOVE? n
** Phase 3 - Check Connectivity
** Phase 4 - Check Reference Counts
** Phase 5 - Check Inode Map
** Phase 6 - Check Block Map
Filesystem integrity is not guaranteed
139 files 1989378240 blocks 107773760 free

dbv校验
======
$ dbv file=/u03/oradata/UAT3/ifsapp_data01.dbf blocksize=8192
DBVERIFY: Release 10.1.0.5.0 - Production on Tue Sep 10 23:43:03 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

DBV-00100: Specified FILE (/u03/oradata/UAT3/ifsapp_data01.dbf) not accessible
$



页: [1]
查看完整版本: AIX系统上oracle 数据文件损坏