建立了一个控制文件的trace文件SQL> alter database backup controlfile to trace;
从trace文件里面抽取出了重建控制文件的脚本：
CREATE CONTROLFILE REUSE DATABASE "RAC" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 192
    MAXLOGMEMBERS 3
    MAXDATAFILES 1024
    MAXINSTANCES 32
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '+DATA/rac/onlinelog/group_1.261.811989905'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '+DATA/rac/onlinelog/group_2.262.811989911'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '+DATA/rac/onlinelog/group_3.263.811989915'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '+DATA/rac/datafile/system.256.811989669',
  '+DATA/rac/datafile/sysaux.257.811989671',
  '+DATA/rac/datafile/undotbs1.258.811989671',
  '+DATA/rac/datafile/users.259.811989671',
  '+DATA/rac/datafile/example.265.811989943'
CHARACTER SET ZHS16GBK
;
删除所有控制文件，模拟控制文件全部丢失，重建控制文件后
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1021344 generated at 05/06/2013 00:01:09 needed for thread 1
ORA-00289: suggestion : +DATA
ORA-15173: entry 'ARCHIVELOG' does not exist in directory 'RAC'
ORA-00280: change 1021344 for thread 1 is in sequence #6


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+data/rac/ONLINELOG/group_1.261.811989905
ORA-00310: archived log contains sequence 4; sequence 6 required
ORA-00334: archived log: '+DATA/rac/onlinelog/group_1.261.811989905'


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: '+DATA/rac/datafile/system.256.811989669'

报的这个错ORA-01110: data file 1: '+DATA/rac/datafile/system.256.811989669'是什么原因，怎么解决？

jackey.qiu 发表于 2013-5-6 20:49
你看看你的归档目录在哪里，安照报错，应该是在+data/rac/archivelog目录下，你用asmcmd到+data下边看看是 ...

是的，已经解决，谢谢

你看看你的归档目录在哪里，安照报错，应该是在+data/rac/archivelog目录下，你用asmcmd到+data下边看看是否存在archivelog目录。如果没有手工创建一下，还有就是
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+data/rac/ONLINELOG/group_1.261.811989905
你把v$log中查询到的都在这里输入下，
现在数据库打不开，说明还是需要日志回复才可以