Error :
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
Starting backup at 18-NOV-21
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 11/18/2021 17:29:50
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u02/immam/db/apps_st/data/archive/1_500_1195296918.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Solution :
Once in a while, there will be an archive log that is expired but not deleted.
If that is the case, there is an easy answer :
RMAN> crosscheck archivelog all;
RMAN> list expired archivelog all;
RMAN> delete expired archivelog all;Now, run the backup again.. It will work !!
Comments
Tags: #dba_immam, #dbaimmam, #immam_dba, #immamDba, #woesofdba, ORA-19625, ORA-27037, ORA-27037: unable to obtain file status, RMAN-00569, RMAN-00571, RMAN-03002: failure of backup plus archivelog command, SVR4 Error, SVR4 Error: 2: No such file or directory