RMAN 06059 Expected Archived Log Not Found

Melek Durdu

2 years ago

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.

$ rman target /
RMAN> CROSSCHECK ARCHIVELOG ALL;

1 2	$ rman target / RMAN> CROSSCHECK ARCHIVELOG ALL;

We delete archive files marked as expired.

RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;

1	RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;