not possible with DG I think at the end you need to do non_cdb_pdb script
but I think you can create pdb over DB links in parallel
depending on the size that could be an option
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC
FROM
<>Use this clause to specify the source PDB or non-CDB. The files associated
with the source are copied to a new location and these copied files are then
associated with the new PDB.
The source PDB or non-CDB cannot be closed. It can be open as follows:
If the CDB that contains the source PDB (the source CDB) or the source non-CDB
is in ARCHIVELOG mode and local undo mode, then the source PDB or the source
non-CDB can be open in READ WRITE mode and fully functional during the cloning
operation. This is called hot PDB cloning.
If the source CDB or source non-CDB is not in ARCHIVELOG mode, then the source
PDB or non-CDB must be open READONLY.
Specify the source PDB or non-CDB as follows:
If the source is a PDB in the local CDB, then use src_pdb_name to specify the
name of the source PDB. You cannot specify PDB$SEED for src_pdb_name. Instead,
use the create_pdb_from_seed
<https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC__CACEDDDF>
clause to create a PDB by using the seed as a template.
If the source is a PDB in a remote CDB, then use src_pdb_name to specify the
name of the source PDB and dblink to specify the name of the database link to
use to connect to the remote CDB.
If the source is a non-CDB, then specify NON$CDB@dblink, where dblink is the
name of the database link to use to connect to the non-CDB.
Philippe Fierens
philippe@xxxxxxxxxxxxxxxxxxxx
On 26 Feb 2018, at 14:08, VANDER EYKEN Régis <regis.vandereyken@xxxxxx> wrote:
Hello everybody,
Does anybody already tried or experienced a migration from 12.1 to 12.2 (or
18c) from NON-CDB to CDB (single-tenant).
Is it possible with dataguard in one path ?
Thks for your feedback,
Kr,
Régis
