Re: rman duplicate with no target connection fails with RMAN-06024: no backup or copy of the control file found to restore after resetlogs

Hi Andrea,

The fact that you said ‘ DUPLICATE fails as long as I am not connected to the target database‘ leads me to think that you need to ‘set dbid’ for a targetless duplicate. Or did I miss that somewhere in your output?

Secondly try a restore preview vs targetless duplicate with the same scn. The duplicate script generates an scn from your time.

Run {
Set until scn x;
Restore controlfile preview;
}

Finally turn ‘debug on’ to see what it’s doing behind the scene for a target vs targetless duplicate.

Cheers,
Leng

> On 16 Dec 2019, at 7:56 pm, Andrea Monti <ilsuonogiallo_at_gmail.com> wrote:
> 
> 
> Hi,
> I double-checked following documents:
> 
> 
> Bug 14215868 : BACKUP DATABASE PLUS ARCHIVELOG WITH AUTOBACKUP IS NOT SUFFICIENT TO DUPLICATE
> RMAN duplicate errors with RMAN-6026 RMAN-6024 no backup of controlfile (Doc ID 1348071.1)
> Bug 14054568 - RMAN DUPLICATE fails with RMAN-6054 (Doc ID 14054568.8)
> Perform Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups (Doc ID 1375864.1)
> RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection (Doc ID 874352.1)
> 
> but none apply. The problem comes up only when duplicating from backups a db with several incarnations without connecting to target. The same strategy works fine if I connect to the target (source) database or if the target (source) database only has 1 incarnation
> Regards,
> Andrea
> 
> 

>>> On Fri, Dec 13, 2019 at 3:31 PM Andrea Monti <ilsuonogiallo_at_gmail.com> wrote:
>>> Hi Tim,
>>> That would be nice but some circumstances we are forced to use backup - based duplication (may be because we have to restore to a quite old point in time, or because we must restore to different network,or because we want to apply the same strategy to some 11.2 DBs... ), thus we cannot always rely on PFBs hot clones
>>> 
>>> Regards, 
>>> Andrea
>>> 
>>> 
>>> 
>>> Il ven 13 dic 2019, 17:47 Tim Hall <tim_at_oracle-base.com> ha scritto:
>>>> Sorry to answer a question with a question, but why would you use an RMAN duplicate if you were working with Multitenant?
>>>> 
>>>> We use lone-PDB for everything we can, or 3 PDBs on 19c. :) On those where we have PDBs I never run an RMAN duplicate. I try to act like the CDB doesn't exist. :) All clones are done using PDB clones. I see for the banner you are on 12.2, so you can do hot clones, which are awesome. I've just never felt the need to clone the CDB since I switched. It also means renames are easy. :)
>>>> 
>>>> https://oracle-base.com/articles/12c/multitenant-hot-clone-remote-pdb-or-non-cdb-12cr2 
>>>> 
>>>> Cheers
>>>> 
>>>> Tim...

--
http://www.freelists.org/webpage/oracle-l