ExaDB-D dbaascli で出来ること

ExaDB-D dbaascli で出来ること
dbaascli 23.1.1.0.1 (230113)
2023/11/21
(一部 version 23.4.1.0.0)

View Slide

dbaascli --help
[oracle@vm01wasa-zb1hy1 ~]$ dbaascli --help
DBAAS CLI version 23.1.1.0.1
Executing command --help
Usage: dbaascli [] []
Following are the possible flags:
--help - display help.
The following are the supported objects and associated commands. To view the available for a command, use the --help flag on the
respective command.
admin updateStack - install/update a dbaastools RPM
admin showLatestStackVersion - shows the version of latest available dbaastools stack to update
diag collect - diagnostic log collection
diag healthcheck
cswLib download - CSWLIB download/update dbnid bits.
cswLib showImages - CSWLIB list available DB/GI images.
cswLib listLocal - CSWLIB list locally available DB/GI images.
cswLib deleteLocal - CSWLIB deletes local image.
database bounce - bounce a specific database.
database changePassword - change the password for a given user in the database.
database addInstance - allows user to add the database instance on the specified node.
database deleteInstance - allows user to delete the database instance on the specified node.
database convertToPDB - to convert given non-CDB database to PDB.
database getDetails - display details about a specific database.
database modifyParameters - modifies or resets initialization parameters for a given Oracle database.
database move - move DB from one home to another home.
database start - start a specific database.
database status - checks status of a database.
database stop - stop a specific database.
database upgrade - performs the upgrade of an Oracle database.
database upgradeTimeZone - run the dst postinstalls on the mentioned dbname.
dbaascli で出来ること
Copyright © 2023, Oracle and/or its affiliates,
2
本リリースでの
変更点を赤字表示

View Slide

dbaascli --help
database create - create a new database.
database duplicate - create a new database from active database.
database delete - delete the given database.
database runDatapatch - patches the database.
database backup - performs database backup operations.
database recover - performs database recovery.
database getPDBs - display information of PDBs in specified database.
database createTemplate - create a new template from the specified database.
dataguard failover - failover to Standby when all db nodes are up. This command is expected to fail if primary is down. Failover can be
performed using 'force' operation at your own risk.
dataguard reinstate - reinstate failed Primary as new Standby
dataguard status - show dataguard status.
dataguard switchover - switchover to Standby.
dataguard verify - checks cluster readiness for hosting a standby database.
dataguard configureAWR - enables generation of AWR reports for standby database from primary database.
dataguard convertStandby - facilitates type conversion for Standby Database.
dataguard configureRedoApply - manage and monitor the redo apply setting for a given Oracle database configured for Dataguard.
dataguard prepareStandbyBlob - generate a TAR file containing the primary database wallet to export for standby PDB creation.
dataguard updateDGConfigAttributes - update Dataguard Automation Attributes across all nodes of a cluster.
dataguard showDGConfigAttributes - show Dataguard Automation Attributes on a cluster.
dbHome patch - patches the dbhome from one patch level to another.
dbHome create - create database Oracle Home.
dbHome delete - delete the given Oracle Database Home.
dbHome getDetails - display details of specified Oracle home.
dbHome getDatabases - display details of databases in specified Oracle home.
grid changePassword - change the sys and asmsnmp passwords for grid.
grid upgrade - upgrade the grid from one major version to another.
grid patch - patch the grid to the specified minor version.
grid configureTCPS - configure TCPS for existing cluster.
grid rotateTCPSCert - rotate TCPS certificates.
grid getDetails - display the details of configured grid home.
3

View Slide

dbaascli --help
job getStatus - display the status info of specified job.
pdb localClone - clone a PDB from another PDB in the same database.
pdb getConnectString - get connectString of the specified PDB.
pdb remoteClone - clone the specified PDB from an another database.
pdb close - close a PDB.
pdb create - create a new PDB.
pdb open - open a PDB.
pdb relocate - relocate the specified PDB from remote DB into local DB.
pdb delete - delete a PDB.
pdb bounce - bounce the PDB.
pdb getDetails - get the details of provided PDB in the database.
pdb backup - performs PDB backup operations.
pdb recover - performs PDB recovery.
system getDatabases - list details of all the databases.
system getDBHomes - list the details of all the Oracle homes.
tde setPrimaryHSMKey - change primary HSM(KMS) key for existing HSM(KMS) configuration.
tde setKeyVersion - sets the version of the primary key to be used in DB/CDB or PDB.
tde removeSecondaryHSMKey - remove second HSM(KMS) key from existing HSM(KMS) configuration.
tde hsmToFile - convert HSM(KMS/OKV) based TDE to FILE based TDE.
tde getPrimaryHSMKey - get Primary HSM(KMS) key from existing HSM(KMS) configuration.
tde fileToHSM - convert FILE based TDE to HSM(KMS/OKV) based TDE.
tde addSecondaryHSMKey - add second HSM(KMS) key to existing HSM(KMS) configuration.
tde backup - backup TDE wallets to local disk.
tde changePassword - changes TDE keystore password as well as DB wallet password for the alias tde_ks_passwd.
tde listKeys - list TDE master keys.
tde status - show TDE configuration status.
tde getMKIDForKeyVersionOCID - get Masterkey ID associated to KMS key version OCID.
tde getHSMKeys - get TDE active key details.
tde encryptTablespacesInPDB - encrypt all the tablespaces present in the given PDB.
tde enableWalletRoot - enable wallet_root spfile parameter for existing database.
tde exportTDEKey - export TDE master encryption key into a file.
tde rotateMasterKey - rotate TDE master key.
4

View Slide

dbaascli --help
[root@wasabi-isfff1 ~]# dbaascli --help
Following are the supported objects and associated commands. To view the available for a command, use the --help flag on the respective
command.
admin updateStack - install/update a dbaastools rpm
admin showLatestStackVersion - shows the version of latest available dbaastools stack to update
diag healthCheck - diagnostic healthcheck
cswLib list - list available images.
cswLib deleteLocal - CSWLIB deletes local image.
database bounce - help for database bounce.
database start - help for database start.
database status - checks status of a Database.
database stop - help for database stop.
続く
5
前回

View Slide

dbaascli --help
database backup - performs database backup operations.
database recover - performs database recovery.
database createTemplate - create a new template from the specified database.
dataguard healthCheck - dataguard Healthcheck API.
dataguard prepareStandbyBlob - generate a TAR file containing the primary database wallet to export for standby PDB creation.
dbHome delete - delete the given Oracle Database Home.
dbHome getDetails - display details of specified Oracle Home.
dbHome getDatabases - display details of databases in specified Oracle Home.
6
前回

View Slide

dbaascli --help
pdb connectString - get connectString of the specified PDB.
pdb bounce - bounce the PDB.
pdb backup - performs PDB backup operations.
pdb recover - performs PDB recovery.
system getDBHomes - list the details of all the oracle homes.
tde rotate masterkey - rotate TDE master key.
7
前回

View Slide

dbaascli --help
[root@orcl-jyvid1 ~]# dbaascli --help
Following are the supported objects and associated commands. To view the available for a command, use the --help flag on the respective
command.
admin showLatestStackVersion - get latest available dbaastools rpm
cpuScale getStatus - shows the details of latest core count update requested from the current VM.
cpuScale update - update CPU core count for each VM in the cluster to the input count value.
domUEvent notify - Notify CPS of a domu event.
cswLib list - list available images.
database bounce - help for database bounce.
database changePassword - help for DATABASE CHANGEPASSWORD.
database configureInstance - allows user to add the database instance on the specified node.
database status - checks status of a Database.
8
前回

View Slide

dbaascli --help
database backup - Performs database backup operations.
database recover - Performs database recovery.
dbHome create - restore Oracle Home from OSS Backup.
dbHome purge - purge an empty Oracle Database Home/s existing on the VM.
dbHome getDetails - display details of specified Oracle Home.
dbImage list - list of available dbimages on dbaas_acfs/dbnid.
dbImage activateBP - activateBP available images.
dbImage purge - purge available images.
9
前回

View Slide

dbaascli --help
pdb bounce - Bounce the PDB.
pdb list - get information of PDBs in a db.
pdb backup - Performs PDB backup operations.
pdb recover - Performs PDB recovery.
system getDBHomes - list the details of all the oracle homes.
tde rotate masterkey - rotate TDE master key.
10
前回

View Slide

dbaascli --help
11

View Slide

dbaascli -v
[oracle@vmem-6gl0h1 ~]$ dbaascli -v
Executing command -v
[oracle@vmem-6gl0h1 ~]$ rpm -qa | grep dbaas
dbaastools_exa-1.0-23.4.1.0.0_231031.1153.x86_64
dbaascli バージョン確認
12
2023/11/21時点

View Slide

host_access_control idle-timeout --help
-m CLIENTALIVECOUNTMAX, --clientalivecountmax=CLIENTALIVECOUNTMAX
ClientAliveCountMax, SSH client idle timeout. The
number of client alive messages which may be sent
without sshd receiving any messages back from the
client. Input is limited from 0 to 100000 (*Exadata
factory default is 0)
-l SHELL, --shell=SHELL
Shell idle timeout. Number of seconds of no input
before the shell will terminate. Input is limited to
0 or from 300 to 31557600 (one year) (*Exadata factory
default is 14400 (4h))
--defaults Set all idle-timeout values to *Exadata factory
defaults
-s, --status Display current idle timeout settings
ssh タイムアウトの延長
13
[root@vmem-6gl0h1 ~]# host_access_control idle-timeout --help
Usage: host_access_control idle-timeout [options] [arguments] [arguments]
--client {integer}
--clientaliveinterval {integer}
--clientalivecountmax {integer}
--shell {integer}
--defaults
--status
Idle Timeout Settings Control
Options:
-h, --help show this help message and exit
-c CLIENT, --client=CLIENT
SSH client idle timeout. Option retained for backwards
compatibility. Number of seconds of inactivity on an
ssh connection before the connection is terminated.
Sets ClientAliveCountMax to 0 and ClientAliveInterval
to the given --client value. Input is limited from 0
to 31557600 (one year) (*Exadata factory default is
600 (10m))
-i CLIENTALIVEINTERVAL, --clientaliveinterval=CLIENTALIVEINTERVAL
ClientAliveInterval, SSH client idle timeout. Number
of seconds of inactivity before a message is sent to
request a response from the client. Input is limited
from 0 (disabled) to 31557600 (one year) (*Exadata
factory default is 600 (10m))
2023/11/21時点

View Slide

host_access_control idle-timeout
[root@vmem-6gl0h1 ~]# host_access_control idle-timeout -l 14400
[2023-11-20 13:22:45 +0900] [INFO] [IMG-SEC-0404] Shell timeout set to 14400
[root@vmem-6gl0h1 ~]# cat /etc/ssh/sshd_config | grep -i inter
ClientAliveInterval 600
[root@vmem-6gl0h1 ~]# host_access_control idle-timeout -c 14400
[2023-11-20 13:23:04 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to 14400
[2023-11-20 13:23:05 +0900] [INFO] [IMG-SEC-0A02] SSHD Service restarted. Changes in effect for new connections.
[root@vmem-6gl0h1 ~]# cat /etc/ssh/sshd_config | grep -i inter
ClientAliveInterval 14400
[root@vmem-6gl0h1 ~]# host_access_control idle-timeout -s
[2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0402] Shell timeout is set to TMOUT=14400
[2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to ClientAliveInterval 14400
[2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to ClientAliveCountMax 0
コマンド実行時のタイムアウトを避けるために、ssh タイムアウトの延長
（デフォルト600秒でタイムアウト）
14
2023/11/21時点

View Slide

dbaascli を用いたデータベースの作成
15

View Slide

1. データベースの使用可能なソフトウェア・イメージおよびバージョンの一覧表示
2. Oracle Database Home の作成
3. 指定されたOracle Database Home でのOracle Databaseの作成
流れ
16

View Slide

dbaascli cswlib showImages --help
※Ver 22.1.1.1.0から「dbaascli cswlib list」が非推奨となり、こちらのコマンドに置き換わりました
[root@vmem-6gl0h1 ~]# dbaascli cswlib showimages --help
Executing command cswlib showimages --help
Usage: dbaascli cswLib showImages [--product ] [--jsonFormat [--jsonFilePath ]]
Where:
[--product - product type. The valid values are: DATABASE | GRID .]
[--jsonFormat - displays output in JSON format.]
[--jsonFilePath - path of the JSON file.]
データベースの使用可能なソフトウェア・イメージおよびバージョンの一覧表示
17
2023/11/21時点

View Slide

dbaascli cswlib showImages
[root@vmem-6gl0h1 ~]# dbaascli cswlib showimages
Executing command cswlib showimages
Job id: c45ccffd-a8b9-4de5-8d36-92c3c929b84c
Session log: /var/opt/oracle/log/cswLib/showImages/dbaastools_2023-
11-20_01-24-57-PM_173707.log
Log file location:
/var/opt/oracle/log/cswLib/showImages/dbaastools_2023-11-20_01-24-57-
PM_173707.log
############ List of Available database Artifacts #############
1.IMAGE_TAG=11.2.0.4.230418
VERSION=11.2.0.4.230418
DESCRIPTION=11.2 APR 2023 DB Image
2.IMAGE_TAG=12.2.0.1.230117
VERSION=12.2.0.1.230117
DESCRIPTION=12.2 JAN 2023 DB Image
3.IMAGE_TAG=12.2.0.1.230718
VERSION=12.2.0.1.230718
DESCRIPTION=12.2 JUL 2023 DB Image
4.IMAGE_TAG=18.23.0.0.0
VERSION=18.23.0.0.0
DESCRIPTION=18c JUL 2023 DB Image
5.IMAGE_TAG=12.1.0.2.231017
VERSION=12.1.0.2.231017
DESCRIPTION=12.1 OCT 2023 DB Image
続く
6.IMAGE_TAG=18.22.0.0.0
VERSION=18.22.0.0.0
DESCRIPTION=18c APR 2023 DB Image
7.IMAGE_TAG=11.2.0.4.231017
VERSION=11.2.0.4.231017
8.IMAGE_TAG=12.1.0.2.230418
VERSION=12.1.0.2.230418
9.IMAGE_TAG=19.18.0.0.0
VERSION=19.18.0.0.0
DESCRIPTION=19c JAN 2023 DB Image
10.IMAGE_TAG=19.20.0.0.0
VERSION=19.20.0.0.0
11.IMAGE_TAG=11.2.0.4.230117
VERSION=11.2.0.4.230117
12.IMAGE_TAG=18.21.0.0.0
VERSION=18.21.0.0.0
DESCRIPTION=18c JAN 2023 DB Image
13.IMAGE_TAG=12.2.0.1.230418
VERSION=12.2.0.1.230418
14.IMAGE_TAG=11.2.0.4.230718
VERSION=11.2.0.4.230718
15.IMAGE_TAG=12.1.0.2.230718
VERSION=12.1.0.2.230718
続く
18
2023/11/21時点

View Slide

dbaascli cswlib showImages
16.IMAGE_TAG=18.20.0.0.0
VERSION=18.20.0.0.0
DESCRIPTION=18c OCT 2022 DB Image
17.IMAGE_TAG=12.2.0.1.231017
VERSION=12.2.0.1.231017
18.IMAGE_TAG=18.24.0.0.0
VERSION=18.24.0.0.0
19.IMAGE_TAG=19.19.0.0.0
VERSION=19.19.0.0.0
DESCRIPTION=19c APR 2023 DB Image
20.IMAGE_TAG=19.21.0.0.0
VERSION=19.21.0.0.0
21.IMAGE_TAG=12.1.0.2.230117
VERSION=12.1.0.2.230117
Images can be downloaded using their image tags. For details, see help using 'dbaascli cswlib download --help'.
dbaascli execution completed
19
2023/11/21時点

View Slide

dbaascli dbimage list → dbaascli cswLib listLocal
現在のデフォルト確認
[root@vmem-6gl0h1 ~]# dbaascli dbimage list
Executing command dbimage list
[INFO] [DBAAS-14011] - The usage of this command is deprecated.
ACTION: It is recommended to use 'dbaascli cswLib listLocal' for this operation.
INFO : Log file => /var/opt/oracle/log/dbimage_list/dbimage_list_2023-11-20_13:27:21.923054190786.log
INFO : dbimage fixup executed.
################## List of Available dbimages on acfs ###################
-JUL2023 (For DB Versions 19000) => du: consumed on acfs
-OCT2023 (For DB Versions 19000) => du: consumed on acfs
######################## Default BP on acfs #############################
-19000 => JUL2023
################## Acfs disk space usage ######################
Filesystem Size Used Avail Use% Mounted on
/dev/asm/acfsvol01-99 100G 46G 55G 46% /acfs01
################# /var/opt/oracle/dbaas_acfs/dbnid space usage ###################
12G
データベースの使用可能なソフトウェア・イメージ
現在のデフォルトバージョン確認
20
2023/11/21時点

View Slide

dbaascli cswLib listLocal
[root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal --help
Executing command cswlib listLocal --help
Usage: dbaascli cswLib listLocal [--product ]
Where:
[root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal
Executing command cswlib listLocal
Job id: dc4a03a3-c63f-4600-b09e-dad1c5092d3f
Session log: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_07-43-42-PM_301284.log
Log file location: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_07-43-42-PM_301284.log
############ List of Available Database Images #############
1.IMAGE_TAG=19.20.0.0.0
IMAGE_SIZE=5GB
VERSION=19.20.0.0.0
2.IMAGE_TAG=19.21.0.0.0
IMAGE_SIZE=5GB
VERSION=19.21.0.0.0
[root@vmem-6gl0h1 ~]#
ローカルのバージョン確認
21
2023/11/21時点

View Slide

dbaascli cswlib download --help
[root@vmem-6gl0h1 ~]# dbaascli cswlib download --help
Executing command cswlib download --help
Usage: dbaascli cswLib download
{
--version
| --imageTag
}
[--product ]
Where:
--version | --imageTag
--version - Oracle home image version.
--imageTag - Oracle home image tag.
イメージのダウンロード
22
2023/11/21時点

View Slide

dbaascli cswlib download
[root@vmem-6gl0h1 ~]# dbaascli cswlib download --version 19.21.0.0.0
Executing command cswlib download --version 19.21.0.0.0
Job id: f0e6e39c-250d-4fe2-b484-478798089491
Session log: /var/opt/oracle/log/cswLib/download/dbaastools_2023-11-20_01-29-57-PM_204515.log
Image location=/var/opt/oracle/dbaas_acfs/dbnid/19.21.0.0.0
Download succeeded
Log file location: /var/opt/oracle/log/cswLib/download/dbaastools_2023-11-20_01-29-57-PM_204515.log
You have new mail in /var/spool/mail/root
[root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal
Executing command cswlib listLocal
Job id: c162764a-49e8-47e0-aacc-a95e12376162
Session log: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_01-31-38-PM_214945.log
Log file location: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_01-31-38-PM_214945.log
############ List of Available Database Images #############
1.IMAGE_TAG=19.20.0.0.0
IMAGE_SIZE=5GB
VERSION=19.20.0.0.0
2.IMAGE_TAG=19.21.0.0.0
IMAGE_SIZE=5GB
VERSION=19.21.0.0.0
19.21 がローカルにダウンロードされた
イメージのダウンロード
23
2023/11/21時点

View Slide

dbaascli cswlib download
[root@vmem-6gl0h1 ~]# ls -al /var/opt/oracle/dbaas_acfs/dbnid/19.21.0.0.0
total 5267560
drwx------ 2 oracle oinstall 20480 Nov 16 16:45 .
drwxr-xr-x 6 oracle oinstall 20480 Nov 16 16:42 ..
-rwx------ 1 oracle oinstall 5389406916 Nov 16 16:43 db19000_bits_EXA.zip
[root@vmem-6gl0h1 ~]# ls -al /var/opt/oracle/dbaas_acfs/dbnid/
total 316
drwxr-xr-x 6 oracle oinstall 20480 Nov 16 16:42 .
drwxr-xr-x 22 oracle oinstall 20480 Nov 20 13:23 ..
drwx------ 2 oracle oinstall 20480 Oct 20 10:09 19.20.0.0.0
drwx------ 2 oracle oinstall 20480 Nov 16 16:45 19.21.0.0.0
lrwxrwxrwx 1 oracle oinstall 65 Oct 20 10:09 db19000_bits_EXA.zip -> /var/opt/oracle/dbaas_acfs/dbnid/19.20.0.0.0/db19000_bits_EXA.zip
drwxr-xr-x 3 oracle oinstall 20480 Oct 20 13:36 NONCDB
drwxr-xr-x 2 oracle oinstall 20480 Oct 20 13:36 OCT2021
ダウンロードされたファイルの確認
24
2023/11/21時点

View Slide

dbaascli dbimage activateBP
[root@vmem-6gl0h1 ~]# dbaascli dbimage activateBP --help
Executing command dbimage activateBP --help
デフォルトバージョン設定
25
2023/11/21時点

View Slide

dbaascli dbhome create --help
[root@vmem-6gl0h1 ~]# dbaascli dbhome create --help
Executing command dbhome create --help
Usage: dbaascli dbHome create --version [--oracleHomeName ] [--oracleHome ] [--imageTag ] [--
enableUnifiedAuditing ] [--executePrereqs] [--imageFilePath ] [--waitForCompletion ]
Where:
--version - Oracle home version, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0).
[--oracleHomeName - user defined home name, if not provided default name will be used. ]
[--oracleHome - specifies Oracle home location]
[--imageTag - Oracle home image tag.]
[--enableUnifiedAuditing - specifies true|false to enable|disable unified auditing link option in Oracle home.]
[--executePrereqs - run the prerequisite checks and report the results. ]
[--imageFilePath - absolute path of the image file to be used. ]
[--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.]
version の指定が five numeric segments separated by periods になった
-bp の指定がなくなった
imageFilePath, waitForCompletion, executePrereqs のオプションが追加された
Oracle Database Home の作成
26
2023/11/21時点

View Slide

dbaascli dbhome create
[root@vmem-6gl0h1 ~]# dbaascli dbhome create --version 19.21.0.0.0
Executing command dbhome create --version 19.21.0.0.0
Job id: f987b833-9dc3-4c39-ba53-fa863c2c92d5
Session log: /var/opt/oracle/log/dbHome/create/dbaastools_2023-11-
20_01-36-21-PM_239183.log
Loading PILOT...
Session ID of the current execution is: 1118
Log file location: /var/opt/oracle/log/dbHome/create/pilot_2023-11-
20_01-36-25-PM_239783
-----------------
Running Plugin_initialization job
Completed Plugin_initialization job
-----------------
Running OH_image_validate job
Completed OH_image_validate job
-----------------
Running OH_image_download job
Completed OH_image_download job
-----------------
Running DB_home_version_check job
Completed DB_home_version_check job
-----------------
Running OH_image_version_check job
Completed OH_image_version_check job
-----------------
Running Validate_backup_location job
Completed Validate_backup_location job
-----------------
Running Disk_space_check job
Completed Disk_space_check job
-----------------
Running Cluster_nodes_check job
Completed Cluster_nodes_check job
-----------------
Running Validate_users_group job
Completed Validate_users_group job
Acquiring write lock: _u02_app_oracle_product_19.0.0.0_dbhome_6
Acquiring write lock: provisioning
-----------------
Running Pre_OH_creation_lock_manager job
Completed Pre_OH_creation_lock_manager job
-----------------
Running OH_pre_existence_check job
Completed OH_pre_existence_check job
-----------------
Running Local_node_oh_image_unzip job
Completed Local_node_oh_image_unzip job
-----------------
Running OH_creation_cvu_prechecks job
Completed OH_creation_cvu_prechecks job
-----------------
Running Local_node_oh_clone job
Completed Local_node_oh_clone job
-----------------
Running Update_dbnid_bits job
Skipping. Job is detected as not applicable.
-----------------
Running Local_node_oh_backup_creation job
Completed Local_node_oh_backup_creation job
-----------------
27
2023/11/21時点

View Slide

Running Remote_nodes_software_copy job
Completed Remote_nodes_software_copy job
-----------------
Running Remote_nodes_attach_home job
Completed Remote_nodes_attach_home job
-----------------
Running Remote_nodes_post_install_steps job
Completed Remote_nodes_post_install_steps job
-----------------
Running Inventory_nodes_list_update job
Completed Inventory_nodes_list_update job
-----------------
Running Root_script_run job
Completed Root_script_run job
-----------------
Running Post_OH_creation_lock_manager job
Completed Post_OH_creation_lock_manager job
Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_6
Releasing lock: provisioning
-----------------
Running Generate_dbhome_metadata job
Completed Generate_dbhome_metadata job
-----------------
Running Generate_dbhome_system_details job
Acquiring native write lock: global_dbsystem_details_generation
Releasing native lock: global_dbsystem_details_generation
Completed Generate_dbhome_system_details job
-----------------
Running Plugin_cleanup job
Completed Plugin_cleanup job
---------- START OF PLUGIN RESULT ----------
{"ORACLE_HOME_NAME":"OraHome6","ORACLE_HOME":"/u02/app/oracle/product
/19.0.0.0/dbhome_6"}
---------- END OF PLUGIN RESULT ----------
28
2023/11/21時点

View Slide

dbaascli system getDBHomes
[root@vmem-6gl0h1 ~]# dbaascli system getDBHomes --help
Executing command system getDBHomes --help
system getDBHomes - list the details of all the Oracle homes.
Usage: dbaascli system getDBHomes
You have new mail in /var/spool/mail/root
作成された Database Home の確認
29
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli system getDBHomes
Executing command system getDBHomes
Job id: 15a9c693-d217-47b4-98f9-68eadd3b2766
Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2023-
11-20_01-51-42-PM_371920.log
{
"OraHome1" : {
"homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1",
"homeName" : "OraHome1",
"version" : "19.20.0.0.0",
"createTime" : 1697764298000,
"updateTime" : 1697765609000,
"unifiedAuditEnabled" : false,
"ohNodeLevelDetails" : {
"vmem-6gl0h1" : {
"nodeName" : "vmem-6gl0h1",
"version" : "19.20.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.20.0.0.0"
}
},
"messages" : [ ]
},
"OraHome2" : {
"version" : "19.13.0.0.0",
"createTime" : 1697776609000,
"updateTime" : 1697777833000,
"vmem-6gl0h1" : {
"version" : "19.13.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.13.0.0.0"
}
},
"messages" : [ ]
},
クラスタ上のすべてのデータベースのOracleホームを取得
30
2023/11/21時点

View Slide

OraHome3" : {
"version" : "19.14.0.0.0",
"createTime" : 1697786065000,
"updateTime" : 1697786065000,
"vmem-6gl0h1" : {
"version" : "19.14.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.14.0.0.0"
}
},
"messages" : [ ]
},
"OraHome4" : {
"version" : "19.20.0.0.0",
"createTime" : 1699923823000,
"updateTime" : 1700215854000,
"vmem-6gl0h1" : {
"version" : "19.20.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.20.0.0.0"
}
},
"messages" : [ ]
},
"OraHome5" : {
"version" : "19.21.0.0.0",
"createTime" : 1700131168000,
"updateTime" : 1700182340000,
"vmem-6gl0h1" : {
"version" : "19.21.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.21.0.0.0"
}
},
"messages" : [ ]
},
"OraHome6" : {
"version" : "19.21.0.0.0",
"createTime" : 1700455140000,
"updateTime" : 1700455140000,
"vmem-6gl0h1" : {
"version" : "19.21.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.21.0.0.0"
}
},
"messages" : [ ]
}
}
クラスタ上のすべてのデータベースのOracleホームを取得
31
2023/11/21時点

