[Oracle Cloud] Exadata Exascale (ExaDB-XS) へ VMノード追加/削除してみてみた

Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS) は 小規模から大規模までスケーラブルな性能かつ柔軟な価格で提供可能とした新たなデータベースサービスです。ニーズの増大に応じて既存のVMクラスタに対して簡単に VM (Vehicle Machine) を追加または削除することができます。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/300934f5-8ac5-cc19-8eb9-b4612660ce22.png)
ということで、前回作成した [ExaDB-XS](https://qiita.com/shirok/items/d0f1ad7864c7f4a9f5b7) へ VMノード追加と削除してみてみます。

https://qiita.com/shirok/items/d0f1ad7864c7f4a9f5b7


# ■ VMクラスタへのVMの追加
## ● VMノード追加
VMクラスタに仮想マシンを 2ノード追加してみてみます。
**1) VMクラスタ画面**
作成した ExaDB-XS 画面の Resources にある [仮想マシン]を選択し、[仮想マシンの追加]ボタンをクリック
![21_仮想マシンの追加01.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/bd227ce7-5aba-8861-f48a-cea288d0a41c.png)


**2) 仮想マシンの追加画面**
追加する仮想マシンの数を入力し、[追加]をクリック。ここでは２つ追加してみてみます。
![21_仮想マシンの追加02.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/f03bc16e-7ec5-5989-6895-659678719788.png)


**3）仮想マシン追加中**
![21_仮想マシンの追加03.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c0c10a29-d6a5-2c92-2aeb-a2e67a788620.png)



**4）仮想マシン追加完了**
![21_仮想マシンの追加04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/645268c5-8db9-ecb3-b6a0-1d2a7bea14a3.png)

**5) ログ・メッセージ確認**
![21_仮想マシンの追加06.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/713cbe77-66d2-7b2b-65c7-02b87bb54afc.png)

## ● Container Database (CDB) 確認
Instance, UNDO表領域, REDOなどが追加されていることを確認
**・ CDB へ SQLcl 接続**
```
[opc@exadb-xs1-55470 ~]$ sudo su - oracle
	Last login: Thu Jul 11 10:28:45 UTC 2024

[oracle@exadb-xs1-55470 ~]$ source CDB23ai.env
[oracle@exadb-xs1-55470 ~]$ sql / as sysdba


	SQLcl: Release 24.1 Production on Thu Jul 11 10:37:57 2024

	Copyright (c) 1982, 2024, Oracle.  All rights reserved.

	Connected to:
	Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production
	Version 23.4.0.24.05
```


**・ gv$instance確認**
```
SQL> select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION,STATUS, THREAD#,INSTANCE_ROLE,DATABASE_TYPE from gv$instance order by 1;

   INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME          VERSION       STATUS       THREAD# INSTANCE_ROLE       DATABASE_TYPE
__________________ ________________ __________________ _____________ _________ __________ ___________________ ________________
                 1 CDB23ai1         exadb-xs1-55470    23.0.0.0.0    OPEN               1 PRIMARY_INSTANCE    RAC
                 2 CDB23ai2         exadb-xs2-55471    23.0.0.0.0    OPEN               2 PRIMARY_INSTANCE    RAC
                 3 CDB23ai3         exadb-xs3-45716    23.0.0.0.0    OPEN               3 PRIMARY_INSTANCE    RAC
                 4 CDB23ai4         exadb-xs4-45715    23.0.0.0.0    OPEN               4 PRIMARY_INSTANCE    RAC
```

**・ gv$database確認**
```
SQL>  select DBID, CDB, NAME, DB_UNIQUE_NAME, INST_ID, LOG_MODE,FLASHBACK_ON, PROTECTION_MODE from gv$database;

         DBID CDB    NAME       DB_UNIQUE_NAME        INST_ID LOG_MODE      FLASHBACK_ON    PROTECTION_MODE
_____________ ______ __________ __________________ __________ _____________ _______________ ______________________
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             1 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             3 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             4 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             2 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
```

