シナリオ: 統合されたパッチ適用Oracle Data Guard

5 シナリオ: 統合されたパッチ適用Oracle Data Guard

このシナリオでは、DCSスタック上のOracle Database Applianceの統合Oracle Data Guardにパッチを適用する方法について説明します。

「環境」
Oracle Database Applianceを使用した後続のData Guard設定例で使用されるプライマリおよびスタンバイ・データベース環境のトポロジの理解。
「統合されたパッチ適用Oracle Data Guard」
このシナリオでは、Oracle Data Guardをodacli configure-dataguardで構成したODACLI、またはodacli register-dataguardを使用してOracle Data Guardを登録した場合の、データベースへのパッチ適用について説明します。

環境

Oracle Database Applianceを使用した後続のData Guard設定例で使用されるプライマリおよびスタンバイ・データベース環境のトポロジの理解。

コンポーネント	プライマリOracle Database Appliance	スタンバイOracle Database Appliance
ホスト名	proddb1, proddb2	stbydb1, stbydb2
データベース名	texas	texas
一意のデータベース名	austin	houston
インスタンス名	texas1, texas2	texas1, texas2
Grid Infrastructureソフトウェアのインストール	/u01/app/19.18.0.0/grid	/u01/app/19.18.0.0/grid
ソースOracle Databaseソフトウェアのインストール	/u01/app/odaorahome/oracle/product/19.0.0.0/db_home4	/u01/app/odaorahome/oracle/product/19.0.0.0/db_home1
ターゲットOracle Databaseソフトウェアのインストール	/u01/app/odaorahome/oracle/product/19.0.0.0/db_home5	/u01/app/odaorahome/oracle/product/19.0.0.0/db_home5

親トピック: シナリオ : 統合されたパッチ適用Oracle Data Guard

統合されたパッチ適用Oracle Data Guard

このシナリオでは、Oracle Data Guardをodacli configure-dataguardで構成したODACLI、またはodacli register-dataguardを使用してOracle Data Guardを登録した場合の、データベースへのパッチ適用について説明します。

前提条件:

Oracle Database Applianceの個々のOracleデータベースへのパッチ適用は、Oracle Database Applianceリリース19.17以降で使用できます。
サーバーおよびオプションで、ストレージには、ソースおよびターゲットのOracle Database Applianceベア・メタル・システムの最新バージョンにすでにパッチが適用されています。
データベースがDBシステムで実行されている場合、DBシステムのサーバー・レベルは、ソース・システムおよびターゲット・システムの最新リリースにパッチが適用されます。
リポジトリは、ソースおよびターゲット・アプライアンス上のターゲット・データベースのクローン・ファイルで更新されます。

サーバーおよびストレージへのパッチ適用に関するノート:

スタンバイOracle Database Applianceのパッチ・サーバーおよびストレージ、データベースのスイッチオーバー、以前のプライマリ・サーバーおよびストレージへのパッチ適用、データベースのスイッチバック
サーバーおよびストレージのパッチ・レポートでは、ローカル・パッチ適用が適用可能かどうかに関する情報が提供されます。ローカル・パッチ適用が可能な場合は、プライマリおよびスタンバイ・サーバーとストレージにローリング方式でパッチを適用: ノードごとに--localフラグを使用します。

次のステップに従って、データベースにパッチを適用します:

ソース・システムとターゲット・システムの新しいデータベース・バージョンを使用して、新しいデータベース・ホームを作成します。

# odacli create-dbhome -v 19.18.0.0.230117

Primary:

[root@proddb1 ]# odacli list-dbhomes

ID                                       Name                 DB Version                               Home Location                                 Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
cf4b5561-a965-43c1-afb9-99a7c96ee143     OraDB19000_home4     19.17.0.0.221018                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_4 CONFIGURED
f90adcc1-f64a-41ce-b72d-154db155b1fa     OraDB19000_home5     19.18.0.0.230117                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5 CONFIGURED

Standby:

[root@stbydb1 ]# odacli list-dbhomes

ID                                       Name                 DB Version                               Home Location                                 Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
2df4aede-e3a1-438f-8eb8-28a960f8c0b5     OraDB19000_home1     19.17.0.0.221018                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED
fe72fa84-b609-4cea-b040-4fd7308008c8     OraDB19000_home5     19.18.0.0.230117                          /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_5 CONFIGURED

スタンバイ・データベースが実行されているOracle Database Applianceシステムを確認します。