View Slide

dbaascli dbhome getDetails
[root@vmem-6gl0h1 ~]# dbaascli dbHome getDetails --help
Executing command dbHome getDetails --help
dbHome getDetails - display details of specified Oracle home.
Usage: dbaascli dbHome getDetails
{
--oracleHomeName
| --oracleHome
}
Where:
--oracleHomeName | --oracleHome
--oracleHomeName - Oracle home name.
--oracleHome - Oracle home path.
作成された Database Home の詳細確認
32
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli dbHome getDetails --oracleHomeName oraHome6
Executing command dbHome getDetails --oracleHomeName oraHome6
Job id: 034fe3fe-3639-4ef1-a7f5-788545bef811
Session log: /var/opt/oracle/log/dbHome/getDetails/dbaastools_2023-11-20_01-56-19-PM_49162.log
{
"version" : "19.21.0.0.0",
"createTime" : 1700455140000,
"updateTime" : 1700455140000,
"vmem-6gl0h1" : {
"version" : "19.21.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.21.0.0.0"
}
},
"messages" : [ ]
}
作成された Database Home の詳細確認
33
2023/11/21時点

View Slide

作成された Database Home の詳細確認(コンソール)
34
2023/11/21時点

View Slide

dbaascli dbhome getDatabases
[root@vmem-6gl0h1 ~]# dbaascli dbhome getDatabases --help
Executing command dbhome getDatabases --help
dbHome getDatabases - display details of databases in specified Oracle home.
Usage: dbaascli dbHome getDatabases
{
--oracleHomeName
| --oracleHome
}
Where:
-------↓旧バージョンで実行 -----------------
[root@vm01wasa-zb1hy1 ~]#
[root@vm01wasa-zb1hy1 ~]# dbaascli dbhome getDatabases --oracleHomeName oraHome1
Executing command dbhome getDatabases --oracleHomeName oraHome1
Job id: c459c843-dea6-4bef-b64f-55785d8f4073
Session log: /var/opt/oracle/log/dbHome/getDatabases/dbaastools_2023-02-14_08-41-07-AM_175717.log
[WARNING] [DBAAS-80101] Unable to get list of databases.
CAUSE: There are no databases registered in the system.
作成された Database Home 上のDB確認
35
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli dbhome create --version 19.12.0.0.0
Executing command dbhome create --version 19.12.0.0.0
Job id: 2bc77ced-42a6-4f35-8237-64e3f12f4966
Session log: /var/opt/oracle/log/dbHome/create/dbaastools_2023-11-20_06-30-14-PM_115485.log
Loading PILOT...
Log file location: /var/opt/oracle/log/dbHome/create/pilot_2023-11-20_06-30-18-PM_116347
-----------------
-----------------
Running OH_image_validate job
Completed OH_image_validate job
-----------------
Running OH_image_download job
Execution of OH_image_download failed
[FATAL] [DBAAS-60143] Failed to download the image '19.12.0.0.0'.
SUMMARY:
- [DBAAS-60143] Failed to download the image '19.12.0.0.0'.
*** Executing jobs which need to be run always... ***
-----------------
Running Post_OH_creation_lock_manager job
Completed Post_OH_creation_lock_manager job
-----------------
Running Plugin_cleanup job
Completed Plugin_cleanup job
******** PLUGIN EXECUTION FAILED ********
ソフトウェア・イメージにないバージョン指定でDatabase Home 作成に失敗する例
36
2023/11/21時点

View Slide

dbaascli database create --help
[root@vmem-6gl0h1 ~]# dbaascli database create --help
Executing command database create --help
Usage: dbaascli database create --dbName
{
--oracleHome
| --oracleHomeName
}
[--dbUniqueName ] [--dbSID ] [--createAsCDB ] [--pdbName ] [--pdbAdminUserName ] [--dbCharset ]
[--dbNCharset ] [--dbLanguage ] [--dbTerritory ] [--sgaSizeInMB ] [--pgaSizeInMB ] [--datafileDestination
] [--fraDestination ] [--fraSizeInMB ] [--nodeList ] [--tdeConfigMethod
{
[--kmsKeyOCID [--kmsKeyVersionOCID ] [--pdbKMSKeyVersionOCID ]]
| [--okvServer --okvAdminUserName [--okvServerRestPort ] [--okvWalletName ]]
}]
{
[--resume [--sessionID ]]
| [--revert [--sessionID ]]
}
[--executePrereqs] [--honorNodeNumberForInstance ] [--lockPDBAdminAccount ] [--dbcaTemplateFilePath ] [--
waitForCompletion ] [--templateFromObjectStorage --objectStorageLoginUser --objectStorageBucketName --templateName
[--objectStorageUrl ]]
続き
Database Create コマンド一覧
37
2023/11/21時点

View Slide

続き
Where:
--dbName - Oracle database name.
--oracleHome | --oracleHomeName
--oracleHome - specifies Oracle home location
--oracleHomeName - specifies Oracle home name
[--dbUniqueName - specifies database unique name]
[--dbSID - specifies database SID]
[--createAsCDB - specifies true/false to create database as CDB/Non-CDB]
[--pdbName - specifies PDB name]
[--pdbAdminUserName - specifies PDB admin user name]
[--dbCharset - specifies database character set]
[--dbNCharset - specifies database national character set]
[--dbLanguage - specifies database language]
[--dbTerritory - specifies database territory]
[--sgaSizeInMB - specifies sga_target value in mega byte unit]
[--pgaSizeInMB - specifies pga_aggregate_target value in mega byte unit]
[--datafileDestination - specifies ASM disk group name to use for database datafiles]
[--fraDestination - specifies ASM disk group name to use for database fast recovery area]
[--fraSizeInMB - specifies fast recovery area size value in mega byte unit]
[--nodeList - specifies comma separated node list for database]
[--tdeConfigMethod - specifies TDE configuration method. Allowed values are FILE, KMS and OKV]
[--kmsKeyOCID | --okvServer]
[--kmsKeyOCID - specifies KMS key OCID to use for TDE. This is applicable only if KMS is selected for TDE]
[--kmsKeyVersionOCID - OCI Vault key version OCID to be set. This is applicable only if OCI Vault is selected for TDE]
[--pdbKMSKeyVersionOCID - OCI Vault key version OCID to be set for PDB. This is applicable only if OCI Vault is selected for TDE]
[--okvServer - Specifies the Oracle Key Vault server. This is applicable only if OKV is selected for TDE]
--okvAdminUserName - Specifies the Oracle Key Vault admin user name
[--okvServerRestPort - Specifies the rest port number for Oracle Key Vault]
[--okvWalletName - Specifies the Oracle Key Vault wallet name]
38
2023/11/21時点

View Slide

続き
[--resume | --revert]
[--resume - to resume the previous operation]
[--sessionID - to resume a specific session id.]
[--revert - to rollback the previous operation]
[--honorNodeNumberForInstance - specifies true or false to indicate instance name to be suffixed with cluster node numbers when database
is created on subset of nodes. Default value is true]
[--lockPDBAdminAccount - specifies true or false to lock the PDB admin user account. Default value is true]
[--dbcaTemplateFilePath - specifies the absolute path of the dbca template name to create the database.]
[--templateFromObjectStorage - to create database from template present in object storage]
--objectStorageLoginUser - object storage login user
--objectStorageBucketName - object storage bucket name
--templateName - specifies the template name
[--objectStorageUrl - object storage URL]
39
2023/11/21時点

View Slide

dbaascli database create --executePrereq
[root@vmem-6gl0h1 ~]# dbaascli database create --dbname dbcli01 --
oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --executePrereqs
yes
Executing command database create --dbname dbcli01 --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6 --executePrereqs yes
Job id: fc003e99-f921-4715-94b6-882534e50469
Session log:
/var/opt/oracle/log/dbcli01/database/create/dbaastools_2023-11-20_06-
34-59-PM_154607.log
Enter SYS_PASSWORD:
Enter SYS_PASSWORD (reconfirmation):
Enter TDE_PASSWORD:
Enter TDE_PASSWORD (reconfirmation):
Loading PILOT...
Enter SYS_PASSWORD
********************
*****************
Enter TDE_PASSWORD
*********************
******************
Log file location:
/var/opt/oracle/log/dbcli01/database/create/pilot_2023-11-20_06-36-
41-PM_163619
-----------------
Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_6
-----------------
Running Default_value_initialization job
Completed Default_value_initialization job
-----------------
Running Validate_input_params job
Completed Validate_input_params job
-----------------
Running Validate_cpu_availability job
Completed Validate_cpu_availability job
-----------------
Running Validate_asm_availability job
Completed Validate_asm_availability job
-----------------
Running Validate_disk_space_availability job
Completed Validate_disk_space_availability job
-----------------
Running validate_users_umask job
Completed validate_users_umask job
-----------------
Running Validate_huge_pages_availability job
Completed Validate_huge_pages_availability job
-----------------
Running Validate_hostname_domain job
Completed Validate_hostname_domain job
-----------------
Running Install_db_cloud_backup_module job
-----------------
Oracle Databaseを作成する前に前提条件チェックを実行
40
2023/11/21時点

View Slide

Running Perform_dbca_prechecks job
Completed Perform_dbca_prechecks job
-----------------
Running Validate_backup_report job
Acquiring write lock: create_db_cloud
-----------------
Running Setup_acfs_volumes job
-----------------
Running Setup_db_folders job
-----------------
Running DB_creation job
Releasing lock: create_db_cloud
-----------------
Running Generate_db_metadata job
-----------------
Running Create_db_from_backup job
Completed Create_db_from_backup job
-----------------
Running Load_db_details job
-----------------
Running Populate_creg job
-----------------
Running Register_ocids job
-----------------
Running Run_datapatch job
-----------------
Running Create_users_tablespace job
-----------------
Running Configure_pdb_service job
-----------------
Running Set_pdb_admin_user_profile job
-----------------
Running Lock_pdb_admin_user job
-----------------
Running Configure_flashback job
-----------------
Running Update_cloud_service_recommended_config_parameters job
-----------------
Running Update_distributed_lock_timeout job
-----------------
Running Configure_archiving job
-----------------
41
2023/11/21時点

View Slide

Running Configure_huge_pages job
-----------------
Running Set_credentials job
-----------------
Running Update_dba_directories job
-----------------
Running Set_cluster_interconnects job
-----------------
Running Create_db_secure_profile job
-----------------
Running Set_utc_timezone job
-----------------
Running Run_dst_post_installs job
-----------------
Running Enable_auditing job
-----------------
Running Apply_security_measures job
-----------------
Running Set_listener_init_params job
-----------------
Running Update_db_wallet job
-----------------
Running Add_oratab_entry job
-----------------
Running Configure_sqlnet_ora job
-----------------
Running Configure_tnsnames_ora job
-----------------
Running Enable_fips job
-----------------
Running DTRS_DB_Configure_Job job
-----------------
Running Restart_database job
-----------------
Running Create_db_login_environment_file job
-----------------
Running Generate_dbsystem_details job
-----------------
Running Cleanup job
42
2023/11/21時点

View Slide

dbaascli database create
[root@vmem-6gl0h1 ~]# dbaascli database create --dbname dbcli01 --
oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6
Executing command database create --dbname dbcli01 --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6
Job id: aa2c12d2-ac0b-4ccd-8ff9-53aba535c640
Session log:
/var/opt/oracle/log/dbcli01/database/create/dbaastools_2023-11-20_06-
45-13-PM_220170.log
Enter SYS_PASSWORD:
Enter TDE_PASSWORD:
Loading PILOT...
Enter SYS_PASSWORD
********************
*******************
Enter TDE_PASSWORD
******************
********************
Log file location:
12-PM_229558
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
指定されたOracle DatabaseホームでのOracle Databaseの作成
43
2023/11/21時点

View Slide

Running Install_db_cloud_backup_module job
-----------------
-----------------
Running Validate_backup_report job
Acquiring write lock: create_db_cloud
-----------------
Completed Setup_acfs_volumes job
-----------------
Completed Setup_db_folders job
-----------------
Completed DB_creation job
Releasing lock: create_db_cloud
-----------------
Running Generate_db_metadata job
Completed Generate_db_metadata job
-----------------
Running Create_db_from_backup job
Completed Create_db_from_backup job
-----------------
Completed Load_db_details job
-----------------
-----------------
Completed Populate_creg job
-----------------
-----------------
Running Run_datapatch job
-----------------
-----------------
-----------------
-----------------
-----------------
Completed Configure_flashback job
-----------------
Completed Update_cloud_service_recommended_config_parameters job
-----------------
44
2023/11/21時点

View Slide

Completed Update_distributed_lock_timeout job
-----------------
Completed Configure_archiving job
-----------------
Completed Configure_huge_pages job
-----------------
Completed Set_credentials job
-----------------
Completed Update_dba_directories job
-----------------
Completed Set_cluster_interconnects job
-----------------
Completed Create_db_secure_profile job
-----------------
Completed Set_utc_timezone job
-----------------
Completed Run_dst_post_installs job
-----------------
Completed Enable_auditing job
-----------------
Completed Apply_security_measures job
-----------------
Completed Set_listener_init_params job
-----------------
Completed Update_db_wallet job
-----------------
Completed Add_oratab_entry job
-----------------
Completed Configure_sqlnet_ora job
-----------------
Completed Configure_tnsnames_ora job
-----------------
Completed Enable_fips job
-----------------
Running DTRS_DB_Configure_Job job
Completed DTRS_DB_Configure_Job job
-----------------
Completed Restart_database job
-----------------
Completed Create_db_login_environment_file job
-----------------
Completed Generate_dbsystem_details job
-----------------
Running Cleanup job
Completed Cleanup job
45
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli dbhome getDatabases --oracleHomeName oraHome1
Executing command dbhome getDatabases --oracleHomeName oraHome1
Job id: b25b9808-9a86-4eb8-b794-81dfec37870b
Session log: /var/opt/oracle/log/dbHome/getDatabases/dbaastools_2023-11-20_07-35-05-PM_256165.log
{
"DB19" : {
"dbSyncTime" : 1700475789484,
"createTime" : 1697765022000,
"updateTime" : 0,
"dbName" : "DB19",
"dbUniqueName" : "DB19_qq4_kix",
"dbDomain" : "sub04210756190.exavcn.oraclevcn.com",
"dbId" : 881928558,
"cpuCount" : 4,
"sgaTarget" : "3808MB",
"pgaAggregateTarget" : "2500MB",
"dbSize" : "55GB",
"dbUsedSize" : "12GB",
"totalFraSize" : "1024GB",
"fraSizeUsed" : "24GB",
"dbKmsKeyOcid" : null,
"isCDB" : true,
"dbRole" : "PRIMARY",
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"dgEnabled" : false,
"patchVersion" : "19.20.0.0.0“,
続く
Database Home 上のDB確認
46
2023/11/21時点

View Slide

"resourceOCIDSettings" : {
"tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca",
"compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a",
"resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqa5gxmj3ghhtbyetakgl6w3qke6xpiq2o22up42s4jrsmq",
"resourceID" : "d2705e01-7891-4bf7-8e91-5f01988a5a64",
"resourceType" : "CDB",
"parentResourceID" : null
},
"tdeDetails" : {
"tdeKeystoreType" : "FILE",
"keyVersionOcid" : null,
"tdeMasterKeyId" : "AZF3cdN/r08+v+h8h+xNzfoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
"dbCharacterSet" : {
"characterSet" : "AL32UTF8",
"nlsCharacterset" : "AL16UTF16",
"dbTerritory" : "AMERICA",
"dbLanguage" : "AMERICAN"
},
"dbNodeLevelDetails" : {
"vmem-6gl0h1" : {
"instanceName" : "DB191",
"version" : "19.20.0.0.0",
"status" : "OPEN"
},
47
2023/11/21時点

View Slide

"vmem-6gl0h2" : {
"version" : "19.20.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "3793508688",
"cdbId" : "d2705e01-7891-4bf7-8e91-5f01988a5a64",
"refreshablePDB" : false,
"refreshMode" : null,
"refreshIntervalInMinutes" : null,
"cpuCount" : 4,
"storageAllocated" : "UNLIMITED",
"storageUsed" : "8544MB",
"guid" : "081CDD8C63033C68E0639500000A7A09",
"dbid" : "3793508688",
"conId" : "3",
"resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka-1.anvwsljrssl65iqar7ii5kmp2bxfwc3e7t2hjgnaou5u6ipgt4pre6ppgvaq",
"resourceID" : "3793508688",
"resourceType" : "PDB",
"parentResourceID" : "d2705e01-7891-4bf7-8e91-5f01988a5a64"
},
48
2023/11/21時点

View Slide

"tdeDetails" : {
"tdeMasterKeyId" : "AUWRZPDD2U/Iv3TnUlZjty8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
"pdbNodeLevelDetails" : {
"vmem-6gl0h1" : {
"openMode" : "READ_WRITE",
"restricted" : false
},
"vmem-6gl0h2" : {
}
},
"pdbConnectStrings" : [ {
"serviceName" : "DB19_PDB1.paas.oracle.com",
"connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/DB19_PDB1.paas.oracle.com",
"tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/DB19_PDB1.paas.oracle.com" ]
} ],
"pdbSize" : "8GB",
"pdbUsedSize" : "1GB",
"pdbSnapshotDetails" : null
}
},
"messages" : [ ]
},
49
2023/11/21時点

View Slide

"DBFDSI" : {
"dbSyncTime" : 1700475789354,
"createTime" : 1697777238000,
"updateTime" : 0,
"dbName" : "DBFDSI",
"dbUniqueName" : "DBFDSI_phh_kix",
"dbId" : 3353687590,
"cpuCount" : 4,
"dbSize" : "55GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"dgEnabled" : true,
"patchVersion" : "19.20.0.0.0",
50
2023/11/21時点

View Slide

"resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqa2tavuxqsonfs432lnl5dpycn7o4y3v5uxfddwjjvlg3q",
"resourceID" : "2b67088f-a84c-4b70-a2bc-9650d128fa97",
},
"tdeDetails" : {
"tdeMasterKeyId" : "ASMotBwDek/vvwNK44p4rhoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
},
"vmem-6gl0h1" : {
"instanceName" : "DBFDSI1",
"version" : "19.20.0.0.0",
"status" : "OPEN"
},
"vmem-6gl0h2" : {
"instanceName" : "DBFDSI2",
"version" : "19.20.0.0.0",
"status" : "OPEN"
}
},
51
2023/11/21時点

View Slide

"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "3217098636",
"cdbId" : "2b67088f-a84c-4b70-a2bc-9650d128fa97",
"cpuCount" : 4,
"guid" : "081FB65CDB86887CE0639500000ABAD4",
"dbid" : "3217098636",
"conId" : "3",
"resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka-1.anvwsljrssl65iqay24yxzmv7szvwdkutzl2yfvv37pss4iagd5vhrebl3mq",
"resourceID" : "3217098636",
"parentResourceID" : "2b67088f-a84c-4b70-a2bc-9650d128fa97"
},
"tdeDetails" : {
"tdeMasterKeyId" : "ARbww5QrCU8bv8x9UaBu1H0AAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
52
2023/11/21時点

View Slide

"vmem-6gl0h1" : {
},
"vmem-6gl0h2" : {
}
},
"serviceName" : "DBFDSI_PDB1.paas.oracle.com",
"connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/DBFDSI_PDB1.paas.oracle.com",
"tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/DBFDSI_PDB1.paas.oracle.com" ]
}, {
"serviceName" : "PDB1_dg",
"connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/PDB1_dg",
"tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/PDB1_dg" ]
}, {
"serviceName" : "PDB1_dg_ro",
"connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/PDB1_dg_ro",
"tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/PDB1_dg_ro" ]
} ],
"pdbSize" : "8GB",
}
},
"messages" : [ ]
}
}
53
2023/11/21時点

View Slide

Database Home 上のDB確認(コンソール)
54
2023/11/21時点

View Slide

dbaascli database create --パラメータ --executePrereqs yes
[root@orakawa-vgfvk1 ~]# dbaascli database create --dbname dbcli01 --
oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid
--dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE --
dbUniqueName dbcli01uniq --dbCharset JA16SJISTILDE --sgaSizeInMB 2000
--pdbName dbcli01pdb01 --pgaSizeInMB 2000 --executePrereqs yes
Executing command database create --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid --
dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE --
--pdbName dbcli01pdb01 --pgaSizeInMB 2000 --executePrereqs yes
Job id: 21ee5ded-be08-4668-87dc-8285d048f9e6
Enter SYS_PASSWORD:
Enter TDE_PASSWORD:
Loading PILOT...
Enter SYS_PASSWORD
*************
*************
Enter TDE_PASSWORD
**********
***********
Log file location:
11-AM
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
<続く>
Database の作成（パラメーター指定）プリチェック
68

View Slide

<続き>
-----------------
-----------------
Running DB_creation_acquire_lock job
-----------------
-----------------
-----------------
Running Check_and_configure_huge_pages job
-----------------
-----------------
Running DB_creation_release_lock job
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
Running Configure_undo_retention job
-----------------
-----------------
-----------------
<続く>
69

View Slide

<続き>
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
Running DB_backup_assistant job
-----------------
-----------------
-----------------
-----------------
Running Cleanup job
70

View Slide

dbaascli database create --パラメーター
[root@orakawa-vgfvk1 ~]# dbaascli database create --dbname dbcli01 --
oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid
--dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE --
--pdbName dbcli01pdb01 --pgaSizeInMB 2000
Executing command database create --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid --
dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE --
--pdbName dbcli01pdb01 --pgaSizeInMB 2000
Job id: dd17a9d8-5422-44a0-a963-910d30f37e93
Enter SYS_PASSWORD:
Enter TDE_PASSWORD:
Loading PILOT...
Enter SYS_PASSWORD
**************
************
Enter TDE_PASSWORD
************
************
Log file location:
23-AM
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
<続く>
Database の作成（パラメーター指定）
71

View Slide

<続き>
-----------------
Running DB_creation_acquire_lock job
Completed DB_creation_acquire_lock job
-----------------
Completed Setup_acfs_volumes job
-----------------
Completed Setup_db_folders job
-----------------
Running Check_and_configure_huge_pages job
Completed Check_and_configure_huge_pages job
-----------------
Completed DB_creation job
-----------------
Running DB_creation_release_lock job
Completed DB_creation_release_lock job
-----------------
-----------------
Completed Populate_creg job
-----------------
-----------------
Completed Update_dba_directories job
-----------------
Completed Set_cluster_interconnects job
-----------------
Completed Create_db_secure_profile job
-----------------
Completed Set_utc_timezone job
-----------------
Completed Run_dst_post_installs job
-----------------
Completed Enable_auditing job
-----------------
Completed Apply_security_measures job
-----------------
Completed Set_listener_init_params job
-----------------
Completed Update_db_wallet job
-----------------
Completed Add_oratab_entry job
-----------------
<続く>
72

View Slide

<続き>
Completed Configure_sqlnet_ora job
-----------------
-----------------
Completed Enable_fips job
-----------------
Completed DB_backup_assistant job
-----------------
Completed Restart_database job
-----------------
Completed Create_db_login_environment_file job
-----------------
-----------------
Running Cleanup job
Completed Cleanup job
73

View Slide

ログファイルから dbca に渡しているパラメーターを確認
ログファイル
[root@ecc2c1n1 ~]# less /var/opt/oracle/log/dbcli01/database/create/pilot_2022-03-28_09-11-23-AM
INFO: [2022-03-28 09:11:44.459 JST][pool-176-thread-1][DefaultCommandExecutor$2.call:284] Command constructed for node (localnode):/usr/bin/su
oracle -c 'export LC_ALL=en_US.UTF-8;export TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/dbcli01;export
ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1;/var/opt/oracle/dbaastools/dbaasca/bin/dbca -silent -oui_internal -createDatabase -
databaseConfigType RAC -templateName /u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed.dbc -datafileJarLocation
/u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed.dfb -pdbSeedMetadataFile
/u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed_pdbseed.xml -pdbSeedBackUpfile
/u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed_pdbseed.dfb -gdbName dbcli01.sub03230643360.orakawavcn.oraclevcn.com
-sid dbclisid -createAsContainerDatabase true -numberOfPdbs 1 -pdbName dbcli01pdb01 -pdbAdminUserName admin -honorNodeNumberForInstance -
storageType ASM -datafileDestination +DATAC1 -recoveryAreaDestination +RECOC1 -recoveryAreaSize 307200 -redoLogFileDestination +DATAC1 -
numberOfRedoLogsPerInstance 4 -redoLogFileSize 4000 -useOMF true -enableArchive true -tempFileProperties 1024MB:16GB:512GB -pdbTempFileProperties
1024MB:16GB:UNLIMITED -pdbTablespaceProperties USERS:1024MB:16GB:UNLIMITED -useBigFileForTablespace true -adminManaged -nodelist orakawa-
vgfvk1,orakawa-vgfvk2 -characterSet JA16SJISTILDE -forceInternalAlterCharacterSet -nationalCharacterSet UTF8 -configureTDE true -tdeWalletRoot
/var/opt/oracle/dbaas_acfs/dbcli01/wallet_root -encryptTablespaces ALL -initParams
'"'"'nls_territory=JAPAN,db_create_online_log_dest_1=+DATAC1,os_authent_prefix="",db_name=dbcli01,pga_aggregate_target=2000m,nls_language=JAPANESE
,sga_target=2000m,control_management_pack_access=DIAGNOSTIC+TUNING,db_domain=sub03230643360.orakawavcn.oraclevcn.com,enable_ddl_logging=TRUE,inmem
ory_size=400m,db_unique_name=dbcli01uniq'"'"' -skipPasswordComplexityCheck false -checkOnly -J-Dapplication.exceptions.severity=DBT-
06012:WARNING,DBT-06604:WARNING -J-Doracle.assistants.dbca.useStandardLogLocation=true -jreLoc /usr/java/jdk1.8.0_311-amd64/jre'
74

View Slide

