Re: RMAN backup

Posted by ErmanArslansOracleBlog on Oct 12, 2016; 7:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backup-tp1369p1389.html

Roshan, it seems you deleted your last update, but regarding your next RMAN problem;
which is the following;
-------------------------------------
The recover process is completing with error.

input datafile copy recid=12 stamp=924987917 filename=/data/ora/PMTCC01/indx3.dbf
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=924987917 filename=/data/ora/PMTCC01/indx4.dbf

contents of Memory Script:
{
   set until scn  134772031598;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 11-OCT-16

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/data/ora/PMTCC01/system01.dbf'

released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/11/2016 21:05:19
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1661 lowscn 134769828495 found to restore
-------------------->

ANSWER:

This is another issue.
you needed to create a seperate issue for this.

anyways, for this time, I will answer from here.
But the issue persist, please open another issue.

Check this support note:
RMAN ACTIVE DUPLICATE fails with ORA-1547 RMAN-6053 RMAN-6025 (Doc ID 2015271.1)

Check the following as well;

Resolving RMAN-06023 or RMAN-06025 (Doc ID 2038119.1) -- check step 3 especially.