RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

Alınan Hata :

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /backup/archive/1_543823_156765345.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

Çözüm :

Crosscheck yapılarak diskte mevcut olmayan arşiv dosyaları expired olarak işaretlenir.

$ rman target /
RMAN> CROSSCHECK ARCHIVELOG ALL;

Expired olarak işaretlenen arşiv dosyaları silinir.

RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;