uniquname, SID, NLSパラメーター確認
[oracle@orakawa-vgfvk1 ~]$ . dbcli01.env
[oracle@orakawa-vgfvk1 ~]$ env | grep ORA
ORACLE_UNQNAME=dbcli01uniq
ORACLE_SID=dbclisid1
ORACLE_BASE=/u02/app/oracle
ORACLE_HOSTNAME=orakawa-vgfvk1.sub03230643360.orakawavcn.oraclevcn.com
ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1
[oracle@orakawa-vgfvk1 ~]$ export NLS_LANG=Japanese_Japan.AL32UTF8
[oracle@orakawa-vgfvk1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 月 3月 28 09:52:55 2022
Version 19.11.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
に接続されました。
SQL> SELECT PARAMETER, VALUE
2 FROM NLS_DATABASE_PARAMETERS
3 WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
UTF8
NLS_CHARACTERSET
JA16SJISTILDE
75

View Slide

NLSパラメーター確認
SQL> select * from v$nls_parameters;
PARAMETER VALUE CON_ID
----------------------------------- ----------------------------------- ----------
NLS_LANGUAGE JAPANESE 1
NLS_TERRITORY JAPAN 1
NLS_CURRENCY \ 1
NLS_ISO_CURRENCY JAPAN 1
NLS_NUMERIC_CHARACTERS ., 1
NLS_CALENDAR GREGORIAN 1
NLS_DATE_FORMAT RR-MM-DD 1
NLS_DATE_LANGUAGE JAPANESE 1
NLS_CHARACTERSET JA16SJISTILDE 1
NLS_SORT BINARY 1
NLS_TIME_FORMAT HH24:MI:SSXFF 1
NLS_TIMESTAMP_FORMAT RR-MM-DD HH24:MI:SSXFF 1
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR 1
NLS_TIMESTAMP_TZ_FORMAT RR-MM-DD HH24:MI:SSXFF TZR 1
NLS_DUAL_CURRENCY \ 1
NLS_NCHAR_CHARACTERSET UTF8 1
NLS_COMP BINARY 1
NLS_LENGTH_SEMANTICS BYTE 1
NLS_NCHAR_CONV_EXCP FALSE 1
19行が選択されました。
76

View Slide

PDB作成、 PGA SGAサイズ確認
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DBCLI01PDB01 READ WRITE NO
[root@orakawa-vgfvk1 ~]# dbaascli database list
Executing command database list
Retrieving dbs..
Database List
1.DB Name=dbcli01
CPU=4
PGA=2 GB
SGA=2 GB
DATA=0 GB
FRA=0 GB
Nodelist=orakawa-vgfvk1,orakawa-vgfvk2
Cluster Information
Total CPU per Node=4
Total Memory per Node=1367 GB
Total Nodes=orakawa-vgfvk1,orakawa-vgfvk2
77

View Slide

※dbTerritory, dbLanguageが AMERICAになっている…
[root@orakawa-vgfvk1 ~]# dbaascli database getDetails --dbname
dbcli01
Executing command database getDetails
Job id: e3d753c9-3f66-44f7-b3e5-6cb6d92474bc
{
"id" : "79c3169c-f7e8-43b0-95db-ae884a85de37",
"dbSyncTime" : 0,
"createTime" : 1648393200000,
"updateTime" : 0,
"dbName" : "dbcli01",
"dbUniqueName" : "dbcli01uniq",
"dbDomain" : "sub03230643360.orakawavcn.oraclevcn.com",
"dbId" : 3324078197,
"cpuCount" : 4,
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.11.0.0.0",
"resourceOCIDSettings" : null,
"characterSet" : "JA16SJISTILDE",
"nlsCharacterset" : "UTF8",
},
"orakawa-vgfvk1" : {
"nodeName" : "orakawa-vgfvk1",
"instanceName" : "dbclisid1",
"version" : "19.11.0.0.0",
"status" : "OPEN"
},
"version" : "19.11.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"DBCLI01PDB01" : {
"pdbName" : "DBCLI01PDB01",
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
<続く>
78

View Slide

※dbTerritory, dbLanguageが AMERICAになっている…
<続き>
"openMode" : "READ_WRITE"
},
}
},
"serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com",
"connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com"
} ]
}
},
"messages" : [ ]
}
[root@orakawa-vgfvk1 ~]#
79

View Slide

database の詳細確認、一覧、削除
80

View Slide

dbaascli system getDatabases
[root@wasabi-isfff1 ~]# dbaascli system getDatabases --help
Executing command system getDatabases --help
Usage: dbaascli system getDatabases [--oracleHome ]
Where:
[--oracleHome - Oracle home path. ]
[root@wasabi-isfff1 ~]#
データベースの一覧
81

View Slide

[root@wasabi-isfff1 ~]# dbaascli system getDatabases
Executing command system getDatabases
Job id: 1f87b1dc-79bb-43fe-8f0e-e71485c13b0f
{
"DB1" : {
"id" : "134663e7-60b8-41f9-bfb8-f438f32eb072",
"dbSyncTime" : 1665558623416,
"createTime" : 1664463600000,
"updateTime" : 0,
"dbName" : "DB1",
"dbUniqueName" : "DB1_5jj_kix",
"dbDomain" : "sub07160524340.testvcn.oraclevcn.com",
"dbId" : 1710651431,
"cpuCount" : 4,
"dbSize" : "48GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.9.0.0.0",
82

View Slide

[root@wasabi-isfff1 ~]# dbaascli system getDatabases --oracleHome
Executing command system getDatabases --oracleHome
Job id: 64a88d13-6ac5-4049-bd7d-1181a37293dc
{
"DB1" : {
"id" : "134663e7-60b8-41f9-bfb8-f438f32eb072",
"dbSyncTime" : 1665634730252,
"createTime" : 1664463600000,
"updateTime" : 0,
"dbName" : "DB1",
"dbUniqueName" : "DB1_5jj_kix",
"dbId" : 1710651431,
"cpuCount" : 4,
"dbSize" : "48GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
続く
続く
"patchVersion" : "19.9.0.0.0",
},
"wasabi-isfff1" : {
"nodeName" : "wasabi-isfff1",
"version" : "19.9.0.0.0",
"status" : "OPEN"
},
"wasabi-isfff2" : {
"version" : "19.9.0.0.0",
"status" : "OPEN"
}
},
続く
83

View Slide

続く
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "3093976667",
"cpuCount" : null,
"guid" : "E9E467DD272E037BE0536900000AA583",
"dbid" : "3093976667",
"conId" : "3",
"wasabi-isfff2" : {
},
"wasabi-isfff1" : {
}
},
"connectString" : "wasabi-isfff-
scan.sub07160524340.testvcn.oraclevcn.com:1521/DB1_PDB1.paas.oracle.c
om"
} ],
"pdbSize" : "4GB",
"pdbUsedSize" : "1GB"
}
},
"messages" : [ ]
}
84

View Slide

dbaascli database getDetails --help
[root@orakawa-vgfvk1 ~]# dbaascli database getDetails --help
Executing command database getDetails --help
Usage: dbaascli database getDetails --dbname
Where:
--dbname - Oracle database name.
データベースの詳細確認
85

View Slide

dbaascli database getDetails
[root@orakawa-vgfvk1 ~]# dbaascli database getDetails --dbname
dbcli01
Job id: be584b63-dfc5-4bcf-8683-165f20b8747f
{
"id" : "79c3169c-f7e8-43b0-95db-ae884a85de37",
"dbSyncTime" : 0,
"createTime" : 1648393200000,
"updateTime" : 0,
"dbUniqueName" : "dbcli01uniq",
"dbId" : 3324078197,
"cpuCount" : 4,
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.11.0.0.0",
"characterSet" : "JA16SJISTILDE",
"nlsCharacterset" : "UTF8",
"dbLanguage" : "AMERICAN“
},
"version" : "19.11.0.0.0",
"status" : "OPEN"
},
"version" : "19.11.0.0.0",
"status" : "OPEN"
}
},
<続き>
86

View Slide

<続き>
"pdbs" : {
"DBCLI01PDB01" : {
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
"connectString" : "orakawa-vgfvk-
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb0
1.paas.oracle.com"
} ]
}
},
"messages" : [ ]
}
87

View Slide

dbaascli dbhome info
[root@orakawa-vgfvk1 ~]# dbaascli dbhome info
Executing command dbhome info
Enter a homename or just press enter if you want details of all homes
1.HOME_NAME=dbcli01
HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1
VERSION=19.11.0.0
PATCH_LEVEL=19.11.0.0
DBs installed=dbcli01
Agent DB IDs=79c3169c-f7e8-43b0-95db-ae884a85de37
OH Backup=NOT Configured
Agent DB ID で各 dbhome 上の DB が分かる
Database Home の一覧
88

View Slide

dbaascli database delete --help
[root@wasabi-isfff1 ~]# dbaascli database delete --help
Executing command database delete --help
Usage: dbaascli database delete --dbname [--deleteArchiveLogs ] [--deleteBackups ] [--precheckOnly ] [--
waitForCompletion ] [--force] [--dbSID ] [--resume [--sessionID ]]
Where:
[--deleteArchiveLogs - specify true or false to indicate database archive logs deletion. ]
[--deleteBackups - specify true or false to indicate database backups deletion. ]
[--precheckOnly - specify yes to run only the prechecks for this operation. Valid values : yes|no ]
[--waitForCompletion - specify false to run the operation in background. Valid values : true|false.]
[--force - flag to force delete database.]
[--dbSID - specify database SID]
[--resume - to resume the previous execution]
データベースの削除
89

View Slide

dbaascli database delete
[root@orcl0329-pfutx1 ~]# dbaascli database delete --dbName dbcli02
Executing command database delete --dbName dbcli02
Job id: 222c0750-f49e-4d97-aa23-5f85c9351115
Loading PILOT...
Log file location:
/var/opt/oracle/log/dbcli02/database/delete/pilot_2022-03-30_11-55-
01-PM
-----------------
-----------------
Running Validate_version job
Completed Validate_version job
-----------------
-----------------
-----------------
Running DB_deletion_acquire_lock job
Completed DB_deletion_acquire_lock job
-----------------
Running DB_deletion job
Completed DB_deletion job
-----------------
Running Remove_oratab_entry job
Completed Remove_oratab_entry job
-----------------
Running Clear_crontab_entries job
Completed Clear_crontab_entries job
-----------------
Running Delete_db_network_directory job
Completed Delete_db_network_directory job
-----------------
Running Clear_asm_entries job
Completed Clear_asm_entries job
-----------------
Running DB_deletion_release_lock job
Completed DB_deletion_release_lock job
-----------------
Running Delete_db_login_environment_file job
Completed Delete_db_login_environment_file job
-----------------
Running Delete_creg_file job
Completed Delete_creg_file job
-----------------
Running Delete_db_acfs_directory job
Completed Delete_db_acfs_directory job
-----------------
データベースの削除
90

View Slide

Databases で Failed になってしまっているので、メニュー > Terminate で情報を削除する
dbaascli からデータベース削除実施後のコンソールからの見え方
91

View Slide

dbaascli database deleteInstance --help
[root@wasabi-isfff1 ~]# dbaascli database deleteinstance --help
Executing command database deleteinstance --help
Usage: dbaascli database deleteInstance --dbname --node [--continueOnUnreachableNode]
Where:
--node - specify the node name for database instance.
[--continueOnUnreachableNode - Perform the operation even if the node is unreachable.]
特定ノードのDBインスタンスを削除
92
22.3.1.1.0 新機能
22.2.1.0.1 新機能

View Slide

dbaascli database deleteInstance
--インスタンス削除前のDBの状態
[root@orcl-jyvid1 ~]# dbaascli database getdetails --dbname DB19c
Executing command database getdetails
Job id: c31f0748-927d-4e1c-90f4-3ab5cddc9f30
{
"id" : "91e07074-c0e7-499c-9dce-f7a1b005dff2",
"dbSyncTime" : 0,
"createTime" : 1652227200000,
"updateTime" : 0,
"dbName" : "DB19c",
"dbUniqueName" : "DB19c_vxm_kix",
"dbId" : 2232397119,
"cpuCount" : 4,
"dbSize" : "47GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.13.0.0.0",
},
"orcl-jyvid1" : {
"nodeName" : "orcl-jyvid1",
"instanceName" : "DB19c1",
"version" : "19.13.0.0.0",
"status" : "OPEN"
},
"orcl-jyvid2" : {
"version" : "19.13.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "2902028327",
"cpuCount" : null,
"guid" : "DEB2908B77A2DE19E053CA00000A9EE5",
93
22.2.1.0.1 新機能

View Slide

"dbid" : "2902028327",
"conId" : "3",
"orcl-jyvid1" : {
},
"orcl-jyvid2" : {
}
},
"serviceName" : "DB19c_PDB1.paas.oracle.com",
"connectString" : "orcl-jyvid-scan.sub07160524340.testvcn.oraclevcn.com:1521/DB19c_PDB1.paas.oracle.com"
} ],
"pdbSize" : "4GB",
}
},
"messages" : [ ]
}
94
22.2.1.0.1 新機能

View Slide

dbaascli database deleteInstance（失敗パターン１）
[root@orcl-jyvid1 ~]# dbaascli database deleteInstance --dbname DB19c --node orcl-jyvid1
Executing command database deleteInstance --node orcl-jyvid1
Job id: 357de19c-6e75-4f77-9fb8-997238e2f618
Loading PILOT...
Log file location: /var/opt/oracle/log/DB19c/database/deleteInstance/pilot_2022-05-11_12-58-24-AM
-----------------
-----------------
Running Validate_input job
Execution of Validate_input failed
[FATAL] [DBAAS-70126] An instance cannot be deleted from the local node.
ACTION: Specify a different node.
Executing jobs which need to be run always...
Completed execution.
[FATAL] [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin delete_db_instance_cloud NODE_NAME="orcl-jyvid1" DB_NAME="DB19c"
-J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DB19c/database/deleteInstance -silent -
checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_311-amd64/jre ' execution has failed on nodes [localnode].
ACTION: Refer application log file for more information.
*MORE DETAILS*
Result of node:localnode
[Execution of Validate_input failed, [FATAL] [DBAAS-70126] An instance cannot be deleted from the local node., ACTION: Specify a different
node., ******** PLUGIN EXECUTION FAILED ********, Executing jobs which need to be run always..., Completed execution.]
Exit code of the operation:255
--自ノードのインスタンスは削除できない
95
22.2.1.0.1 新機能

View Slide

dbaascli database deleteInstance（失敗パターン2）
Job id: 985eebdd-fea3-43ed-bf47-f02a1d53e820
Loading PILOT...
-----------------
-----------------
Execution of Validate_input failed
[FATAL] [DBAAS-70127] The instance in node 'orcl-jyvid2' is a preferred instance for service 'DB19c_PDB1.paas.oracle.com'.
ACTION: Specify a different node.
[FATAL] [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin delete_db_instance_cloud NODE_NAME="orcl-jyvid2" DB_NAME="DB19c"
-J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DB19c/database/deleteInstance -silent -
checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_311-amd64/jre ' execution has failed on nodes [localnode].
*MORE DETAILS*
[Execution of Validate_input failed, [FATAL] [DBAAS-70127] The instance in node 'orcl-jyvid2' is a preferred instance for service
'DB19c_PDB1.paas.oracle.com'., ACTION: Specify a different node., ******** PLUGIN EXECUTION FAILED ********, Executing jobs which need to be
run always..., Completed execution.]
--削除対象のインスタンスがDB19c_PDB1.paas.oracle.comサービスのpreferredに指定されている為、削除できない
96
22.2.1.0.1 新機能

View Slide

Job id: b5070c29-5a56-4cc6-9484-95ccf096ffa6
Loading PILOT...
-----------------
-----------------
Completed Validate_input job
-----------------
Running Delete_db_instance job
Completed Delete_db_instance job
-----------------
Running Reload_db_details job
Completed Reload_db_details job
-----------------
Running Remove_backup_jobs job
Completed Remove_backup_jobs job
-----------------
Running Update_cloud_metadata job
Completed Update_cloud_metadata job
-----------------
97
22.2.1.0.1 新機能

View Slide

--該当サービスの優先インスタンスからノード２を除外した後、再度削除処理を実施
Job id: b5070c29-5a56-4cc6-9484-95ccf096ffa6
Loading PILOT...
-----------------
-----------------
Completed Validate_input job
-----------------
Running Delete_db_instance job
Completed Delete_db_instance job
-----------------
Running Reload_db_details job
Completed Reload_db_details job
-----------------
Running Remove_backup_jobs job
Completed Remove_backup_jobs job
-----------------
Running Update_cloud_metadata job
Completed Update_cloud_metadata job
-----------------
98
22.2.1.0.1 新機能

View Slide

--インスタンス削除後のDBの状態
[root@orcl-jyvid1 ~]# dbaascli database getdetails --dbname DB19c
Executing command database getdetails
Job id: 3330b270-92d7-4c79-9d6b-7486695c415c
{
"dbSyncTime" : 0,
"createTime" : 1652227200000,
"updateTime" : 0,
"dbName" : "DB19c",
"dbId" : 2232397119,
"cpuCount" : 4,
"dbSize" : "29GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.13.0.0.0",
},
"orcl-jyvid1" : {
"version" : "19.13.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "2902028327",
"cpuCount" : null,
"dbid" : "2902028327",
"conId" : "3",
"orcl-jyvid1" : {
99

View Slide

}
},
} ],
"pdbSize" : "4GB",
}
},
"messages" : [ ]
}
100
22.2.1.0.1 新機能

View Slide

--インスタンス削除後、OCIコンソールでは下記メッセージが表示される
101
22.2.1.0.1 新機能

View Slide

dbaascli database duplicate
[root@vm01wasa-zb1hy1 ~]# dbaascli database duplicate --help
Executing command database duplicate --help
Usage: dbaascli database duplicate --dbName --sourceDBConnectionString
{
--oracleHome
| --oracleHomeName
}
[--dbSID ] [--dbUniqueName ] [--sgaSizeInMB ] [--pgaSizeInMB ] [--datafileDestination ] [--
fraDestination ] [--fraSizeInMB ] [--sourceDBWalletLocation ] [--nodeList ]
{
}
[--rmanParallelism ] [--rmanSectionSizeInGB ] [--tdeConfigMethod [--kmsKeyOCID ]] [--sourceDBTdeConfigMethod
[--sourceDBKmsKeyOCID ]] [--executePrereqs] [--waitForCompletion ]
Where:
--sourceDBConnectionString - source database connection string in the format of :/.
--oracleHome - specifies Oracle home location
--oracleHomeName - specifies Oracle home name
[--dbSID - specifies database SID]
[--dbUniqueName - specifies database unique name]
[--sgaSizeInMB - specifies sga_target value in mega byte unit]
[--pgaSizeInMB - specifies pga_aggregate_target value in mega byte unit]
[--datafileDestination - specifies ASM disk group name to use for database datafiles]
[--fraDestination - specifies ASM disk group name to use for database fast recovery area]
[--fraSizeInMB - specifies fast recovery area size value in mega byte unit]
[--sourceDBWalletLocation - specifies source database TDE wallet directory location. This is required to duplicate database from active
database. ]
データベースのduplicate
102

View Slide

dbaascliを使用したOracle Grid Infrastructure
およびOracle Databasesへのパッチ適用
103

View Slide

• インプレース適用
• 現在の Oracle Home にパッチを適用する
• dbaascli dbhome patch
• アウトオブプレース適用（推奨）
• パッチ適用済（新しいバージョン）のOracle Home にデータベースを移動する
• dbaascli database move
データベースへのパッチ適用
104

View Slide

Oracle Databasesへのインプレースパッチ適用
105

View Slide

[root@vmem-6gl0h1 ~]# dbaascli dbhome info
ACTION: It is recommended to use 'dbaascli dbHome getDetails or
dbaascli system getDBHomes' for this operation.
1.HOME_NAME=OraHome2
VERSION=19.13.0.0
DBs installed=
VERSION=19.14.0.0
DBs installed=
VERSION=19.20.0.0
DBs installed=DBFDSI DB19
Agent DB IDs=2b67088f-a84c-4b70-a2bc-9650d128fa97 d2705e01-7891-
4bf7-8e91-5f01988a5a64
VERSION=19.21.0.0
Agent DB IDs=e1546bda-82ae-4d56-b824-6d3a89e8afeb
VERSION=19.20.0.0
DBs installed=Tutorial
Agent DB IDs=56916e81-b9ed-436b-ad80-8c771b24da0a
データベースホームへのパッチ適用(インプレース・パッチ適用)事前確認
106
2023/11/21時点

View Slide

dbaascli dbhome patch --help
[root@vmem-6gl0h1 ~]# dbaascli dbhome patch --help
Executing command dbhome patch --help
Usage: dbaascli dbHome patch --targetVersion
{
--oracleHome
| --oracleHomeName
}
[--imageFilePath ] [--executePrereqs] [--nodes ]
{
| [--rollback [--sessionID ]]
}
[--skipDatapatch] [--skipClosedPDBs] [--skipPDBs ] [--continueWithDbDowntime] [--skipUnreachableNodes] [--waitForCompletion ]
Where:
--targetVersion - target version to be patched to, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0).
[--imageFilePath - absolute path of the image file to be used. ]
[--nodes - comma separated list of nodes if operation has to be performed on subset of nodes. ]
[--resume | --rollback]
[--rollback - option to rollback patched Oracle home. ]
[--skipDatapatch - option to skip running datapatch on the databases. ]
[--skipClosedPDBs - option to skip running datapatch on closed PDBs. ]
[--skipPDBs - option to skip running datapatch on given PDBs. Example: cdb1:pdb1,cdb2:pdb2... ]
[--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is only 1 active instance
running and the patching operation can be continued even with downtime.]
[--skipUnreachableNodes - option to skip operation on unreachable nodes. ]
データベースホームへのパッチ適用(インプレース・パッチ適用)コマンド一覧
107
2023/11/21時点

View Slide

dbaascli dbhome patch --executePrereqs
[root@vmem-6gl0h1 ~]# dbaascli dbhome patch --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0
--executePrereqs
Executing command dbhome patch --oracleHome
--executePrereqs
Job id: 69e14da1-c965-44c1-97cc-857391ee9665
Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11-
21_02-01-32-PM_85342.log
Loading PILOT...
Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11-
21_02-01-36-PM_86313
-----------------
Running initialization job
Completed initialization job
-----------------
Running validate_user_input job
Completed validate_user_input job
-----------------
Running validate_nodes job
Completed validate_nodes job
-----------------
Running validate_oracle_home job
Completed validate_oracle_home job
-----------------
Running validate_source_version job
Completed validate_source_version job
-----------------
Running validate_target_version job
Completed validate_target_version job
-----------------
Running validate_creg_file_existence job
Completed validate_creg_file_existence job
-----------------
Running validate_diag_perm job
Completed validate_diag_perm job
-----------------
Running validate_backup_loc job
Completed validate_backup_loc job
-----------------
Running validate_patch_across_nodes job
Completed validate_patch_across_nodes job
-----------------
Running validate_databases job
Completed validate_databases job
-----------------
-----------------
108
2023/11/21時点

View Slide

dbaascli dbhome patch --executePrereqs
<続き>
Running validate_gold_image_url job
Completed validate_gold_image_url job
-----------------
Running validate_disk_space job
Completed validate_disk_space job
-----------------
Running validate_audit_files_in_source_home job
Completed validate_audit_files_in_source_home job
-----------------
Running download_gold_image job
Completed download_gold_image job
-----------------
Running validate_gold_image job
Completed validate_gold_image job
-----------------
Running run_installer_prereqs job
Completed run_installer_prereqs job
-----------------
Running check_patch_conflict job
Completed check_patch_conflict job
-----------------
Running remove_unzip_loc job
Completed remove_unzip_loc job
109
2023/11/21時点

View Slide

dbaascli dbhome patch
Job id: d086529e-2cf6-47b1-8a7e-f29e03de71b0
21_02-08-28-PM_148985.log
Loading PILOT...
21_02-08-32-PM_149942
-----------------
-----------------
-----------------
-----------------
-----------------
Running validate_source_version job
Completed validate_source_version job
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
<続く>
データベースホームへのパッチ適用(インプレース・パッチ適用)適用
110
2023/11/21時点

View Slide

<続き>
-----------------
-----------------
-----------------
Running pre_patch_lock_manager job
Completed pre_patch_lock_manager job
-----------------
Running copy_image-vmem-6gl0h1 job
Completed copy_image-vmem-6gl0h1 job
-----------------
Running stop_database_instance-vmem-6gl0h1 job
Completed stop_database_instance-vmem-6gl0h1 job
-----------------
Running detach_home-vmem-6gl0h1 job
Completed detach_home-vmem-6gl0h1 job
-----------------
Running move_home-vmem-6gl0h1 job
Completed move_home-vmem-6gl0h1 job
-----------------
Running move_image_to_home_loc-vmem-6gl0h1 job
Completed move_image_to_home_loc-vmem-6gl0h1 job
-----------------
Running setup_db_home-vmem-6gl0h1 job
Completed setup_db_home-vmem-6gl0h1 job
-----------------
Running update_inventory-vmem-6gl0h1 job
Completed update_inventory-vmem-6gl0h1 job
-----------------
Running root_script_execution-vmem-6gl0h1 job
Completed root_script_execution-vmem-6gl0h1 job
-----------------
Running copy_home_to_backup_loc-vmem-6gl0h1 job
Completed copy_home_to_backup_loc-vmem-6gl0h1 job
-----------------
Running move_config_files-vmem-6gl0h1 job
Completed move_config_files-vmem-6gl0h1 job
-----------------
Running start_database_instance-vmem-6gl0h1 job
Completed start_database_instance-vmem-6gl0h1 job
-----------------
Running exacs_post_patch_node_updation-vmem-6gl0h1 job
Completed exacs_post_patch_node_updation-vmem-6gl0h1 job
-----------------
-----------------
-----------------
-----------------
-----------------
<続く>
111
2023/11/21時点

View Slide

<続き>
-----------------
-----------------
-----------------
-----------------
-----------------
Running remove_home_from_backup_loc job
Completed remove_home_from_backup_loc job
-----------------
Running datapatch_and_recompile_invalid_objects job
Datapatch execution on database 'Tutorial' is in progress
Datapatch execution on database 'Tutorial' is complete
Recompilation of invalid objects on database 'Tutorial' is in
progress
Recompilation of invalid objects on database 'Tutorial' is complete
Completed datapatch_and_recompile_invalid_objects job
-----------------
Running backup_old_home job
Completed backup_old_home job
-----------------
-----------------
Running post_patch_lock_manager job
Completed post_patch_lock_manager job
-----------------
Running cleanup job
Completed cleanup job
-----------------
Running generate_dbsystem_details job
Completed generate_dbsystem_details job
112
2023/11/21時点

View Slide

dbaascli dbhome patch --resume
[root@vmem-6gl0h1 opc]# dbaascli dbhome patch --oracleHome
--resume
--resume
Job id: 7255a0a9-82ce-47f0-bac9-e5e202490a61
16_04-03-10-PM_355722.log
Loading PILOT...
16_04-03-14-PM_356469
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
dbaascliを使用したデータベース・ホームへのパッチ適用再開
113
2023/11/21時点

View Slide

-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
Running
114
2023/11/21時点

View Slide

-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
progress
-----------------
Running backup_old_home job
Completed backup_old_home job
-----------------
-----------------
Running cleanup job
-----------------
115
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli dbhome info
ACTION: It is recommended to use 'dbaascli dbHome getDetails or dbaascli
system getDBHomes' for this operation.
VERSION=19.21.0.0
Agent DB IDs=e1546bda-82ae-4d56-b824-6d3a89e8afeb
VERSION=19.21.0.0
DBs installed=Tutorial
Agent DB IDs=56916e81-b9ed-436b-ad80-8c771b24da0a
VERSION=19.13.0.0
DBs installed=
VERSION=19.14.0.0
DBs installed=
VERSION=19.20.0.0
DBs installed=DBFDSI DB19
Agent DB IDs=2b67088f-a84c-4b70-a2bc-9650d128fa97 d2705e01-7891-
4bf7-8e91-5f01988a5a64
OH Backup=NOT Configure
データベースホームへのパッチ適用(インプレース・パッチ適用)適用後確認
116
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli database getDetails --dbname Tutorial
Executing command database getDetails --dbname Tutorial
Job id: 7ecf510c-4d24-48b1-85f7-baa324bafc64
Session log:
/var/opt/oracle/log/Tutorial/database/getDetails/dbaastools_2023-11-
21_02-52-20-PM_237823.log
{
"dbSyncTime" : 1700544784902,
"createTime" : 1699936138000,
"updateTime" : 0,
"dbName" : "Tutorial",
"dbUniqueName" : "Tutorial_mss_kix",
"dbId" : 2483528602,
"cpuCount" : 4,
"dbSize" : "51GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.21.0.0.0",
"tenancyOCID" :
"ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb
uazc5tkguca",
"compartmentOCID" :
"ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37
iydjpezoghgmh7a",
"resourceOCID" : "ocid1.database.oc1.ap-osaka-
1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm7ze6tf6aa",
"resourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a",
},
"tdeDetails" : {
"tdeMasterKeyId" :
"AdyFgnerrE/+v3zjE/rRJJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
},
"vmem-6gl0h1" : {
"instanceName" : "Tutorial1",
"version" : "19.21.0.0.0",
"status" : "OPEN"
},
117
2023/11/21時点

