Dropping PDB IS NOT Releasing Space of ASM Flex Filegroup (Doc ID 2448270.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Sometimes, drop pdb is not release space of ASM Flex Filegroup.

For example:

##create pdb
SQL> create pluggable database test from cdb3pdb;
SQL> alter pluggable database test open;
SQL> alter session set container=test;
SQL> show pdbs;
   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        4 TEST                           READ WRITE NO

SQL> select FILE_NAME,TABLESPACE_NAME from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
--------------------------------------------------------------------------------
+TESTQ/CDB3/67589F442D916771E0530200A8C06584/DATAFILE/system.281.970751719
SYSTEM

+TESTQ/CDB3/67589F442D916771E0530200A8C06584/DATAFILE/sysaux.278.970751717
SYSAUX

+TESTQ/CDB3/67589F442D916771E0530200A8C06584/DATAFILE/undotbs1.279.970751717
UNDOTBS1

+TESTQ/CDB3/67589F442D916771E0530200A8C06584/DATAFILE/undo_2.280.970751719
UNDO_2

ASMCMD> lsfg
File Group         Disk Group  Quota Group  Used Quota MB  Client Name    Client Type
DEFAULT_FILEGROUP  TESTQ       GENERIC      0
TEST               TESTQ       GENERIC      2456           TEST           DATABASE　<<<<--this one


ASMCMD> ls -l +testq/cdb3
Type  Redund  Striped  Time             Sys  Name
                                       Y    675762946021738AE0530200A8C0A054/
                                       Y    67583022C33D15E5E0530100A8C0A0D7/
                                       Y    67589F442D916771E0530200A8C06584/　<<<<---directory was added

ASMCMD> ls -l 67589F442D916771E0530200A8C06584/datafile
Type      Redund  Striped  Time             Sys  Name
DATAFILE  MIRROR  COARSE   MAR 14 13:00:00  Y    SYSAUX.278.970751717
DATAFILE  MIRROR  COARSE   MAR 14 13:00:00  Y    SYSTEM.281.970751719
DATAFILE  MIRROR  COARSE   MAR 14 13:00:00  Y    UNDOTBS1.279.970751717
DATAFILE  MIRROR  COARSE   MAR 14 13:00:00  Y    UNDO_2.280.970751719




##drop pdb
SQL>  DROP PLUGGABLE DATABASE test INCLUDING DATAFILES;  <<<<<<<<<<<<<<<<<<<<---drop pdb


ASMCMD> ls -l
Type  Redund  Striped  Time             Sys  Name
                                       Y    675762946021738AE0530200A8C0A054/
                                       Y    67583022C33D15E5E0530100A8C0A0D7/
                                                                             <<<<<<<<<<<<---directory was dropped

ASMCMD> lsfg
File Group         Disk Group  Quota Group  Used Quota MB  Client Name    Client Type
DEFAULT_FILEGROUP  TESTQ       GENERIC      0
TEST               TESTQ       GENERIC      816            TEST           DATABASE  <<<---but space was not released

Changes

Using ASM Flex Filegroup on 12.2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.