Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS) は 小規模から大規模までスケーラブルな性能かつ柔軟な価格で提供可能とした新たなデータベースサービスです。ニーズの増大に応じて既存のVMクラスタに対して簡単に VM (Vehicle Machine) を追加または削除することができます。
ということで、前回作成した ExaDB-XS へ VMノード追加と削除してみてみます。
■ VMクラスタへのVMの追加
● VMノード追加
VMクラスタに仮想マシンを 2ノード追加してみてみます。
1) VMクラスタ画面
作成した ExaDB-XS 画面の Resources にある [仮想マシン]を選択し、[仮想マシンの追加]ボタンをクリック
2) 仮想マシンの追加画面
追加する仮想マシンの数を入力し、[追加]をクリック。ここでは２つ追加してみてみます。
3）仮想マシン追加中
4）仮想マシン追加完了
5) ログ・メッセージ確認
● 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つのドット記号をクリックして[削除]をクリック
2) 仮想マシンの削除画面
VMの名前を入力し、[削除]をクリック
3) 仮想マシンの削除中
4) 仮想マシンの削除完了
4) ログメッセージ確認
● 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確認
削除したインスタンスの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で削除してみてみます。
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確認
削除したインスタンスの 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
・ 表領域確認
削除したインスタンスの 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で削除してみてみます。
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
■ 参考
・ Press Release
- Oracle Announces Exadata Exascale, World’s Only Intelligent Data Architecture for the Cloud
・ Documents
- Exadata Database Service on Exascale Infrastructure
- Provision Oracle Exadata Database Service on Exascale Infrastructure
- Oracle Exadata Database Service on Exascale Infrastructure
- Exadata Database Service on Exascale Infrastructure
- Oracle ORAchkおよびOracle EXAchkの概要
- UNDO表領域の削除
・ Blog
- Introducing Oracle Exadata Database Service on Exascale Infrastructure
- Exadata Exascale - World's Only Intelligent Data Architecture for Cloud
- Global Industry Analyst Perspectives on Oracle Exadata Exascale
- Exadata の2023年の振り返り
・ YouTube
- Oracle Exadata Exascale: The World’s Only Intelligent Data Architecture for Cloud
- Exadata Database Service on Exascale Infrastructure Provisioning
・ x.com
- Oracle Exadata (@OracleExadata)