[ORACLE] RMAN-06054

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 04/06/2022 00:39:29

RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 150 and starting SCN of 5875886

 

 

-->  RMAN-06054 해결방법

SQL> select max(sequence#), thread# from v$archived_log L, v$database D where L.resetlogs_change#=D.resetlogs_change# and L.backup_count > 0 group by L.thread#;  2    3    4       MAX(SEQUENCE#)      THREAD# -------------- ----------        162        1        149        2

 

run {

set until sequence 167 thread 1;

set until sequence 153 thread 2;

recover database;

alter database open resetlogs;

}