ORA-00349: failure obtaining block size for

在做NBU恢复时，由于RENAME过程中，拼写错误
ORA-1511 signalled during: alter database rename file' +RECO_DM02/jccrm/onlinelog/group_131.52548.930668639' to '/u01/app/oracle/ora
data/orcl/group_131.52548.930668639'...


当执行ALTER DATABASE OPEN RESETLOGS时，报如下错误
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 15098820263819
Errors in file /u01/app/oracle/diag/rdbms/jccrm/JCCRM/trace/JCCRM_ora_24680.trc:
ORA-00313: open failed for members of log group 131 of thread 1
ORA-00312: online log 131 thread 1: '+RECO_DM02/jccrm/onlinelog/group_131.52548.930668639'
ORA-17503: ksfdopn:2 Failed to open file +RECO_DM02/jccrm/onlinelog/group_131.52548.93066863


尝试进行CLEAR操作
SQL> alter database clear unarchived logfile group 131;
alter database clear unarchived logfile group 131
*
ERROR at line 1:
ORA-00349: failure obtaining block size for '+reco_dm0


对所有文件数据头进行验证
SQL> select  CHECKPOINT_CHANGE#,count(*) from V$DATAFILE_HEADER group by CHECKPOINT_CHANGE#;


  CHECKPOINT_CHANGE#             COUNT(*)
-------------------- --------------------
      15098820263819                   76


可以看出所有文件SCN一致
重建控制文件


 ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql' resetlogs ;




将库SHUTDOWN ABORT；
执行SQL
SQL> recover database using backup controlfile  until cancel;
ORA-00279: change 15098820266252 generated at 02/24/2017 00:00:02 needed for
thread 1
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_7530_846240555.dbf
ORA-00280: change 15098820266252 for thread 1 is in sequence #7530




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;


Database altered.


再次启动，库成功OPEN