View Slide

<続き>
"vmem-6gl0h2" : {
"version" : "19.21.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "1370933588",
"cdbId" : "56916e81-b9ed-436b-ad80-8c771b24da0a",
"cpuCount" : 4,
"guid" : "0A165E6D95AD5FF4E0639500000AC2B9",
"dbid" : "1370933588",
"conId" : "3",
"tenancyOCID" :
"ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5
tkguca",
"compartmentOCID" :
"ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjp
ezoghgmh7a",
"tenancyOCID" :
"ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkg
uca",
"compartmentOCID" :
"ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezo
ghgmh7a",
"resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka-
1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbojiorfrsgdu6ccmgv3gvaia",
"resourceID" : "1370933588",
"parentResourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a"
},
"tdeDetails" : {
"tdeMasterKeyId" :
"ARbiuLLc6086v+JmNfEoia8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
},
118
2023/11/21時点

View Slide

"vmem-6gl0h1" : {
},
"vmem-6gl0h2" : {
}
},
"serviceName" : "Tutorial_PDB1.paas.oracle.com",
"connectString" : "vmem-6gl0h-
scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.orac
le.com",
"tcpsConnectStrings" : [ "vmem-6gl0h-
scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.orac
le.com" ]
} ],
"pdbSize" : "8GB",
}
},
"messages" : [ ]
}
119
2023/11/21時点

View Slide

/u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 --
rollback
/u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 --
rollback
Job id: 5c2b0096-1e09-45aa-bffb-366b24729277
Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11-21_02-56-
27-PM_318459.log
Loading PILOT...
Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11-21_02-
56-32-PM_319554
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
データベースホームへのパッチ適用(インプレース・パッチ適用)適用後ロールバック
120
2023/11/21時点

View Slide

-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
121
2023/11/21時点

View Slide

-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
122
2023/11/21時点

View Slide

-----------------
-----------------
progress
-----------------
-----------------
Running cleanup job
-----------------
123
2023/11/21時点

View Slide

Oracle Databasesへのアウトオブプレースパッチ適
用
124

View Slide

dbaascli database move --help
[root@vmem-6gl0h1 ~]# dbaascli database move --help
Executing command database move --help
Usage: dbaascli database move
{
--oracleHome
| --oracleHomeName
}
--dbname [--executePrereqs]
{
}
[--skipDatapatch] [--skipPDBs ] [--skipClosedPDBs] [--continueWithDbDowntime] [--allowParallelDBMove] [--waitForCompletion ] [--nodeList ]
Where:
[--rollback - option to rollback database to previous home. ]
[--skipDatapatch - option to skip running datapatch on the databases. ]
[--skipPDBs - option to skip patching on given PDBs. Example: pdb1,pdb2... ]
[--skipClosedPDBs - option to skip patching on closed PDBs. ]
[--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is only 1 active instance
running and the patching operation can be continued even with downtime.]
[--allowParallelDBMove - option to allow database move in parallel. ]
[--nodeList - comma separated list of nodes if operation has to be performed on subset of nodes. ]
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)コマンド一覧
125
2023/11/21時点

View Slide

dbaascli database move
Job id: d6028009-c39b-4267-82d9-cb134d883acb
Session log:
21_03-21-04-PM_165778.
{
"dbSyncTime" : 1700546894660,
"createTime" : 1699936138000,
"updateTime" : 0,
"dbId" : 2483528602,
"cpuCount" : 4,
"dbSize" : "51GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.20.0.0.0",
"tenancyOCID" :
uazc5tkguca",
"compartmentOCID" :
iydjpezogh
1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)現状確認
126
2023/11/21時点

View Slide

},
"vmem-6gl0h1" : {
"version" : "19.20.0.0.0",
"status" : "OPEN"
},
"vmem-6gl0h2" : {
"version" : "19.20.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "1370933588",
"cpuCount" : 4,
"dbid" : "1370933588",
"conId" : "3",
"tenancyOCID" :
uazc5tkguc
"compartmentOCID" :
iydjpe
1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbo
"resourceID" : "1370933588",
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
127
2023/11/21時点

View Slide

"vmem-6gl0h1" : {
},
"vmem-6gl0h2" : {
}
},
"connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.
"tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB
} ],
"pdbSize" : "8GB",
}
},
"messages" : [ ]
}
128
2023/11/21時点

View Slide

移動先の DBHOME の確認
[root@vmem-6gl0h1 ~]# dbaascli system getDBHomes
Executing command system getDBHomes
Job id: a061464e-8d74-4d0d-ab6c-08e359d9a108
Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2023-
11-21_03-29-34-PM_272098.log
{
"OraHome1" : {
"version" : "19.20.0.0.0",
"createTime" : 1697764298000,
"updateTime" : 1697765609000,
"vmem-6gl0h1" : {
"version" : "19.20.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.20.0.0.0"
}
},
"messages" : [ ]
},
"OraHome2" : {
"version" : "19.13.0.0.0",
"createTime" : 1697776609000,
"updateTime" : 1697777833000,
"vmem-6gl0h1" : {
"version" : "19.13.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.13.0.0.0"
}
},
"messages" : [ ]
},
"OraHome3" : {
"version" : "19.14.0.0.0",
"createTime" : 1697786065000,
"updateTime" : 1697786065000,
"vmem-6gl0h1" : {
"version" : "19.14.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.14.0.0.0"
}
},
"messages" : [ ]
},
129
2023/11/21時点

View Slide

移動先の DBHOME の確認
"OraHome4" : {
"version" : "19.20.0.0.0",
"createTime" : 1699923823000,
"updateTime" : 1700546433000,
"vmem-6gl0h1" : {
"version" : "19.20.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.20.0.0.0"
}
},
"messages" : [ ]
},
" "OraHome6" : {
"version" : "19.21.0.0.0",
"createTime" : 1700455140000,
"updateTime" : 1700474635000,
"vmem-6gl0h1" : {
"version" : "19.21.0.0.0"
},
"vmem-6gl0h2" : {
"version" : "19.21.0.0.0"
}
},
"messages" : [ ]
}
}
130
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli database move --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial
Executing command database move --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial
Job id: c1b726e7-89af-4846-adab-d72533630f7e
Session log:
/var/opt/oracle/log/Tutorial/database/move/dbaastools_2023-11-21_03-
33-09-PM_304389.log
Loading PILOT...
Log file location:
/var/opt/oracle/log/Tutorial/database/move/pilot_2023-11-21_03-33-14-
PM_305034
-----------------
-----------------
-----------------
Running validate_database job
Completed validate_database job
-----------------
-----------------
Running validate_source_home job
Completed validate_source_home job
-----------------
Running validate_major_version job
Completed validate_major_version job
-----------------
Running validate_oracle_home_type job
Completed validate_oracle_home_type job
-----------------
Running check_target_source_home_not_same job
Completed check_target_source_home_not_same job
-----------------
Running validate_home_existence job
Completed validate_home_existence job
-----------------
Running validate_home_consistency job
Completed validate_home_consistency job
-----------------
Running validate_home_options job
Completed validate_home_options job
-----------------
Acquiring write lock: tutorial
----------------------------------
-----------------
Running copy_config_files job
Completed copy_config_files job
-----------------
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)適用
131
2023/11/21時点

View Slide

-----------------
Running update_database_resource-vmem-6gl0h1 job
Completed update_database_resource-vmem-6gl0h1 job
-----------------
-----------------
-----------------
-----------------
-----------------
Running exacs_post_patch_node_updation job
Completed exacs_post_patch_node_updation job
-----------------
Running update_dba_directories job
Completed update_dba_directories job
-----------------
progress
-----------------
Releasing lock: tutorial
-----------------
Running invoke_backup_asst job
Completed invoke_backup_asst job
-----------------
Running post_move_validation job
Completed post_move_validation job
-----------------
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)適用
132
2023/11/21時点

View Slide

Job id: beaf2d8a-ab11-42fe-b991-c20f43e607d7
Session log:
21_03-44-33-PM_59171.log
{
"dbSyncTime" : 1700548919945,
"createTime" : 1699936138000,
"updateTime" : 0,
"dbId" : 2483528602,
"cpuCount" : 4,
"dbSize" : "55GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.21.0.0.0",
"tenancyOCID" :
uazc5tkguca",
"compartmentOCID" :
iydjpezoghgmh7a",
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
},
"vmem-6gl0h1" : {
"version" : "19.21.0.0.0",
"status" : "OPEN"
},
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)適用後確認
133
2023/11/21時点

View Slide

"vmem-6gl0h2" : {
"version" : "19.21.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "1370933588",
"cpuCount" : 4,
"dbid" : "1370933588",
"conId" : "3",
"tenancyOCID" :
"ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkgu
ca",
"compartmentOCID" :
"ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezog
hgmh7a",
"resourceID" : "1370933588",
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
"vmem-6gl0h1" : {
},
"vmem-6gl0h2" : {
}
},
scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.oracle.com",
scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.oracle.com" ]
} ],
"pdbSize" : "8GB",
}
},
"messages" : [ ]
}
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)適用後確認
134
2023/11/21時点

View Slide

[root@vmem-6gl0h1 ~]# dbaascli database move --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial --
rollback
Executing command database move --oracleHome
/u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial --
rollback
Job id: 31050e2b-b205-4a16-9d7c-dac5275dff5e
Session log:
/var/opt/oracle/log/Tutorial/database/move/dbaastools_2023-11-21_03-
47-32-PM_89169.log
Loading PILOT...
Log file location:
/var/opt/oracle/log/Tutorial/database/move/pilot_2023-11-21_03-47-37-
PM_91117
-----------------
-----------------
-----------------
Running validate_database job
Completed validate_database job
-----------------
-----------------
-----------------
Running validate_oracle_home_type job
Completed validate_oracle_home_type job
-----------------
Running check_target_source_home_not_same job
Completed check_target_source_home_not_same job
-----------------
Running validate_home_existence job
Completed validate_home_existence job
-----------------
Running validate_home_consistency job
Completed validate_home_consistency job
-----------------
Running validate_home_options job
Completed validate_home_options job
-----------------
Acquiring write lock: tutorial
-----------------
データベースホームへのパッチ適用(アウト・オブ・プレース・パッチ適用)
適用後ロールバック
135
2023/11/21時点

View Slide

-----------------
Running copy_config_files job
Completed copy_config_files job
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
Running exacs_post_patch_node_updation job
Completed exacs_post_patch_node_updation job
-----------------
Running update_dba_directories job
Completed update_dba_directories job
-----------------
progress
-----------------
Releasing lock: tutorial
-----------------
Running invoke_backup_asst job
Completed invoke_backup_asst job
-----------------
Running post_move_validation job
Completed post_move_validation job
-----------------
適用後ロールバック
136
2023/11/21時点

View Slide

Job id: db3787a5-5d7a-48da-827c-bb45a470c975
Session log:
21_04-00-10-PM_287998.log
{
"dbSyncTime" : 1700549872565,
"createTime" : 1699936138000,
"updateTime" : 0,
"dbId" : 2483528602,
"cpuCount" : 4,
"dbSize" : "55GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.20.0.0.0",
"tenancyOCID" :
uazc5tkguca",
"compartmentOCID" :
iydjpezoghgmh7a",
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
},
"vmem-6gl0h1" : {
"version" : "19.20.0.0.0",
"status" : "OPEN"
},
適用後ロールバック後確認
137
2023/11/21時点

View Slide

"vmem-6gl0h2" : {
"version" : "19.20.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "1370933588",
"cpuCount" : 4,
"dbid" : "1370933588",
"conId" : "3",
"tenancyOCID" :
"ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca",
"compartmentOCID" :
"ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgm
h7a",
"resourceID" : "1370933588",
},
"tdeDetails" : {
"tdeMasterKeyId" :
},
"vmem-6gl0h1" : {
},
"vmem-6gl0h2" : {
}
},
scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.oracle.com",
scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.oracle.com"
]
} ],
"pdbSize" : "8GB",
}
},
"messages" : [ ]
}
適用後ロールバック後確認
138
2023/11/21時点

View Slide

Grid Infrastructure へのパッチ適用/ロールバック
139

View Slide

dbaascli grid patch --help
[root@vmem-6gl0h1 ~]# dbaascli grid patch --help
Executing command grid patch --help
grid patch - patch the Grid Infrastructure to the specified minor version.
Usage: dbaascli grid patch
{
--targetVersion
| --targetHome
}
[--executePrereqs] [--nodeList ] [--continueWithDbDowntime] [--containerURL ]
{
[--createImage [--createImageDir ]]
| [--imageFile ]
}
[--patchInParallel]
{
}
[--waitForCompletion ]
<続く>
グリッド・インフラストラクチャへのパッチ適用前の事前チェック
140
2023/11/21時点

View Slide

dbaascli grid patch --help
<続き>
Where:
--targetVersion | --targetHome
--targetVersion - target version to be patched to, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0).
--targetHome - fully qualified path of the target Grid Infrastructure home for the out of place patching.
[--nodeList - comma separated list of nodes if patching has to be performed on subset of nodes. ]
[--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is
only 1 active instance running and the patching operation can be continued even with downtime.]
[--containerURL - custom URL for fetching Oracle Grid Infrastructure Image. ]
[--createImage | --imageFile]
[--createImage - create an image from a copy of the active Grid Infrastructure home, patched to the specified target version.]
[--createImageDir - fully qualified path of the directory where the image is to be created.]
[--imageFile - fully qualified path of the image to be used.]
[--patchInParallel - perform the patching of the remote nodes in parallel.]
[--rollback - option to rollback patched OH. ]
グリッド・インフラストラクチャへのパッチ適用前の事前チェック
141
2023/11/21時点

View Slide

dbaascli grid patch --executePrereqs
[root@orakawa-vgfvk1 ~]# dbaascli grid patch --targetversion 19.14.0.0.0 --
executePrereqs
Executing command grid patch --targetversion 19.14.0.0.0 --executePrereqs
-----------------
Setting up parameters...
Patch Parameters setup successful.
-----------------
Loading PILOT...
Log file location: /var/opt/oracle/log/gridPatch/pilot_2022-03-28_01-33-05-
PM
-----------------
-----------------
-----------------
-----------------
Running validate_backup_locations job
Completed validate_backup_locations job
-----------------
-----------------
-----------------
Running validate_crs_stack_state job
Completed validate_crs_stack_state job
-----------------
-----------------
-----------------
Running validate_perm_on_dir job
Completed validate_perm_on_dir job
-----------------
-----------------
Running download_patches job
Completed download_patches job
-----------------
Running unpackage_patches job
Completed unpackage_patches job
-----------------
Running replace_opatch job
Completed replace_opatch job
-----------------
Running validate_patches job
Completed validate_patches job
-----------------
Running check_patch_conflicts job
Completed check_patch_conflicts job
<続く>
グリッド・インフラストラクチャへのパッチ適用前の事前チェックの実行
142

View Slide

dbaascli grid patch --executePrereqs
<続き>
-----------------
Running restore_opatch_prereqs_only job
Completed restore_opatch_prereqs_only job
-----------------
Running cleanup_prereqs_only job
Completed cleanup_prereqs_only job
Grid Patching Prereqs Execution Successful.
[root@orakawa-vgfvk1 ~]#
グリッド・インフラストラクチャへのパッチ適用前の事前チェックの実行
143

View Slide

dbaascli grid patch
[root@vmem-6gl0h1 opc]# dbaascli grid patch --targetVersion
19.21.0.0.0
Executing command grid patch --targetVersion 19.21.0.0.0
Job id: 837916c6-3496-4124-9ff9-48dc55dbe5a0
Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-11-17_11-
53-52-AM_163990.log
Loading PILOT...
Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-11-
17_11-53-56-AM_164600
-----------------
-----------------
-----------------
-----------------
Running validate_backup_locations job
Completed validate_backup_locations job
-----------------
-----------------
-----------------
Running validate_crs_stack_state job
Completed validate_crs_stack_state job
-----------------
-----------------
-----------------
Running validate_perm_on_dir job
Completed validate_perm_on_dir job
-----------------
-----------------
Running unpackage_patches job
Completed unpackage_patches job
-----------------
Running remove_zipped_patches job
Completed remove_zipped_patches job
-----------------
Running replace_opatch job
Completed replace_opatch job
-----------------
Running check_patch_conflicts job
Completed check_patch_conflicts job
Acquiring write lock: _u01_app_19.0.0.0_grid
-----------------
-----------------
Running create_global_backup_loc job
Completed create_global_backup_loc job
<続く>
dbaascliを使用したOracle Grid Infrastructureへのパッチ適用
144
2023/11/21時点

View Slide

dbaascli grid patch
<続き>
-----------------
Running rotate_image_backup job
Completed rotate_image_backup job
-----------------
Running backup_image job
Completed backup_image job
-----------------
Running rotate_config_backup job
Completed rotate_config_backup job
-----------------
Running backup_config-vmem-6gl0h1 job
Completed backup_config-vmem-6gl0h1 job
-----------------
Running save_local_backup-vmem-6gl0h1 job
Completed save_local_backup-vmem-6gl0h1 job
-----------------
Running stop_db_instances-vmem-6gl0h1 job
Completed stop_db_instances-vmem-6gl0h1 job
-----------------
Running run_rootcrs_prepatch-vmem-6gl0h1 job
Completed run_rootcrs_prepatch-vmem-6gl0h1 job
-----------------
Running stop_tfa-vmem-6gl0h1 job
Completed stop_tfa-vmem-6gl0h1 job
-----------------
Running check_processes-vmem-6gl0h1 job
Completed check_processes-vmem-6gl0h1 job
-----------------
Running rollback_conflicting_patches-vmem-6gl0h1 job
Completed rollback_conflicting_patches-vmem-6gl0h1 job
-----------------
Running apply_gi_oneoffs_prepatch-vmem-6gl0h1 job
Completed apply_gi_oneoffs_prepatch-vmem-6gl0h1 job
-----------------
Running apply_ru-vmem-6gl0h1 job
Completed apply_ru-vmem-6gl0h1 job
-----------------
Running stop_processes-vmem-6gl0h1 job
Completed stop_processes-vmem-6gl0h1 job
-----------------
Running apply_gi_oneoffs_postpatch-vmem-6gl0h1 job
Completed apply_gi_oneoffs_postpatch-vmem-6gl0h1 job
-----------------
Running rootadd_rdbms_script-vmem-6gl0h1 job
Completed rootadd_rdbms_script-vmem-6gl0h1 job
-----------------
Running run_rootcrs_postpatch-vmem-6gl0h1 job
Completed run_rootcrs_postpatch-vmem-6gl0h1 job
-----------------
Running start_db_instances-vmem-6gl0h1 job
Completed start_db_instances-vmem-6gl0h1 job
-----------------
Running update_opatch_log_ownership-vmem-6gl0h1 job
Completed update_opatch_log_ownership-vmem-6gl0h1 job
-----------------
Running disable_diagsnap-vmem-6gl0h1 job
Completed disable_diagsnap-vmem-6gl0h1 job
-----------------
<続く>
145
2023/11/21時点

View Slide

dbaascli grid patch
<続き>
Running restore_tfa_status-vmem-6gl0h1 job
Completed restore_tfa_status-vmem-6gl0h1 job
-----------------
Running remove_local_backup-vmem-6gl0h1 job
Completed remove_local_backup-vmem-6gl0h1 job
-----------------
Running cleanup-vmem-6gl0h1 job
Completed cleanup-vmem-6gl0h1 job
-----------------
Running backup_config_on_node-vmem-6gl0h2 job
Completed backup_config_on_node-vmem-6gl0h2 job
-----------------
Running save_local_backup_on_node-vmem-6gl0h2 job
Completed save_local_backup_on_node-vmem-6gl0h2 job
-----------------
Running stop_db_instances_on_node-vmem-6gl0h2 job
Completed stop_db_instances_on_node-vmem-6gl0h2 job
-----------------
Running run_rootcrs_prepatch_on_node-vmem-6gl0h2 job
Completed run_rootcrs_prepatch_on_node-vmem-6gl0h2 job
-----------------
Running stop_tfa_on_node-vmem-6gl0h2 job
Completed stop_tfa_on_node-vmem-6gl0h2 job
-----------------
Running stop_processes_on_node-vmem-6gl0h2 job
Completed stop_processes_on_node-vmem-6gl0h2 job
-----------------
Running remove_home_on_node-vmem-6gl0h2 job
Completed remove_home_on_node-vmem-6gl0h2 job
-----------------
Running copy_patched_home_from_local_node-vmem-6gl0h2 job
Completed copy_patched_home_from_local_node-vmem-6gl0h2 job
-----------------
Running unpackage_config_backup_on_node-vmem-6gl0h2 job
Completed unpackage_config_backup_on_node-vmem-6gl0h2 job
-----------------
Running run_rootcrs_postpatch_on_node-vmem-6gl0h2 job
Completed run_rootcrs_postpatch_on_node-vmem-6gl0h2 job
-----------------
Running start_db_instances_on_node-vmem-6gl0h2 job
Completed start_db_instances_on_node-vmem-6gl0h2 job
-----------------
Running disable_diagsnap_on_node-vmem-6gl0h2 job
Completed disable_diagsnap_on_node-vmem-6gl0h2 job
-----------------
Running restore_tfa_status_on_node-vmem-6gl0h2 job
Completed restore_tfa_status_on_node-vmem-6gl0h2 job
-----------------
Running remove_local_backup_on_node-vmem-6gl0h2 job
Completed remove_local_backup_on_node-vmem-6gl0h2 job
-----------------
Running remove_local_patched_home_on_node-vmem-6gl0h2 job
Completed remove_local_patched_home_on_node-vmem-6gl0h2 job
-----------------
<続く>
146
2023/11/21時点

View Slide

dbaascli grid patch
<続き>
Running cleanup_patched_home_backup job
Completed cleanup_patched_home_backup job
-----------------
Running post_patch_validation job
Completed post_patch_validation job
-----------------
Running update_creg job
Completed update_creg job
-----------------
Releasing lock: _u01_app_19.0.0.0_grid
-----------------
Running generate_system_details job
Completed generate_system_details job
147
2023/11/21時点

View Slide

dbaascli grid patch
[grid@vmem-6gl0h1 ~]$ opatch lspatches
35762404;OCW Interim patch for 35762404
35763448;ENFORCE V2 CHECKS ONLY FOR CLIENT CLOUD MNEMONIC QUERIES
34697081;NOT SHIPPING LIBAUTH_SDK_IAM.SO IN 23 SHIPHOME INSTALL
35638318;JDK BUNDLE PATCH 19.0.0.0.231017
35652062;ACFS RELEASE UPDATE 19.21.0.0.0 (35652062)
35643107;Database Release Update : 19.21.0.0.231017 (35643107)
35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096)
35099674;DSTV41 UPDATE - TZDATA2022G - NEED OJVM FIX
35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
dbaascliを使用したOracle Grid Infrastructureへのパッチ適用確認
148
2023/11/21時点

View Slide

dbaascli grid patch --rollback
[opc@vmem-6gl0h1 ~]$ sudo -s
[root@vmem-6gl0h1 opc]# dbaascli grid patch --targetVersion
19.21.0.0.0 --rollback
Executing command grid patch --targetVersion 19.21.0.0.0 --rollback
Job id: 740847a4-c20f-4dc9-9486-6c632ce1d548
Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-11-17_01-
09-55-PM_240689.log
Loading PILOT...
Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-11-
17_01-09-59-PM_241789
-----------------
-----------------
Running validate_backup_existence job
Completed validate_backup_existence job
Acquiring write lock: _u01_app_19.0.0.0_grid
-----------------
Running pre_rollback_lock_manager job
Completed pre_rollback_lock_manager job
-----------------
Running save_local_backup_for_rollback-vmem-6gl0h2 job
Completed save_local_backup_for_rollback-vmem-6gl0h2 job
-----------------
Running run_rootcrs_prepatch_for_rollback-vmem-6gl0h2 job
Completed run_rootcrs_prepatch_for_rollback-vmem-6gl0h2 job
-----------------
Running remove_home-vmem-6gl0h2 job
Completed remove_home-vmem-6gl0h2 job
-----------------
Running unpackage_image_backup-vmem-6gl0h2 job
Completed unpackage_image_backup-vmem-6gl0h2 job
-----------------
Running unpackage_config_backup-vmem-6gl0h2 job
Completed unpackage_config_backup-vmem-6gl0h2 job
-----------------
Running run_rootcrs_postpatch_for_rollback-vmem-6gl0h2 job
Completed run_rootcrs_postpatch_for_rollback-vmem-6gl0h2 job
-----------------
Running remove_local_backup_for_rollback-vmem-6gl0h2 job
Completed remove_local_backup_for_rollback-vmem-6gl0h2 job
-----------------
Running remove_global_config_backup_for_rollback-vmem-6gl0h2 job
Completed remove_global_config_backup_for_rollback-vmem-6gl0h2 job
-----------------
Running cleanup_for_rollback-vmem-6gl0h2 job
Completed cleanup_for_rollback-vmem-6gl0h2 job
-----------------
Running save_local_backup_for_rollback-vmem-6gl0h1 job
Completed save_local_backup_for_rollback-vmem-6gl0h1 job
-----------------
Running run_rootcrs_prepatch_for_rollback-vmem-6gl0h1 job
Completed run_rootcrs_prepatch_for_rollback-vmem-6gl0h1 job
-----------------
Running remove_home-vmem-6gl0h1 job
Completed remove_home-vmem-6gl0h1 job
-----------------
Running unpackage_image_backup-vmem-6gl0h1 job
Completed unpackage_image_backup-vmem-6gl0h1 job
-----------------
<続く>
dbaascliを使用したOracle Grid Infrastructureへのパッチのロールバック適用
149
2023/11/21時点

View Slide

<続き>
Running unpackage_config_backup-vmem-6gl0h1 job
Completed unpackage_config_backup-vmem-6gl0h1 job
-----------------
Running run_rootcrs_postpatch_for_rollback-vmem-6gl0h1 job
Completed run_rootcrs_postpatch_for_rollback-vmem-6gl0h1 job
-----------------
Running remove_local_backup_for_rollback-vmem-6gl0h1 job
Completed remove_local_backup_for_rollback-vmem-6gl0h1 job
-----------------
Running remove_global_config_backup_for_rollback-vmem-6gl0h1 job
Completed remove_global_config_backup_for_rollback-vmem-6gl0h1 job
-----------------
Running cleanup_for_rollback-vmem-6gl0h1 job
Completed cleanup_for_rollback-vmem-6gl0h1 job
-----------------
Running cleanup_patched_home_backup_on_rollback job
Completed cleanup_patched_home_backup_on_rollback job
-----------------
Running post_rollback_validation job
Completed post_rollback_validation job
-----------------
Running update_creg_for_rollback job
Completed update_creg_for_rollback job
-----------------
Running post_rollback_lock_manager job
Completed post_rollback_lock_manager job
Releasing lock: _u01_app_19.0.0.0_grid
-----------------
Running generate_system_details job
Completed generate_system_details job
dbaascliを使用したOracle Grid Infrastructureへのパッチのロールバック適用
150
2023/11/21時点