**・ Data Files確認**
```
SQL>  SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME
;

	TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                            Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
	__________________ ___________ ____________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
	SYSAUX                    6096 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSAUX.OMF.664A5E60      YES                               4096   33,554,432             8192 YES
	SYSTEM                    2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSTEM.OMF.4037C9A4      YES                               4096   33,554,432             8192 YES
	TEMP                     17408 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/TEMPFILE/TEMP.OMF.2F25E22B        YES                              16384      524,288             8192 YES
	UNDOTBS1                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS1.OMF.0F3E2866    YES                               4096      524,288             8192 YES
	UNDOTBS2                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS2.OMF.59C33A6B    YES                               4096      524,288             8192 YES
	UNDOTBS3                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS3.OMF.1461C6BD    YES                               4096      524,288             8192 YES
	UNDOTBS4                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS4.OMF.51EAA52B    YES                               4096      524,288             8192 YES
	USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/USERS.OMF.326FA4F8       YES                                500   33,554,432             8192 YES

	8 rows selected.
```

**・ Redo Log確認**
```
SQL>  SELECT
    b.THREAD#
    ,b.MEMBERS
    ,a.GROUP#
    ,b.SEQUENCE#
    ,a.MEMBER
    ,b.bytes/1024/1024 as "Bytes(MB)"
    ,a.TYPE
    ,b.STATUS
    ,b.ARCHIVED
FROM
v$logfile a
,v$log b
WHERE
a.GROUP#=b.GROUP#
ORDER BY GROUP#;


   THREAD#    MEMBERS    GROUP#    SEQUENCE# MEMBER                                                                                                   Bytes(MB) TYPE      STATUS      ARCHIVED
__________ __________ _________ ____________ _____________________________________________________________________________________________________ ____________ _________ ___________ ___________
         1          1         1         1085 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_1.OMF.0D7A9596             4000 ONLINE    CURRENT     NO
         1          1         2         1082 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_2.OMF.4989B1BB             4000 ONLINE    INACTIVE    YES
         1          1         3         1083 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_3.OMF.353F433A             4000 ONLINE    INACTIVE    YES
         1          1         4         1084 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_4.OMF.518E17CA             4000 ONLINE    INACTIVE    YES
         2          1         5         1049 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_5.OMF.55ED58F7             4000 ONLINE    INACTIVE    YES
         2          1         6         1050 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_6.OMF.112BC50C             4000 ONLINE    CURRENT     NO
         2          1         7         1047 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_7.OMF.0D0C6A2F             4000 ONLINE    INACTIVE    YES
         2          1         8         1048 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_8.OMF.57A73396             4000 ONLINE    INACTIVE    YES
         3          1         9            1 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_9.OMF.623D2D7C             4000 ONLINE    INACTIVE    YES
         3          1        10            2 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_10.OMF.5ECCBC3C            4000 ONLINE    INACTIVE    YES
         3          1        11            3 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_11.OMF.0B4D158A            4000 ONLINE    INACTIVE    YES
         3          1        12            4 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_12.OMF.3CA2E154            4000 ONLINE    CURRENT     NO
         4          1        13            1 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_13.OMF.50A9C4FA            4000 ONLINE    INACTIVE    YES
         4          1        14            2 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_14.OMF.1F150ED9            4000 ONLINE    INACTIVE    YES
         4          1        15            3 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_15.OMF.52E1D786            4000 ONLINE    INACTIVE    YES
         4          1        16            4 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_16.OMF.4EED4DA5            4000 ONLINE    CURRENT     NO

16 rows selected.
```


## ● Pluggable Database (PDB) 確認
UNDO表領域が追加されていることを確認
**・ PDB へ SQLcl 接続**
```
SQL> alter session set container=PDB23AI;

    Session altered.

SQL> show pdbs

   CON_ID CON_NAME    OPENMODE      RESTRICTED
_________ ___________ _____________ _____________
        3 PDB23AI     READ WRITE    NO
```

