Total Pageviews

Drop PDB (Pluggable database) from RAC CDB (Container Database) in Oracle 12c

Scope:
This post explains the easy steps to remove the Plugabble database from RAC Container database.




Drop Pluggable database from RAC Container Database
Steps:
  1. Remove the Dynamic PDB services.
  2. Close all PDB instances.
  3. Drop the pluggable database.
Steps in detail:

Remove the Dynamic PDB services


$srvctl remove service -db <Contaner Database Name> -service <Service_Name>.

Close all PDB instances
Login to SQL container database and close all PDB instances

$ sqlplus "/ as sysdba"
SQL> alter pluggable database <PDB_name> close instance=ALL;

Drop the pluggable database

Login to SQL container database and run drop command with/without including datafiles.

$ sqlplus "/ as sysdba"
SQL> drop pluggable database <PDB_name> including Datafiles;


No comments:

Post a Comment