View Slide

[grid@vmem-6gl0h1 ~]$ opatch lspatches
34243634;AIM ORA-600 [ATBMMN 1] - ATBMMN_MAKE_MODV_NULLABLE
34697081;NOT SHIPPING LIBAUTH_SDK_IAM.SO IN 23 SHIPHOME INSTALL
35080170;APPLIANCE.MODE IS DEFAULTED TO FALSE WITH ASM DISKGROUPS ON X10 EF CELLS AND CANNOT BE CHANGED
34993018;CLSF NEEDS TO CHECK I/O OSS ERROR CODE
34975490;14 SECS BLACKOUT WITH GRACEFUL CELL SERVICES SHUTDOWN
34810987;CACHE ASM METADATA IOS INTO EXADATA FLASHCACHE
35309390;OCW Interim patch for 35309390
35099674;DSTV41 UPDATE - TZDATA2022G - NEED OJVM FIX
35004974;JDK BUNDLE PATCH 19.0.0.0.230418
35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341)
35107512;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35107512)
35050325;ACFS RELEASE UPDATE 19.19.0.0.0 (35050325)
35042068;Database Release Update : 19.19.0.0.230418 (35042068)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
OPatch succeeded.
dbaascliを使用したOracle Grid Infrastructureパッチのロールバック後確認
151
2023/11/21時点

View Slide

その他
152

View Slide

dbaascli database stop --help
[root@orakawa-vgfvk1 ~]# dbaascli database stop --help
Executing command database stop --help
Usage: dbaascli database stop [--dbname ] [--mode ]
Where:
[--dbname - Oracle database name. ]
[--mode - abort|immediate|normal|transactional for DB. ]
データベースの停止
153

View Slide

dbaascli database stop
[root@orakawa-vgfvk1 ~]# dbaascli database stop --dbname dbcli01
Executing command database stop
Job id: 11be0a84-80e7-4e53-b94a-dff2ce819fde
[root@orakawa-vgfvk1 ~]# dbaascli database status --dbname dbcli01
Executing command database status
Database Status:
Instance dbclisid1 is not running on node orakawa-vgfvk1
Instance dbclisid2 is not running on node orakawa-vgfvk2
[root@orakawa-vgfvk1 ~]# ps -ef | grep ora_smon
oracle 240797 1 0 15:10 ? 00:00:00 ora_smon_dbcli02sid1
root 325923 297968 0 15:22 pts/1 00:00:00 grep --color=auto ora_smon
データベースの停止
154

View Slide

dbaascli database start --help
[root@orakawa-vgfvk1 ~]# dbaascli database start --help
Executing command database start --help
Usage: dbaascli database start [--dbname ] [--mode ]
Where:
[--mode - mount|nomount for DB.]
データベースの起動
155

View Slide

dbaascli database start
[root@orakawa-vgfvk1 ~]# dbaascli database start --dbname dbcli01
Executing command database start
Job id: d65598db-a4d0-419e-aa17-99362b572455
[root@orakawa-vgfvk1 ~]# dbaascli database status --dbname dbcli01
Executing command database status
Database Status:
Instance dbclisid1 is running on node orakawa-vgfvk1 with online services dbcli01_dbcli01pdb01.paas.oracle.com. Instance status: Open.
Instance dbclisid2 is running on node orakawa-vgfvk2 with online services dbcli01_dbcli01pdb01.paas.oracle.com. Instance status: Open.
Database name: dbcli01
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 – Production
[root@orakawa-vgfvk1 ~]# ps -ef | grep ora_smon
oracle 240797 1 0 15:10 ? 00:00:00 ora_smon_dbcli02sid1
oracle 336376 1 0 15:23 ? 00:00:00 ora_smon_dbclisid1
root 348701 297968 0 15:25 pts/1 00:00:00 grep --color=auto ora_smon
データベースの起動
156

View Slide

dbaascli database modifyParameters --help
[root@ecc2c1n1 ~]# dbaascli database modifyParameters --help
Executing command database modifyParameters --help
Usage: dbaascli database modifyParameters --dbname
{
--setParameters [--backupPrepared] [--instance ] [--allowBounce]
| --resetParameters [--backupPrepared] [--instance ] [--allowBounce]
}
Where:
--setParameters | --resetParameters
--setParameters - comma separated list of parameters to be modified with new values. E.g. parameter1=valueA,parameter2=valueB,etc.
[--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.]
[--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database
level.]
[--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.]
--resetParameters - comma separated list of parameters to be reset to their corresponding default values. E.g. parameter1,parameter2,etc.
[--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.]
[--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database
level.]
[--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.]
[root@ecc2c1n1 ~]#
データベースのパラメーター変更
157

View Slide

dbaascli database modifyParameters
[root@orakawa-vgfvk1 ~]# dbaascli database modifyParameters --dbname dbcli01 --setParameters "sga_min_size=100M"
Executing command database modifyParameters --setParameters sga_min_size=100M
INFO : Review log file => /var/opt/oracle/log/dbcli01/modifyParameters/modifyParameters_2022-03-28_15:28:46.168027364905.log
INFO : Validating inputs...
INFO : Validation of inputs PASSED
INFO : Processing parameters of the dbcli01 database...
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/modifyParameters/pilot_2022-03-28_03-28-47-PM
-----------------
Running Plugin_Initialize job
Completed Plugin_Initialize job
-----------------
Running Validate_Parameters job
Completed Validate_Parameters job
-----------------
Running Apply_Dynamic_Parameters_Changes job
Completed Apply_Dynamic_Parameters_Changes job
-----------------
Running Apply_Static_Parameters_Changes job
Completed Apply_Static_Parameters_Changes job
INFO : Parameters processing of the dbcli01 database COMPLETED
・・・
SQL> show parameter sga_min_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_min_size big integer 100M
データベースのパラメーター変更
158

View Slide

dbaascli database modifyParameters
[root@orakawa-vgfvk1 ~]# dbaascli database modifyParameters --dbname dbcli01 --resetParameters sga_min_size
Executing command database modifyParameters --resetParameters sga_min_size
INFO : Review log file => /var/opt/oracle/log/dbcli01/modifyParameters/modifyParameters_2022-03-28_15:32:15.674018387709.log
INFO : Validating inputs...
INFO : Validation of inputs PASSED
INFO : Processing parameters of the dbcli01 database...
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/modifyParameters/pilot_2022-03-28_03-32-16-PM
-----------------
Running Plugin_Initialize job
Completed Plugin_Initialize job
-----------------
Running Validate_Parameters job
Completed Validate_Parameters job
-----------------
Running Apply_Dynamic_Parameters_Changes job
Completed Apply_Dynamic_Parameters_Changes job
-----------------
Running Apply_Static_Parameters_Changes job
Completed Apply_Static_Parameters_Changes job
INFO : Parameters processing of the dbcli01 database COMPLETED
・・・
SQL> show parameter sga_min_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_min_size big integer 0
データベースのパラメーターリセット
159

View Slide

dbaascli dbhome purge --help
[root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --help
Executing command dbhome purge --help
dbHome purge - purge an empty Oracle Database Home/s existing on the VM.
Usage: dbaascli dbHome purge [--hName ] [--hPath ]
Where:
[--hName - name of Oracle Home to be purged. ]
[--hPath - path of Oracle Home to be purged. ]
Database Homeの削除
160

View Slide

dbaascli dbhome purge
DBの存在している dbhome の削除はエラーになる
VERSION=19.13.0.0
VERSION=19.13.0.0
DBs installed=
3.HOME_NAME=dbcli01
VERSION=19.12.0.0
Agent DB IDs=cc9b557e-4112-4df0-b126-50fd87c67cf5
[root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --hpath
Executing command dbhome purge --hpath
Number of databases in oracle home is 1: dbcli01
ERROR: Cannot purge with path /u02/app/oracle/product/19.0.0.0/dbhome_2: OH
is in use (at least one db is running from this OH)
For more information, check logs at /var/opt/oracle/log/deloh
161

View Slide

dbaascli dbhome purge DBの存在していない dbhome は一瞬で削除
VERSION=19.13.0.0
VERSION=19.13.0.0
DBs installed=
3.HOME_NAME=dbcli01
VERSION=19.12.0.0
[root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --hpath
Executing command dbhome purge --hpath
INFO: Removing Oracle Home /u02/app/oracle/product/19.0.0.0/dbhome_3
Successfully removed with path /u02/app/oracle/product/19.0.0.0/dbhome_3
VERSION=19.13.0.0
2.HOME_NAME=dbcli01
VERSION=19.12.0.0
162

View Slide

Failed > ハンバーガーメニューから Delete
dbaascli から dbhome 削除後のコンソールからの見え方
163

View Slide

21.4.1.1.0 からサポート非推奨
[root@orakawa-vgfvk1 ~]# dbaascli
The usage of dbaascli shell (interactive session) is deprecated. It is recommended to execute complete dbaascli commands on command prompt as suggested in all
document examples.
dbaascli のインタラクティブモードの非推奨
164

View Slide

dbaascli diag collect
[root@orakawa-vgfvk1 ~]# dbaascli diag collect --help
Executing command diag collect --help
Usage: dbaascli diag collect [--components ] [--startTime ] [--endTime ] [--nodes ] [--dbNames ] [--
objectStoreBucketURI ] [--destLocation ]
Where:
[--components - list of components for log collection. Expected values (one of) : db|gi|os|dbaastools|all]
[--startTime - specify startTime for log collection in the format YYYY-MM-DDTHH24:MM:SS. Default value is 24 hours prior to endTime.]
[--endTime - specify endTime for log collection in the format YYYY-MM-DDTHH24:MM:SS. Default value is current system time.]
[--nodes - comma separated list of nodes to collect logs]
[--dbNames - dbName for which to collect logs. Only one dbName can be specified]
[--objectStoreBucketURI - OSS PAR URL to upload log collection.]
[--destLocation - Location on domU to collect logs. Default : /var/opt/oracle/dbaas_acfs ]
デフォルトで24時間分を取得
それ以前が必要な場合は –-startTimeで指定
SR上げる際の情報取得
165

View Slide

dbaascli diag collect
[root@orakawa-vgfvk1 ~]# dbaascli diag collect
Executing command diag collect
LogFile: /var/opt/oracle/log/diagondemand/collect/collect_2022-03-28_15:39:22.24343636453.log
dbaascli diag collect called without component
INFO: Collecting logs between 2022-03-27T15:39:22 and 2022-03-28T15:39:22
INFO: Starting diag collect
Collected Archives: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20220328-0639.tar.gz ★先ファイルをSRにアップロード
SR上げる際の情報取得実行例
166

View Slide

dbaascli admin showLatestStackVersion --help
[root@orcl-jyvid1 ~]# dbaascli admin showLatestStackVersion --help
Executing command admin showLatestStackVersion --help
admin showLatestStackVersion - get latest available dbaastools rpm
Usage: dbaascli admin showLatestStackVersion
ダウンロードしてインストールできる最新バージョンのdbaastoolsを表示
167
22.2.1.0.1 追加

View Slide

dbaascli admin showLatestStackVersion
[root@orcl-jyvid1 ~]# dbaascli admin showLatestStackVersion
Executing command admin showLatestStackVersion
Job id: 41e009a8-51a2-4da0-9819-990f8adeb104
{
"description" : "DBAAS Tools for Oracle Public Cloud",
"version" : "22.2.1.0.1_220423.1318",
"baseVersion" : "22.2.1.0.1"
}
ダウンロードしてインストールできる最新バージョンのdbaastoolsを表示
168
22.2.1.0.1 追加

View Slide

dbaascli admin updateStack --help
[root@orakawa-vgfvk1 ~]# dbaascli admin updateStack --help
Executing command admin updateStack --help
Usage: dbaascli admin updateStack
{
[--version ]
| [--location ]
}
[--nodes ] [--force] [--resume [--sessionID ]] [--prechecksOnly]
Where:
[--version | --location]
[--version - Dbaastools rpm patch id or version number or LATEST.]
[--location - Full path of the dbaastools rpm to be installed.]
[--nodes - Comma separate list of nodes to install the rpm on. If this argument is not passed, then rpm will be installed on all the cluster nodes.]
[--force - Force the installation of a lower rpm version.]
[--resume - To resume the previous execution]
[--prechecksOnly - Only the prechecks will be executed for this operation.]
dbaascli の更新
169

View Slide

dbaascli admin updateStack --prechecksOnly
[root@exacs-test-6k76y1 ~]# dbaascli admin updateStack --version
21.4.1.1.0_220209.2354 --prechecksOnly
Executing command admin updateStack --version 21.4.1.1.0_220209.2354 --
prechecksOnly
INFO : Review log file => /var/opt/oracle/log/tooling/Update/Update_2022-04-
14_10:04:26.48630760203.log
============ Starting RPM update operation ===========
Loading PILOT...
Log file location: /var/opt/oracle/log/tooling/Update/pilot_2022-04-14_10-
04-27-AM
-----------------
-----------------
-----------------
Running Rpm_version_validation job
Execution of Rpm_version_validation failed
[FATAL] [DBAAS-70200] The target rpm version specified '21.4.1.1.0-
220209.2354' is lower than the existing source rpm version '22.1.1.1.0-
220317.1256' on node 'exacs-test-6k76y1'.
CAUSE: Cannot update rpm to a lower version level
ACTION: Specify a higher rpm version level than the source rpm version
level
[FATAL] [DBAAS-70200] The target rpm version specified '21.4.1.1.0-
220209.2354' is lower than the existing source rpm version '22.1.1.1.0-
220317.1256' on node 'exacs-test-6k76y1'.\n CAUSE: Cannot update rpm to a
lower version level\n ACTION: Specify a higher rpm version level than the
source rpm version level\n\n******** PLUGIN EXECUTION FAILED
********\n\nExecuting jobs which need to be run always...\nCompleted
execution. Operation failed with exit code 255
An error occurred during module execution.
Please refer to the log file for more information.
dbaascli の更新事前チェック（下位バージョンへのダウングレード時）
170

View Slide

dbaascli admin updateStack --prechecksOnly
[root@exacs-test-6k76y1 ~]# dbaascli admin updateStack --version LATEST --
prechecksOnly
Executing command admin updateStack --version LATEST --prechecksOnly
14_09:51:32.321065234657.log
Loading PILOT...
51-33-AM
-----------------
-----------------
-----------------
Completed Rpm_version_validation job
-----------------
Running Rpm_source_validation job
Completed Rpm_source_validation job
-----------------
Running Disk_space_validate job
Completed Disk_space_validate job
-----------------
Running Rpm_download job
-----------------
Running Rpm_validation job
-----------------
Running Rpm_local_installation job
-----------------
Running Rpm_remote_installation job
-----------------
Running Installed_rpm_backup job
-----------------
Running Cleanup_downloaded_rpm job
-----------------
Running Cleanup_legacy_rpms job
dbaascli の更新事前チェック（最新へのアップグレード時）
171

View Slide

dbaascli admin updateStack
[root@orakawa-vgfvk1 ~]# dbaascli admin updateStack --version LATEST
Executing command admin updateStack --version LATEST
28_15:45:35.50620880111.log
Loading PILOT...
45-36-PM
-----------------
-----------------
-----------------
[WARNING] [DBAAS-70212] The target rpm version specified '22.1.1.1.0-
220317.1256' is already installed on node 'orakawa-vgfvk1'.
level or exclude the specified node from node list
[WARNING] [DBAAS-70212] The target rpm version specified '22.1.1.1.0-
220317.1256' is already installed on node 'orakawa-vgfvk2'.
level or exclude the specified node from node list
Completed Rpm_version_validation job
-----------------
Running Rpm_source_validation job
Completed Rpm_source_validation job
-----------------
Running Disk_space_validate job
Completed Disk_space_validate job
-----------------
Running Rpm_download job
Completed Rpm_download job
-----------------
Running Rpm_validation job
Completed Rpm_validation job
-----------------
Running Rpm_local_installation job
Completed Rpm_local_installation job
-----------------
Running Rpm_remote_installation job
Completed Rpm_remote_installation job
-----------------
Running Installed_rpm_backup job
Completed Installed_rpm_backup job
-----------------
Running Cleanup_downloaded_rpm job
Completed Cleanup_downloaded_rpm job
-----------------
Running Cleanup_legacy_rpms job
Completed Cleanup_legacy_rpms job
============ Starting post RPM update operations ===========
Loading PILOT...
46-52-PM
-----------------
<続く>
dbaascli の更新
172

View Slide

<続き>
Running Plugin_initialize job
Completed Plugin_initialize job
-----------------
Running Validate_grid job
Completed Validate_grid job
-----------------
Running Validate_setup_scripts job
-----------------
Running Fix_dbname_property job
Completed Fix_dbname_property job
-----------------
Running Setup_journal_service job
-----------------
Running Setup_users job
Completed Setup_users job
-----------------
Running Create_sudoers job
-----------------
Running TTY_setup job
-----------------
Running Setup_atp_file_handlers job
-----------------
Running Mount_atp_huge_pages job
-----------------
Running Setup_huge_pages job
-----------------
Running Setup_rc_local job
-----------------
Running Update_u02_ownership job
-----------------
Running Setup_clean_db_logs_cron_job job
-----------------
Running Remove_rpm_update_cron_entries job
Completed Remove_rpm_update_cron_entries job
-----------------
Running Setup_backup_cron_entries job
Completed Setup_backup_cron_entries job
-----------------
Running Setup_acfs_symlinks job
-----------------
Running Create_acfs_volume job
-----------------
Running Add_oracle_user_to_acfs_resource job
Completed Add_oracle_user_to_acfs_resource job
-----------------
Running Setup_db_agent_wallet job
-----------------
<続く>
dbaascli の更新
173

View Slide

<続き>
Running Setup_tcps_wallet job
-----------------
Running Setup_image_encryption_wallet job
Completed Setup_image_encryption_wallet job
-----------------
Running Setup_bashrc job
-----------------
Running Pin_cluster_nodes job
-----------------
Running Setup_sys_asmsnmp_password job
-----------------
Running Configure_network_security job
-----------------
Running Setup_tcps_listeners job
-----------------
Running Populate_grid_creg job
-----------------
Running Setup_python job
Completed Setup_python job
-----------------
Running Setup_metadata_repository job
-----------------
Running Enable_SQL_patch_update job
-----------------
Running Update_ADBD_listener_configuration job
-----------------
Running Setup_ovm_templates job
-----------------
Running Remove_exadbcpatch_keys job
Completed Remove_exadbcpatch_keys job
-----------------
Running Synchronize_config_files job
Completed Synchronize_config_files job
-----------------
Running Disable_auto_rpm_update job
Completed Disable_auto_rpm_update job
-----------------
Running Remove_wget_rpm job
Completed Remove_wget_rpm job
-----------------
Running Toggle_cleandb_logs job
Completed Toggle_cleandb_logs job
-----------------
Running Setup_backup_assistant job
Completed Setup_backup_assistant job
-----------------
Running Clean_duplicate_images job
Completed Clean_duplicate_images job
-----------------
<続く>
dbaascli の更新
174

View Slide

<続き>
Running Update_sql_net_ora_file job
Completed Update_sql_net_ora_file job
-----------------
Running Update_db_env_file job
Completed Update_db_env_file job
-----------------
Running Fix_db_creg_file job
Completed Fix_db_creg_file job
-----------------
Running Check_tmp_ownership job
Completed Check_tmp_ownership job
-----------------
Running Fix_grid_sqlnet_file job
Completed Fix_grid_sqlnet_file job
-----------------
Running Setup_syslens job
Completed Setup_syslens job
-----------------
Running Update_creg_and_log_ownership job
Completed Update_creg_and_log_ownership job
-----------------
Running Upgrade_ahf job
Completed Upgrade_ahf job
dbaascli の更新
175

View Slide

dbaascli patch tools list
[root@orakawa-vgfvk1 ~]# dbaascli patch tools list
Executing command patch tools list
Checking Current tools on all nodes
orakawa-vgfvk1: Patchid : 22.1.1.1.0_220317.1256
No applicable tools patches are available
orakawa-vgfvk2: Patchid : 22.1.1.1.0_220317.1256
No applicable tools patches are available
All Nodes have the same tools version
dbaastools 更新版の一覧（現在は非推奨コマンドだが代替が見つからず。。）
176

View Slide

dbaascli diag healthCheck --help
[root@orakawa-vgfvk1 ~]# dbaascli diag healthcheck --help
Executing command diag healthcheck --help
Usage: dbaascli diag healthCheck [--nodes ] [--objectStoreBucketURI ] [--dbNames ] [--destLocation ]
Where:
[--nodes - comma separated list of nodes to collect logs]
[--objectStoreBucketURI - OSS PAR URL to upload log collection.]
[--dbNames - dbName for which to collect logs. Only one dbName can be specified]
[--destLocation - Location on domU to collect logs. Default : /var/opt/oracle/dbaas_acfs ]
診断ヘルスチェック
177

View Slide

dbaascli diag healthCheck
[root@orakawa-vgfvk1 ~]# dbaascli diag healthcheck
Executing command diag healthcheck
LogFile: /var/opt/oracle/log/diagondemand/healthcheck/healthcheck_2022-03-28_15:53:56.87035248471.log
INFO: Starting diag healthcheck
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20220328-0654.tar.gz
[root@orakawa-vgfvk1 ~]# gunzip /tmp/diag_cloudlogs_20220328-0654.tar.gz
178

View Slide

dbaascli diag healthCheck
[root@orakawa-vgfvk1 ~]# tar xvf /tmp/diag_cloudlogs_20220328-0654.tar
diag_cloudlogs_20220328-0654/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/diag_cloudlogs_bkgrd.sh
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/HealthCheckInfo/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/HealthCheckInfo/health_check_2022-03-28_15:54:04.53233449960.log
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/oracle/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/oracle/log/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/diag_cloudlogs_2022-03-28_15:54:03.42702949960.log
diag_cloudlogs_20220328-0654/orakawa-vgfvk1/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/diag_cloudlogs-cmd_2022-03-28_15:54:03.42702949960.log
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/diag_cloudlogs_bkgrd.sh
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/HealthCheckInfo/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/HealthCheckInfo/health_check_2022-03-28_15:54:04.609162356825.log
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/oracle/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/oracle/log/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/diag_cloudlogs_2022-03-28_15:54:03.426849356825.log
diag_cloudlogs_20220328-0654/orakawa-vgfvk2/CloudToolInfo/commonLogs/var/opt/oracle/log/diag_cloudlogs/diag_cloudlogs-cmd_2022-03-28_15:54:03.426849356825.log
diag_cloudlogs_20220328-0654/diag_cloudlogs.sh
diag_cloudlogs_20220328-0654/HealthCheckJson_orakawa-vgfvk1_20220328-0654.json
diag_cloudlogs_20220328-0654/Summary_20220328-0656.txt
diag_cloudlogs_20220328-0654/HealthCheckJson_orakawa-vgfvk2_20220328-0654.json
179

View Slide

dbaascli job getStatus
[root@ecc2c1n1 ~]# dbaascli job getstatus --jobID 510a29f9-536e-43fb-92ba-c05f2a098580
Executing command job getstatus --jobID 510a29f9-536e-43fb-92ba-c05f2a098580
{
"jobId" : "510a29f9-536e-43fb-92ba-c05f2a098580",
"status" : "Running",
"message" : "pdb localClone job: Running",
"logFile" : "/var/opt/oracle/log/dbcli05/pdb/localClone/dbaastools_2022-03-08_10-27-21-AM.log",
"createTimestamp" : 1646702843029,
"updatedTime" : 1646702890885,
"description" : "Service job report for operation pdb localClone",
"appMessages" : {
"messages" : [ ],
"errorAction" : null
},
"resourceList" : [ ],
"pct_complete" : "40"
}
jobの確認
180

View Slide

dbaascli job getStatus
[root@orakawa-vgfvk1 ~]# dbaascli job getstatus --jobID 5fe09764-a314-4113-a279-1638e322b33d
Executing command job getstatus --jobID 5fe09764-a314-4113-a279-1638e322b33d
{
"jobId" : "5fe09764-a314-4113-a279-1638e322b33d",
"status" : "Success",
"message" : "database delete job: Success",
"logFile" : "/var/opt/oracle/log/dbcli02/database/delete/dbaastools_2022-03-28_04-03-28-PM.log",
"createTimestamp" : 1648451011342,
"updatedTime" : 1648451223622,
"description" : "Service job report for operation database delete",
"appMessages" : {
"messages" : [ ],
"errorAction" : "SUCCEED_AND_SHOW"
},
"resourceList" : [ ],
"pct_complete" : "100"
}
jobの確認
181

View Slide

dbaascli domUevent notify
[oracle@orakawa-vgfvk1 ~]$ dbaascli domUevent notify --help
Executing command domUevent notify --help
domUEvent notify - Notify CPS of a domu event.
Usage: dbaascli domUEvent notify --eventFile --sha256sum
Where:
--eventFile - Path of the event file
--sha256sum - sha256 checksum of the event file
domUイベントの CPS 通知
182

View Slide

dbaascli database deleteInstance --help
[root@orcl-jyvid1 ~]# dbaascli database deleteInstance --help
Executing command database deleteInstance --help
Usage: dbaascli database deleteInstance --dbname --node
Where:
--node - Specify the node name for database instance.
インスタンスの削除
183
22.2.1.0.1 で追加

View Slide

[root@orcl-jyvid1 ~]# dbaascli database deleteInstance --help
Usage: dbaascli database deleteInstance --dbname --node
Where:
--node - Specify the node name for database instance.
184
22.2.1.0.1 で追加

View Slide

dbaascli dbHome getDatabases --help
[root@orcl-jyvid1 ~]# dbaascli dbHome getDatabases --help
Executing command dbHome getDatabases --help
Usage: dbaascli dbHome getDatabases
{
--oracleHomeName
| --oracleHome
}
Where:
オラクル・ホームの情報表示
185
22.2.1.0.1 で追加

View Slide

dbaascli dbHome getDatabases
[root@orcl-jyvid1 ~]# dbaascli dbHome getDatabases --oraclehomename OraHome4
Executing command dbHome getDatabases --oraclehomename OraHome4
Job id: 0f00a4b9-8ec2-4b2e-8977-a1fa2c91af99
{
"DB19c" : {
"dbSyncTime" : 0,
"createTime" : 1652227200000,
"updateTime" : 0,
"dbName" : "DB19c",
"dbId" : 2232397119,
"cpuCount" : 4,
"dbSize" : "29GB",
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "19.13.0.0.0",
},
"orcl-jyvid1" : {
"version" : "19.13.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"PDB1" : {
"pdbName" : "PDB1",
"pdbUID" : "2902028327",
"cpuCount" : null,
"dbid" : "2902028327",
"conId" : "3",
"orcl-jyvid1" : {
}
オラクル・ホーム内のデータベースの情報表示
186
22.2.1.0.1 で追加

View Slide

dbaascli dbHome getDatabases
},
} ],
"pdbSize" : "4GB",
}
},
"messages" : [ ]
}
}
オラクル・ホーム内のデータベースの情報表示
187
22.2.1.0.1 で追加

View Slide