**・ 表領域確認**
```
SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME;


	TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                                                             Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
	__________________ ___________ _____________________________________________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
	SYSAUX                    4696 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSAUX.OMF.615A3B80      YES                               4096   33,554,432             8192 YES
	SYSTEM                     600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSTEM.OMF.1CA59B45      YES                               4096   33,554,432             8192 YES
	TEMP                      1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/TEMPFILE/TEMP.OMF.39A0866D        NO                                   0            0             8192 YES
	UNDOTBS1                   600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDOTBS1.OMF.24F9A4A0    YES                               4096      524,288             8192 YES
	UNDO_4                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_4.OMF.328C79F8      YES                               4096      524,288             8192 YES
	UNDO_7                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_7.OMF.28A4961E      YES                               4096      524,288             8192 YES
	UNDO_8                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_8.OMF.63495B44      YES                               4096      524,288             8192 YES
	USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/USERS.OMF.67813A53       YES                              16384   33,554,432             8192 YES

	8 rows selected.
```



## ● Grid Infrastructure リソース確認
Grid Infrastructure リソースが追加されていることを確認
**・ gridユーザー・ログイン**
```
[opc@exadb-xs1-55470 ~]$ sudo su - grid
Last login: Thu Jul 11 10:28:43 UTC 2024
```

**・ クラスタ・リソース状態**
```
[grid@exadb-xs1-55470 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.acfsrm
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.ccmb
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.chad
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.edcvmrfc.vexdb78.acfs
               ONLINE  ONLINE       exadb-xs1-55470          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
               ONLINE  ONLINE       exadb-xs2-55471          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
               ONLINE  ONLINE       exadb-xs3-45716          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
               ONLINE  ONLINE       exadb-xs4-45715          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
ora.net1.network
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.ons
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
               ONLINE  ONLINE       exadb-xs3-45716          STABLE
               ONLINE  ONLINE       exadb-xs4-45715          STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       exadb-xs3-45716          STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.cdb23ai_ashburn.cdb23ai_pdb23ai.paas.oracle.com.svc
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          STABLE
      3        ONLINE  ONLINE       exadb-xs3-45716          STABLE
      4        ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.cdb23ai_ashburn.db
      1        ONLINE  ONLINE       exadb-xs1-55470          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
      3        ONLINE  ONLINE       exadb-xs3-45716          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
      4        ONLINE  ONLINE       exadb-xs4-45715          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
ora.cdb23ai_ashburn.pdb23ai.pdb
      1        ONLINE  ONLINE       exadb-xs1-55470          READ WRITE,STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          READ WRITE,STABLE
      3        ONLINE  ONLINE       exadb-xs3-45716          READ WRITE,STABLE
      4        ONLINE  ONLINE       exadb-xs4-45715          READ WRITE,STABLE
ora.cdp1.cdp
      1        ONLINE  ONLINE       exadb-xs3-45716          STABLE
ora.cdp2.cdp
      1        ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.cdp3.cdp
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.cvu
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.exadb-xs1-55470.vip
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.exadb-xs2-55471.vip
      1        ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.exadb-xs3-45716.vip
      1        ONLINE  ONLINE       exadb-xs3-45716          STABLE
ora.exadb-xs4-45715.vip
      1        ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       exadb-xs3-45716          STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       exadb-xs4-45715          STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
--------------------------------------------------------------------------------
```



**・ RAC Node確認**
```
[grid@exadb-xs1-55470 ~]$ olsnodes -n -s
	exadb-xs1-55470	1	Active
	exadb-xs2-55471	2	Active
	exadb-xs3-45716	3	Active
	exadb-xs4-45715	4	Active
```

