Oracle无法启动，显示dbf文件需要介质恢复？
oracle服务器的硬盘忽然出现故障，后来硬盘插拔一次之后，可以了，但是oracle无法启动了，显示有个dbf文件需要介质启动
SQL> startup
ORACLE instance started.
Total System Global Area 1238732800 bytes
Fixed Size 1299596 bytes
Variable Size 771754868 bytes
Database Buffers 452984832 bytes
Redo Buffers 12693504 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/u01/Gs/Designer01.dbf'
使用recover database命令时，它提示的log文件不存在，无法执行。
该怎么办呢？
谢谢，我刚试了一下，第一个命令显示结果如下：
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 21556751361 generated at 05/24/2012 17:34:54 needed for
thread 1
ORA-00289: suggestion :
/usr/local/oracle/flash_recovery_area/GS/archivelog/2012_08_06/o1_mf_1_164297_%u
_.arc
ORA-00280: change 21556751361 for thread 1 is in sequence #164297
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/usr/local/oracle/oradata/Gs/system01.dbf'
ORA-01112: media recovery not started
里边提示的system01.dbf文件存在，也可以拷出来
页:
[1]