Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Error Received:
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
Solution :
By crosschecking, we mark archive files that do not exist on the disk as expired.
1 2 | $ rman target / RMAN> CROSSCHECK ARCHIVELOG ALL; |
We delete archive files marked as expired.
1 | RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL; |