dbaascli database addInstance
[root@vm01wasa-zb1hy1 ~]# dbaascli database addInstance --help
Executing command database addInstance --help
Usage: dbaascli database addInstance --dbname --node [--newNodeSID ]
{
}
Where:
--node - specifies the node name for database instance.
[--newNodeSID - SID for the instance to add in the new node. ]
インスタンスの追加
188

View Slide

[root@vm01wasa-zb1hy1 ~]# dbaascli database deleteInstance --help
Usage: dbaascli database deleteInstance --dbname --node [--continueOnUnreachableNode]
{
}
Where:
--node - specifies the node name for database instance.
[--continueOnUnreachableNode - perform the operation even if the node is unreachable.]
189

View Slide

dbaascli database changePassword
[root@vm01wasa-zb1hy1 ~]# dbaascli database changePassword --help
Executing command database changePassword --help
Usage: dbaascli database changePassword --dbname [--user ]
{
[--prepareStandbyBlob [--blobLocation ]]
| [--standbyBlobFromPrimary ]
}
Where:
[--user - username whose password change is required. ]
[--prepareStandbyBlob | --standbyBlobFromPrimary]
[--prepareStandbyBlob - specifies true to generate a blob file containing the artifacts needed to perform the operation in a DG environment. ]
[--blobLocation - custom directory location where the standby blob file will be generated in a DG environment.]
[--standbyBlobFromPrimary - specifies the location of the standby blob file which is prepared from the primary database. This is required only for
standby operations. ]
データベースのパスワード変更
190

View Slide

OCPU数の増減
191

View Slide

dbaascli cpuScale update
[root@orakawa-vgfvk1 ~]# dbaascli cpuScale update --help
Executing command cpuScale update --help
cpuScale update - update CPU core count for each VM in the cluster to the input count value.
Usage: dbaascli cpuScale update --coreCount [--message ]
Where:
--coreCount - CPU core count value (per VM) for the cluster.
[--message - text message.]
[root@orakawa-vgfvk1 ~]# dbaascli cpuScale getStatus
Executing command cpuScale getStatus
** CPU Scale Status **
OCPU数の増減
192

View Slide

dbaascli cpuScale update -coreCount
[root@orakawa-vgfvk1 ~]# dbaascli cpuScale update --coreCount 4
Executing command cpuScale update --coreCount 4
** CPU Scale Update **
OCPU数の増減
193
※現バージョンではExaC@C専用の
コマンドの為、実行してもエラーになる

View Slide

dbaascli cpuScale getStatus
[root@orakawa-vgfvk1 ~]# dbaascli cpuScale get_Status
Executing command cpuScale get_Status
** CPU Scale Status **
OCPU数の増減
194
※現バージョンではExaC@C専用の
コマンドの為、実行してもエラーになる

View Slide

アップグレード
195

View Slide

dbaascli database upgrade --help
[root@orakawa-vgfvk1 ~]# dbaascli database upgrade --help
Executing command database upgrade --help
Usage: dbaascli database upgrade --dbname
{
--targetHome
| --targetHomeName
}
{
[--executePrereqs]
| [--postUpgrade]
| [--revert]
}
{
[--standBy]
| [--allStandbyPrepared]
}
{
[--upgradeOptions ]
| [--standBy]
}
[--removeGRP] [--increaseCompatibleParameter]
データベースのアップグレード
196

View Slide

dbaascli database upgrade --help
<続き>
Where:
--targetHome | --targetHomeName
--targetHome - target Oracle database home location.
--targetHomeName - target Oracle database home name.
[--executePrereqs | --postUpgrade | --revert]
[--executePrereqs - to execute the Pre-Upgrade checks only. ]
[--postUpgrade - if post upgrade failed and need to rerun the post upgrade steps. ]
[--revert - to revert an Oracle database to its original Oracle home. ]
[--standBy | --allStandbyPrepared]
[--standBy - use this to upgrade Oracle standby databases in Data Guard configurations. ]
[--allStandbyPrepared - required for Data Guard configured Oracle primary databases. Flag to acknowledge that all the required operations are performed
on the Oracle standby databases prior to performing the upgrade of Oracle primary database. ]
[--upgradeOptions | --standBy]
[--upgradeOptions - to pass DBUA specific arguments to perform the Oracle database upgrade. Refer to the corresponding Oracle documentation for the
supported arguments and options. ]
[--standBy - use this to upgrade Oracle standby databases in Data Guard configurations. ]
[--removeGRP - to automatically remove the Guaranteed Restore Point (GRP) backup only if the upgrade of the database was successful. ]
[--increaseCompatibleParameter - to automatically increase the compatible parameter as part of the database upgrade. The parameter will get increased
only if the database upgrade was successful. ]
データベースのアップグレード
197

View Slide

dbaascli database --getDetails
[root@orcl0329-pfutx1 ~]# dbaascli database getDetails --dbname dbcli18
Job id: e1ef9bd8-4d83-43ce-98f8-b8218e24612a
{
"id" : "25275077-16be-46d9-ae57-bb7ebc4ffc49",
"dbSyncTime" : 0,
"createTime" : 1648598400000,
"updateTime" : 0,
"dbUniqueName" : "dbcli18_n3q_kix",
"dbId" : 3595557280,
"cpuCount" : 4,
"isCDB" : true,
"dbType" : "RAC",
"dbClass" : "OLTP",
"dbEdition" : "EE",
"patchVersion" : "18.16.0.0.0",
},
"orcl0329-pfutx1" : {
"nodeName" : "orcl0329-pfutx1",
"instanceName" : "dbcli181",
"version" : "18.16.0.0.0",
"status" : "OPEN"
},
"instanceName" : "dbcli182",
"version" : "18.16.0.0.0",
"status" : "OPEN"
}
},
"pdbs" : {
"DBCLI18PDB01" : {
"pdbUID" : "1720577308",
"cpuCount" : null,
"guid" : "DB65849B719C4BAEE0531E00000A1BCC",
"dbid" : "1720577308",
"conId" : "3",
<続く>
データベースのアップグレード事前確認
198

View Slide

dbaascli database --getDetails
<続き>
},
}
},
"connectString" : "orcl0329-pfutx-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli18_dbcli18pdb01.paas.oracle.com"
} ]
}
},
"messages" : [ ]
}
199

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli dbhome info
VERSION=18.16.0.0
DBs installed=dbcli18 ★アップグレード対象のDB
Agent DB IDs=25275077-16be-46d9-ae57-bb7ebc4ffc49
<略>
HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_3 ★アップグレード先のDBホーム
VERSION=19.13.0.0
Agent DB IDs=67cccc45-2067-4719-b643-fab5a4714949
200

View Slide

dbaascli database upgrade
[root@orcl0329-pfutx1 ~]# dbaascli database upgrade --dbname dbcli18 --
targetHome /u02/app/oracle/product/19.0.0.0/dbhome_3
Executing command database upgrade --targetHome
INFO : Review log file =>
/var/opt/oracle/log/dbcli18/dbupgrade/dbupgrade_2022-03-
30_01:22:13.718925395863.log
INFO : Source ohome is /u02/app/oracle/product/18.0.0.0/dbhome_1
INFO : Source version is 18.16.0.0.0
INFO : Target version is 19.13.0.0.0
INFO : Executing Pre-Upgrade steps...
INFO : Running Pre-Upgrade information tool checks...
Logs directory:
/u02/app/oracle/cfgtoollogs/dbcli18_n3q_kix/preupgrade/2022-03-30012225
Performing Pre-Upgrade Checks...
============================
Pre-Upgrade Checks Results
=============================
/u02/app/oracle/cfgtoollogs/dbcli18_n3q_kix/preupgrade/2022-03-
30012225/dbcli18_n3q_kix/upgrade.xml
30012225/dbcli18_n3q_kix/preupgrade_fixups.sql
30012225/dbcli18_n3q_kix/postupgrade_fixups.sql
INFO : Refer to the following log file for any required action(s) that need
to be reviewed or addressed:
/var/opt/oracle/log/dbcli18/dbupgrade/preupgrade_summary_2022-03-
30_01:22:13.718925.log
INFO : No required manual actions were detected as part of the Pre-Upgrade
check results.
INFO : Pre-Upgrade information tool checks PASSED
INFO : Running Pre-Upgrade check for valid components in the source
database...
INFO : Pre-Upgrade check for valid components in the source database PASSED
INFO : Running collection of Pre-Upgrade diagnostics...
INFO : Collection of Pre-Upgrade diagnostics PASSED
INFO : Running Pre-Upgrade check for TDE wallet in autologin mode...
INFO : Validating TDE wallet configuration in node orcl0329-pfutx1...
INFO : Validating TDE wallet configuration in node orcl0329-pfutx2...
INFO : Pre-Upgrade check for TDE wallet PASSED
INFO : Running Pre-Upgrade check for EM Database Control repository...
INFO : Pre-Upgrade check for EM Database Control repository PASSED
INFO : Running Pre-Upgrade check for the SPFILE pointer integrity...
INFO : Pre-Upgrade check for the SPFILE pointer integrity PASSED
INFO : Running Pre-Upgrade check for ARCHIVELOG enabling...
INFO : Pre-Upgrade check for ARCHIVELOG enabling PASSED
INFO : Running Pre-Upgrade check for new timezone version in source
database...
INFO : Pre-Upgrade check for new timezone version in source database PASSED
INFO : Running Pre-Upgrade check for closed PDBs...
INFO : Pre-Upgrade check for closed PDBs PASSED
INFO : Running Pre-Upgrade check for permissions on network configuration...
INFO : Pre-Upgrade check for permissions on network configuration PASSED
INFO : Running Pre-Upgrade check for valid ARCHIVELOG destinations...
INFO : Pre-Upgrade check for valid ARCHIVELOG destinations PASSED
INFO : Pre-Upgrade steps PASSED
INFO : Executing Upgrade steps...
<続く>
データベースのアップグレード実行
201

View Slide

<続き>
INFO : Running Upgrade step for creation of guaranteed restore point...
INFO : Guaranteed Restore Point created, restore point name:
DBAAS#UPGRADE#20220330013247#
INFO : Upgrade step for creation of guaranteed restore point COMPLETED
INFO : Running upgrade step for back up of configuration files...
INFO : Backup of creg, env, spfile and pfile to
/var/opt/oracle/dbaas_acfs/upgrade_backup/dbcli18
INFO : Upgrade step for back up of configuration files COMPLETED
INFO : Running upgrade step for deletion of crontab entries related to
dbcli18 on all nodes...
INFO : Crontab entry deleted. After upgrade Reconfigure the backup again.
INFO : Upgrade step for deletion of crontab entries related to dbcli18 on
all nodes COMPLETED
INFO : Running upgrade step for dropping of profile 'dbaassecure'...
INFO : Upgrade step for dropping of profile 'dbaassecure' COMPLETED
INFO : Running upgrade step for disablement of concurrent stats gathering...
INFO : Setting CONCURRENT statistics to OFF
INFO : Upgrade step for disablement of concurrent stats gathering COMPLETED
INFO : Running upgrade step for Oracle Label Security preprocess script...
INFO : Copying olspreupgrade.sql from Target to Source
INFO : As Database Vault is installed. Grant DV_PATCH_ADMIN to SYS.
INFO : Executing script olspreupgrade.sql at Source
INFO : Script olspreupgrade.sql executed
INFO : Upgrade step for Oracle Label Security preprocess script COMPLETED
INFO : Running upgrade step for copying tnsname.ora and sqlnet.ora from
/u02/app/oracle/product/18.0.0.0/dbhome_1/network/admin/dbcli18 to
/u02/app/oracle/product/19.0.0.0/dbhome_3/network/admin/dbcli18...
INFO : Upgrade step for copying tnsname.ora and sqlnet.ora from
/u02/app/oracle/product/18.0.0.0/dbhome_1/network/admin/dbcli18 to
/u02/app/oracle/product/19.0.0.0/dbhome_3/network/admin/dbcli18 COMPLETED
INFO : Running upgrade step for assistant tool...
Logs directory: /u02/app/oracle/cfgtoollogs/dbcli18_n3q_kix/upgrade/2022-
03-30013247
Performing Pre-Upgrade Checks...
============================
Pre-Upgrade Checks Results
=============================
/u02/app/oracle/cfgtoollogs/dbcli18_n3q_kix/upgrade/2022-03-
30013247/dbcli18_n3q_kix/upgrade.xml
30013247/dbcli18_n3q_kix/preupgrade_fixups.sql
30013247/dbcli18_n3q_kix/postupgrade_fixups.sql
[WARNING] [DBT-20060] One or more Oracle upgrade pre-checks resulted in
warning conditions that may require further review.
ACTION: Refer to the pre-upgrade results location for details:
30013247/dbcli18_n3q_kix
7% complete
9% complete
15% complete
23% complete
23% complete
23% complete
23% complete
<続く>
202

View Slide

<続き>
23% complete
23% complete
24% complete
24% complete
24% complete
24% complete
24% complete
24% complete
24% complete
25% complete
25% complete
25% complete
25% complete
25% complete
25% complete
26% complete
26% complete
26% complete
26% complete
26% complete
26% complete
26% complete
27% complete
27% complete
27% complete
27% complete
27% complete
27% complete
28% complete
28% complete
28% complete
28% complete
28% complete
28% complete
28% complete
29% complete
29% complete
29% complete
29% complete
29% complete
29% complete
30% complete
30% complete
30% complete
30% complete
30% complete
30% complete
38% complete
46% complete
46% complete
47% complete
53% complete
54% complete
61% complete
61% complete
61% complete
62% complete
62% complete
62% complete
62% complete
<続く>
203

View Slide

<続き>
62% complete
62% complete
62% complete
63% complete
63% complete
63% complete
63% complete
63% complete
63% complete
64% complete
64% complete
64% complete
64% complete
64% complete
64% complete
64% complete
65% complete
65% complete
65% complete
65% complete
65% complete
65% complete
66% complete
66% complete
66% complete
66% complete
66% complete
66% complete
66% complete
67% complete
67% complete
67% complete
67% complete
67% complete
67% complete
68% complete
68% complete
68% complete
68% complete
68% complete
68% complete
68% complete
69% complete
69% complete
76% complete
84% complete
92% complete
Database upgrade has been completed successfully, and the database is ready
to use.
100% complete
INFO : Running upgrade step for modifying source metadata cloud registry...
INFO : Adding original env values in Source creg
INFO : Updating Source env values with values of Target
INFO : Upgrade step for modifying source metadata cloud registry COMPLETED
INFO : Collecting logs from assistant tool...
INFO : Upgrade step for assistant tool COMPLETED
INFO : Running upgrade step for collecting Post-Upgrade diagnostics...
INFO : Upgrade step for collecting Post-Upgrade diagnostics COMPLETED
INFO : Upgrade steps executed
INFO : Executing Post-Upgrade steps...
<続く>
204

View Slide

<続き>
INFO : Running Post-Upgrade step for fixups...
INFO : Post-Upgrade step for fixups COMPLETED
INFO : Running Post-Upgrade step for setting new tns_admin environment
variable: /u02/app/oracle/product/19.0.0.0/dbhome_3/network/admin/dbcli18 ...
INFO : Post-Upgrade step for setting new tns_admin environment variable
COMPLETED
INFO : Running Post-Upgrade step for replicating the PFILE across nodes...
INFO : Running Post-Upgrade step for replicating the PFILE across nodes
COMPLETED
INFO : Restarting the DB.
INFO : Running Post-Upgrade step for modifying oratab entry to all nodes...
INFO : Post-Upgrade step for modifying oratab entry to all nodes COMPLETED
INFO : Running Post-Upgrade step for modifying oraenv entry to all nodes...
INFO : Post-Upgrade step for modifying oraenv entry to all nodes COMPLETED
INFO : Running Post-Upgrade step for updating creg file...
INFO : Post-Upgrade step for updating creg file COMPLETED
INFO : Running Post-Upgrade step for syncing tnsnames.ora file to other rac
nodes...
INFO : Post-Upgrade step for syncing tnsnames.ora file to other rac nodes
COMPLETED
INFO : Running Post-Upgrade step for bkup assistant for dbname: dbcli18
INFO : Post-Upgrade step for bkup assistant for dbname: dbcli18 COMPLETED
INFO : Post-upgrade steps executed
INFO : Database upgrade operation COMPLETED
205

View Slide

dbaascli grid upgrade --help
[root@orcl0329-pfutx1 ~]# dbaascli grid upgrade --help
Executing command grid upgrade --help
Usage: dbaascli grid upgrade --targetVersion [--containerURL ] [--executePrereqs] [--resume [--sessionID ]] [--rollback] [--
targetHome ] [--softwareOnly]
Where:
--targetVersion - target version to be upgraded to.
[--containerURL - custom url for fetching GI Image. ]
[--executePrereqs - option to execute prereqs. ]
[--rollback - option to revert failed execution. ]
[--targetHome - path of the target grid home for the operation which is different from the current grid home. ]
[--softwareOnly - option to install only grid software. ]
gridのアップグレード
206

View Slide

dbaascli grid upgrade --executePrereqs
gridのアップグレード事前確認
207
19c以上のメジャーバージョンがない
ため、実施不可

View Slide

dbaascli grid upgrade
gridのアップグレード実行
208

View Slide

dbaascli grid upgrade
gridのアップグレード実行後確認
209

View Slide

PDBの管理
210

View Slide

dbaascli pdb --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb --help
Executing command pdb --help
pdb bounce - Bounce the PDB.
PDBコマンド一覧
211

View Slide

dbaascli pdb bounce
[root@orakawa-vgfvk1 ~]# dbaascli pdb bounce --dbName dbcli01 --pdbname DBCLI01PDB01
Executing command pdb bounce --dbName dbcli01 --pdbname DBCLI01PDB01
Job id: 0f60aad0-e23d-418c-973c-46994dbbb9ec
PDBのバウンス
212

View Slide

dbaascli pdb close
[root@orakawa-vgfvk1 ~]# dbaascli pdb close --dbName dbcli01 --pdbname DBCLI01PDB01
Executing command pdb close --dbName dbcli01 --pdbname DBCLI01PDB01
Job id: 336d0d67-408a-4859-9f65-31412c2de034
[oracle@orakawa-vgfvk1 ~]$ sqlplus / as sysdba
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DBCLI01PDB01 MOUNTED
PDBを停止
213

View Slide

dbaascli pdb close
[root@orakawa-vgfvk1 ~]# dbaascli pdb list --dbName dbcli01
Executing command pdb list --dbName dbcli01
Job id: 1ec38883-d4d4-4235-896f-cfb337c45ce1
[ {
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
"openMode" : "MOUNTED"
},
"openMode" : "MOUNTED"
}
},
} ]
} ]
PDBを停止
214

View Slide

dbaascli pdb open
[root@orakawa-vgfvk1 ~]# dbaascli pdb open --dbName dbcli01 --pdbname DBCLI01PDB01
Executing command pdb open --dbName dbcli01 --pdbname DBCLI01PDB01
Job id: be9f07c6-b3b7-46ec-a997-94fb36377a21
PDBのオープン
215

View Slide

dbaascli pdb open
[root@orakawa-vgfvk1 ~]# dbaascli pdb getdetails --dbName dbcli01 --pdbname DBCLI01PDB01
Executing command pdb getdetails --dbName dbcli01 --pdbname DBCLI01PDB01
Job id: a67c12f8-8a3f-4d8a-89dd-8460b359a01b
{
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
} ]
}
PDBのオープン
216

View Slide

dbaascli pdb connectString
[root@orakawa-vgfvk1 ~]# dbaascli pdb connectString --dbName dbcli01 --pdbname DBCLI01PDB01
Executing command pdb connectString --dbName dbcli01 --pdbname DBCLI01PDB01
Job id: 127e0f19-453c-403c-a36e-baf641a3e1d7
[ {
} ]
PDBの接続記述子
217

View Slide

baascli pdb create --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb create --help
Executing command pdb create --help
Usage: dbaascli pdb create --pdbName --dbName [--maxCPU ] [--maxSize ] [--pdbAdminUserName ] [--lockPDBAdminAccount
] [--resume [--sessionID ]] [--executePrereqs ] [--waitForCompletion ] [--primaryDBWalletTar ] [--resourceOCID --
tenancyOCID --compartmentOCID ]
Where:
--pdbName - Specify new PDB name.
[--maxCPU - Specify max number of CPUs to be allocated for the PDB. ]
[--maxSize - Specify max storage size in GB for the new PDB. ]
[--pdbAdminUserName - Specify new PDB admin user name]
[--lockPDBAdminAccount - Specify true or false to lock the PDB admin user account. Default value is true]
[--executePrereqs - Specify yes to run only the prereqs for this operation. Valid values : yes|no ]
[--waitForCompletion - Specify false to run the operation in background. Valid values : true|false.]
[--primaryDBWalletTar - specify primary database wallet tar file. This is required only for standby database PDB operations. ]
[--resourceOCID - resource OCID value to register the resource OCID.]
--tenancyOCID - tenancy OCID value to register the resource OCID.
--compartmentOCID - compartment OCID value to register the resource OCID.
PDBの作成
218

View Slide

baascli pdb create
[root@orakawa-vgfvk1 ~]# dbaascli pdb create --dbName dbcli01 --pdbname
DBCLI01PDB02
Executing command pdb create --dbName dbcli01 --pdbname DBCLI01PDB02
Job id: 047929e7-9ae9-45d0-8dd7-3e6df1d82435
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/pdb/create/pilot_2022-03-
28_04-51-39-PM
-----------------
-----------------
-----------------
-----------------
Running PDB_creation job
Completed PDB_creation job
-----------------
Running Load_pdb_details job
Completed Load_pdb_details job
-----------------
Completed Configure_pdb_service job
-----------------
-----------------
Completed Set_pdb_admin_user_profile job
-----------------
Completed Lock_pdb_admin_user job
-----------------
-----------------
PDBの作成
219

View Slide

dbaascli pdb delete --help
[oracle@vm01wasa-zb1hy1 ~]$ dbaascli pdb delete --help
Executing command pdb delete --help
Usage: dbaascli pdb delete --dbName
{
--pdbName
| --pdbUID
}
[--executePrereqs] [--waitForCompletion ] [--resume [--sessionID ]] [--allStandbyPrepared] [--cleanupRelocatedPDB]
Where:
--pdbName | --pdbUID
--pdbName - specifies name of the PDB to delete.
--pdbUID - specifies UID of the PDB to delete.
[--allStandbyPrepared - specifies to confirm that the operation has been successfully run on all the standby databases.]
[--cleanupRelocatedPDB - option to cleanup source database after a PDB has been relocated. ]
[oracle@vm01wasa-zb1hy1 ~]$
PDBの削除
220

View Slide

dbaascli pdb delete --help
[root@orcl-jyvid1 ~]# dbaascli pdb delete --help
Executing command pdb delete --help
Usage: dbaascli pdb delete --dbName
{
--pdbName
| --pdbUID
}
[--executePrereqs ] [--waitForCompletion ] [--resume [--sessionID ]] [--allStandbyPrepared]
Where:
--pdbName - Specify name of the PDB to delete.
--pdbUID - Specify UID of the PDB to delete.
[--allStandbyPrepared - Specify to confirm that the operation has been successfully run on all the standby databases.]
PDBの削除
221

View Slide

dbaascli pdb delete
[root@orakawa-vgfvk1 ~]# dbaascli pdb delete --dbName dbcli01 --pdbname DBCLI01PDB02
Executing command pdb delete --dbName dbcli01 --pdbname DBCLI01PDB02
Job id: 82612c7f-4725-4c88-9bca-90b6ee66a147
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/pdb/delete/pilot_2022-03-28_04-56-00-PM
-----------------
-----------------
-----------------
Running Delete_pdb_service job
Completed Delete_pdb_service job
-----------------
Running PDB_deletion job
Completed PDB_deletion job
-----------------
Running Delete_tnsnames_entry job
Completed Delete_tnsnames_entry job
-----------------
Running Cleanup_resource_ocid_file job
Completed Cleanup_resource_ocid_file job
-----------------
PDBの削除
222

View Slide

DB削除時と同じく、Failedになるので、コンソールから Terminated する
PDBの削除
コンソールからの見え方
223
削除後

View Slide

dbaascli pdb getDetails --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb getDetails --help
Executing command pdb getDetails --help
Usage: dbaascli pdb getDetails --dbname
{
--pdbName
| --pdbUID
}
Where:
--pdbName - PDB name.
--pdbUID - Identifier of PDB.
PDBの詳細確認
224

View Slide

dbaascli pdb getDetails
[root@orakawa-vgfvk1 ~]# dbaascli pdb getDetails --dbname dbcli01 --pdbname DBCLI01PDB01
Executing command pdb getDetails --pdbname DBCLI01PDB01
Job id: 64be9375-4ff6-44d2-b0d8-89f40468afb8
{
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
} ]
}
PDBの詳細確認
225

View Slide

dbaascli pdb list --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb list --help
Executing command pdb list --help
Usage: dbaascli pdb list --dbname
Where:
CDB内のPDBの一覧
226

View Slide

dbaascli pdb list
Job id: 0cc22b44-5f05-40fd-b460-ed95f0307dff
[ {
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
} ]
} ]
227

View Slide

dbaascli pdb localClone --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb localClone --help
Executing command pdb localClone --help
Usage: dbaascli pdb localClone --pdbName --dbName [--targetPDBName ] [--powerLimit ] [--maxCPU ] [--maxSize ]
[--resume [--sessionID ]] [--executePrereqs ] [--waitForCompletion ] [--primaryDBWalletTar ] [--excludeUserTablespaces ] [--
excludePDBData ] [--pdbAdminUserName ] [--lockPDBAdminAccount ] [--sourcePDBServiceConvertList ] [--resourceOCID --
tenancyOCID --compartmentOCID ]
Where:
--pdbName - Specify source PDB name to clone.
[--targetPDBName - Specify name for the target PDB (new cloned PDB). ]
[--powerLimit - Specify degree of parallelism to be used for the clone operation.]
[--excludeUserTablespaces - Option to skip user table spaces, example t1,t2,t3. ]
[--excludePDBData - Specify true/yes to skip user data from source pdb. ]
[--sourcePDBServiceConvertList - Specify comma separated list of source to target service names which need to be converted. Syntax is
source_srv1:new_srv1,source_srv2:new_srv2.]
同一CDB内のローカルクローンPDB作成
228

View Slide

dbaascli pdb localClone
[root@orakawa-vgfvk1 ~]# dbaascli pdb localClone --dbName dbcli01 --pdbName
DBCLI01PDB01
Executing command pdb localClone --dbName dbcli01 --pdbName DBCLI01PDB01
Job id: b06c6f36-fd17-4df8-a0a1-07de4ca90b34
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/pdb/localClone/pilot_2022-03-
28_05-02-12-PM
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
229

View Slide

Job id: 946bf399-972b-4f8d-8d86-aec9b0112bcb
[ {
“pdbName” : “DBCLI01PDB01”, ★クローン元
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.
oracle.com"
} ]
}, {
“pdbName” : “DBCLI01_DBCLI01PDB01”, ★クローンして作成したPDB
"pdbUID" : "2527289634",
"cpuCount" : null,
"guid" : "DB43BDF61CB7F94DE0533500000AF910",
"dbid" : "2527289634",
"conId" : "4",
},
}
},
"serviceName" : "dbcli01_DBCLI01_DBCLI01PDB01.paas.oracle.com",
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_DBCLI01_DBCLI01PDB
01.paas.oracle.com"
} ]
} ]
作成後の確認
230

View Slide

