My Oracle Support Banner

PDB をdropした際にASM Flex Filegroupのスペースを開放しない (Doc ID 2466045.1)

Last updated on FEBRUARY 03, 2019

適用範囲:

Oracle Database - Enterprise Edition - バージョン 12.2.0.1 以降
この文書の内容はすべてのプラットフォームに適用されます。
本文書利用上のご注意   本文書は英語の文書 Document 2448270.1 (最終メジャー更新日: 2018年09月29日) の日本語翻訳版です。   英語の文書のメジャー更新に応じて本文書を随時更新いたします。

現象

pdbをdropした後で、ASM Flex Filegroup のスペースを開放しない場合があります。

例:

##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



変更点

12.2でASM Flex Filegroupを使用しています。

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


本書の内容
現象
変更点
原因
解決策
参照情報

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