Oracle Db backup error following restore


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> }
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


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


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