Oracle 12c Migration Pluggable database to heterogeneous library

1. SOURCE Library:

Sql> Show PDBs

con_id con_name OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 pdb$seed READ only NO

3 PDB READ WRITE NO

4 TEST READ WRITE NO

2. Target Library:

Sql> Show PDBs

con_id con_name OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 pdb$seed READ only NO

3 PDB READ WRITE NO

Sql>

Migrate the test of the source library to the target library.

operation on the Source library:

sql> alter pluggable database test close immediate;

Pluggable database altered.

Sql> Show PDBs

con_id con_name OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 pdb$seed READ only NO

3 PDB READ WRITE NO

4 TEST mounted

sql> alter pluggable database test unplug into '/u01/test/test.xml ';

Pluggable database altered.

Target Library:

[Email protected] cdb]$ mkdir/u01/app/oracle/oradata/cdb/test

[Email protected] cdb]$ mkdir/u01/test

SOURCE Library:

[Email protected] ~]$ scp-r/u01/test/test.xml [email protected]:/u01/test/test.xml

[Email protected] ~]$ scp-r/u01/app/oracle/oradata/cdb/test/* [email protected]:/u01/app/oracle/oradata/cdb/test/

Target Library:

Sql> Create pluggable database test using '/u01/test/test.xml ' nocopy tempfile reuse;

Pluggable database created.

Sql> Show PDBs

con_id con_name OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 pdb$seed READ only NO

3 PDB READ WRITE NO

4 TEST mounted

Sql> exec dbms_pdb. Sync_pdb ();

PL/SQL procedure successfully completed.

This article is from the "unity of Knowledge" blog, please be sure to keep this source http://dovelauren.blog.51cto.com/9876026/1718235

Oracle 12c Migration Pluggable database to heterogeneous library