ISSUE
Application: Oracle 11
Platform: Linux
Operation: Oracle Full
Reference Log: /usr/bp/logs.dir/rae-5.log
Command Failed: Executing Oracle Backup
5> backup format '/usr/bp/mnt/OCLxxx/unitrends-full-%n-%T-%s-%p-%t' database include current controlfile tag 'unitrends-5465' plus archivelog delete all input tag 'unitrends-5465';
6> backup spfile format '/usr/bp/mnt/OCLxxx/unitrends-OCLxxx.spfile' tag 'unitrends-spfile-5465';
7> backup current controlfile format '/usr/bp/mnt/OCL107/unitrends-OCLxxx.ctf' tag 'unitrends-ctf-5465';
8> }
9>
using target database control file instead of recovery catalog
allocated channel: OCLxxx-1
channel OCLxxx-1: SID=156 device type=DISK
Starting backup at 11-FEB-19
current log archived
released channel: OCLxxx-1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 02/11/2019 22:02:48
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /oradata/PROD/OCLxxx/OCLxxx/arch/OCLxxx_x_xxxxxx_xxxxxxxxxx.ARC
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
RESOLUTION
Below are the commands you will need to run on the Oracle server via the Oracle DBA
delete archivelog all;
crosscheck archivelog all;
delete expired archivelog all;
Then you will need to run a new rman full after running those commands.
This will need to be done for each database giving the error
CAUSE
the archivelog is not reset on the restore functions in Oracle/Rman setup. This needs to be deleted manually and a new full ran