oracle 11.2.0.4, standard edition, linux x86_64.
Restore to new server (setting files in asm), recover until some redo logs.
then alter database open resetlogs error:
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 12/09/2019 09:33:08
ORA-00392: log 2 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/DWHCI/redo02.log'
If I try recover database, he tells:
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 243967 and starting SCN of 6130587958
which is normal as I didn't give him this redo log.
How can I open the database?