resetlogs 无法创建redo ORA-00344: unable to re-create online log

数据库rman恢复recover

SQL> recover database using backup controlfile until time '2018-11-27 02:00:00';

ORA-00279: change 10495820489810 generated at 11/27/2018 00:00:15 needed for

thread 1

ORA-00289: suggestion : /archlog/1_24363_764960754.dbf

ORA-00280: change 10495820489810 for thread 1 is in sequence #24363

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 10495820511332 generated at 11/27/2018 01:00:14 needed for

thread 1

ORA-00289: suggestion : /archlog/1_24364_764960754.dbf

ORA-00280: change 10495820511332 for thread 1 is in sequence #24364

ORA-00278: log file '/archlog/1_24363_764960754.dbf' no longer needed for this

recovery

ORA-00279: change 10495820512543 generated at 11/27/2018 01:01:23 needed for

thread 1

ORA-00289: suggestion : /archlog/1_24365_764960754.dbf

ORA-00280: change 10495820512543 for thread 1 is in sequence #24365

ORA-00278: log file '/archlog/1_24364_764960754.dbf' no longer needed for this

recovery

ORA-00279: change 10495820523738 generated at 11/27/2018 01:53:07 needed for

thread 1

ORA-00289: suggestion : /archlog/1_24366_764960754.dbf

ORA-00280: change 10495820523738 for thread 1 is in sequence #24366

ORA-00278: log file '/archlog/1_24365_764960754.dbf' no longer needed for this

recovery

ORA-00279: change 10495820523777 generated at 11/27/2018 01:53:09 needed for

thread 1

ORA-00289: suggestion : /archlog/1_24367_764960754.dbf

ORA-00280: change 10495820523777 for thread 1 is in sequence #24367

ORA-00278: log file '/archlog/1_24366_764960754.dbf' no longer needed for this

recovery

Log applied.

Media recovery complete.

recover完成后open read only是没问题的

SQL> alter database open read only;

Database altered.

open resetlogs 报错

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1: