怎样将pdb退回到nocdb？

How to Move a PDB Back to a Non-CDB Using TRANSPORTABLE=ALWAYS (文档 ID 2027352.1)

In this Document

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later

---

 

APPLIES TO:

Information in this document applies to any platform.

GOAL

You want to move a PDB back to a non-CDB.  Probably the easiest way is to use the FULLY TRANSPORTABLE feature of expdp to accomplish this (FULL=Y TRANSPORTABLE=ALWAYS).
 

SOLUTION

The requirements/limitations are the same when you use TRANSPORTABLE=ALWAYS to move back to a non-CDB from a PDB, as they are when moving between non-CDBs, such as same characterset, same RDBMS version and patches, etc.   (See note "Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable (Doc ID 1454872.1).")

The overall steps are basically the same as exporting from a non-CDB, but need some modifications, per steps 2,3,4, 10.

1. Target - Create a new, empty, non-CDB database, using the same 12c binaries (same RDBMS version and patches).

2. Source - Put the PDB's user-defined tablespace(s) in read-only mode.

3. Source - From the PDB, create a directory for where the metadata dumpfile will be created (named TC_DIR in the example; note: you cannot modify DATA_PUMP_DIR for use in a PDB.)

4. Source - Run the export from the CDB.  Example:

host expdp system/<password>@<pdbname> directory=TC_DIR dumpfile=fullexp.dmp logfile=fullexp.log full=y transportable=always;

5. Copy the fullexp.dmp file from the target directory to the source directory.

6. The export log will list the datafiles that need to be copied to the target.  Example:

******************************************************************************
Datafiles required for transportable tablespace USERS:
    /u02/app/oracle/oradata/pdb1/users01.dbf   <-------
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Mon Jun 29 18:38:28 2015 elapsed 0 00:04:52

7.  Copy (and endian convert, if necessary) the datafiles to the desired location on the target.

8.  Target - Create the directory pointing to the location of the metadata dumpfile (named TC_DIR in the example).

9.  Target - Import as normal for a regular TTS import, but add the full=y parameter.  Example:

host impdp system/<password> directory=TC_DIR dumpfile=fullexp.dmp logfile=fullimp.log full=y transport_datafiles='<new_path_on_target>/users01.dbf'

10. Source - If you want to keep the PDB, you are done.  If you do not want the PDB, unplug it and then drop it (you will have to manually drop the datafiles if you do not unplug the PDB first).  Example:

ALTER PLUGGABLE DATABASE <pdb_name> UNPLUG INTO '<path_name>/<pdb_name>.xml';
DROP PLUGGABLE DATABASE <pdb_name> INCLUDING DATAFILES;

 

 

To move from 12c PDB to 11g NON-CDB:

1,It is required to first move from 12c PDB to 12c Non-CDB
2,Then move the 12c Non-CDB to 11g
Check:
Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable (Doc ID 1454872.1)

REFERENCES

NOTE:1166564.1 - Master Note for Transportable Tablespaces (TTS) -- Common Questions and Issues