Oracle Cloud Infrastructure (OCI) の Oracle Cloud Database の自動バックアップ機能は、ORACLEによって管理される Oracle Management Bucket (OMB) の Objeect Storage Bucketに格納され、ユーザーはこの領域にアクセスできません。
ユーザー管理の Bucket である Customer Management Bucket (CMB) に OMB のコピーが必要な場合、OMB から CMB へのコピーは、 MV2Bucketツールを利用して実行できます。
ということで、OMBに保存された バックアップファイルを、CMB と ローカル・ディレクトリ へコピーしてみてみます。
■ 構成
■ Oracle Cloud Database バックアップ作成
自動バックアップを設定していない場合は、[Create Backup]をクリックしてバックアップを作成
■ Object Storage Bucket 作成
OMBに保存された バックアップファイルを コピーする Object Storage Bucket を作成
■ OCI CLIインストール
● CLIインストールと設定
次を参考に OCI CLI を設定
・参考: Oracle Database Service へ OCI コマンド・ライン・インタフェース(CLI) をインストール
● CLI 動作確認
作成した Object Storage に CLI でアクセスできることを確認
[root@db19c .oci]# oci os bucket list -c ocid1.compartment.oc1..aaaaaaaa2dmjokxvji6x4zejxiyx5fijgyuigxpsw --output table
/root/lib/oracle-cli/lib64/python3.6/site-packages/oci/_vendor/httpsig_cffi/sign.py:10: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography and will be removed in a future release.
from cryptography.hazmat.backends import default_backend # noqa: F401
+------------------------------------------------------------------+------------------------------------------------------------------------------+--------------+-------------------------+---------------+-------------------------+------------+----------------------------------+
| compartment-id | created-by | defined-tags | etag | freeform-tags | name | namespace | time-created |
+------------------------------------------------------------------+------------------------------------------------------------------------------+--------------+-------------------------+---------------+-------------------------+------------+----------------------------------+
| ocid1.compartment.oc1..aaaaaaaa2dmjokxvji6x4zejxiyx5fijgyuigxpsw | ocid1.saml2idp.oc1..aaaaaaaarponux6ehq4p2iu3k356p6rx27lc5f/shirok@shirok.com | None | dd65f8d6-63b2-4f44-93b9 | None | bucket-Backup-cdb_tokyo | shirok | 2023-03-04T10:50:10.496000+00:00 |
+------------------------------------------------------------------+------------------------------------------------------------------------------+--------------+-------------------------+---------------+-------------------------+------------+----------------------------------+
■ Install MV2Bucket
1) Download
My Oracle Support (MOS) へログインし、次のドキュメントへアクセスして 対象の Linux Version の Latest MV2Bucket をダウンロードします。
(OCI) mv2bucket - Oracle Managed Bucket Content Manager (Doc ID 2723911.1)
2) Download確認
[root@db19c ~]# ls -l /tmp/mv2bucket-2.0.1-12.el7.x86_64.rpm
-rw-r--r-- 1 opc opc 8232824 Mar 4 09:54 /tmp/mv2bucket-2.0.1-12.el7.x86_64.rpm
3) Install
[root@db19c ~]# rpm -Uvh /tmp/mv2bucket-2.0.1-12.el7.x86_64.rpm
warning: /tmp/mv2bucket-2.0.1-12.el7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 46caeffa: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mv2bucket-2.0.1-12 ################################# [100%]
mv2bucket-2.0.1.12 binary has been installed on /opt/mv2bucket succesfully!
4) Install確認
[root@db19c ~]# ls -la /opt/mv2bucket/
total 10188
drwxr-xr-x 2 root root 4096 Mar 4 09:56 .
drwxr-xr-x. 13 root root 4096 Mar 4 06:19 ..
-rwxr-xr-x 1 root root 10421714 Dec 29 08:22 mv2bucket.bin
■ MV2Bucket を使う
● 要件
MV2Bucket 要件
・oci-cli をインストールして構成する必要があります。
・rootユーザーとして実行する必要があります。それ以外の場合は、「sudo」を構成する必要があります。
・ソース ホスト外で MV2Bucket を実行するには、Oracle_HOME(データベース・バイナリ) が必要です。特に、「mkstore」実行可能ファイルが必要です。 代わりに sqlcl ('PATH' にある必要があります) を利用して、'mkstore' ラッパー スクリプトを追加することができます。
そして、アクセスするデータベースの OPC_FILE (--opcfile), OPC_WALLET (--opcwallet) ファイルが必要になります。
● Oracle Managed Bucket 容量 確認
1) 使い方
mv2bucket.bin size --dbuniquename <database unique name> | --dbhome <dbhome path> --opcfile <opc file path> [--opcwallet <wallet file path>] | --bucketname <bucket name>
[--nocli --ociregion <OCI region> --ocitenancy <OCI tenancy name> --ociid <OCI user ID>]
[--filter <filter string>] [--begin <date valid format YYYYMMDD> --end <date valid format YYYYMMDD>] | [--approx]
[--parallel <max parallel decode process>]
[--nosudo]
2) 実行
[root@db19c ~]# /opt/mv2bucket/mv2bucket.bin size --dbuniquename cdb_tokyo
INFO: 2023-03-04 10:04:56: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_92186.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 10:04:56: Database 'cdb_tokyo' existence check
INFO: 2023-03-04 10:04:56: Getting OPC file
INFO: 2023-03-04 10:05:00: Getting OPC file parameters
INFO: 2023-03-04 10:05:01: Checking Oracle Managed Bucket connectivity
INFO: 2023-03-04 10:05:01: Getting Oracle Managed Bucket informations, please wait...
INFO: 2023-03-04 10:05:01: Decoding Files size informations, please wait...
-------------------------------------------------
Oracle Managed Bucket content
- Number of files : 51
- Total Files size: 1.20 GB
-------------------------------------------------
● Oracle Managed Bucket ファイル一覧
1) 使い方
mv2bucket.bin list --dbuniquename <database unique name> | --dbhome <dbhome path> --opcfile <opc file path> [--opcwallet <wallet file path>] | --bucketname <bucket name>
[--nocli --ociregion <OCI region> --ocitenancy <OCI tenancy name> --ociid <OCI user ID>]
[--filter <filter string>]
[--begin <date valid format YYYYMMDD> --end <date valid format YYYYMMDD>]
[--parallel <max parallel decode process>]
[--nosudo]
2) 実行
[root@db19c ~]# /opt/mv2bucket/mv2bucket.bin list --dbuniquename cdb_tokyo
INFO: 2023-03-04 10:25:33: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_10837.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 10:25:33: Database 'cdb_tokyo' existence check
INFO: 2023-03-04 10:25:34: Getting OPC file
INFO: 2023-03-04 10:25:37: Getting OPC file parameters
INFO: 2023-03-04 10:25:38: Checking Oracle Managed Bucket connectivity
INFO: 2023-03-04 10:25:39: Getting Oracle Managed Bucket informations, please wait...
INFO: 2023-03-04 10:25:39: Decoding Files size informations, please wait...
|==================================================================================================================================================================|============|
|Oracle Managed Bucket Files Name | File Size|
|==================================================================================================================================================================|============|
|db19c/tdewallet/cdb_tokyo/2245251976/TDEWallet.tar.gz | 11.88 KB|
|dbSys25zpcvoq/database/2245251976/cdb_tokyo/backuppieces/2023-03-02/backupPieces_DBTLongterm1677736551682J8O_20230302062627.json | 952.00 B|
|dbSys25zpcvoq/database/2245251976/cdb_tokyo/dbconfig/2023-03-02/DBCONFIG_DBTLongterm1677736551682J8O_2023-03-02_06-26-28.0364.tar.gz | 412.00 B|
|dbSys25zpcvoq/database/2245251976/cdb_tokyo/rmanlog/2023-03-02/rman_backup_DBTLongterm1677736551682J8O_2023-03-02_06-25-18-7718467373050755978.log | 12.47 KB|
|dbSys25zpcvoq/database/2245251976/cdb_tokyo/tdewallet/TDEWallet.tar.gz | 11.88 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000001 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000002 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000003 | 85.25 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000001 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000002 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000003 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000004 | 60.25 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/GVF5Yz9C6UH2/0000000001 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/GVF5Yz9C6UH2/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/0000000001 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/0000000002 | 81.50 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/avX51MSb1bdp/0000000001 | 97.25 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/avX51MSb1bdp/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/0000000001 | 100.00 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/0000000002 | 72.50 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/c61Y7oaCQoPv/0000000001 | 31.75 MB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/c61Y7oaCQoPv/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/j8atrvD8Pw3N/0000000001 | 256.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/j8atrvD8Pw3N/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/h0rO4xLEG1xy/0000000001 | 512.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/h0rO4xLEG1xy/metadata.xml | 1.86 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/kjJvHgXUt2MX/0000000001 | 512.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/kjJvHgXUt2MX/metadata.xml| 1.87 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/mj4AkpDZQTYO/0000000001 | 512.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/mj4AkpDZQTYO/metadata.xml | 1.79 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-00/HDRNAUyTkh09/0000000001 | 512.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-00/HDRNAUyTkh09/metadata.xml | 1.74 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-01/aaFK9vI9IsUJ/0000000001 | 512.00 KB|
|file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-01/aaFK9vI9IsUJ/metadata.xml | 1.74 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/metadata.xml | 1.86 KB|
|sbt_catalog/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/metadata.xml | 1.87 KB|
|sbt_catalog/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/metadata.xml | 1.79 KB|
|sbt_catalog/c-2245251976-20230302-00/metadata.xml | 1.74 KB|
|sbt_catalog/c-2245251976-20230302-01/metadata.xml | 1.74 KB|
|==================================================================================================================================================================|============|
|Oracle Managed Bucket content size | 1.20 GB|
|==================================================================================================================================================================|============|
● Object Storage Bucketへコピー
1) 使い方
mv2bucket.bin copy --dbuniquename <database unique name> | --dbhome <dbhome path> --opcfile <opc file path> [--opcwallet <wallet file path>]
--bucketname <target bucket name>
[--nocli --ociregion <OCI region> --ocitenancy <OCI tenancy name> --ociid <OCI user ID>]
[--stage <Stage area for files>]
[--parallel <max parallel download/upload/decode process>]
[--incremental]
[--filter <filter string>]
[--begin <date valid format YYYYMMDD> --end <date valid format YYYYMMDD>]
[--cksum]
[--dryrun]
[--offline [--split <number of file>]]
[--nosudo]
2) 実行
/opt/mv2bucket/mv2bucket.bin copy --dbuniquename cdb_tokyo --bucketname bucket-Backup-cdb_osaka --stage /tmp/RC_TEST
4) mv2bucket Copy
[root@db19c ~]# mkdir /tmp/RC_TEST
[root@db19c ~]# /opt/mv2bucket/mv2bucket.bin copy --dbuniquename cdb_tokyo --bucketname bucket-Backup-cdb_tokyo --stage /tmp/RC_TEST
INFO: 2023-03-04 10:16:23: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_1752.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 10:16:24: Target bucket 'bucket-Backup-cdb_tokyo' existence check
INFO: 2023-03-04 10:16:24: Database 'cdb_tokyo' existence check
INFO: 2023-03-04 10:16:25: Getting OPC file
INFO: 2023-03-04 10:16:28: Getting OPC file parameters
INFO: 2023-03-04 10:16:30: Checking Oracle Managed Bucket connectivity
INFO: 2023-03-04 10:16:30: Getting Oracle Managed Bucket informations, please wait...
INFO: 2023-03-04 10:16:30: Decoding Files size informations, please wait...
INFO: 2023-03-04 10:16:30: Required stage area size is 1.20 GB
INFO: 2023-03-04 10:16:30: Available free space on stage area '/tmp/RC_TEST' is 14.31 GB
INFO: 2023-03-04 10:16:30: Getting Oracle Managed Bucket files list
INFO: 2023-03-04 10:16:30: Getting '51' files from Oracle Managed Bucket, it will take time, please wait...
SUCCESS: 2023-03-04 10:16:35: Files downloaded from Oracle Managed Bucket successfully
INFO: 2023-03-04 10:16:35: Uploading files to own bucket, it will take time, please wait...
SUCCESS: 2023-03-04 10:16:54: Files Uploaded to 'bucket-Backup-cdb_tokyo' successfully
3) Copyファイル確認
[root@db19c ~]# oci os object list -ns shirok -bn bucket-Backup-cdb_tokyo --output table
/root/lib/oracle-cli/lib64/python3.6/site-packages/oci/_vendor/httpsig_cffi/sign.py:10: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography and will be removed in a future release.
from cryptography.hazmat.backends import default_backend # noqa: F401
+----------------+-------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+----------------------------------+----------------------------------+
| archival-state | etag | md5 | name | size | storage-tier | time-created | time-modified |
+----------------+-------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+----------------------------------+----------------------------------+
| None | fac55f2d-f43b-40ce-848d | B7iSEnTnLuA== | db19c/tdewallet/cdb_tokyo/2245251976/TDEWallet.tar.gz | 12167 | Standard | 2023-03-04T10:16:36.248000+00:00 | 2023-03-04T10:16:36.248000+00:00 |
| None | 121e6f49-5b12-434e-a55e | WV41Kinj/cQ== | dbSys25zpcvoq/database/2245251976/cdb_tokyo/backuppieces/2023-03-02/backupPieces_DBTLongterm1677736551682J8O_20230302062627.json | 952 | Standard | 2023-03-04T10:16:36.351000+00:00 | 2023-03-04T10:16:36.351000+00:00 |
| None | 91f447c3-1f7b-4f49-a2ac | dzp8lQIB50Q== | dbSys25zpcvoq/database/2245251976/cdb_tokyo/dbconfig/2023-03-02/DBCONFIG_DBTLongterm1677736551682J8O_2023-03-02_06-26-28.0364.tar.gz | 412 | Standard | 2023-03-04T10:16:36.323000+00:00 | 2023-03-04T10:16:36.323000+00:00 |
| None | 2ecb8a7b-1031-4ffb-8927 | NUFmxTtmrog== | dbSys25zpcvoq/database/2245251976/cdb_tokyo/rmanlog/2023-03-02/rman_backup_DBTLongterm1677736551682J8O_2023-03-02_06-25-18-7718467373050755978.log | 12765 | Standard | 2023-03-04T10:16:36.412000+00:00 | 2023-03-04T10:16:36.412000+00:00 |
| None | e6513b03-c22b-4ef1-b2f6 | B7iSEnTnLuA== | dbSys25zpcvoq/database/2245251976/cdb_tokyo/tdewallet/TDEWallet.tar.gz | 12167 | Standard | 2023-03-04T10:16:37.293000+00:00 | 2023-03-04T10:16:37.293000+00:00 |
| None | 4b7e63bf-c104-4b62-95d8 | eaX24mpuYRw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000001 | 104857600 | Standard | 2023-03-04T10:16:39.227000+00:00 | 2023-03-04T10:16:39.227000+00:00 |
| None | 4ec9c2d1-6e35-4fc7-800b | 5BODFCnZjkQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000002 | 104857600 | Standard | 2023-03-04T10:16:39.031000+00:00 | 2023-03-04T10:16:39.031000+00:00 |
| None | 0c18a098-a0a5-4530-99ad | jm4md1ujKkw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/0000000003 | 89391104 | Standard | 2023-03-04T10:16:38.966000+00:00 | 2023-03-04T10:16:38.966000+00:00 |
| None | 8607a449-0013-45ac-83b3 | FbDo8Q4NgAw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/5v0jwNZgZspw/metadata.xml | 1900 | Standard | 2023-03-04T10:16:38.152000+00:00 | 2023-03-04T10:16:38.152000+00:00 |
| None | 0f1036dc-ad29-4f1d-8784 | zeuzX/Afthg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000001 | 104857600 | Standard | 2023-03-04T10:16:40.370000+00:00 | 2023-03-04T10:16:40.370000+00:00 |
| None | a5c09be4-761c-483b-95da | MBWujpxQO/A== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000002 | 104857600 | Standard | 2023-03-04T10:16:41.778000+00:00 | 2023-03-04T10:16:41.778000+00:00 |
| None | 260a3e7f-1a55-42a4-87ca | ODoDNNJmOmA== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000003 | 104857600 | Standard | 2023-03-04T10:16:41.607000+00:00 | 2023-03-04T10:16:41.607000+00:00 |
| None | bc1347d9-e619-444c-8cae | NZld/abX1Qg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/0000000004 | 63176704 | Standard | 2023-03-04T10:16:41.490000+00:00 | 2023-03-04T10:16:41.490000+00:00 |
| None | 1630f9ae-5a3e-44e2-b864 | AeDvWmHGKZA== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/5MvnrYW4b78V/metadata.xml | 1900 | Standard | 2023-03-04T10:16:41.065000+00:00 | 2023-03-04T10:16:41.065000+00:00 |
| None | 734a026d-4f01-4c8c-9e59 | 5zBqu9jWpfg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/GVF5Yz9C6UH2/0000000001 | 104857600 | Standard | 2023-03-04T10:16:43.616000+00:00 | 2023-03-04T10:16:43.616000+00:00 |
| None | e16a789f-1e81-4177-a7a3 | KYjafyNpvAQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/GVF5Yz9C6UH2/metadata.xml | 1900 | Standard | 2023-03-04T10:16:42.520000+00:00 | 2023-03-04T10:16:42.520000+00:00 |
| None | 54c7b6c7-2f0d-478a-b2f0 | EaWBXy0KNNg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/0000000001 | 104857600 | Standard | 2023-03-04T10:16:44.338000+00:00 | 2023-03-04T10:16:44.338000+00:00 |
| None | 8a6d3bd7-f740-4f43-ade8 | ueUvLelyRdg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/0000000002 | 85458944 | Standard | 2023-03-04T10:16:44.020000+00:00 | 2023-03-04T10:16:44.020000+00:00 |
| None | fe8856db-89e5-4187-9e1c | 0TX2Hd17maA== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/AMAA53RC0att/metadata.xml | 1900 | Standard | 2023-03-04T10:16:43.488000+00:00 | 2023-03-04T10:16:43.488000+00:00 |
| None | 5a5106bf-b337-4d77-8688 | P/t4RS2JSUw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/avX51MSb1bdp/0000000001 | 101974016 | Standard | 2023-03-04T10:16:46.378000+00:00 | 2023-03-04T10:16:46.378000+00:00 |
| None | c0a7e779-b62e-4c94-bb6c | nLiKjQ2+v0Q== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/avX51MSb1bdp/metadata.xml | 1900 | Standard | 2023-03-04T10:16:44.361000+00:00 | 2023-03-04T10:16:44.361000+00:00 |
| None | 5a2b1ba4-c14a-4fa0-afa8 | K9v6PV6RNVw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/0000000001 | 104857600 | Standard | 2023-03-04T10:16:46.818000+00:00 | 2023-03-04T10:16:46.818000+00:00 |
| None | eec0449b-3a66-428e-9b76 | dbvtiWiU3gw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/0000000002 | 76021760 | Standard | 2023-03-04T10:16:46.487000+00:00 | 2023-03-04T10:16:46.487000+00:00 |
| None | b09e8180-e268-4d28-ae8b | STb5fqOLf+A== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/nljk1kHENsw3/metadata.xml | 1900 | Standard | 2023-03-04T10:16:45.168000+00:00 | 2023-03-04T10:16:45.168000+00:00 |
| None | fa54ce07-4d9d-4512-9871 | gLoZpx4S+aw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/c61Y7oaCQoPv/0000000001 | 33292288 | Standard | 2023-03-04T10:16:46.576000+00:00 | 2023-03-04T10:16:46.576000+00:00 |
| None | 5f20cc31-eaf7-4d3a-b95a | vG232r9joag== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/c61Y7oaCQoPv/metadata.xml | 1906 | Standard | 2023-03-04T10:16:47.357000+00:00 | 2023-03-04T10:16:47.357000+00:00 |
| None | c50f16a1-c179-491e-855b | /DYTDorRCqw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/j8atrvD8Pw3N/0000000001 | 262144 | Standard | 2023-03-04T10:16:47.461000+00:00 | 2023-03-04T10:16:47.461000+00:00 |
| None | d750a743-df20-4b91-aa47 | IWuPjbqst0g== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/j8atrvD8Pw3N/metadata.xml | 1901 | Standard | 2023-03-04T10:16:47.519000+00:00 | 2023-03-04T10:16:47.519000+00:00 |
| None | 7c450d9d-b060-481c-a8ce | FIybfiN9Prg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/h0rO4xLEG1xy/0000000001 | 524288 | Standard | 2023-03-04T10:16:47.882000+00:00 | 2023-03-04T10:16:47.882000+00:00 |
| None | e5d8d098-177a-49e1-ae35 | rA99Teb7yOg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/h0rO4xLEG1xy/metadata.xml | 1906 | Standard | 2023-03-04T10:16:48.363000+00:00 | 2023-03-04T10:16:48.363000+00:00 |
| None | ffabd0c3-9b26-4b20-8d6b | uujHC4+RBGg== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/kjJvHgXUt2MX/0000000001 | 524288 | Standard | 2023-03-04T10:16:48.447000+00:00 | 2023-03-04T10:16:48.447000+00:00 |
| None | 60afa662-163d-43c3-873c | 74iNJBrU5wQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/kjJvHgXUt2MX/metadata.xml | 1910 | Standard | 2023-03-04T10:16:48.581000+00:00 | 2023-03-04T10:16:48.581000+00:00 |
| None | 3186fd4e-4146-42c1-9120 | WIaq/QrpeCA== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/mj4AkpDZQTYO/0000000001 | 524288 | Standard | 2023-03-04T10:16:48.938000+00:00 | 2023-03-04T10:16:48.938000+00:00 |
| None | de6ef040-e765-4d39-ad38 | hYo7qTZj4mQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/mj4AkpDZQTYO/metadata.xml | 1836 | Standard | 2023-03-04T10:16:49.408000+00:00 | 2023-03-04T10:16:49.408000+00:00 |
| None | c8538519-69d3-4f4b-8c81 | DRMCwj39JaQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-00/HDRNAUyTkh09/0000000001 | 524288 | Standard | 2023-03-04T10:16:49.439000+00:00 | 2023-03-04T10:16:49.439000+00:00 |
| None | b576155b-6a87-4d04-89ac | yBBtTxL3TVQ== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-00/HDRNAUyTkh09/metadata.xml | 1781 | Standard | 2023-03-04T10:16:49.732000+00:00 | 2023-03-04T10:16:49.732000+00:00 |
| None | bb15947b-3080-4acf-9bb8 | aCxcArI2ouw== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-01/aaFK9vI9IsUJ/0000000001 | 524288 | Standard | 2023-03-04T10:16:49.972000+00:00 | 2023-03-04T10:16:49.972000+00:00 |
| None | d675055b-7c14-4997-8247 | FHTuLSMirIA== | file_chunk/2245251976/CDB/backuppiece/2023-03-02/c-2245251976-20230302-01/aaFK9vI9IsUJ/metadata.xml | 1782 | Standard | 2023-03-04T10:16:50.349000+00:00 | 2023-03-04T10:16:50.349000+00:00 |
| None | 73f46db2-0070-4596-9a00 | FbDo8Q4NgAw== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_041m0sml_4_1_1_20230302_1130394325_set4/metadata.xml | 1900 | Standard | 2023-03-04T10:16:50.445000+00:00 | 2023-03-04T10:16:50.445000+00:00 |
| None | bbe2f3a8-0dc2-4ed4-be40 | AeDvWmHGKZA== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_051m0sml_5_1_1_20230302_1130394325_set5/metadata.xml | 1900 | Standard | 2023-03-04T10:16:50.864000+00:00 | 2023-03-04T10:16:50.864000+00:00 |
| None | 51ed209d-9e4e-42ff-9373 | KYjafyNpvAQ== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_061m0sne_6_1_1_20230302_1130394350_set6/metadata.xml | 1900 | Standard | 2023-03-04T10:16:50.917000+00:00 | 2023-03-04T10:16:50.917000+00:00 |
| None | 8387f371-81c4-4cf2-b3bf | 0TX2Hd17maA== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_071m0sne_7_1_1_20230302_1130394350_set7/metadata.xml | 1900 | Standard | 2023-03-04T10:16:51.369000+00:00 | 2023-03-04T10:16:51.369000+00:00 |
| None | 3d841edd-1654-4932-806b | nLiKjQ2+v0Q== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_081m0snl_8_1_1_20230302_1130394357_set8/metadata.xml | 1900 | Standard | 2023-03-04T10:16:51.622000+00:00 | 2023-03-04T10:16:51.622000+00:00 |
| None | a4491649-73fa-4d7d-b7a3 | STb5fqOLf+A== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_091m0snn_9_1_1_20230302_1130394359_set9/metadata.xml | 1900 | Standard | 2023-03-04T10:16:51.959000+00:00 | 2023-03-04T10:16:51.959000+00:00 |
| None | f55f2299-b346-461d-af8c | vG232r9joag== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0a1m0snu_10_1_1_20230302_1130394366_set10/metadata.xml | 1906 | Standard | 2023-03-04T10:16:51.934000+00:00 | 2023-03-04T10:16:51.934000+00:00 |
| None | fcf422b7-541b-4877-8d9f | IWuPjbqst0g== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0b1m0so1_11_1_1_20230302_1130394369_set11/metadata.xml | 1901 | Standard | 2023-03-04T10:16:52.356000+00:00 | 2023-03-04T10:16:52.356000+00:00 |
| None | 25c6a37e-c608-4e15-84b8 | rA99Teb7yOg== | sbt_catalog/DBTLongterm1677736551682J8O__CDB_2245251976_0c1m0so5_12_1_1_20230302_1130394373_set12/metadata.xml | 1906 | Standard | 2023-03-04T10:16:52.690000+00:00 | 2023-03-04T10:16:52.690000+00:00 |
| None | 0b68b26b-8609-41f4-9c73 | 74iNJBrU5wQ== | sbt_catalog/DBTLongterm1677736551682J8O_cf_CDB_2245251976_0d1m0so9_13_1_1_20230302_1130394377_set13/metadata.xml | 1910 | Standard | 2023-03-04T10:16:52.822000+00:00 | 2023-03-04T10:16:52.822000+00:00 |
| None | 87998313-d641-443e-bf61 | hYo7qTZj4mQ== | sbt_catalog/auto_cf_CDB_2245251976_021m0rqo_2_1_1_20230302_1130393432_set2/metadata.xml | 1836 | Standard | 2023-03-04T10:16:53.040000+00:00 | 2023-03-04T10:16:53.040000+00:00 |
| None | 0c2b0eda-345f-4185-a507 | yBBtTxL3TVQ== | sbt_catalog/c-2245251976-20230302-00/metadata.xml | 1781 | Standard | 2023-03-04T10:16:53.276000+00:00 | 2023-03-04T10:16:53.276000+00:00 |
| None | e25cd488-9348-40ee-8830 | FHTuLSMirIA== | sbt_catalog/c-2245251976-20230302-01/metadata.xml | 1782 | Standard | 2023-03-04T10:16:53.430000+00:00 | 2023-03-04T10:16:53.430000+00:00 |
+----------------+-------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+----------------------------------+----------------------------------+
prefixes: []
4) OCI コンソールで BUcket 確認
ファイルがダウンロードされていることを確認
● OPC と Wallet file 確認
バックアップした、PC と Wallet file を確認することができます
[root@db19c ~]# /opt/mv2bucket/mv2bucket.bin opcinfo --dbuniquename cdb_tokyo
INFO: 2023-03-04 10:30:38: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_15061.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 10:30:38: Database 'cdb_tokyo' existence check
INFO: 2023-03-04 10:30:38: Getting OPC file
INFO: 2023-03-04 10:30:42: Getting OPC file parameters
===============================================================================================
OPC_FILE : /opt/oracle/dcs/commonstore/oss/cdb_tokyo/963614e8-9833-4261-b685/opc_cdb_tokyo.ora
OPC_WALLET: /opt/oracle/dcs/commonstore/oss/cdb_tokyo/963614e8-9833-4261-b685/cwallet.sso
===============================================================================================
● Bucketファイルをローカル・デイレクトリへDown Load
1) Load 構文
mv2bucket load --bucketname <target bucket name> --stage <Stage area for files>
[--nocli --ociregion <OCI region> --ocitenancy <OCI tenancy name> --ociid <OCI user ID>]
[--parallel <max parallel upload process>]
[--incremental]
[--filter <filter string>]
[--begin <date valid format YYYYMMDD> --end <date valid format YYYYMMDD>]
[--cksum]
[--offline [--split <number of file>]]
[--dryrun]
[--nosudo]
2) Down Load 実行
[root@db19c .oci]# /opt/mv2bucket/mv2bucket.bin load --bucketname bucket-Backup-cdb_tokyo --stage /tmp/RMAN --incremental --parallel 10
INFO: 2023-03-04 15:39:07: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_76915.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 15:39:07: Target bucket 'bucket-Backup-cdb_tokyo' existence check
INFO: 2023-03-04 15:39:08: Getting target bucket 'bucket-Backup-cdb_tokyo' files list
INFO: 2023-03-04 15:39:09: Getting stage '/tmp/RMAN' files list
INFO: 2023-03-04 15:39:09: Im going to copy '51' files missing on target 'bucket-Backup-cdb_tokyo'
INFO: 2023-03-04 15:39:09: Uploading files to own bucket, it will take time, please wait...
SUCCESS: 2023-03-04 15:39:24: Files Uploaded to 'bucket-Backup-cdb_tokyo' successfully
3) Load 確認
[root@db19c .oci]# /opt/mv2bucket/mv2bucket.bin size --bucketname bucket-Backup-cdb_tokyo
INFO: 2023-03-04 15:40:15: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_78232.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-03-04 15:40:15: Target Bucket 'bucket-Backup-cdb_tokyo' existence check
INFO: 2023-03-04 15:40:16: Getting target bucket 'bucket-Backup-cdb_tokyo' information
-------------------------------------------------
Bucket 'bucket-Backup-cdb_tokyo' content
- Number of files : 51
- Total Files size: 1.20 GB
-------------------------------------------------
3) OS 上で確認
[root@db19c ~]# ls -l /tmp/RMAN/
total 0
drwxr-xr-x 3 root root 60 Mar 4 15:18 db19c
drwxr-xr-x 3 root root 60 Mar 4 15:18 dbSys25zpcvoq
drwxr-xr-x 3 root root 60 Mar 4 15:18 file_chunk
drwxr-xr-x 15 root root 300 Mar 4 15:18 sbt_catalog
■ mv2bucket を Database Node 外で使用する場合
mv2bucket が Database Node 外で使用する場合、実行するホストに データベース Oracle_HOME (--dbhome) が必要です(RDBMS バイナリ)。特に、「mkstore」実行可能ファイルが必要です。
そして、アクセスするデータベースの OPC_FILE (--opcfile), OPC_WALLET (--opcwallet) の引数が必要になります。
OPC_FILE と OPC_WALLET は、アクセスするデータベースから次のようにファイル・パスを取得し、実行するホストへ持ってきます。
1) OPC_FILE と OPC_WALLET ファイル・パス取得
Database Nodeで実行
[root@db19c1 ~]# /opt/mv2bucket/mv2bucket.bin opcinfo --dbuniquename DB19c_tokyo
INFO: 2023-04-06 08:44:34: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_41734.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-04-06 08:44:34: Database 'DB19c_tokyo' existence check
INFO: 2023-04-06 08:44:35: Getting OPC file
INFO: 2023-04-06 08:44:38: Getting OPC file parameters
============================================================================================================
OPC_FILE : /opt/oracle/dcs/commonstore/oss/DB19c_tokyo/4f31fa20-1639-428f-8f72/opc_DB19c_tokyo.ora
OPC_WALLET: /opt/oracle/dcs/commonstore/oss/DB19c_tokyo/4f31fa20-1639-428f-8f72/cwallet.sso
============================================================================================================
2) mv2bucket を実行するホストへ、OPC_FILE と OPC_WALLETファイルを転送
scpコマンド などで、OPC_FILE と OPC_WALLETファイルをmv2bucket を実行するホストへ転送
・ファイル転送確認
[root@db19c-clone1 ~]# ls -ltr /tmp
total 8592
-rw-r--r-- 1 opc opc 248 Apr 6 09:18 opc_DB19c_tokyo.ora
-rwxrwxr-x 1 opc opc 113647 Apr 6 09:18 cwallet.sso
・OPC_FILE確認
[root@db19c-clone1 ~]# cat /tmp/opc_DB19c_tokyo.ora
OPC_HOST=https://swiftobjectstorage.ap-tokyo-1.oraclecloud.com/v1/dbbackupnrt
OPC_WALLET='LOCATION=file:/opt/oracle/dcs/commonstore/oss/DB19c_tokyo/4f31fa20-1639-428f-8f72 CREDENTIAL_ALIAS=alias_opc'
OPC_CONTAINER=1dr6XOb13LKSbecwQZ
3) mv2bucketコマンド実行
--dbhome, --opcfile, --opcwallet を指定して実行
[root@db19c-clone1 ~]# /opt/mv2bucket/mv2bucket.bin list --dbhome /u01/app/oracle/product/19.0.0.0/dbhome_1 --opcfile /tmp/opc_DB19c_tokyo.ora --opcwallet /tmp/cwallet.sso
INFO: 2023-04-06 09:21:00: Please check the logfile '/opt/mv2bucket/out/log/mv2bucket_44404.log' for more details
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2bucket - (OCI) Oracle Managed Bucket Content Manager
Version: 2.0.1-12
Copyright (c) 2020-2022 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
INFO: 2023-04-06 09:21:00: Getting OPC file parameters
INFO: 2023-04-06 09:21:01: Checking Oracle Managed Bucket connectivity
INFO: 2023-04-06 09:21:01: Getting Oracle Managed Bucket informations, please wait...
INFO: 2023-04-06 09:21:01: Decoding Files size informations, please wait...
|===========================================================================================================================================================================|============|
|Oracle Managed Bucket Files Name | File Size|
|===========================================================================================================================================================================|============|
|db19c1/tdewallet/DB19c_tokyo/2260344047/TDEWallet.tar.gz | 52.81 KB|
|db19c2/tdewallet/DB19c_tokyo/2260344047/TDEWallet.tar.gz | 52.81 KB|
|dbSys2spvwkfq/database/2260344047/DB19c_tokyo/backuppieces/2023-04-01/backupPieces_Auto_Archive_20230401020328.json | 546.00 B|
|dbSys2spvwkfq/database/2260344047/DB19c_tokyo/backuppieces/2023-04-01/backupPieces_Auto_Archive_20230401030254.json | 390.00 B|
|dbSys2spvwkfq/database/2260344047/DB19c_tokyo/backuppieces/2023-04-01/backupPieces_Auto_Archive_20230401040251.json | 390.00 B|
・・・
|sbt_catalog/c-2260344047-20230406-12/metadata.xml | 1.74 KB|
|sbt_catalog/c-2260344047-20230406-13/metadata.xml | 1.74 KB|
|===========================================================================================================================================================================|============|
|Oracle Managed Bucket content size | 7.78 GB|
|===========================================================================================================================================================================|============|
■ Object Storage から Object Storageへのコピー(オプション)
Rcloneを使用して、ソースをローカル・ファイル・システムまたは別のクラウド・プロバイダとして定義できます。
次を参考に Oracle Object Storage から 異なるテナントの Object Storage へデーターを Copyできます
・参考: Rcloneを使用して Object Storage から 異なる テナントの Object Storage へデーターをコピー
■ 参考
・ Oracle Cloud
- My Oracle Support: (OCI) mv2bucket - Oracle Managed Bucket Content Manager (Doc ID 2723911.1)
- My Oracle Support: (OCI) How to restore a Database using a copy of OMB content done with MV2Bucket (Doc ID 2919463.1)
- MV2BUCKET: Easy way to move Oracle DB Cloud Service backups
・ rclone.org
- : Rclone syncs your files to cloud storage