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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 18:48:07 | 查看: 1234| 回复: 0
今天单位的oracle10g突然当掉了,执行startup命令,系统mount后提示:
SQL> startup
ORACLE instance started.
Total System Global Area 3154116608 bytes
Fixed Size                  2087280 bytes
Variable Size            2533361296 bytes
Database Buffers          603979776 bytes
Redo Buffers               14688256 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/htian/system.256.dbf'
,随后执行recover database,系统提示:
ORA-00279: change 440225591 generated at 09/14/2011 17:34:23 needed for thread
1
ORA-00289: suggestion : /opt/oracle/oradata/arch/1_60_761103063.dbf
ORA-00280: change 440225591 for thread 1 is in sequence #60

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/opt/oracle/oradata/arch/1_60_761103063.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
,检查了“system.256.dbf”是存在的,“1_60_761103063.dbf”对应目录下没有,发现“/opt/oracle/oradata/arch”目录下只有5个文件,且后缀带“761103063”的就四个文件,分别1_6311_761103063.dbf到1_6314_761103063,请问这个问题如何解决?请各位高人指导。


    error=27072 txt: 'Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 108425
Additional information: -1'
Sat May 25 15:17:50 2013
KCF: write/open error block=0x1f9da online=1
     file=51 /oradata/htian/nnc_data01.304.dbf
     error=27072 txt: 'Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 129498
Additional information: -1'
Automatic datafile offline due to write error on
file 51: /oradata/htian/nnc_data01.304.dbf
Sat May 25 15:17:50 2013
Automatic datafile offline due to write error on
file 52: /oradata/htian/nnc_data01.305.dbf
Sat May 25 15:17:50 2013
Errors in file /opt/oracle/admin/htian/bdump/htian_lgwr_19004.trc:
ORA-00345: 重做日志写入块 3375 计数 2 出错
ORA-00312: 联机日志 3 线程 1: '/oradata/htian/redo3_1.dbf'
ORA-27072: 文件 I/O 错误
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 3375
Additional information: -1
ORA-00345: 重做日志写入块 3375 计数 2 出错
ORA-00312: 联机日志 3 线程 1: '/oradata/htian/redo3_2.dbf'
ORA-27072: 文件 I/O 错误
Linux-x86_64 Error: 30: Read-only file system
Additional information: 4
Additional information: 3375
Additional information: -1
Sat May 25 15:17:51 2013
Errors in file /opt/oracle/admin/htian/bdump/htian_lgwr_19004.trc:

截取了出错时的日志
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-6-1 21:19 , Processed in 0.050195 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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