**・ Interconnect確認**
```:Node1
[grid@exadb-xs1-55470 ~]$ olsnodes -l -p
exadb-xs1-55470	100.107.1.48,100.107.1.49
```
```:Node2
[grid@exadb-xs2-55471 ~]$ olsnodes -l -p
exadb-xs2-55471	100.107.1.50,100.107.1.51
```
```:Node3
[grid@exadb-xs3-45716 ~]$ olsnodes -l -p
exadb-xs3-45716	100.107.1.116,100.107.1.117
```
```:Node4
[grid@exadb-xs4-45715 ~]$ olsnodes -l -p
exadb-xs4-45715	100.107.1.114,100.107.1.115
```



# ■ VMクラスタの VM削除
プロビジョニングされたクラスタから仮想マシンを削除するには、この手順を使用します。 

## ● VMノード削除
**1) VMクラスタ画面**
作成した ExaDB-XS 画面の Resources にある [仮想マシン]を選択し、削除する仮想マシンの右側にある 3つのドット記号をクリックして[削除]をクリック

![61_仮想マシンNode4削除02.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/88b1e106-7530-e93c-52a1-ad955e67fc7c.png)

**2) 仮想マシンの削除画面**
VMの名前を入力し、[削除]をクリック
![61_仮想マシンNode4削除03.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/7ff74e73-43f0-a201-fbae-aacd54218f21.png)

**3) 仮想マシンの削除中**
![61_仮想マシンNode4削除04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/2d17c53b-6c62-a59d-bb21-e4e2e1e2d5a3.png)

**4) 仮想マシンの削除完了**
![61_仮想マシンNode4削除05.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/650bb46c-f529-c6e1-67da-3ed6b5ef5dcb.png)

**4) ログメッセージ確認**
![61_仮想マシンNode4削除06.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/974b64c7-9e0e-309a-5825-9b9e0a7b300b.png)



## ● Container Database (CDB) 確認
**・ CDB へ SQLcl 接続**
インスタンス削除されていることを確認
```
[opc@exadb-xs1-55470 ~]$ sudo su - oracle
[oracle@exadb-xs1-55470 ~]$ source CDB23ai.env
[oracle@exadb-xs1-55470 ~]$ sql / as sysdba


SQLcl: Release 24.1 Production on Tue Jul 30 03:22:57 2024

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Connected to:
Oracle Database 23ai EE Extreme Perf Release 23.0.0.0.0 - Production
Version 23.4.0.24.05
```

**・ gv$instance確認**
```
SQL> select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION,STATUS, THREAD#,INSTANCE_ROLE,DATABASE_TYPE from gv$instance order by 1;

   INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME          VERSION       STATUS       THREAD# INSTANCE_ROLE       DATABASE_TYPE
__________________ ________________ __________________ _____________ _________ __________ ___________________ ________________
                 1 CDB23ai1         exadb-xs1-55470    23.0.0.0.0    OPEN               1 PRIMARY_INSTANCE    RAC
                 2 CDB23ai2         exadb-xs2-55471    23.0.0.0.0    OPEN               2 PRIMARY_INSTANCE    RAC
```

**・ gv$database確認**
```
SQL> select DBID, CDB, NAME, DB_UNIQUE_NAME, INST_ID, LOG_MODE,FLASHBACK_ON, PROTECTION_MODE from gv$database;

         DBID CDB    NAME       DB_UNIQUE_NAME        INST_ID LOG_MODE      FLASHBACK_ON    PROTECTION_MODE
_____________ ______ __________ __________________ __________ _____________ _______________ ______________________
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             2 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
   2166430355 YES    CDB23AI    CDB23ai_Ashburn             1 ARCHIVELOG    YES             MAXIMUM PERFORMANCE
```


**・ Data Files確認**

