1
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

Oracle管理の自動バックアップでのOracle管理バケットのバックアップファイルサイズを確認する方法

Last updated at Posted at 2023-12-08

この記事は、JPOUG Advent Calendar 2023 8日目の記事です。7日目は gowatana さんの記事 「Oracle Linux 9 の LIO iSCSI Target が VAAI 対応しているか確認してみる。」でした。

概要

Oracle Cloud Infrastructure (OCI) のOracle Cloud Database の自動バックアップ機能は、ORACLEによって管理される Oracle Management Bucket (OMB) の Objeect Storage Bucketに格納され、ユーザーはこの領域にアクセスできません。
そのため、どのくらいのサイズのバックアップファイルが出力されたのか、OS上のファイルを確認するように簡単に確認することができません。
しかし、課金管理やバックアップ完了時間の想定をつけるため、バックアップファイルサイズを確認したいことがあります。
今回は、その確認方法について、SQLを使った確認方法とmv2bucketを使った確認方法の2通りの例を記載したいと思います。

実行は、Base DB(SE)環境にて確認しております。

[方法1]SQLを使った確認方法

V$BACKUP_FILESを使った確認例を記載します。
ここでは、LV0バックアップ、LV1バックアップ、アーカイブログバックアップを出力します。
BaseDBではアーカイブログバックアップは1時間に一回、ExaDB-Dでは30分に一回実施されていますが、ここでは表示行数を圧縮するため、日にち毎のSUMを表示しています。

select TO_CHAR(b.completion_time,'YYYY-MM-DD') as backup_comp_date,b.TAG,TRUNC(SUM(b.BYTES/1024/1024)) SIZE_MB
from V$BACKUP_FILES b
where 0=0
and b.FILE_TYPE = 'PIECE'
and b.TAG like 'DBT%' or b.TAG = 'AUTO_ARCHIVE'
group by TO_CHAR(b.completion_time,'YYYY-MM-DD'),b.TAG
order by backup_comp_date
;

出力例
image.png


自動バックアップで実施されたバックアップのTAGにはフルバックでは、DBTREGULAR-L0xxxxxxxxx、増分バックアップでは、DBTREGULAR-L1xxxxxxxxxという名称で、オンデマンドバックアップでは、DBTLONGTERMxxxxxxという名前になるようです。また、アーカイブログバックアップにはAUTO_ARCHIVEというタグがつくようです。

[方法2]mv2bucketを使った確認方法

mv2bucketを使った確認例を記載します。
mv2bucketとは、Oracle Management Bucket (OMB) にあるファイルをリスト表示したり、OMBからCustomer Management Bucket (CMB) に OMB のコピーをすることができるツールになります。

mv2bucketについてのインストール方法や使い方は以下の@shirokさんのQIITA記事を参考にしてください。

[Oracle Cloud Databse Service] MV2BUCKET を使用して Oracle管理のバックアップをダウンロードしてみてみた

ここでは、すでにインストール済みであるとします

OMBにあるDBのバックアップ関連ファイルの全体サイズのみ確認したい場合は以下コマンドになります。

[root@dbhosta ~]# /opt/mv2bucket/mv2bucket.bin size --dbuniquename db19c_a

実行結果

-------------------------------------------------
Oracle Managed Bucket content
  - Number of files : 2501
  - Total Files size: 8.42 GB
-------------------------------------------------


--dbuniquename の後ろはDBユニーク名です。
自動バックアップでオブジェクトストレージに格納する際はバックアップピースがさらに細かく100MBごとに分割されて格納されるためファイル数が多くなります。また実行時のログファイルやアーカイブログバックアップ、コントロールファイルやSPFILEのバックアップも格納されています。

これらは、以下listコマンドで一覧表示でき、それぞれのファイルサイズも確認できるのですが、膨大な行数になってしまいがちなため、バックアップピース毎にまとめて表示してくれるmetareportというコマンドを使います。

↓これは膨大にでてくるので

[root@dbhosta ~]# /opt/mv2bucket/mv2bucket.bin metareport list --dbuniquename db19c_a

↓こちらで確認するのがお勧め

[root@dbhosta ~]# /opt/mv2bucket/mv2bucket.bin metareport --dbuniquename db19c_a

metareport実行結果

