Unplugging a database

Here i am exploring the concept of unplugging a database in 12c multi-tenant setup architecture.

SQL> alter pluggable database pdb2 unplug into ‘/oracle/DCE/pdb2_unplug.xml’;

unplug sql query

If you query:

select * from cdb_pdbs;

database status changed to —–> UNPLUGGED

database status unplugged

The database is unplugged but not dropped and you can still see it any many data dictionary views:

v$pdb

To drop pluggable database:

SQL> DROP PLUGGABLE DATABASE PDB2 INCLUDING DATAFILES;

drop pluggale database

Checking the data dictionary, the pluggable database doesn’t exist anymore:

query fo pluggable status

***** Its important to know that unplugging the database could cause problems while patching/upgrading, so its better to drop your database before applying any patches to avoid problems.

Hope this information is useful.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s