Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 10:49:19 | 查看: 1399| 回复: 0
原来数据库所在的操作系统硬盘损坏,修复后,数据库启动报错,不知道怎么解决,请高手帮忙!
SQL> startup
ORACLE instance started.

Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/opt/oracle/oradata/cicro/system01.dbf'
ORA-01251: Unknown File Header Version read for file number 1

执行dbv检测,信息如下:
[oracle@localhost cicro]$ dbv file=system01.dbf  blocksize=8192

DBVERIFY: Release 9.2.0.1.0 - Production on Fri Jan 20 20:38:34 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

DBVERIFY - Verification starting : FILE = system01.dbf
Block Checking: DBA = 4202225, Block Type = Unlimited data segment header
Incorrect last map DBA: 0x0001f5c1
Block Checking: DBA = 4247057, Block Type = Unlimited data segment header
Incorrect last map DBA: 0x00007aa2
Block Checking: DBA = 4247081, Block Type = Unlimited data segment header
Incorrect last map DBA: 0x00007a92
Block Checking: DBA = 4247089, Block Type = Unlimited data segment header
Incorrect last map DBA: 0x00007a9e
Block Checking: DBA = 4247257, Block Type = Unlimited data segment header
Incorrect last map DBA: 0x0001f512
Block Checking: DBA = 4247273, Block Type = Unlimited data segment header
Incorrect total map count: 0
Block Checking: DBA = 4247275, Block Type = KTB-managed data block
data header at 0x40c2625c
kdbchk: bad row offset slot 2 offs 96 fseo 412 dtl 8168 bhs 72
Page 52971 failed with check code 6135
Block Checking: DBA = 4251716, Block Type = KTB-managed data block
data header at 0x40bd825c
kdbchk: row locked by non-existent transaction
        table=0   slot=5
        lockid=1   ktbbhitc=2
Page 57412 failed with check code 6101
Block Checking: DBA = 4251742, Block Type = KTB-managed data block
data header at 0x40c0c25c
kdbchk: xaction header lock count mismatch
        trans=2 ilk=1 nlo=0
Page 57438 failed with check code 6108
Block Checking: DBA = 4251752, Block Type = KTB-managed data block
data header at 0x40c20274
kdbchk: xaction header lock count mismatch
        trans=2 ilk=1 nlo=0
Page 57448 failed with check code 6108
Block Checking: DBA = 4252995, Block Type = KTB-managed data block
**** kdxcofbo = 898 != 1038
---- end index block validation
Page 58691 failed with check code 6401


DBVERIFY - Verification complete

Total Pages Examined         : 60160
Total Pages Processed (Data) : 37431
Total Pages Failing   (Data) : 4
Total Pages Processed (Index): 4665
Total Pages Failing   (Index): 1
Total Pages Processed (Other): 4689
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 13364
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

可能是数据文件有坏块,导致数据库不能启动,难道数据就这样over了,请教高手指点!

他们没有做备份,是出问题的时候才找到我的,请问李迪,用RMAN怎么修复呀,还请指教!
谢谢!


这个数据库是noarchivelog的,也没有备份,可能恢复没有希望了!
郁闷呀,快过年了,出现这种事情!
晕死

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 19:38 , Processed in 0.051052 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569