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