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
Il giorno ven 13 dic 2019 alle ore 22:56 sallianz11 . <sallianz11@xxxxxxxxx>
ha scritto:
Andrea,
you might be hitting the issue reported in the below ML Note if your ctl
file backup is newer than the arch backups.
===
RMAN duplicate errors with RMAN-6026 RMAN-6024 no backup of controlfile
(Doc ID 1348071.1)
CAUSE
RMAN will be using the SCN of the highest backed up archived redolog and
will try to find a backup of the controlfile before that. This is not
succeeding for the backup of the controlfile as the backup of the
controlfile is newer than the last archivebackup, so cannot be used.
SOLUTION
You can resolve this by making another archivelog backup of the target
database.
*RMAN> backup archivelog all;*
and than restart the duplicate afterwards, then the database duplicated
successfully.
Another option (if backups are on disk) would be to use targetless
duplicate with 'backup_location' option and NO until clause specified with
the rman duplicate command.
On Fri, Dec 13, 2019 at 3:31 PM Andrea Monti <ilsuonogiallo@xxxxxxxxx>
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@xxxxxxxxxxxxxxx> 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...
