- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-14 17:35:10
|
查看: 1230 |
回复: 0
操作系统版本: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
$
|
|