In Oracle Database 12c, the RMAN “DUPLICATE” command has new “NOOPEN” option which clones the database but does not open the auxiliary instance. This feature can be used to duplicate a database to higher version.
MOS Note: 2022820.1
Upgrade to 12c database using RMAN Duplicate with NOOPEN clause
The note contains also a full example on how to duplicate the production database as a standby, and upgrade it.
–Mike
This works for v12.1 -> v18.3.
Thanks for the info.
Thanks Brian!
Cheers,
Mike
This would for 12.2 to 19c upgrade and also for simultaneous migration from one server to another (same endian) ?
Yes.
Cheers,
Mike
I’m doing a 11.2.04 to 19.3 upgrade but the duplicate command fails because it “can’t find” the control file although it is in the backup location.
Hi Ivo,
then please check with Oracle Support – and please please please, don’t use 19.3.0 but patch to 19.11.0 at first.
https://mikedietrichde.com/2021/04/21/patching-all-my-environments-with-the-april-2021-patch-bundles/
Cheers,
Mike
Dear Mike! Good afternoon!
I need to migrate and upgrade from 12.2. to 19.12 (new server) using duplicate noopen and source database backup. Please, since preupgrd.sql and utluppkg.sql scripts are no lonnger available on 19c binaries, how to perform preupgrade tasks in the source database server without install the 19c on it?
thanks a lot.
Hi,
please take an hour and watch Episode 2 of our Virtual Classroom Seminars:
https://mikedietrichde.com/videos/
Cheers,
Mike
is recovery possible while using the NOOPEN clause in duplication ?
I’d guess so – but please try it out.
Cheers,
Mike