在线等答案:起ORACLE时报:ORA-01113: file 3 needs media recovery 错误 (小女子,请个位大哥,多多帮忙)

Question

SQL> startup
ORACLE instance started.Total System Global Area  286332028 bytes
Fixed Size                   451708 bytes
Variable Size             234881024 bytes
Database Buffers           50331648 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/opt/oracle/oradata/ORA92/TEST.dbf' recover datafile 3;
ORA-00279: change 181891859 generated at 01/07/2008 16:37:45 needed for thread
1
ORA-00289: suggestion : /opt/oracle/product/9.2.0.4/dbs/arch1_1231.dbf
ORA-00280: change 181891859 for thread 1 is in sequence #1231
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 181891859 generated at 01/07/2008 16:37:45 needed for thread
1
ORA-00289: suggestion : /opt/oracle/product/9.2.0.4/dbs/arch1_1231.dbf
ORA-00280: change 181891859 for thread 1 is in sequence #1231
ORA-00308: cannot open archived log 'ORA-00279:'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Answer 1

ORA-00308: cannot open archived log 'ORA-00279:' 
Linux Error: 2: No such file or directory 
===================================================
找不到归档日志/opt/oracle/product/9.2.0.4/dbs/arch1_1231.dbf看看归档日志还在不在。 

Answer 2

[oracle@Linux1 ORA92]$ cd /opt/oracle/product/9.2.0.4/dbs/
[oracle@Linux1 dbs]$ ls
initdw.ora  init.ora  lkORA92  orapwORA92  spfileORA92.ora

Answer 3

搜一下arch1_1231.dbf ，把他找出来考到/opt/oracle/product/9.2.0.4/dbs/ 再试试

Answer 4

arch1_1231.dbf 似乎丢掉了。你使用的是归档模式吧。
你的归档文件都放到哪里去了，将找到以后的归档文件放到/opt/oracle/product/9.2.0.4/dbs/再试试