:::note info
削除したインスタンスのUNDO表領域は削除されないため、必要に応じて手動で削除します。
:::
```
SQL> SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME
;

TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                            Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
__________________ ___________ ____________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
SYSAUX                    6096 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSAUX.OMF.664A5E60      YES                               4096   33,554,432             8192 YES
SYSTEM                    2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSTEM.OMF.4037C9A4      YES                               4096   33,554,432             8192 YES
TEMP                     17408 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/TEMPFILE/TEMP.OMF.2F25E22B        YES                              16384      524,288             8192 YES
UNDOTBS1                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS1.OMF.0F3E2866    YES                               4096      524,288             8192 YES
UNDOTBS2                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS2.OMF.59C33A6B    YES                               4096      524,288             8192 YES
UNDOTBS3                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS3.OMF.1461C6BD    YES                               4096      524,288             8192 YES
UNDOTBS4                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS4.OMF.51EAA52B    YES                               4096      524,288             8192 YES
USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/USERS.OMF.326FA4F8       YES                                500   33,554,432             8192 YES

8 rows selected.
```


### ・ 参考: CDBの不要UNDO表領域の削除 
削除したインスタンスの UNDO表領域をSQLで削除してみてみます。

:::note info
UNDO表領域は、現在どのインスタンスでも使用されていない場合にのみ削除できます。UNDO表領域に処理中のトランザクションが含まれている場合(トランザクションが失敗してまだリカバリされていない場合など)、DROP TABLESPACE文は失敗します。しかし、DROP TABLESPACEは、UNDO表領域に期限切れでない(保存期間内である)ロールバック情報が含まれている場合でもUNDO表領域を削除するため、既存の問合せでロールバック情報を必要とする場合は、UNDO表領域を削除しないように注意する必要があります。
:::

**1) UNDO 表領域削除**
```
SQL> DROP TABLESPACE UNDOTBS3 INCLUDING CONTENTS AND DATAFILES;

      TABLESPACE UNDOTBS3 dropped.

SQL> DROP TABLESPACE UNDOTBS4 INCLUDING CONTENTS AND DATAFILES;

      TABLESPACE UNDOTBS4 dropped.
```

**2) UNDO 表領域削除確認**
```
SQL> SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME;

      TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                            Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
      __________________ ___________ ____________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
      SYSAUX                    6096 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSAUX.OMF.664A5E60      YES                               4096   33,554,432             8192 YES
      SYSTEM                    2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/SYSTEM.OMF.4037C9A4      YES                               4096   33,554,432             8192 YES
      TEMP                     17408 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/TEMPFILE/TEMP.OMF.2F25E22B        YES                              16384      524,288             8192 YES
      UNDOTBS1                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS1.OMF.0F3E2866    YES                               4096      524,288             8192 YES
      UNDOTBS2                  2000 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/UNDOTBS2.OMF.59C33A6B    YES                               4096      524,288             8192 YES
      USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/DATAFILE/USERS.OMF.326FA4F8       YES                                500   33,554,432             8192 YES

      6 rows selected.
```
**・ Redo Log確認**

:::note info
削除したインスタンスの REDOファイルは削除されないため、必要に応じて手動で削除します。
REDOログ・グループを削除するには、ALTER DATABASEシステム権限が必要です。REDOログ・グループを削除する前に、次の制限と注意点について検討してください。
・　グループ内のメンバー数にかかわらず、インスタンスには少なくとも2つのREDOログ・ファイルのグループが必要です。(1つのグループは1つ以上のメンバーから構成されます。)
・　REDOログ・グループは、非アクティブである場合にのみ削除できます。カレントのグループを削除する必要がある場合は、最初にログ・スイッチを発生させる必要があります。
・ 削除する前に、REDOログ・グループがアーカイブされていることを確認します(アーカイブが使用可能になっている場合)。アーカイブされているかどうかを確認するには、V$LOGビューを使用します。 
:::