Dbname      Dbid           FileName                                                                                                      FileSize          LastModified          BackupType            Incremental  Compressed   Encrypted
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hm29pmgo_4662_1_1_20231025_1151130136_set4662                   362807296         2023-10-25 06:22:38   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hn29pmgo_4663_1_1_20231025_1151130136_set4663                   396886016         2023-10-25 06:22:36   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_ho29pmhh_4664_1_1_20231025_1151130161_set4664                   305135616         2023-10-25 06:22:54   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hp29pmhi_4665_1_1_20231025_1151130162_set4665                   302514176         2023-10-25 06:22:54   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hq29pmi1_4666_1_1_20231025_1151130177_set4666                   5505024           2023-10-25 06:22:58   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hr29pmi1_4667_1_1_20231025_1151130177_set4667                   2621440           2023-10-25 06:22:58   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hs29pmi4_4668_1_1_20231025_1151130180_set4668                   200015872         2023-10-25 06:23:08   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_ht29pmi4_4669_1_1_20231025_1151130180_set4669                   101711872         2023-10-25 06:23:06   Datafile              false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hu29pmim_4670_1_1_20231025_1151130198_set4670                   242745344         2023-10-25 06:23:24   ArchivedLog           false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_hv29pmiu_4671_1_1_20231025_1151130206_set4671                   262144            2023-10-25 06:23:26   SPFILE                false        true         true
DB19C       2261350085     DBTLongterm1698214510862EkO__DB19C_2261350085_i029pmiv_4672_1_1_20231025_1151130207_set4672                   1310720           2023-10-25 06:23:28   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_arc_DB19C_2261350085_0d2cebmb_5133_1_1_20231126_1153904331_set5133              262144            2023-11-26 08:58:52   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_052cebkg_5125_1_1_20231126_1153904272_set5125               354942976         2023-11-26 08:58:10   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_062cebkg_5126_1_1_20231126_1153904272_set5126               397148160         2023-11-26 08:58:12   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_072cebl9_5127_1_1_20231126_1153904297_set5127               305135616         2023-11-26 08:58:30   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_082cebl9_5128_1_1_20231126_1153904297_set5128               302514176         2023-11-26 08:58:31   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_092ceblp_5129_1_1_20231126_1153904313_set5129               5505024           2023-11-26 08:58:34   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_0a2ceblp_5130_1_1_20231126_1153904313_set5130               2621440           2023-11-26 08:58:34   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_0b2cebls_5131_1_1_20231126_1153904316_set5131               200015872         2023-11-26 08:58:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01700988634584mBZ_df_DB19C_2261350085_0c2cebls_5132_1_1_20231126_1153904316_set5132               101711872         2023-11-26 08:58:42   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_arc_DB19C_2261350085_382d4941_5224_1_1_20231203_1154622593_set5224              398983168         2023-12-03 16:30:03   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_arc_DB19C_2261350085_3h2d496b_5233_1_1_20231203_1154622667_set5233              262144            2023-12-03 16:31:08   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_cf_DB19C_2261350085_3j2d496f_5235_1_1_20231203_1154622671_set5235               1310720           2023-12-03 16:31:13   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_392d494g_5225_1_1_20231203_1154622608_set5225               356253696         2023-12-03 16:30:27   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3a2d494g_5226_1_1_20231203_1154622608_set5226               397148160         2023-12-03 16:30:28   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3b2d4959_5227_1_1_20231203_1154622633_set5227               305135616         2023-12-03 16:30:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3c2d4959_5228_1_1_20231203_1154622633_set5228               302514176         2023-12-03 16:30:47   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3d2d495p_5229_1_1_20231203_1154622649_set5229               5505024           2023-12-03 16:30:50   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3e2d495p_5230_1_1_20231203_1154622649_set5230               2621440           2023-12-03 16:30:50   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3f2d495s_5231_1_1_20231203_1154622652_set5231               200015872         2023-12-03 16:30:59   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L01701620566493YBK_df_DB19C_2261350085_3g2d495s_5232_1_1_20231203_1154622652_set5232               101711872         2023-12-03 16:30:57   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_arc_DB19C_2261350085_0k2ch15u_5140_1_1_20231127_1153991870_set5140              259784704         2023-11-27 09:17:59   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_arc_DB19C_2261350085_0t2ch16p_5149_1_1_20231127_1153991897_set5149              262144            2023-11-27 09:18:17   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0l2ch16e_5141_1_1_20231127_1153991886_set5141               27000832          2023-11-27 09:18:10   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0m2ch16e_5142_1_1_20231127_1153991886_set5142               15466496          2023-11-27 09:18:10   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0n2ch16l_5143_1_1_20231127_1153991893_set5143               4194304           2023-11-27 09:18:14   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0o2ch16l_5144_1_1_20231127_1153991893_set5144               3670016           2023-11-27 09:18:14   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0p2ch16m_5145_1_1_20231127_1153991894_set5145               3407872           2023-11-27 09:18:15   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701074983494CTn_df_DB19C_2261350085_0q2ch16o_5146_1_1_20231127_1153991896_set5146               2883584           2023-11-27 09:18:16   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_arc_DB19C_2261350085_122cjkcp_5154_1_1_20231128_1154077081_set5154              245104640         2023-11-28 08:58:12   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_arc_DB19C_2261350085_1b2cjkdl_5163_1_1_20231128_1154077109_set5163              262144            2023-11-28 08:58:29   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_132cjkd9_5155_1_1_20231128_1154077097_set5155               26738688          2023-11-28 08:58:21   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_142cjkd9_5156_1_1_20231128_1154077097_set5156               16777216          2023-11-28 08:58:22   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_152cjkdg_5157_1_1_20231128_1154077104_set5157               4194304           2023-11-28 08:58:25   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_162cjkdg_5158_1_1_20231128_1154077104_set5158               3932160           2023-11-28 08:58:25   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_172cjkdj_5159_1_1_20231128_1154077107_set5159               3670016           2023-11-28 08:58:28   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701161437395HIO_df_DB19C_2261350085_182cjkdk_5160_1_1_20231128_1154077108_set5160               3145728           2023-11-28 08:58:28   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_arc_DB19C_2261350085_1g2cm8m9_5168_1_1_20231129_1154163401_set5168              269484032         2023-11-29 08:56:50   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_arc_DB19C_2261350085_1p2cm8n3_5177_1_1_20231129_1154163427_set5177              524288            2023-11-29 08:57:07   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1h2cm8mp_5169_1_1_20231129_1154163417_set5169               28573696          2023-11-29 08:57:01   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1i2cm8mp_5170_1_1_20231129_1154163417_set5170               20185088          2023-11-29 08:57:01   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1j2cm8n0_5171_1_1_20231129_1154163424_set5171               4456448           2023-11-29 08:57:05   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1k2cm8n0_5172_1_1_20231129_1154163424_set5172               3932160           2023-11-29 08:57:05   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1l2cm8n1_5173_1_1_20231129_1154163425_set5173               3145728           2023-11-29 08:57:06   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701247764402E6h_df_DB19C_2261350085_1m2cm8n1_5174_1_1_20231129_1154163425_set5174               3145728           2023-11-29 08:57:06   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_arc_DB19C_2261350085_1u2cot5d_5182_1_1_20231130_1154249901_set5182              234618880         2023-11-30 08:58:29   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_arc_DB19C_2261350085_272cot66_5191_1_1_20231130_1154249926_set5191              262144            2023-11-30 08:58:47   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_1v2cot5s_5183_1_1_20231130_1154249916_set5183               25427968          2023-11-30 08:58:40   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_202cot5s_5184_1_1_20231130_1154249916_set5184               17301504          2023-11-30 08:58:40   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_212cot63_5185_1_1_20231130_1154249923_set5185               3932160           2023-11-30 08:58:44   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_222cot64_5186_1_1_20231130_1154249924_set5186               3670016           2023-11-30 08:58:44   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_232cot65_5187_1_1_20231130_1154249925_set5187               3932160           2023-11-30 08:58:45   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L117013342802144LA_df_DB19C_2261350085_242cot65_5188_1_1_20231130_1154249925_set5188               3145728           2023-11-30 08:58:45   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_arc_DB19C_2261350085_2c2cu73r_5196_1_1_20231201_1154423931_set5196              238551040         2023-12-01 09:19:00   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_arc_DB19C_2261350085_2l2cu74m_5205_1_1_20231201_1154423958_set5205              262144            2023-12-01 09:19:18   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_cf_DB19C_2261350085_2n2cu74q_5207_1_1_20231201_1154423962_set5207               1310720           2023-12-01 09:19:24   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2d2cu74b_5197_1_1_20231201_1154423947_set5197               26738688          2023-12-01 09:19:11   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2e2cu74b_5198_1_1_20231201_1154423947_set5198               18612224          2023-12-01 09:19:11   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2f2cu74i_5199_1_1_20231201_1154423954_set5199               3407872           2023-12-01 09:19:15   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2g2cu74i_5200_1_1_20231201_1154423954_set5200               3670016           2023-12-01 09:19:15   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2h2cu74j_5201_1_1_20231201_1154423955_set5201               2883584           2023-12-01 09:19:16   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701420661084CRk_df_DB19C_2261350085_2i2cu74l_5202_1_1_20231201_1154423957_set5202               2621440           2023-12-01 09:19:17   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_arc_DB19C_2261350085_2q2d0q7c_5210_1_1_20231202_1154509036_set5210              286261248         2023-12-02 08:57:27   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_arc_DB19C_2261350085_332d0q87_5219_1_1_20231202_1154509063_set5219              262144            2023-12-02 08:57:43   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_cf_DB19C_2261350085_352d0q8b_5221_1_1_20231202_1154509067_set5221               1310720           2023-12-02 08:57:48   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_2r2d0q7s_5211_1_1_20231202_1154509052_set5211               27000832          2023-12-02 08:57:36   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_2s2d0q7s_5212_1_1_20231202_1154509052_set5212               20709376          2023-12-02 08:57:36   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_2t2d0q83_5213_1_1_20231202_1154509059_set5213               4194304           2023-12-02 08:57:40   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_2u2d0q83_5214_1_1_20231202_1154509059_set5214               4194304           2023-12-02 08:57:40   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_2v2d0q84_5215_1_1_20231202_1154509060_set5215               3932160           2023-12-02 08:57:41   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701507002758KIW_df_DB19C_2261350085_302d0q85_5216_1_1_20231202_1154509061_set5216               3670016           2023-12-02 08:57:42   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_arc_DB19C_2261350085_3m2d62vt_5238_1_1_20231204_1154681853_set5238              166985728         2023-12-04 08:57:40   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_arc_DB19C_2261350085_3v2d630g_5247_1_1_20231204_1154681872_set5247              262144            2023-12-04 08:57:52   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_cf_DB19C_2261350085_412d630k_5249_1_1_20231204_1154681876_set5249               1310720           2023-12-04 08:57:57   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3n2d6305_5239_1_1_20231204_1154681861_set5239               20185088          2023-12-04 08:57:44   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3o2d6305_5240_1_1_20231204_1154681861_set5240               15204352          2023-12-04 08:57:45   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3p2d630c_5241_1_1_20231204_1154681868_set5241               3407872           2023-12-04 08:57:49   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3q2d630c_5242_1_1_20231204_1154681868_set5242               3145728           2023-12-04 08:57:49   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3r2d630d_5243_1_1_20231204_1154681869_set5243               2097152           2023-12-04 08:57:50   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701679831320jKQ_df_DB19C_2261350085_3s2d630e_5244_1_1_20231204_1154681870_set5244               1835008           2023-12-04 08:57:51   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_arc_DB19C_2261350085_442d8om8_5252_1_1_20231205_1154769608_set5252              258736128         2023-12-05 09:20:16   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_arc_DB19C_2261350085_4d2d8on2_5261_1_1_20231205_1154769634_set5261              262144            2023-12-05 09:20:34   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_cf_DB19C_2261350085_4f2d8on6_5263_1_1_20231205_1154769638_set5263               1310720           2023-12-05 09:20:39   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_452d8omn_5253_1_1_20231205_1154769623_set5253               28049408          2023-12-05 09:20:27   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_462d8omn_5254_1_1_20231205_1154769623_set5254               18612224          2023-12-05 09:20:28   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_472d8omv_5255_1_1_20231205_1154769631_set5255               3407872           2023-12-05 09:20:31   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_482d8omv_5256_1_1_20231205_1154769631_set5256               3145728           2023-12-05 09:20:32   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_492d8on0_5257_1_1_20231205_1154769632_set5257               2883584           2023-12-05 09:20:33   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701766323455Ekw_df_DB19C_2261350085_4a2d8on0_5258_1_1_20231205_1154769632_set5258               2621440           2023-12-05 09:20:33   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_arc_DB19C_2261350085_4i2dbbni_5266_1_1_20231206_1154854642_set5266              262930432         2023-12-06 08:57:30   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_arc_DB19C_2261350085_4r2dbboc_5275_1_1_20231206_1154854668_set5275              262144            2023-12-06 08:57:48   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_cf_DB19C_2261350085_4t2dbbog_5277_1_1_20231206_1154854672_set5277               1310720           2023-12-06 08:57:53   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4j2dbbo2_5267_1_1_20231206_1154854658_set5267               28049408          2023-12-06 08:57:41   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4k2dbbo2_5268_1_1_20231206_1154854658_set5268               17825792          2023-12-06 08:57:42   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4l2dbbo9_5269_1_1_20231206_1154854665_set5269               4194304           2023-12-06 08:57:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4m2dbbo9_5270_1_1_20231206_1154854665_set5270               3932160           2023-12-06 08:57:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4n2dbboa_5271_1_1_20231206_1154854666_set5271               3407872           2023-12-06 08:57:47   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701852611403ZBZ_df_DB19C_2261350085_4o2dbboa_5272_1_1_20231206_1154854666_set5272               3145728           2023-12-06 08:57:47   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_arc_DB19C_2261350085_502de079_5280_1_1_20231207_1154941161_set5280              238551040         2023-12-07 08:59:29   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_arc_DB19C_2261350085_592de083_5289_1_1_20231207_1154941187_set5289              262144            2023-12-07 08:59:47   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_cf_DB19C_2261350085_5b2de087_5291_1_1_20231207_1154941191_set5291               1310720           2023-12-07 08:59:52   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_512de07p_5281_1_1_20231207_1154941177_set5281               25690112          2023-12-07 08:59:40   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_522de07p_5282_1_1_20231207_1154941177_set5282               16777216          2023-12-07 08:59:41   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_532de080_5283_1_1_20231207_1154941184_set5283               3932160           2023-12-07 08:59:44   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_542de080_5284_1_1_20231207_1154941184_set5284               3932160           2023-12-07 08:59:45   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_552de081_5285_1_1_20231207_1154941185_set5285               3670016           2023-12-07 08:59:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11701939102778mK2_df_DB19C_2261350085_562de081_5286_1_1_20231207_1154941185_set5286               3145728           2023-12-07 08:59:46   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_arc_DB19C_2261350085_5e2dgkht_5294_1_1_20231208_1155027517_set5294              235405312         2023-12-08 08:58:45   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_arc_DB19C_2261350085_5n2dgkio_5303_1_1_20231208_1155027544_set5303              262144            2023-12-08 08:59:05   ArchivedLog           false        true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_cf_DB19C_2261350085_5p2dgkis_5305_1_1_20231208_1155027548_set5305               1310720           2023-12-08 08:59:10   ControlFile           false        true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5f2dgkid_5295_1_1_20231208_1155027533_set5295               26214400          2023-12-08 08:58:57   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5g2dgkid_5296_1_1_20231208_1155027533_set5296               14417920          2023-12-08 08:58:57   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5h2dgkik_5297_1_1_20231208_1155027540_set5297               3932160           2023-12-08 08:59:01   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5i2dgkik_5298_1_1_20231208_1155027540_set5298               3407872           2023-12-08 08:59:01   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5j2dgkim_5299_1_1_20231208_1155027542_set5299               3145728           2023-12-08 08:59:02   Datafile              true         true         true
DB19C       2261350085     DBTRegular-L11702025490522vPI_df_DB19C_2261350085_5k2dgkin_5300_1_1_20231208_1155027543_set5300               2883584           2023-12-08 08:59:03   Datafile              true         true         true
DB19C       2261350085     c-2261350085-20231130-01                                                                                      1310720           2023-11-30 08:58:53   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231201-00                                                                                      1310720           2023-12-01 09:19:20   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231201-01                                                                                      1310720           2023-12-01 09:19:25   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231202-00                                                                                      1310720           2023-12-02 08:57:45   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231202-01                                                                                      1310720           2023-12-02 08:57:50   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231203-00                                                                                      1310720           2023-12-03 16:31:09   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231203-01                                                                                      1310720           2023-12-03 16:31:14   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231204-00                                                                                      1310720           2023-12-04 08:57:54   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231204-01                                                                                      1310720           2023-12-04 08:57:59   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231205-00                                                                                      1310720           2023-12-05 09:20:35   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231205-01                                                                                      1310720           2023-12-05 09:20:40   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231206-00                                                                                      1310720           2023-12-06 08:57:50   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231206-01                                                                                      1310720           2023-12-06 08:57:55   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231207-00                                                                                      1310720           2023-12-07 08:59:48   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231207-01                                                                                      1310720           2023-12-07 08:59:53   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231208-00                                                                                      1310720           2023-12-08 08:59:06   ControlFile SPFILE    false        true         true
DB19C       2261350085     c-2261350085-20231208-01                                                                                      1310720           2023-12-08 08:59:11   ControlFile SPFILE    false        true         true
Total Storage: 8.41 GB

以上になります

1
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?