[root@orakawa-vgfvk1 ~]# dbaascli pdb localClone --dbName dbcli01 --pdbName
DBCLI01PDB01 --targetPDBName CLONE_PDB01
Executing command pdb localClone --dbName dbcli01 --pdbName DBCLI01PDB01 --
targetPDBName CLONE_PDB01
Job id: 84f2296c-3f09-444d-81c2-3ad2a7f8a140
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/pdb/localClone/pilot_2022-03-
28_05-07-34-PM
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
クローンのPDB名を指定して作成
231

View Slide

Job id: f70e7252-0446-40cb-87ba-188daa1478fc
[ {
“pdbName” : “CLONE_PDB01”, ★名前指定でクローンしたPDB
"pdbUID" : "1350521126",
"cpuCount" : null,
"guid" : "DB43D125DB4AA987E0533500000A5A8E",
"dbid" : "1350521126",
"conId" : "5",
},
}
},
"serviceName" : "dbcli01_CLONE_PDB01.paas.oracle.com",
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_CLONE_PDB01.paas.o
racle.com"
} ]
}, {
"pdbUID" : "3034439310",
"cpuCount" : null,
"guid" : "DB3D7503BCD57E96E0533500000A2869",
"dbid" : "3034439310",
"conId" : "3",
},
}
},
oracle.com"
} ]
<続く>
クローン後の確認
232

View Slide

<続き>
}, {
"pdbName" : "DBCLI01_DBCLI01PDB01",
"pdbUID" : "2527289634",
"cpuCount" : null,
"guid" : "DB43BDF61CB7F94DE0533500000AF910",
"dbid" : "2527289634",
"conId" : "4",
},
}
},
"connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_DBCLI01_DBCLI01PDB01.paas.oracle.com"
} ]
} ]
クローン後の確認
233

View Slide

dbaascli pdb remoteClone --help
[oracle@vm01wasa-zb1hy1 ~]$ dbaascli pdb remoteclone --help
Executing command pdb remoteclone --help
Usage: dbaascli pdb remoteClone --pdbName --dbName --sourceDBConnectionString [--targetPDBName ] [--powerLimit ] [--
maxCPU ] [--maxSize ] [--resume [--sessionID ]] [--executePrereqs] [--waitForCompletion ] [--sourcePDBExportedTDEKeyFile ]
{
[--blobLocation ]
}
[--excludeUserTablespaces ] [--excludePDBData ] [--pdbAdminUserName ] [--lockPDBAdminAccount ] [--
sourcePDBServiceConvertList ] [--refreshablePDB --refreshMode [--refreshIntervalInMinutes ] --dblinkUsername [--
honorCaseSensitiveUserName]] [--updateDBBlockCacheSize]
Where:
--pdbName - specifies source PDB name to clone.
--dbName - specifies target database name.
[--targetPDBName - specifies name for the target PDB (new cloned PDB). ]
[--powerLimit - specifies degree of parallelism to be used for the clone operation.]
[--maxCPU - specifies max number of CPUs to be allocated for the PDB. ]
[--maxSize - specifies max storage size in GB for the new PDB. ]
[--sourcePDBExportedTDEKeyFile - specifies source pdb exported key file. This variable is applicable to only 12.1 database.]
[--blobLocation | --standbyBlobFromPrimary]
[--standbyBlobFromPrimary - specifies the location of the standby blob file which is prepared from the primary database. This is required only for
standby operations. ]
[--excludeUserTablespaces - option to skip user table spaces, example t1,t2,t3. ]
[--excludePDBData - specifies true/yes to skip user data from source PDB. ]
別CDBへのリモートクローンPDB作成
コマンド一覧
234

View Slide

dbaascli pdb remoteClone --help
[root@orakawa-vgfvk1 ~]# dbaascli pdb remoteclone --help
Executing command pdb remoteclone --help
Usage: dbaascli pdb remoteClone --pdbName --dbName --sourceDBConnectionString [--targetPDBName ] [--powerLimit ] [--
maxCPU ] [--maxSize ] [--resume [--sessionID ]] [--executePrereqs ] [--waitForCompletion ] [--sourcePDBExportedTDEKeyFile
] [--primaryDBWalletTar ] [--excludeUserTablespaces ] [--excludePDBData ] [--pdbAdminUserName ] [--lockPDBAdminAccount
] [--sourcePDBServiceConvertList ] [--resourceOCID --tenancyOCID --compartmentOCID ]
Where:
--pdbName - Specify source PDB name to clone.
--dbName - Specify target database name.
--sourceDBConnectionString - Source database connection string in the format of :/.
[--targetPDBName - Specify name for the target PDB (new cloned PDB). ]
[--powerLimit - Specify degree of parallelism to be used for the clone operation.]
[--sourcePDBExportedTDEKeyFile - Specify source pdb exported key file. This variable is applicable to only 12.1 database.]
[--excludeUserTablespaces - Option to skip user table spaces, example t1,t2,t3. ]
[--excludePDBData - Specify true/yes to skip user data from source pdb. ]
[--sourcePDBServiceConvertList - Specify comma separated list of source to target service names which need to be converted. Syntax is
source_srv1:new_srv1,source_srv2:new_srv2.]
コマンド一覧
235

View Slide

dbaascli pdb remoteClone
[root@ecc2c1n1 dbhome_1]# cd network/
[root@ecc2c1n1 network]# ls
admin install jlib lib log mesg tools trace
[root@ecc2c1n1 network]# cd admin/
[root@ecc2c1n1 admin]# ls
DB220403 DB220404 dbcli03 dbcli04 samples shrept.lst
[root@ecc2c1n1 admin]# cd dbcli04
[root@ecc2c1n1 dbcli04]# cat tnsnames.ora
DBCLI04=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=ecc2c1-scan)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli04.jp.osc.oracle.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
PDB4=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=ecc2c1-scan)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=PDB4.jp.osc.oracle.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
DBCLI04_PDB4=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=ecc2c1-scan)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli04_PDB4.paas.oracle.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
[root@ecc2c1n1 dbcli04]#
ソースデータベース（CDB)の接続記述子確認
236

View Slide

[oracle@orcl0329-pfutx1 ~]$ cd $ORACLE_HOME/network/admin/dbcli01
[oracle@orcl0329-pfutx1 dbcli01]$ cat tnsnames.ora
DBCLI01_CZR_KIX=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=orcl0329-pfutx-scan.sub03230643360.orakawavcn.oraclevcn.com)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli01_czr_kix.sub03230643360.orakawavcn.oraclevcn.com)))
DBCLI01=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli01_czr_kix.sub03230643360.orakawavcn.oraclevcn.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
DBCLI01PDB01=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli01pdb01.sub03230643360.orakawavcn.oraclevcn.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
DBCLI01_DBCLI01PDB01=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=dbcli01_dbcli01pdb01.paas.oracle.com)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
ソースデータベース（CDB)の接続記述子確認
237

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli pdb remoteClone --
sourceDBconnectionString orcl0329-
pfutx1.****.oraclevcn.com:1521/dbcli01_czr_.****.oraclevcn.com --pdbName
DBCLI01PDB01 --dbname dbcli02
Executing command pdb remoteClone --sourceDBconnectionString orcl0329-pfutx-
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_czr_kix.sub0323064
3360.orakawavcn.oraclevcn.com --pdbName DBCLI01PDB01
Job id: 633cb170-8c4a-407b-a0d6-88057fb3fdb4
Enter REMOTE_DB_SYS_PASSWORD:
Enter REMOTE_DB_SYS_PASSWORD (reconfirmation):
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli02/pdb/remoteClone/pilot_2022-
03-30_05-01-05-AM
-----------------
Enter REMOTE_DB_SYS_PASSWORD
*************
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
238

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli pdb list --dbName dbcli02
Job id: 0e2fa202-146d-4514-b52e-66942cb38e6c
[ {
"pdbUID" : "1883940535",
"cpuCount" : null,
"guid" : "DB69026AA1F16CB5E0531E00000A109D",
"dbid" : "1883940535",
"conId" : "3",
},
}
},
"serviceName" : "dbcli02_DBCLI02PDB01.paas.oracle.com",
"connectString" : "orcl0329-pfutx-
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli02_DBCLI02PDB01.paas.
oracle.com"
} ]
}, {
“pdbName” : “DBCLI02_DBCLI01PDB01”,★クローンしたPDB
"pdbUID" : "639353669",
"cpuCount" : null,
"guid" : "DB6978B4E3F99C5EE0531E00000A0392",
"dbid" : "639353669",
"conId" : "4",
},
}
},
01.paas.oracle.com"
} ]
} ]
作成後の確認
239

View Slide

dbaascli pdb relocate --help
[root@orcl0329-pfutx1 ~]# dbaascli pdb relocate --help
Executing command pdb relocate --help
Usage: dbaascli pdb relocate --pdbName --dbName --sourceDBConnectionString [--targetPDBName ] [--powerLimit ] [--
maxCpu ] [--maxSize ] [--resume [--sessionID ]] [--executePrereqs ] [--sourcePDBServices ] [--sourcePDBReadOnlyServices
] [--waitForCompletion ] [--primaryDBWalletTar ]
Where:
--pdbName - Specify source pdb name to relocate.
--dbName - Specify target database name.
--sourceDBConnectionString - Source database connection string in the format of :/.
[--targetPDBName - Specify name for the target pdb (new relocated pdb). ]
[--powerLimit - Specify degree of parallelism to be used for the relocate operation.]
[--maxCpu - Specify max number of CPUs to be allocated for the PDB. ]
[--sourcePDBServices - Specify comma separated source PDB services]
[--sourcePDBReadOnlyServices - Specify comma separated source PDB read only services]
リモートデータベースからローカルデータベースへのPDBのリロケート
240

View Slide

dbaascli pdb relocate --help
[oracle@vm01wasa-zb1hy1 ~]$ dbaascli pdb relocate --help
Executing command pdb relocate --help
Usage: dbaascli pdb relocate --pdbName --dbName --sourceDBConnectionString [--targetPDBName ] [--powerLimit ] [--
maxCpu ] [--maxSize ] [--resume [--sessionID ]] [--executePrereqs] [--sourcePDBServices ] [--sourcePDBReadOnlyServices ] [--
waitForCompletion ]
{
[--blobLocation ]
}
[--upgradePDB ] [--updateDBBlockCacheSize]
{
[--skipOpenPDB]
| [--completePDBRelocate]
}
Where:
--pdbName - specifies source PDB name to relocate.
--dbName - specifies target database name.
[--targetPDBName - specifies name for the target PDB (new relocated pdb). ]
[--powerLimit - specifies degree of parallelism to be used for the relocate operation.]
[--maxCpu - specifies max number of CPUs to be allocated for the PDB. ]
[--maxSize - specifies max storage size in GB for the new PDB. ]
[--sourcePDBServices - specifies comma separated source PDB services]
[--sourcePDBReadOnlyServices - specifies comma separated source PDB read only services]
[--blobLocation | --standbyBlobFromPrimary]
241

View Slide

dbaascli pdb relocate
[root@orcl0329-pfutx1 ~]# dbaascli pdb relocate --dbname dbcli01 --pdbname
DBCLI02_DBCLI01PDB01 --sourceDBconnectionString orcl0329-
pfutx****.oraclevcn.com:1521/dbcli02.*****.oraclevcn.com
Executing command pdb relocate --pdbname DBCLI02_DBCLI01PDB01 --
sourceDBconnectionString orcl0329-pfutx-
scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli02_vwc_kix.sub0323064
3360.orakawavcn.oraclevcn.com
Job id: b15f3c7f-4b10-460b-acdc-97530dd69db2
Enter REMOTE_DB_SYS_PASSWORD:
Enter REMOTE_DB_SYS_PASSWORD (reconfirmation):
Loading PILOT...
Log file location: /var/opt/oracle/log/dbcli01/pdb/relocate/pilot_2022-03-
30_05-13-38-AM
-----------------
Enter REMOTE_DB_SYS_PASSWORD
**********
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
-----------------
242

View Slide

--ソースDBから対象のPDBがなくなっている事を確認
Job id: 85762ba4-eaf8-4c41-90ab-f36c745362d7
[ {
"pdbUID" : "1883940535",
"cpuCount" : null,
"guid" : "DB69026AA1F16CB5E0531E00000A109D",
"dbid" : "1883940535",
"conId" : "3",
},
}
},
"serviceName" : "dbcli02_DBCLI02PDB01.paas.oracle.com",
"connectString" : "orcl0329-pfutx-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli02_DBCLI02PDB01.paas.oracle.com"
} ]
} ]
リロケート後の確認
243

View Slide

--ターゲットDB上にPDBがいる事を確認
Job id: 9f11160d-fbfb-4c95-bcb1-9747a439cc63
[ {
"pdbUID" : "365264838",
"cpuCount" : null,
"guid" : "DB64D3DCF5B2E44DE0531E00000AD211",
"dbid" : "365264838",
"conId" : "3",
},
}
},
oracle.com" } ]
}, {
"pdbName" : "DBCLI02_DBCLI01PDB01",
"pdbUID" : "170684233",
"cpuCount" : null,
"guid" : "DB6978B4E3F99C5EE0531E00000A0392",
"dbid" : "639353669",
"conId" : "4",
},
}
},
01.paas.oracle.com"
}, {
01.paas.oracle.com"
} ]
} ]
リロケート後の確認
244

View Slide

dbaascli database getPDBs --help
[root@orcl-jyvid1 ~]# dbaascli database getPDBs --help
Executing command database getPDBs --help
Usage: dbaascli database getPDBs --dbname
Where:
245
22.2.1.0.1 新機能

View Slide

dbaascli database getPDBs
[root@orcl-jyvid1 ~]# dbaascli database getPDBs --dbname DB1909
Executing command database getPDBs
Job id: aa15c7c9-fac9-4317-b392-31f23a5b9212
[ {
"pdbName" : "PDB1",
"pdbUID" : "3260909885",
"cpuCount" : null,
"guid" : "DEA4A04A6059A7E6E053CA00000A6F55",
"dbid" : "3260909885",
"conId" : "3",
"orcl-jyvid1" : {
},
"orcl-jyvid2" : {
}
},
"connectString" : "orcl-jyvid-
scan.sub07160524340.testvcn.oraclevcn.com:1521/DB1909_PDB1.paas.oracle.com"
} ],
"pdbSize" : "4GB",
}, {
"pdbName" : "PDB2",
"pdbUID" : "3371374061",
"cpuCount" : null,
"guid" : "DEA514B85BE9E815E0537D00000AF4E7",
"dbid" : "3371374061",
"conId" : "4",
"orcl-jyvid1" : {
},
"orcl-jyvid2" : {
}
},
"connectString" : "orcl-jyvid-
scan.sub07160524340.testvcn.oraclevcn.com:1521/DB1909_PDB2.paas.oracle.com"
} ],
"pdbSize" : "4GB",
} ]
246
22.2.1.0.1 新機能

View Slide

データベースのバックアップ
247

View Slide

dbaascli database backup --help
[root@orcl0329-pfutx1 ~]# dbaascli database backup --help
Executing command database backup --help
database backup - Performs database backup operations.
Usage: dbaascli database backup --dbname
{
--list [--json ]
| --start
{
[--level0]
| [--level1]
| [--archival --tag ]
}
| --delete --backupTag
| --status --uuid
| --getBackupReport --tag --json
| --configure
{
--configFile
| --enableRTRT
| --disableRTRT
}
| --getConfig [--configFile ]
}
Where:
--list | --start | --delete | --status | --getBackupReport | --
configure | --getConfig
--list - Returns database backup information.
[--json - Specify file Name for json output. ]
--start - Begins database backup.
[--level0 | --level1 | --archival]
[--level0 - Creates a Level-0 (full) backup. ]
[--level1 - Creates a Level-1 (incremental) backup. ]
[--archival - Creates an Archival full backup. ]
--tag - Specify backup tag.
--delete - Deletes Archival backup.
--backupTag
--status
--uuid
--getBackupReport - Returns BackupReport.
--json - Specify file Name for json output.
--configure - Configures database for backup.
--configFile | --enableRTRT | --disableRTRT
--configFile - Specify database backup configuration file.
--enableRTRT - Enable Real Time Redo Transport.
--disableRTRT - Disable Real Time Redo Transport.
--getConfig - Returns database backup configuration.
[--configFile - Specify database backup configuration file. ]
データベースのバックアップコマンド一覧
248

View Slide

cbaascli database backup --getconfig
[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --getconfig --configfile /tmp/configfile_1.txt
Executing command database backup --getconfig --configfile /tmp/configfile_1.txt
DBaaS Backup API V1.5 @2022 Multi-Oracle home
-> Action : get_config
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_c10efe5a_20220329235902.598369.log
File /tmp/configfile_1.txt created
バックアップ構成情報の取得
249

View Slide

dbaascli database backup --getConfig
[root@orcl0329-pfutx1 ~]# cat /tmp/configfile_1.txt
####
#### This is the Backup config for the DB : dbcli01
#### Please refer to for more details about each parameter
####
#### Instance Level Parameters ####
# Enable automatic backup. Can be set to yes or no
bkup_cron_entry=
# Enable automatic cleanup of archive logs when backups are not
# configured using tooling. Can be set to yes or no
bkup_archlog_cron_entry=yes
#Enable backup of config files. Can be set to yes or no
bkup_cfg_files=no
# Time of the daily incremental backup. The format must be hh:mm
bkup_daily_time=1:21
# Archive log frequency in minutes. Valid values are 15,20,30,60,120....
bkup_archlog_frequency=30
# Archive log retention in FRA
bkup_archlog_fra_retention=1
#### This section is applicable for configuring backups to Disk ####
#Enable backup to disk. Can be set to yes or no
bkup_disk=no
#Recovery window of disk. Must be between 1 and 14
bkup_disk_recovery_window=
#### This section is applicable for configuring backups to OSS ####
# Enable backup to oss container. Can be set to yes or no
bkup_oss=no
## Below parameters are required if backups to OSS are configured
# Recovery window of oss. Must be between 1 and 90
bkup_oss_recovery_window=
# OSS url. Example: https://storage.oraclecorp.com/v1/Storage-test/test
bkup_oss_url=
# OSS username
bkup_oss_user=
# OSS password
#bkup_oss_passwd=
#*(Will be deprecated, please use bkup_l0_day) Default day on which level0
backups are taken for OSS
bkup_oss_l0_day=
<続く>
250

View Slide

<続き>
#Default day on which level0 backups are taken
bkup_l0_day=Sun
#### This section is applicable for configuring backups to ZDLRA ####
# Enable backup to ZDLRA. Can be set to yes or no
bkup_zdlra=no
# ZDLRA url
bkup_zdlra_url=
# ZDLRA username
bkup_zdlra_user=
# ZDLRA password
#bkup_zdlra_passwd=
#### This section is applicable for configuring backups to DBRS ####
#Enable backup to dbrs. Can be set to yes or no
bkup_dbrs=no
# Comma separated dbrs ip, host, port and service details.
# IP1:PORT1/SERVICE,IP2:PORT2/SERVICE...
bkup_dbrs_connect_string=
# DBRS username
bkup_dbrs_user=
# DBRS password
#bkup_dbrs_passwd=
# Parameter applicable for both DBRS and ZDLRA
# Enable real time redo transport to RA/DBRS destination. Can be set to yes
or no
bkup_realtime_redotrans=no
#### This section is applicable for configuring backups to NFS ####
#Enable backup to nfs. Can be set to yes or no
bkup_nfs=no
#Recovery window of nfs backups. Must be between 1 and 90
bkup_nfs_recovery_window=30
#NFS mount point location
bkup_nfs_loc=
#####RMAN custom configuration such as compression, section size #########
#compression, valid values are none,basic,low,medium,high
bkup_rman_compression=low
#If custom section size is preferred, set the following two values.
#bkup_set_section_size to yes and a valid bkup_section_size.
bkup_set_section_size=
<続く>
251

View Slide

<続き>
#section size value in G, example 20G
bkup_section_size=
#parallelism, number of channels per node to be used by RMAN
#set value to default for using recommended values based on service, operation
bkup_channels_node=default
# To turn on/off Backup encryption. Valid values True/False
bkup_encryption=
#### This section is applicable when using a rman catalog ####
# Enables RMAN catalog. Can be set to yes or no.
bkup_use_rcat=no
## Below parameters are required if rman catalog is enabled
# RMAN catalog user
bkup_rcat_user=
# RMAN catalog password
#bkup_rcat_passwd=
# RMAN catalog conn string
bkup_rcat_conn=
252

View Slide

[root@orcl0329-pfutx1 ~]# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=""
# For details see man 4 crontabs
# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * user-name command to be executed
15 * * * * oracle /var/opt/oracle/misc/backup_db_wallets.pl
15 * * * * oracle /var/opt/oracle/dbaascli/dbaascli tde backup --alldb
0 */12 * * * oracle /var/opt/oracle/cleandb/cleandblogs.pl
0 04 * * * grid /var/opt/oracle/cleandb/cleandblogs.pl
12,42 * * * * oracle /var/opt/oracle/bkup_api/bkup_api bkup_archlogs --cron --dbname=DB001
12,42 * * * * oracle /var/opt/oracle/bkup_api/bkup_api bkup_archlogs --cron --dbname=DB101
6,36 * * * * oracle /var/opt/oracle/bkup_api/bkup_api bkup_archlogs --cron --dbname=dbcli01
253

View Slide

dbaascli database backup --configure
バックアップ構成情報の設定例 – オブジェクトストレージにバックアップを保存するケース
254
# vi /tmp/tmp/configfile_1.txt
# cat /tmp/configfile_1.txt (※編集箇所抜粋)
bkup_cron_entry=yes
bkup_oss=yes
bkup_oss_url=https://swiftobjectstorage.ap-tokyo-1.oraclecloud.com/v1/xxxxx/bucket-tky
[email protected]
bkup_oss_passwd=_G>4W9IY76xqX3XwR}s#
bkup_oss_recovery_window=15
# chmod 600 /tmp/configfile_1.txt
# ll /tmp/configfile_1.txt
-rw------- 1 root root 3609 Mar 30 00:24 /tmp/configfile_1.txt
Object Storage への
バックアップを有効化
バックアップ先の Object
Storage の URL
バックアップ先の Object
Storage へのアクセス・ユー
ザー名
認証トークン
Object Storage へのバック
アップの保持期間
毎日の自動バックアップ実行
時刻
自動バックアップ構成の
有効化

View Slide