[root@stbydb1 ~]# odacli list-dataguardstatus

Updated about 3 day(s) ago

It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.

ID                                       Name                             Database Name        Role       Protection Mode    Apply Lag       Transport Lag   Apply Rate      Status

---------------------------------------- -------------------------------- -------------------- ---------- ------------------ --------------- --------------- --------------- ----------

6e97c0a7-f6c9-4ec6-96b9-3a28210d408b     austin_huston                    texas                STANDBY    MAX_PERFORMANCE    0 seconds       0 seconds       6.00 KByte/s    CONFIGURED

スタンバイ・データベースのパッチ・レポートを作成します。

[root@stbydb1 ~]# odacli create-prepatchreport -db -dbid 4814ef49-a675-4dd4-84eb-9fca8386ca6a -to fe72fa84-b609-4cea-b040-4fd7308008c8

Job details
----------------------------------------------------------------
                     ID:  dfa9e187-7b1d-4ad7-b874-8eb2060ed924
            Description:  Patch pre-checks for [SINGLEDB, ORACHKSINGLEDB]: Target DB is texas, Destination DbHome is OraDB19000_home5
                 Status:  Created
                Created:  March 17, 2023 1:40:01 PM GMT
                Message:  Use 'odacli describe-prepatchreport -i dfa9e187-7b1d-4ad7-b874-8eb2060ed924' to check details of results

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------

[root@stbydb1 ~]# while true; do odacli describe-prepatchreport -i dfa9e187-7b1d-4ad7-b874-8eb2060ed924; sleep 30; done

Patch pre-check report
------------------------------------------------------------------------
                 Job ID:  dfa9e187-7b1d-4ad7-b874-8eb2060ed924
            Description:  Patch pre-checks for [SINGLEDB, ORACHKSINGLEDB]: Target DB is texas, Destination DbHome is OraDB19000_home5
                 Status:  SUCCESS
                Created:  March 17, 2023 1:40:01 PM GMT
                 Result:  All pre-checks succeeded

Node Name
---------------
stbydb1

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__SINGLEDB__
Is system provisioned           Success   Verified system is provisioned
Validate dbHomesOnACFS          Success   User has configured disk group for
configured                                Database homes on ACFS
Validate Oracle base            Success   Successfully validated Oracle Base
Evaluate DB clone availability  Success   Successfully validated clone file
                                          exists
Evaluate DB patching with RHP   Success   Successfully validated patching DB
                                          with RHP.
Validate command execution      Success   Validated command execution

__ORACHK__
Running orachk for a single     Success   Successfully ran Orachk
database
Validate command execution      Success   Validated command execution

Node Name
---------------
stbydb2

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__SINGLEDB__
Is system provisioned           Success   Verified system is provisioned
Validate dbHomesOnACFS          Success   User has configured disk group for
configured                                Database homes on ACFS
Validate Oracle base            Success   Successfully validated Oracle Base
Evaluate DB clone availability  Success   Successfully validated clone file
                                          exists
Evaluate DB patching with RHP   Success   Successfully validated patching DB
                                          with RHP.
Validate command execution      Success   Validated command execution

__ORACHK__
Running orachk for a single     Success   Successfully ran Orachk
database
Validate command execution      Success   Validated command execution

スタンバイ・データベースにパッチを適用します。

root@stbydb1 ~]# odacli update-database -i 4814ef49-a675-4dd4-84eb-9fca8386ca6a -to fe72fa84-b609-4cea-b040-4fd7308008c8
{
  "jobId" : "611c7a43-53d1-4e0f-be3f-3354a386cbd8",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "March 17, 2023 14:00:32 PM GMT",
  "resourceList" : [ ],
  "description" : "DB Patching: database ID is 4814ef49-a675-4dd4-84eb-9fca8386ca6a",
  "updatedTime" : "March 17, 2023 14:00:32 PM GMT",
  "jobType" : null
}

[root@stbydb1 ~]# odacli describe-job -i 611c7a43-53d1-4e0f-be3f-3354a386cbd8

Job details
----------------------------------------------------------------
                     ID:  611c7a43-53d1-4e0f-be3f-3354a386cbd8
            Description:  DB Patching: database ID is 4814ef49-a675-4dd4-84eb-9fca8386ca6a
                 Status:  Success
                Created:  March 17, 2023 2:00:32 PM GMT
                Message:

