ALLSTARS_ORACLE 发表于 2017-4-14 18:48:07

执行recover database 报错,打不开数据库,求救!

今天单位的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:

截取了出错时的日志
页: [1]
查看完整版本: 执行recover database 报错,打不开数据库,求救!