```
SQL> SELECT
    b.THREAD#
    ,b.MEMBERS
    ,a.GROUP#
    ,b.SEQUENCE#
    ,a.MEMBER
    ,b.bytes/1024/1024 as "Bytes(MB)"
    ,a.TYPE
    ,b.STATUS
    ,b.ARCHIVED
FROM
v$logfile a
,v$log b
WHERE
a.GROUP#=b.GROUP#
ORDER BY GROUP#;

   THREAD#    MEMBERS    GROUP#    SEQUENCE# MEMBER                                                                                                   Bytes(MB) TYPE      STATUS      ARCHIVED
__________ __________ _________ ____________ _____________________________________________________________________________________________________ ____________ _________ ___________ ___________
         1          1         1         2037 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_1.OMF.0D7A9596             4000 ONLINE    CURRENT     NO
         1          1         2         2034 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_2.OMF.4989B1BB             4000 ONLINE    INACTIVE    YES
         1          1         3         2035 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_3.OMF.353F433A             4000 ONLINE    INACTIVE    YES
         1          1         4         2036 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_4.OMF.518E17CA             4000 ONLINE    INACTIVE    YES
         2          1         5         1921 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_5.OMF.55ED58F7             4000 ONLINE    INACTIVE    YES
         2          1         6         1922 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_6.OMF.112BC50C             4000 ONLINE    INACTIVE    YES
         2          1         7         1923 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_7.OMF.0D0C6A2F             4000 ONLINE    INACTIVE    YES
         2          1         8         1924 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_8.OMF.57A73396             4000 ONLINE    CURRENT     NO
         3          1         9          241 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_9.OMF.623D2D7C             4000 ONLINE    INACTIVE    YES
         3          1        10          242 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_10.OMF.5ECCBC3C            4000 ONLINE    INACTIVE    YES
         3          1        11          239 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_11.OMF.0B4D158A            4000 ONLINE    INACTIVE    YES
         3          1        12          240 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_12.OMF.3CA2E154            4000 ONLINE    INACTIVE    YES
         4          1        13          233 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_13.OMF.50A9C4FA            4000 ONLINE    INACTIVE    YES
         4          1        14          234 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_14.OMF.1F150ED9            4000 ONLINE    INACTIVE    YES
         4          1        15          235 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_15.OMF.52E1D786            4000 ONLINE    INACTIVE    YES
         4          1        16          232 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/ONLINELOG/group_16.OMF.4EED4DA5            4000 ONLINE    INACTIVE    YES

16 rows selected.
```

## ● Pluggable Database (PDB) 確認
**・ PDB へ SQLcl 接続**
```
SQL> alter session set container=PDB23AI;

    Session altered.

SQL> show pdbs

   CON_ID CON_NAME    OPENMODE      RESTRICTED
_________ ___________ _____________ _____________
        3 PDB23AI     READ WRITE    NO
```

**・ 表領域確認**

:::note info
削除したインスタンスの UNDO表領域は削除されないため、必要に応じて手動で削除します。
:::

```
SQL> SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME;


TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                                                             Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
__________________ ___________ _____________________________________________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
SYSAUX                    4696 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSAUX.OMF.615A3B80      YES                               4096   33,554,432             8192 YES
SYSTEM                     600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSTEM.OMF.1CA59B45      YES                               4096   33,554,432             8192 YES
TEMP                      1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/TEMPFILE/TEMP.OMF.39A0866D        NO                                   0            0             8192 YES
UNDOTBS1                   600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDOTBS1.OMF.24F9A4A0    YES                               4096      524,288             8192 YES
UNDO_4                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_4.OMF.328C79F8      YES                               4096      524,288             8192 YES
UNDO_7                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_7.OMF.28A4961E      YES                               4096      524,288             8192 YES
UNDO_8                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_8.OMF.63495B44      YES                               4096      524,288             8192 YES
USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/USERS.OMF.67813A53       YES                              16384   33,554,432             8192 YES

8 rows selected.
```


### ・ 参考: PDBの不要UNDO表領域の削除 
削除したインスタンスの UNDO表領域をSQLで削除してみてみます。


