在CONTROLFILE,REDO全都损失的情况下,无备份,能恢复吗?
现在三个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的第一段执行了.再次谢谢.
页:
[1]