Hi Philippe,
Thank you for your quick reply… we are analyzing the different possibilities…
We will try first the conversion from non-cdb to cdb …
Kr,
Régis
From: exabelux-bounce@xxxxxxxxxxxxx [mailto:exabelux-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Philippe Fierens
Sent: lundi 26 février 2018 14:28
To: exabelux@xxxxxxxxxxxxx
Subject: [exabelux] Re: Migration from NON-CDB to single-tenant CDB
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<mailto:philippe@xxxxxxxxxxxxxxxxxxxx>
On 26 Feb 2018, at 14:08, VANDER EYKEN Régis
<regis.vandereyken@xxxxxx<mailto: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