:::note info
UNDO表領域は、現在どのインスタンスでも使用されていない場合にのみ削除できます。UNDO表領域に処理中のトランザクションが含まれている場合(トランザクションが失敗してまだリカバリされていない場合など)、DROP TABLESPACE文は失敗します。しかし、DROP TABLESPACEは、UNDO表領域に期限切れでない(保存期間内である)ロールバック情報が含まれている場合でもUNDO表領域を削除するため、既存の問合せでロールバック情報を必要とする場合は、UNDO表領域を削除しないように注意する必要があります。
:::

**1) UNDO 表領域削除**
```
SQL> DROP TABLESPACE UNDO_8 INCLUDING CONTENTS AND DATAFILES;

      TABLESPACE UNDO_8 dropped.

SQL> DROP TABLESPACE UNDO_7 INCLUDING CONTENTS AND DATAFILES;

      TABLESPACE UNDO_7 dropped.
```
**2) UNDO 表領域削除確認**
```
SQL> SELECT 
    a.TABLESPACE_NAME 
    ,a.BYTES/1024/1024 as "Size(MB)"
    ,a.FILE_NAME
    ,a.autoextensible as "Auto_Extent"
    ,a.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(a.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,b.BLOCK_SIZE
    ,b.BIGFILE
FROM DBA_DATA_FILES a
    , DBA_TABLESPACES b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
union all
SELECT 
    x.TABLESPACE_NAME 
    ,x.BYTES/1024/1024 as "Size(MB)"
    ,x.FILE_NAME
    ,x.autoextensible as "Auto_Extent"
    ,x.increment_by * (select VALUE from v$parameter where NAME='db_block_size') /1024/1024 as "Auto_Extent_Size(MB)"
    ,TO_CHAR(x.MAXBYTES/1024/1024,'999,999,999') as "MAX_SIZE(MB)"
    ,y.BLOCK_SIZE
    ,y.BIGFILE
FROM dba_temp_files x
    , DBA_TABLESPACES y
WHERE x.TABLESPACE_NAME=y.TABLESPACE_NAME  
ORDER By TABLESPACE_NAME;

      TABLESPACE_NAME       Size(MB) FILE_NAME                                                                                                                             Auto_Extent       Auto_Extent_Size(MB) MAX_SIZE(MB)       BLOCK_SIZE BIGFILE
      __________________ ___________ _____________________________________________________________________________________________________________________________________ ______________ _______________________ _______________ _____________ __________
      SYSAUX                    4696 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSAUX.OMF.615A3B80      YES                               4096   33,554,432             8192 YES
      SYSTEM                     600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/SYSTEM.OMF.1CA59B45      YES                               4096   33,554,432             8192 YES
      TEMP                      1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/TEMPFILE/TEMP.OMF.39A0866D        NO                                   0            0             8192 YES
      UNDOTBS1                   600 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDOTBS1.OMF.24F9A4A0    YES                               4096      524,288             8192 YES
      UNDO_4                  95.375 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/UNDO_4.OMF.328C79F8      YES                               4096      524,288             8192 YES
      USERS                     1024 @eDcvMrFC/CLUSTER-9A13620AC695CF0FBF72E1086F987125/CDB23AI_ASHBURN/1B4CB39D5AF74C13E06314016E0A14F8/DATAFILE/USERS.OMF.67813A53       YES                              16384   33,554,432             8192 YES

      6 rows selected.
```
## ● Grid Infrastructure リソース確認
削除VMインスタンスの Grid Infrastructure リソースが削除されていることを確認

**・ gridユーザー・ログイン**
 ```
[opc@exadb-xs1-55470 ~]$ sudo su - grid
```