バックアップ構成情報の設定例 – ローカルディスクにバックアップを保存するケース
255
# vi /tmp/tmp/configfile_1.txt
# cat /tmp/configfile_1.txt (※編集箇所抜粋)
bkup_cron_entry=yes
bkup_disk=yes
bkup_disk_recovery_window=15
# chmod 600 /tmp/configfile_1.txt
# ll /tmp/configfile_1.txt
-rw------- 1 root root 3609 Mar 30 00:30 /tmp/configfile_1.txt
ローカルディスクへの
バックアップを有効化
ローカルディスクへのバックアッ
プの保持期間
毎日の自動バックアップ実行
時刻
自動バックアップ構成の
有効化

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --configure --configfile /tmp/configfile_1.txt
Executing command database backup --configure --configfile /tmp/configfile_1.txt
-> Action : set_config
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_a467a79e_20220330091543.307815.log
cfgfile : /tmp/configfile_1.txt
Using configuration file: /tmp/configfile_1.txt
API::Parameters validated.
UUID fa9d1a64b00911ecbcf5020017011f98 for this set_config(configure-backup)
** process started with PID: 306213
** see log file for monitor progress
-------------------------------------
※構成情報の設定はジョブで実行されている為、反映完了まで少し時間が掛かる（5～10分程度）
反映完了後は構成ファイル(上記ケースでは /tmp/configfile_1.txt)が自動削除される
[root@orcl0329-pfutx1 ~]# ll /tmp/configfile_1.txt
ls: cannot access /tmp/configfile_1.txt: No such file or directory
バックアップ構成情報の設定
256

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --status --uuid fa9d1a64b00911ecbcf5020017011f98
Executing command database backup --status --uuid fa9d1a64b00911ecbcf5020017011f98
@ STARTING CHECK STATUS fa9d1a64b00911ecbcf5020017011f98
[ REQUEST TICKET ]
[UUID -> fa9d1a64b00911ecbcf5020017011f98
[DBNAME -> dbcli01
[STATE -> success
[ACTION -> configure-backup
[STARTED -> 2022-03-30 09:15:46 UTC
[ENDED -> 2022-03-30 09:16:26 UTC
[PID -> 306213
[TAG ->
[PCT ->
[ END TICKET ]
バックアップ構成情報の設定
257

View Slide

dbaascli database backup --start
[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --start
Executing command database backup --start
-> Action : bkup_start
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_5d78dfcb_20220330091918.128951.log
UUID 7a9ee3beb00a11ec8d4c020017011f98 for this backup
-------------------------------------
バックアップの取得
258

View Slide

dbaascli database backup --status --uuid
[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --status --uuid 7a9ee3beb00a11ec8d4c020017011f98
Executing command database backup --status --uuid 7a9ee3beb00a11ec8d4c020017011f98
@ STARTING CHECK STATUS 7a9ee3beb00a11ec8d4c020017011f98
[ REQUEST TICKET ]
[UUID -> 7a9ee3beb00a11ec8d4c020017011f98
[DBNAME -> dbcli01
[STATE -> running
[ACTION -> create-backup-incremental ★増分バックアップ取得中
[STARTED -> 2022-03-30 09:19:22 UTC
[ENDED -> UTC
[PID -> 331799
[TAG ->
[PCT -> 1
[ END TICKET ]
バックアップ実施状況の確認（実行中）
259

View Slide

dbaascli database backup --status --uuid
[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --status --uuid 7a9ee3beb00a11ec8d4c020017011f98
Executing command database backup --status --uuid 7a9ee3beb00a11ec8d4c020017011f98
@ STARTING CHECK STATUS 7a9ee3beb00a11ec8d4c020017011f98
[ REQUEST TICKET ]
[UUID -> 7a9ee3beb00a11ec8d4c020017011f98
[DBNAME -> dbcli01
[STATE -> success
[ACTION -> create-backup-incremental
[STARTED -> 2022-03-30 09:19:22 UTC
[ENDED -> 2022-03-30 09:23:30 UTC
[PID -> 331799
[TAG -> TAG20220330T092146
[PCT -> 100
[LOG -> 2022-03-30 09:19:23.039202 - API:: invoked with args : -dbname=dbcli01 -uuid=7a9ee3beb00a11ec8d4c020017011f98 -format=dbaastools
[LOG -> 2022-03-30 09:19:26.018996 - API:: Oracle database state is up and running
[LOG -> 2022-03-30 09:20:15.059671 - API:: DB instance: dbcli01
[LOG -> 2022-03-30 09:20:22.843253 - API:: Performing backup to local storage (primary backup)
[LOG -> 2022-03-30 09:20:22.843541 - API:: Executing rman instructions
[LOG -> 2022-03-30 09:21:50.473250 - API:: ...... OK
[LOG -> 2022-03-30 09:21:50.473415 - API:: Backup to local storage is completed
[LOG -> 2022-03-30 09:22:54.105071 - API:: VALIDATING DATABASE BACKUPS:
[LOG -> 2022-03-30 09:22:54.105307 - API:: Starting backup of config files
[LOG -> 2022-03-30 09:22:54.668204 - API:: Determining the oracle database id
[LOG -> 2022-03-30 09:22:54.711941 - API:: DBID: 3324214880
[LOG -> 2022-03-30 09:22:54.731281 - API:: Creating directories to store config files
[LOG -> 2022-03-30 09:22:54.820781 - API:: Enabling RAC exclusions for config files.
[LOG -> 2022-03-30 09:22:55.950630 - API:: Compressing config files into tar files
[LOG -> 2022-03-30 09:22:56.022910 - API:: Skipping configuration files backup from legacy code.
[LOG -> 2022-03-30 09:22:56.029702 - API:: Config files backup ended successfully
[LOG -> 2022-03-30 09:22:56.029836 - API:: All requested tasks are completed
[ END TICKET ]
バックアップ実施状況の確認（実行完了後）
260

View Slide

dbaascli database backup --list
[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --list
Executing command database backup --list
-> Action : list
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_00e1cf10_20220330093057.915489.log
-> Listing all backups
Backup Tag Completion Date (UTC) Type keep
---------------------- ----------------------- ----------- --------
TAG20220330T092146 03/30/2022 09:23:30 incremental False
バックアップの一覧
261

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli database backup --dbname dbcli01 --start --level0
Executing command database backup --start --level0
[FATAL] [DBAAS-60022] Command '/var/opt/oracle/bkup_api/bkup_api --dbname="dbcli01" --level0 bkup_start --caller=dbaascli' execution has failed on nodes
[localnode].
*MORE DETAILS*
[API::ERROR option level0 is valid for OSS only, NFS or ZDLRA backup configuration, * RETURN CODE:1, ##################################################]
level0 は内蔵ディスクグループ(FRA)には取得できない
262

View Slide

dbaascli database recover --help
[root@orcl0329-pfutx1 ~]# dbaascli database recover --help
Executing command database recover --help
database recover - Performs database recovery.
Usage: dbaascli database recover --dbname
{
--start
{
--untilTime
| --untilSCN
| --latest
| --tag
}
| --status --uuid
}
Where:
--start | --status
--start - Begins database recovery.
--untilTime | --untilSCN | --latest | --tag
--untilTime - Recovers database until time. Input format: DD-MON-YYYY HH24:MI:SS.
--untilSCN - Recovers database until SCN.
--latest - Recovers database to last known state.
--tag - Recovers database to Archival tag.
--status
--uuid
データベースのリカバー
263

View Slide

dbaascli database recover
[root@orcl0329-pfutx1 ~]# dbaascli database recover --start --dbname dbcli01 --latest
Executing command database recover --start --latest
-> Action : recover_start
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_b9a0c863_20220330093509.535466.log
UUID b1ccc96cb00c11ecb386020017011f98 for this recovery
-------------------------------------
[root@orcl0329-pfutx1 ~]# dbaascli database recover --dbname dbcli01 --status --uuid b1ccc96cb00c11ecb386020017011f98
Executing command database recover --status --uuid b1ccc96cb00c11ecb386020017011f98
@ STARTING CHECK STATUS b1ccc96cb00c11ecb386020017011f98
[ REQUEST TICKET ]
[UUID -> b1ccc96cb00c11ecb386020017011f98
[DBNAME -> dbcli01
[STATE -> running
[ACTION -> recovery-start
[STARTED -> 2022-03-30 09:35:13 UTC
[ENDED -> UTC
[PID -> 25355
[TAG -> latest-backup
[PCT -> 1 ★実行状況（％）
[ END TICKET ]
データベースのリカバー
264

View Slide

[root@orcl0329-pfutx1 ~]# dbaascli database recover --dbname dbcli01 --status --uuid b1ccc96cb00c11ecb386020017011f98
Executing command database recover --status --uuid b1ccc96cb00c11ecb386020017011f98
@ STARTING CHECK STATUS b1ccc96cb00c11ecb386020017011f98
[ REQUEST TICKET ]
[UUID -> b1ccc96cb00c11ecb386020017011f98
[DBNAME -> dbcli01
[STATE -> success
[STARTED -> 2022-03-30 09:35:13 UTC
[ENDED -> 2022-03-30 09:44:51 UTC
[PID -> 25355
[PCT -> 100
[LOG -> 2022-03-30 09:35:25.932974 - API:: Logfile is /var/opt/oracle/log/dbcli01/orec/orec_2022-03-30_09:35:14.29535625793.log
[LOG -> 2022-03-30 09:35:27.618720 - API:: RUNNING IN NON DATAGUARD ENVIRONMENT
[LOG -> 2022-03-30 09:35:27.621826 - API:: Data mode only
[LOG -> 2022-03-30 09:35:27.622064 - API:: Stopping GRID DB
[LOG -> 2022-03-30 09:36:09.559373 - API:: State GRID DB
[LOG -> 2022-03-30 09:36:11.015024 - API:: Executing SHUTDOWN ABORT...2022-03-30 09:36:11.031303 - Output from sql shutdown abort is:
[LOG -> 2022-03-30 09:36:15.937156 - API:: Checking prerequirements before recovery process.
[LOG -> ORA-01034: ORACLE not available2022-03-30 09:36:18.271454 - API:: DB Status : 0
[LOG -> 2022-03-30 09:36:30.289610 - API:: Checking for PFILE in file system...
[LOG -> 2022-03-30 09:36:30.315366 - API:: PFILE is missing in file system and will be recovered.
[LOG -> 2022-03-30 09:36:33.292310 - API:: PFILE recovered to file system.
<続く>
データベースのリカバー確認（完了後）
265

View Slide

<続き>
[LOG -> 2022-03-30 09:36:33.292493 - API:: PFILE is present in file system.
[LOG -> 2022-03-30 09:36:33.839931 - API:: Changing instance to MOUNT stage.
[LOG -> 2022-03-30 09:36:33.840135 - API:: Shutting down the database...2022-03-30 09:36:33.846762 - DEBUG: SQL Executing set hea off set pagesize 5000 set
linesize 400 set newpage none set feedback off prompt =START= shutdown abort; quit
[LOG -> 2022-03-30 09:36:44.053117 - API:: (RMAN) Startup mount...2022-03-30 09:37:12.519925 -
[LOG -> 2022-03-30 09:37:13.061795 - API:: Checking for PDBs directories.
[LOG -> 2022-03-30 09:37:26.000186 - API:: Catalog mode: 2022-03-30 09:37:26.001152 - Disabled
[LOG -> 2022-03-30 09:37:28.658094 - API:: Testing RMAN connection.
[LOG -> 2022-03-30 09:37:35.027959 - API:: bkup_standby_enabled = no
[LOG -> 2022-03-30 09:37:40.431229 - API:: Verifying backups dates ..
[LOG -> 2022-03-30 09:38:16.446819 - API:: Performing recovery from latest backup.2022-03-30 09:38:16.447158 - Output from sql select status from
v$instance is:
[LOG -> 2022-03-30 09:38:27.313624 - API:: Starting all instances in mount mode
[LOG -> 2022-03-30 09:38:27.313771 - API:: Shutting down the database...2022-03-30 09:38:27.321995 - DEBUG: SQL Executing set hea off set pagesize 5000 set
linesize 400 set newpage none set feedback off prompt =START= shutdown abort; quit
[LOG -> 2022-03-30 09:39:06.259017 - API:: State database verbose
[LOG -> 2022-03-30 09:41:06.568328 - API:: Stopping GRID DB
[LOG -> 2022-03-30 09:42:25.259221 - API:: Starting GRID DB
[LOG -> 2022-03-30 09:43:47.605768 - API:: Recovery to latest backup completed.
[LOG -> 2022-03-30 09:43:47.607688 - API:: Patching database...
[ END TICKET ]
データベースのリカバー確認
266

View Slide

dbaascli pdb backup --help
[root@orcl0329-pfutx1 ~]# dbaascli pdb backup --help
Executing command pdb backup --help
Usage: dbaascli pdb backup --dbname --pdbName
{
--start
{
[--level1]
| [--archival --tag ]
}
| --delete --backupTag
| --status --uuid
| --getBackupReport --tag --json
| --list [--json ]
}
Where:
--start | --delete | --status | --getBackupReport | --list
--start - Begins PDB backup.
[--level1 | --archival]
[--level1 - Creates a Level-1 (incremental) backup. ]
[--archival - Creates an Archival full backup. ]
--delete - Deletes Archival backup.
--backupTag - Specify backup tag to delete.
--status
--uuid
--getBackupReport - Returns BackupReport.
--json - Specify file Name for json output.
--list - Returns PDB backup information.
[--json - Specify file Name for json output. ]
PDBのバックアップ
267

View Slide

dbaascli pdb backup --start
[root@orcl0329-pfutx1 ~]# dbaascli pdb backup --dbname dbcli01 --start --pdbname DBCLI01PDB01
Executing command pdb backup --start --pdbname DBCLI01PDB01
-> Action : bkup_start
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_c13c9602_20220330233638.596307.log
UUID 3f8e2b36b08211ec9717020017011f98 for this backup
-------------------------------------
PDBのバックアップ
268

View Slide

dbaascli pdb backup --status
[root@orcl0329-pfutx1 ~]# dbaascli pdb backup --dbname dbcli01 --pdbname DBCLI01PDB01 --status --uuid 3f8e2b36b08211ec9717020017011f98
Executing command pdb backup --pdbname DBCLI01PDB01 --status --uuid 3f8e2b36b08211ec9717020017011f98
@ STARTING CHECK STATUS 3f8e2b36b08211ec9717020017011f98
[ REQUEST TICKET ]
[UUID -> 3f8e2b36b08211ec9717020017011f98
[DBNAME -> dbcli01
[STATE -> success
[ACTION -> create-backup-incremental
[STARTED -> 2022-03-30 23:36:43 UTC
[ENDED -> 2022-03-30 23:40:54 UTC
[PID -> 199502
[TAG -> TAG20220330T233913
[PCT -> 100
[LOG -> 2022-03-30 23:36:43.515786 - API:: invoked with args : -dbname=dbcli01 pdb=DBCLI01PDB01 -uuid=3f8e2b36b08211ec9717020017011f98 -format=dbaastools
[LOG -> 2022-03-30 23:36:46.872835 - API:: Oracle database state is up and running
[LOG -> 2022-03-30 23:37:45.130611 - API:: DB instance: dbcli01
[LOG -> 2022-03-30 23:37:53.755522 - API:: Performing backup to local storage (primary backup)
[LOG -> 2022-03-30 23:37:53.756323 - API:: Executing rman instructions
[LOG -> 2022-03-30 23:39:16.945803 - API:: ...... OK
[LOG -> 2022-03-30 23:39:16.945934 - API:: Backup to local storage is completed
[LOG -> 2022-03-30 23:40:19.778010 - API:: VALIDATING DATABASE BACKUPS:
[LOG -> 2022-03-30 23:40:19.778386 - API:: All requested tasks are completed
[ END TICKET ]
PDBバックアップ実施状況の確認
269

View Slide

dbaascli pdb backup --list
[root@orcl0329-pfutx1 ~]# dbaascli pdb backup --dbname dbcli01 --pdbname DBCLI01PDB01 --list
Executing command pdb backup --pdbname DBCLI01PDB01 --list
-> Action : list
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_ab61a395_20220330234258.435246.log
-> Listing all backups
Backup Tag Completion Date (UTC) Type keep
---------------------- ----------------------- ----------- --------
[root@orcl0329-pfutx1 ~]#
PDBバックアップ取得状況の確認
270

View Slide

dbaascli pdb recover --help
[root@orcl0329-pfutx1 ~]# dbaascli pdb recover --help
Executing command pdb recover --help
Usage: dbaascli pdb recover --dbname --pdbName
{
--start
{
--untilTime
| --untilSCN
| --latest
| --tag
}
| --status --uuid
}
Where:
--start | --status
--start
--untilTime | --untilSCN | --latest | --tag
--untilTime - Recovers PDB until time. Input format: DD-MON-YYYY HH24:MI:SS.
--untilSCN - Recovers PDB until SCN.
--latest - Recovers PDB to last known state.
--tag - Recovers PDB to Archival tag.
--status
--uuid
PDBのリカバー
271

View Slide

dbaascli pdb recover --start
[root@orcl0329-pfutx1 ~]# dbaascli pdb recover --dbname dbcli01 --pdbname DBCLI01PDB01 --start --latest
Executing command pdb recover --pdbname DBCLI01PDB01 --start --latest
-> Action : recover_start
-> logfile: /var/opt/oracle/log/dbcli01/bkup_api_log/bkup_api_f6fdeeac_20220330234411.812367.log
UUID 4e0a7678b08311ecbd14020017011f98 for this recovery
-------------------------------------
PDBのリカバー
272

View Slide

dbaascli pdb recover --status
[root@orcl0329-pfutx1 ~]# dbaascli pdb recover --dbname dbcli01 --pdbname DBCLI01PDB01 --status --uuid 4e0a7678b08311ecbd14020017011f98
Executing command pdb recover --pdbname DBCLI01PDB01 --status --uuid 4e0a7678b08311ecbd14020017011f98
@ STARTING CHECK STATUS 4e0a7678b08311ecbd14020017011f98
[ REQUEST TICKET ]
[UUID -> 4e0a7678b08311ecbd14020017011f98
[DBNAME -> dbcli01
[STATE -> success
[STARTED -> 2022-03-30 23:44:19 UTC
[ENDED -> 2022-03-30 23:48:07 UTC
[PID -> 337236
[PCT -> 100
[LOG -> 2022-03-30 23:44:30.300410 - API:: Logfile is /var/opt/oracle/log/dbcli01/orec/orec_2022-03-30_23:44:20.344685337978.log
[LOG -> 2022-03-30 23:44:31.660508 - API:: RUNNING IN NON DATAGUARD ENVIRONMENT
[LOG -> 2022-03-30 23:44:31.664447 - API:: Data mode only
[LOG -> 2022-03-30 23:44:42.818087 - API:: Catalog mode: 2022-03-30 23:44:42.818997 - Disabled
[LOG -> 2022-03-30 23:44:45.219708 - API:: bkup_standby_enabled = no
[LOG -> 2022-03-30 23:44:50.146794 - API:: Verifying backups dates ..
[LOG -> 2022-03-30 23:45:43.592651 - API:: Performing recovery from latest backup.2022-03-30 23:45:43.592982 - Output from sql select status from
v$instance is:
[LOG -> 2022-03-30 23:47:34.462060 - API:: Recovery to latest backup completed.
[LOG -> 2022-03-30 23:47:34.463939 - API:: Patching database...
[ END TICKET ]
PDBのリカバー確認
273

View Slide

Data Guard Association
274

View Slide

dbaascli dataguard --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard --help
Executing command dataguard --help
dataguard failover - failover to Standby when all db nodes are up. This command is expected to fail if primary is down. Failover can be performed using
'force' operation at your own risk.
Data Guard コマンド一覧
275

View Slide

dbaascli dataguard status --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard status --help
Executing command dataguard status --help
Usage: dbaascli dataguard status [--details ] [--short ] [--dbname ]
Where:
[--details - more information related to dataguard. ]
[--short - short info like primary standby, congiuration name. ]
Data Guard のステータス
276

View Slide

dbaascli dataguard status
[root@orcl0329-pfutx1 ~]# dbaascli dataguard status --dbname dbcli01
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to "dbcli01_czr_kix"
Connected as SYSDG.
Configuration - fsc
Protection Mode: MaxPerformance
Members:
dbcli01_czr_kix - Primary database
dbcli01_standby - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'dbcli01_CFG'
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS
プライマリ
277

View Slide

[root@orcl0330-apjlw1 dg]# dbaascli dataguard status --dbname dbcli01
DETAILS:
Connected to "dbcli01_standby"
Connected as SYSDG.
Configuration - fsc
Members:
Properties:
TraceLevel = 'USER'
SUCCESS
スタンバイ
278

View Slide

DETAILS:
Connected as SYSDG.
Configuration - fsc
Members:
dbcli01_standby - Primary database
dbcli01_czr_kix - Physical standby database
Properties:
TraceLevel = 'USER'
SUCCESS
Data Guard のステータススイッチオーバー後
旧プライマリ
279

View Slide

DETAILS:
Connected as SYSDG.
Configuration - fsc
Members:
Properties:
TraceLevel = 'USER'
SUCCESS
Data Guard のステータススイッチオーバー後
旧スタンバイ
280

View Slide

dbaascli dataguard failover --help
[root@orcl0330-apjlw1 dg]# dbaascli dataguard failover --help
Executing command dataguard failover --help
dataguard failover - failover to Standby when all db nodes are up. This command is expected to fail if primary is down. Failover can be performed using
'force' operation at your own risk.
Usage: dbaascli dataguard failover [--force ] [--password ] [--dbname ]
Where:
[--force - force failover to Standby (yes|no). ]
[--password - password for sys user. ]
Data Guard フェイルオーバー
281

View Slide

dbaascli dataguard failover
[root@orcl0329-pfutx1 ~]# dbaascli dataguard failover --dbname dbcli01 --password *****
Executing command dataguard failover --password *****
Connected as SYSDBA.
Performing failover NOW, please wait...
Failover succeeded, new primary is "dbcli01_czr_kix"
SUCCESS : Successfully failed over to Standby
Data Guard フェイルオーバー
282

View Slide

DETAILS:
Connected as SYSDG.
Configuration - fsc
Members:
dbcli01_standby - Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
TraceLevel = 'USER'
SUCCESS
Data Guard フェイルオーバー後のステータス新プライマリ
283

View Slide

dbaascli dataguard reinstate --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard reinstate --help
Executing command dataguard reinstate --help
Usage: dbaascli dataguard reinstate [--password ] [--dbname ]
Where:
Data Guard フェイルオーバー後、旧プライマリをスタンバイへ
284

View Slide

dbaascli dataguard reinstate
[root@orcl0330-apjlw1 dg]# dbaascli dataguard reinstate --dbname dbcli01 --password *****
Executing command dataguard reinstate --password *****
Successfully reinstated dataguard instances
Detail : Successfully reinstated database : dbcli01_standby
Data Guard フェイルオーバー後、旧プライマリをスタンバイへ
285

View Slide

DETAILS:
Connected as SYSDG.
Configuration - fsc
Members:
Properties:
TraceLevel = 'USER'
SUCCESS
Data Guard reinstate のステータススタンバイ
286

View Slide

dbaascli dataguard switchover --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard switchover --help
Executing command dataguard switchover --help
Usage: dbaascli dataguard switchover [--password ] [--dbname ]
Where:
Data Guard のスイッチオーバー
287

View Slide

dbaascli dataguard switchover
[root@orcl0329-pfutx1 ~]# dbaascli dataguard switchover --dbname dbcli01 --password *****
Executing command dataguard switchover --password *****
Connected as SYSDBA.
Performing switchover NOW, please wait...
New primary database "dbcli01_standby" is opening...
Oracle Clusterware is restarting database "dbcli01_czr_kix" ...
[W000 2022-04-01T02:49:09.532+00:00] Failed to attach to dbcli01_czr_kix.
Switchover succeeded, new primary is "dbcli01_standby"
SUCCESS : Switchover to Standby operation completed successfully
Data Guard のスイッチオーバー
288

View Slide

DETAILS:
Connected as SYSDG.
Configuration - fsc
Members:
Properties:
TraceLevel = 'USER'
SUCCESS
Data Guard reinstate のステータススタンバイ
289

View Slide

dbaascli dataguard healthcheck --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard healthcheck --help
Executing command dataguard healthcheck --help
Usage: dbaascli dataguard healthCheck [--dbname ] [--iperf --remoteNodes ] [--type ]
Where:
[--iperf - Network throughput check using iperf utility. ]
--remoteNodes - remote RAC nodes list.
[--type - decides what type of checks to be performed. ]
Data Guard のヘルスチェック
290

View Slide

dbaascli dataguard healthcheck --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard healthcheck --dbname dbcli01
Executing command dataguard healthcheck
Results:
INFO: Verifying Network
INFO: All SCAN VIPs are enabled and running, check PASSED
ERROR: addstby checks FAILED
To Do:
DGHCK-50601 : One or more SCAN VIP are disabled or not running
Start SCAN's using command '/bin/srvctl start scan -n '
NOTE: Dependent checks might not have run due to above exceptions. Fix them and re-run health check
Done addstby checks...!
Data Guard のヘルスチェック
291

View Slide

dbaascli dataguard verify --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard verify --help
Executing command dataguard verify --help
Usage: dbaascli dataguard verify [--db ] [--remoteNodes ] [--json ]
Where:
[--db - DB on which checks are to be performed.]
[--remoteNodes - remote RAC nodes list. ]
[--json - on primary, prints configuration in JSON format, on Standby, expects primary configuration in JSON format.]
Data Guard のベリファイ
292

View Slide

dbaascli dataguard verify
[root@orcl0329-pfutx1 ~]# dbaascli dataguard verify --db dbcli01
Executing command dataguard verify --db dbcli01
INFO: Verifying Nodes
INFO: scan_listener up on all nodes of cluster, check PASSED
INFO: listener up on all nodes of cluster, check PASSED
INFO: Listener port up on all nodes, check PASSED
INFO: Verifying OS
INFO: Checking user equivalence
INFO: RPM: dbaastools_exa-1.0-1+22.1.1.1.0_220317.1256.x86_64 is same on all nodes
INFO: RPM: dbcs-agent-update-22.1.1.1.0-220317.1256.x86_64 is same on all nodes
INFO: RPM: dbcs-admin-update-1.2-21.1.1.0.1_210324.2216.x86_64 is same on all nodes
INFO: Verifying ASM
INFO: Verifying DB status
INFO: Checking important files
INFO: Verifying Wallet size
<続く>
293

View Slide

<続き>
INFO: Checking wallet tar size is less than 1M
INFO: TAR file size of /var/opt/oracle/dbaas_acfs/dbcli01 is 61440
INFO: Checking patch level on Oracle Home
ERROR: Not all instances of database dbcli01_czr_kix are in READ WRITE mode
INFO: Non KMS environment
Logfile: /var/opt/oracle/log/dbcli01/dghealth_check/dghealth_check_2022-04-01_02:54:13.515953274944.log
.----------------------------------------------------------------------------------------------------.
| CONFIGURATION |
+---------------------------------+------------------------------------------------------------------+
| PARAMETER | VALUE |
+---------------------------------+------------------------------------------------------------------+
| dbaastools_exa_version | dbaastools_exa-1.0-1+22.1.1.1.0_220317.1256.x86_64 |
| dbcs-admin-update-exacc_version | NOT_INSTALLED |
| dbcs-admin-update_version | dbcs-admin-update-1.2-21.1.1.0.1_210324.2216.x86_64 |
| dbcs-agent-update-exacc_version | NOT_INSTALLED |
| dbcs-agent-update_version | dbcs-agent-update-22.1.1.1.0-220317.1256.x86_64 |
| free_space_RECO | 29522717 MB |
| patch_level | d1bdc55d9962bc51d46cc6128fc447b392aee6b3c85cf3d2b0541a0cdb149ec6 |
| required_space_RECO | 40000 MB |
'---------------------------------+------------------------------------------------------------------'
<続く>
294

View Slide

<続き>
.----------------------------------------------------------------------------------------------------.
| EXCEPTIONS |
+-----------+----------------------------------------------------------------------------------------+
| EXCEPTION | DETAILS |
+-----------+----------------------------------------------------------------------------------------+
| CDG-50606 | One or more instances of db 'dbcli01' are disabled or down or not in 'READ WRITE' mode |
| | Enable and Start all instances of database dbcli01 in 'READ_WRITE' mode |
'-----------+----------------------------------------------------------------------------------------'
296

View Slide

dbaascli dataguard configureAWR --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard configureAWR --help
Executing command dataguard configureAWR --help
Usage: dbaascli dataguard configureAWR [--action ] [--dbname ]
Where:
[--action - inputs action to be performed on AWR.]
Data Guard スタンバイ環境のAWR生成をプライマリから実施
297

View Slide

dbaascli dataguard convertStandby --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard convertStandby --help
Executing command dataguard convertStandby --help
Usage: dbaascli dataguard convertStandby --dbname --standbyType [--standbyName ]
Where:
--standbyType - Specify intended standby database type to convert. Possible values are physical | snapshot
[--standbyName - specifies database unique name of standby database to be converted. On omission, defaults to first available standby database.]
Data Guard スタンバイスナップショットへの変換
298

View Slide

dbaascli dataguard configureRedoApply --help
[root@orcl0329-pfutx1 ~]# dbaascli dataguard configureRedoApply --help
Executing command dataguard configureRedoApply --help
Usage: dbaascli dataguard configureRedoApply --dbname
{
--status
| --enable
| --disable
}
Where:
--status | --enable | --disable
--status - obtain the current Redo Apply status for the database being requested.
--enable - enable the Redo Apply setting for the database being requested.
--disable - disable the Redo Apply setting for the database being requested.
Data Guard redo 適用の設定確認
299

View Slide

dbaascli dataguard configureRedoApply --status
[root@orcl0329-pfutx1 ~]# dbaascli dataguard configureRedoApply --dbname dbcli01 --status
Executing command dataguard configureRedoApply --status
Job id: 0426645b-2876-43de-8de2-68d1cb1231f2
{
"redoApplyStatus" : {
"dbcli01_czr_kix" : "ENABLED"
}
}
300

View Slide

dbaascli dataguard configureRedoApply --disable
[root@orcl0329-pfutx1 ~]# dbaascli dataguard configureRedoApply --dbname dbcli01 --disable
Executing command dataguard configureRedoApply --disable
Job id: 8dc55cd9-da1e-4ee2-ab38-d1efd6c69c11
Job id: c6ff1875-89ae-41a4-97be-5189c03d422a
{
"dbcli01_czr_kix" : "DISABLED"
}
}
301

View Slide

dbaascli dataguard configureRedoApply --enable
[root@orcl0329-pfutx1 ~]# dbaascli dataguard configureRedoApply --dbname dbcli01 --enable
Executing command dataguard configureRedoApply --enable
Job id: 447cf941-4b2d-4fd0-89ad-33dd6e6b9006
Job id: f17f929d-899d-4364-b02a-9f562ff93e42
{
"dbcli01_czr_kix" : "ENABLED"
}
}
302

View Slide

dbaascli dataguard updateDGConfigAttributes --help
[root@orcl-jyvid1 ~]# dbaascli dataguard updateDGConfigAttributes --help
Executing command dataguard updateDGConfigAttributes --help
Usage: dbaascli dataguard updateDGConfigAttributes --attributes
Where:
--attributes - Contains the DG Automation attributes that are to be modified. Takes comma separated values of format . Attributes must
be predefined in DG configuration file.
Data Guard の設定変更
303
22.2.1.0.1 新機能

View Slide

dbaascli dataguard showDGConfigAttributes --help
[root@orcl-jyvid1 ~]# dbaascli dataguard showDGConfigAttributes --help
Executing command dataguard showDGConfigAttributes --help
Usage: dbaascli dataguard showDGConfigAttributes [--attribute ]
Where:
[--attribute - Specifies a DG Automation attribute to be shown. Attribute must be predefined in DG configuration file.]
Data Guard の設定確認
304
22.2.1.0.1 新機能

View Slide

305

View Slide

ExaDB-D dbaascli で出来ること

ExaDB-D dbaascli で出来ること

oracle4engineer
PRO

More Decks by oracle4engineer

Other Decks in Technology

Featured

Transcript

ExaDB-D dbaascli で出来ること

ExaDB-D dbaascli で出来ること

oracle4engineer PRO

More Decks by oracle4engineer

Other Decks in Technology

Featured

Transcript

oracle4engineer
PRO