Oracle Db backup error following restore

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us