・ クラスタ・リソース状態
```
[grid@exadb-xs1-55470 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.acfsrm
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.ccmb
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.chad
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.edcvmrfc.vexdb78.acfs
               ONLINE  ONLINE       exadb-xs1-55470          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
               ONLINE  ONLINE       exadb-xs2-55471          mounted on /var/opt/
                                                                                 oracle/dbaas_acfs,ST
                                                                                 ABLE
ora.net1.network
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.ons
               ONLINE  ONLINE       exadb-xs1-55470          STABLE
               ONLINE  ONLINE       exadb-xs2-55471          STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.cdb23ai_ashburn.cdb23ai_pdb23ai.paas.oracle.com.svc
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.cdb23ai_ashburn.db
      1        ONLINE  ONLINE       exadb-xs1-55470          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          Open,HOME=/u02/app/o
                                                             racle/product/23.0.0
                                                             .0/dbhome_1,STABLE
ora.cdb23ai_ashburn.pdb23ai.pdb
      1        ONLINE  ONLINE       exadb-xs1-55470          READ WRITE,STABLE
      2        ONLINE  ONLINE       exadb-xs2-55471          READ WRITE,STABLE
ora.cdp1.cdp
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.cdp2.cdp
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.cdp3.cdp
      1        ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.cvu
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.exadb-xs1-55470.vip
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.exadb-xs2-55471.vip
      1        ONLINE  ONLINE       exadb-xs2-55471          STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       exadb-xs1-55470          STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       exadb-xs2-55471          STABLE
--------------------------------------------------------------------------------
```

**・ RAC Node確認**
```
[grid@exadb-xs1-55470 ~]$ olsnodes -n -s
exadb-xs1-55470	1	Active
exadb-xs2-55471	2	Active
```






# ■ 参考
**・ [VMクラスタからのVMの追加または削除](https://docs.oracle.com/ja-jp/iaas/exadb-xs/doc/manage-vm-clusters.html#EXDXS-GUID-2CD57B89-941C-4961-B9F8-343130068D82)**


**・ Press Release**
　- [Oracle Announces Exadata Exascale, World’s Only Intelligent Data Architecture for the Cloud](https://www.oracle.com/news/announcement/oracle-announces-exadata-exascale-worlds-only-intelligent-data-architecture-for-the-cloud-2024-07-11/)
**・ Documents**
　- [Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/engineered-systems/exadata-database-exascale/exdxs/)
　- [Provision Oracle Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/learn/exadb-xs-db/#introduction)
　- [Oracle Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en-us/iaas/exadb-xs/index.html)
　- [Exadata Database Service on Exascale Infrastructure](https://docs.oracle.com/en/engineered-systems/exadata-database-exascale/exdxs/overview-exadb-xs-service.html)
　- [Oracle ORAchkおよびOracle EXAchkの概要](https://docs.oracle.com/cd/F19136_01/atnms/introduction-orachk-and-exachk.html)
　- [UNDO表領域の削除](https://docs.oracle.com/cd/F19136_01/admin/managing-undo.html#GUID-825E2A2F-7AEB-4D7A-B8BA-B1533D7BE512)

**・ Blog**
　- [Introducing Oracle Exadata Database Service on Exascale Infrastructure](https://blogs.oracle.com/database/post/introducing-oracle-exadata-database-service-on-exascale-infrastructure)
　- [Exadata Exascale - World's Only Intelligent Data Architecture for Cloud](https://blogs.oracle.com/exadata/post/exadata-exascale)
　- [Global Industry Analyst Perspectives on Oracle Exadata Exascale ](https://blogs.oracle.com/infrastructure/post/global-industry-analyst-perspectives-on-oracle-exadata-exascale)
　- [Exadata の2023年の振り返り](https://blogs.oracle.com/oracle4engineer/post/exadata-2023-recap-jp)
**・ YouTube**
　- [Oracle Exadata Exascale: The World’s Only Intelligent Data Architecture for Cloud ](https://www.youtube.com/watch?v=XtV4Dny7c7c)
　- [Exadata Database Service on Exascale Infrastructure Provisioning](https://www.youtube.com/watch?v=ggh0pIuPj2g)
**・ x.com**
　- [Oracle Exadata (@OracleExadata)](https://x.com/oracleexadata)