在CONTROLFILE,REDO全都损失的情况下,无备份,能恢复吗?

ALLSTARS_ORACLE

现在三个REDO全没了,没有备份,CONTROLFILE也没有了.
我第一步是想手工建CONTROLFILE,脚本如下,其中的REDOLOG部份我是写了,但没有这个REDO的.CREATE CONTROLFILE REUSE DATABASE "EXT" NORESETLOGS  ARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 '/u01/app/oracle/oradata/ext/redo01.log'  SIZE 100M,
  GROUP 2 '/u01/app/oracle/oradata/ext/redo02.log'  SIZE 100M,
  GROUP 3 '/u01/app/oracle/oradata/ext/redo03.log'  SIZE 100M
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/ext/system01.dbf',
  '/u01/app/oracle/oradata/ext/undotbs01.dbf',
  '/u01/app/oracle/oradata/ext/cwmlite01.dbf',
  '/u01/app/oracle/oradata/ext/drsys01.dbf',
  '/u01/app/oracle/oradata/ext/example01.dbf',
  '/u01/app/oracle/oradata/ext/indx01.dbf',
  '/u01/app/oracle/oradata/ext/odm01.dbf',
  '/u01/app/oracle/oradata/ext/tools01.dbf',
  '/u01/app/oracle/oradata/ext/users01.dbf',
  '/u01/app/oracle/oradata/ext/xdb01.dbf',
  '/u01/app/oracle/oradata/ext/data02.dbf',
  '/u01/app/oracle/oradata/ext/data01.dbf'
CHARACTER SET ZHS16GBK
;
执行后报错:
SQL> @ext_ora_3775.trc;
CREATE CONTROLFILE REUSE DATABASE "EXT" NORESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/app/oracle/oradata/ext/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


我想到了,先把REDO部份注释掉,结果执行后报:SQL> @ext_ora_3775.trc ;
CREATE CONTROLFILE REUSE DATABASE "EXT" NORESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/log1@.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

'?/dbs/log1@.dbf'这个文件应该是ORACLE默认的REDO.

现在我没有办法把CONTROLFILE建立起来.

有哪位有做过类似的能告诉我吗,谢谢.


对了,这之前的数据库是SHUTDOWN IMMEDIATE状态.而且我也尝试着用了_allow_resetlogs_corruption=true.

理论上,这样是不能恢复的吧,毕竟,REDO里的数据ORACLE还是需要的.但我觉得因为REDO没有了,连CONTROLFILE都不能建立就有点怪了.至少我应该能手工建立CONTROLFILE吧.

谢谢,我不够仔细.直接截取TRACE的第一段执行了.再次谢谢.