Task Name                                Node Name                 Start Time                          End Time                            Status
---------------------------------------- ------------------------- ----------------------------------- ----------------------------------- ----------
Creating wallet for DB Client            stbydb1                March 17, 2023 2:01:17 PM GMT       March 17, 2023 2:01:18 PM GMT       Success
Patch databases by RHP                   stbydb1                March 17, 2023 2:01:18 PM GMT       March 17, 2023 2:08:41 PM GMT       Success
Updating database metadata               stbydb2                March 17, 2023 2:08:41 PM GMT       March 17, 2023 2:08:41 PM GMT       Success
Set log_archive_dest for Database        stbydb1                March 17, 2023 2:08:41 PM GMT       March 17, 2023 2:08:45 PM GMT       Success
Generating and saving BOM                stbydb1                March 17, 2023 2:08:45 PM GMT       March 17, 2023 2:09:41 PM GMT       Success
Generating and saving BOM                stbydb2                March 17, 2023 2:08:45 PM GMT       March 17, 2023 2:09:36 PM GMT       Success
TDE parameter update                     stbydb2                March 17, 2023 2:10:32 PM GMT       March 17, 2023 2:10:33 PM GMT       Success

Database is running from the new home:

root@stbydb1 ~]# odacli list-databases

ID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
980a09c0-dba4-404b-b0ac-985504f7c469     hun        RAC      19.17.0.0.221018     true       OLTP     odb1     ASM        CONFIGURED   2df4aede-e3a1-438f-8eb8-28a960f8c0b5
4814ef49-a675-4dd4-84eb-9fca8386ca6a     texas      RAC      19.18.0.0.230117     true       OLTP     odb1     ASM        CONFIGURED   fe72fa84-b609-4cea-b040-4fd7308008c8

データベースをスイッチオーバーします。

[root@proddb1 ~]# odacli switchover-dataguard -i 6e97c0a7-f6c9-4ec6-96b9-3a28210d408b -u huston
Password for target database:
{
  "jobId" : "41a03f89-bbc9-4d37-9548-5f3d3f1d3977",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "March 17, 2023 15:16:32 PM CET",
  "resourceList" : [ ],
  "description" : "Dataguard operation for austin_huston - SwitchoverDg",
  "updatedTime" : "March 17, 2023 15:16:32 PM CET",
  "jobType" : null
}

[root@proddb1 ~]# odacli describe-job -i 41a03f89-bbc9-4d37-9548-5f3d3f1d3977

Job details
----------------------------------------------------------------
                     ID:  41a03f89-bbc9-4d37-9548-5f3d3f1d3977
            Description:  Dataguard operation for austin_huston - SwitchoverDg
                 Status:  Success
                Created:  March 17, 2023 3:16:32 PM CET
                Message:

Task Name                                Node Name                 Start Time                          End Time                            Status
---------------------------------------- ------------------------- ----------------------------------- ----------------------------------- ----------
Precheck switchover DataGuard            proddb1                March 17, 2023 3:16:32 PM CET       March 17, 2023 3:16:34 PM CET       Success
Switchover DataGuard                     proddb1                March 17, 2023 3:16:34 PM CET       March 17, 2023 3:17:29 PM CET       Success
Postcheck switchover DataGuard           proddb1                March 17, 2023 3:17:29 PM CET       March 17, 2023 3:18:31 PM CET       Success
Check if DataGuard config is updated     proddb2                March 17, 2023 3:18:41 PM CET       March 17, 2023 3:18:51 PM CET       Success


