Plugin a Pluggable Database (PDB) Manually

Plugin a Pluggable Database (PDB) Manually

Plugging in a PDB into the CDB is similar to creating a new PDB. First check the PBD is compatible with the CDB by calling the DBMS_PDB.CHECK_PLUG_COMPATIBILITY function, passing in the XML metadata file and the name of the PDB you want to create using it.

SET SERVEROUTPUT ON

DECLARE

  l_result BOOLEAN;

BEGIN

  l_result := DBMS_PDB.check_plug_compatibility(

                pdb_descr_file => '/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml',

                pdb_name       => 'pdb2');

  IF l_result THEN

    DBMS_OUTPUT.PUT_LINE('compatible');

  ELSE

    DBMS_OUTPUT.PUT_LINE('incompatible');

  END IF;

END;

/

compatible

PL/SQL procedure successfully completed.

SQL>

If the PDB is compatible, create a new PDB using it as the source. If we were creating it with a new name we might do something like this.

CREATE PLUGGABLE DATABASE pdb5 USING '/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml'

  FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdb2/','/u01/app/oracle/oradata/cdb1/pdb5/');

Instead, we want to plug the database back into the same container, so we don't need to copy the files or recreate the temp file, so we can do the following.

CREATE PLUGGABLE DATABASE pdb2 USING '/u01/app/oracle/oradata/cdb1/pdb2/pdb2.xml'

  NOCOPY

  TEMPFILE REUSE;

ALTER PLUGGABLE DATABASE pdb2 OPEN READ WRITE;

SELECT name, open_mode

FROM   v$pdbs

ORDER BY name;

NAME                          OPEN_MODE

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

PDB$SEED                      READ ONLY

PDB1                          MOUNTED

PDB2                          READ WRITE

PDB3                          READ WRITE

SQL>