[root@proddb1 ~]# odacli list-dataguardstatus
Updated about 3 day(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode    Apply Lag       Transport Lag   Apply Rate      Status
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ --------------- --------------- --------------- ----------
6e97c0a7-f6c9-4ec6-96b9-3a28210d408b     austin_huston                    texas                STANDBY    MAX_PERFORMANCE    0 seconds       0 seconds       2.33 MByte/s    CONFIGURED

[root@stbydb1 ~]# odacli list-dataguardstatus
Updated about 3 day(s) ago
It can take up to several minutes to update Data Guard status. You can re-run the command to obtain the latest status.
ID                                       Name                             Database Name        Role       Protection Mode    Apply Lag       Transport Lag   Apply Rate      Status
---------------------------------------- -------------------------------- -------------------- ---------- ------------------ --------------- --------------- --------------- ----------
6e97c0a7-f6c9-4ec6-96b9-3a28210d408b     austin_huston                    texas                PRIMARY    MAX_PERFORMANCE    0 seconds       0 seconds       2.19 MByte/s    CONFIGURED

新しいスタンバイ・システムのパッチ・レポートを作成します。

[root@proddb1 ~]# odacli create-prepatchreport -db -dbid 5ec47358-6027-4ad8-948a-831fcc73f338 -to f90adcc1-f64a-41ce-b72d-154db155b1fa

Job details
----------------------------------------------------------------
                     ID:  e564bfc6-09a9-420b-9c47-19529ad93f92
            Description:  Patch pre-checks for [SINGLEDB, ORACHKSINGLEDB]: Target DB is texas, Destination DbHome is OraDB19000_home5
                 Status:  Created
                Created:  March 17, 2023 3:25:59 PM CET
                Message:  Use 'odacli describe-prepatchreport -i e564bfc6-09a9-420b-9c47-19529ad93f92' to check details of results

[root@proddb1 ~]# odacli describe-prepatchreport -i e564bfc6-09a9-420b-9c47-19529ad93f92

Patch pre-check report
------------------------------------------------------------------------
                 Job ID:  e564bfc6-09a9-420b-9c47-19529ad93f92
            Description:  Patch pre-checks for [SINGLEDB, ORACHKSINGLEDB]: Target DB is texas, Destination DbHome is OraDB19000_home5
                 Status:  SUCCESS
                Created:  March 17, 2023 3:25:59 PM CET
                 Result:  One or more pre-checks failed for [ORACHK]

Node Name
---------------
proddb1

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__SINGLEDB__
Is system provisioned           Success   Verified system is provisioned
Validate dbHomesOnACFS          Success   User has configured disk group for
configured                                Database homes on ACFS
Validate Oracle base            Success   Successfully validated Oracle Base
Evaluate DB clone availability  Success   Successfully validated clone file
                                          exists
Evaluate DB patching with RHP   Success   Successfully validated patching DB
                                          with RHP.
Validate command execution      Success   Validated command execution

__ORACHK__
Running orachk for a single     Success   Successfully ran Orachk database
Validate command execution      Success   Validated command execution

Node Name
---------------
proddb2

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__SINGLEDB__
Is system provisioned           Success   Verified system is provisioned
Validate dbHomesOnACFS          Success   User has configured disk group for
configured                                Database homes on ACFS
Validate Oracle base            Success   Successfully validated Oracle Base
Evaluate DB clone availability  Success   Successfully validated clone file
                                          exists
Evaluate DB patching with RHP   Success   Successfully validated patching DB
                                          with RHP.
Validate command execution      Success   Validated command execution

__ORACHK__
Running orachk for a single     Success   Successfully ran Orachk database
Validate command execution      Success   Validated command execution

スタンバイ・データベースにパッチを適用します。

[root@proddb1 ~]# odacli update-database -i 5ec47358-6027-4ad8-948a-831fcc73f338 -to f90adcc1-f64a-41ce-b72d-154db155b1fa
{
  "jobId" : "cb70fa38-62bb-422d-b6b7-efb684e744fa",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "March 17, 2023 15:42:59 PM CET",
  "resourceList" : [ ],
  "description" : "DB Patching: database ID is 5ec47358-6027-4ad8-948a-831fcc73f338",
  "updatedTime" : "March 17, 2023 15:42:59 PM CET",
  "jobType" : null
}

[root@proddb1 ~]# while true; do odacli describe-job -i cb70fa38-62bb-422d-b6b7-efb684e744fa; sleep 30; done

Job details
----------------------------------------------------------------
                     ID:  cb70fa38-62bb-422d-b6b7-efb684e744fa
            Description:  DB Patching: database ID is 5ec47358-6027-4ad8-948a-831fcc73f338
                 Status:  Success
                Created:  March 17, 2023 3:42:59 PM CET
                Message:

Task Name                                Node Name                 Start Time                          End Time                            Status
---------------------------------------- ------------------------- ----------------------------------- ----------------------------------- ----------
Creating wallet for DB Client            proddb1                March 17, 2023 3:43:42 PM CET       March 17, 2023 3:43:42 PM CET       Success
Patch databases by RHP                   proddb1                March 17, 2023 3:43:42 PM CET       March 17, 2023 3:49:17 PM CET       Success
Updating database metadata               proddb2                March 17, 2023 3:49:17 PM CET       March 17, 2023 3:49:17 PM CET       Success
Set log_archive_dest for Database        proddb1                March 17, 2023 3:49:17 PM CET       March 17, 2023 3:49:20 PM CET       Success
Generating and saving BOM                proddb1                March 17, 2023 3:49:20 PM CET       March 17, 2023 3:50:23 PM CET       Success
Generating and saving BOM                proddb2                March 17, 2023 3:49:20 PM CET       March 17, 2023 3:50:20 PM CET       Success
TDE parameter update                     proddb2                March 17, 2023 3:50:53 PM CET       March 17, 2023 3:50:53 PM CET       Success

現在のプライマリ・システムにデータ・パッチ・タイプのパッチ・レポートを作成します:

[root@stbydb1 ~]# odacli create-prepatchreport -dbid 4814ef49-a675-4dd4-84eb-9fca8386ca6a -dp


[root@stbydb1 ~]# odacli describe-prepatchreport -i 6b8523c1-b2cf-4559-9f6e-ef1e7c7beb37

Patch pre-check report
------------------------------------------------------------------------
                 Job ID:  6b8523c1-b2cf-4559-9f6e-ef1e7c7beb37
            Description:  Patch pre-checks for [DATAPATCH]: Target DB is texas
                 Status:  SUCCESS
                Created:  March 17, 2023 4:16:38 PM GMT
                 Result:  All pre-checks succeeded

Node Name
---------------
stbydb1

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__DATAPATCH__
Is system provisioned           Success   Verified system is provisioned
Validate database role          Success   Successfully validated database role
Evaluate DB data patching       Success   The following patches need to be
with OPatch                               applied : [34765931]. The following
                                          patches need to be rolled back:
                                          [34411846, 34282948]. The following
                                          patches are release updates:
                                          [34786990].
Validate command execution      Success   Validated command execution

Node Name
---------------
stbydb2

Pre-Check                      Status   Comments
------------------------------ -------- --------------------------------------
__DATAPATCH__
Is system provisioned           Success   Verified system is provisioned
Validate database role          Success   Successfully validated database role
Evaluate DB data patching       Success   The following patches need to be
with OPatch                               applied : [34765931]. The following
                                          patches need to be rolled back:
                                          [34411846, 34282948]. The following
                                          patches are release updates:
                                          [34786990].
Validate command execution      Success   Validated command execution

現在のプライマリ・システムにdatapatchを適用します。

[root@stbydb1 ~]# odacli update-database -i 4814ef49-a675-4dd4-84eb-9fca8386ca6a -dp
{
  "jobId" : "3cb0135a-7b31-4113-afe4-8b1cb0747d80",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "March 17, 2023 16:38:30 PM GMT",
  "resourceList" : [ ],
  "description" : "DB Patching: database ID is 4814ef49-a675-4dd4-84eb-9fca8386ca6a",
  "updatedTime" : "March 17, 2023 16:38:30 PM GMT",
  "jobType" : null
}

[root@stbydb1 ~]# while true; do odacli describe-job -i 3cb0135a-7b31-4113-afe4-8b1cb0747d80; sleep 30; done

Job details
----------------------------------------------------------------
                     ID:  3cb0135a-7b31-4113-afe4-8b1cb0747d80
            Description:  DB Patching: database ID is 4814ef49-a675-4dd4-84eb-9fca8386ca6a
                 Status:  Success
                Created:  March 17, 2023 4:38:30 PM GMT
                Message:

Task Name                                Node Name                 Start Time                          End Time                            Status
---------------------------------------- ------------------------- ----------------------------------- ----------------------------------- ----------
Datapatch apply                          stbydb1                March 17, 2023 4:38:39 PM GMT       March 17, 2023 4:42:42 PM GMT       Success

オプションで、プライマリ・システムに切り替えます。

[root@stbydb1 ~]# odacli switchover-dataguard -i 6e97c0a7-f6c9-4ec6-96b9-3a28210d408b -u austin
Password for target database:
{
  "jobId" : "44aa5d2a-b255-4df2-8f85-6b721cda4339",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "March 17, 2023 17:01:33 PM GMT",
  "resourceList" : [ ],
  "description" : "Dataguard operation for austin_huston - SwitchoverDg",
  "updatedTime" : "March 17, 2023 17:01:33 PM GMT",
  "jobType" : null
}

親トピック: シナリオ : 統合されたパッチ適用Oracle Data Guard