環境:
用commvault 備份Oracle 資料庫，要還原時，在裡面都只看到dbf檔，無法顯示裡面的資料表。
解決過程:
commvault 備份Oracle 資料庫的設定，如果沒勾選"啟用表格瀏覽"，就看不到裡面的資料表，這邊的表格，就是指資料表Table的意思。
如果沒有勾選這個功能，還原就會變的很麻煩
1. 沒啟用 Enable Table Browse
若您過去的備份沒有啟用此功能，當有人誤刪資料時：
還原邏輯： 您無法在 Commvault 介面看到「表」的清單，只能看到「資料庫」。
必須全機還原： 您必須像現在一樣選擇 RMAN Duplicate DB，把整個資料庫（數百 GB 或 TB）還原，變成一個資料庫。
手動撈取： 您得自己連進資料庫，下 SQL 或用
expdp撈出那張表，再手動匯入回 。缺點： 極度消耗 磁碟空間，且還原時間很長（因為要搬動所有資料檔）。
2. 啟用 Enable Table Browse 後的差別 (未來的狀況)
如果您現在勾選並完成了一次新的完整備份：
還原邏輯： 在「瀏覽」視窗切換到 Table View，您可以直接看到裡面的所有使用者與資料表清單。
精準還原： 您只需要勾選「被誤刪的那張表」。
自動化輔助實例： Commvault 會自動在Staging Path 建立一個「最小化」的臨時實例。它只會還原必要的系統檔案和該表所在的 Tablespace，而不是整個資料庫。
優點： 節省大量磁碟空間（可能只需還原 10% 的資料量），且 Commvault 會自動完成匯出與匯入的動作。
Environment:
When using Commvault to back up an Oracle database, during restore operations only .dbf files are visible, and the tables inside the database cannot be displayed.
Resolution Process:
In the Commvault Oracle database backup settings, if “Enable Table Browse” is not selected, database tables will not be visible.
Here, “Table” refers to database tables.
If this option is not enabled, restoration becomes very complicated.
1. Without enabling Enable Table Browse
If past backups were performed without this option enabled and a table is accidentally deleted:
-
Restore logic:
You cannot see a list of tables in the Commvault interface. You can only see the database as a whole. -
Full database restore required:
You must perform an RMAN Duplicate DB, restoring the entire database (hundreds of GBs or even TBs) as a separate database instance. -
Manual data extraction:
You must manually connect to the database, run SQL queries, or useexpdpto export the required table, then manually import it back. -
Drawbacks:
Extremely high disk space consumption and very long restore times, since all data files must be restored.
2. Difference after enabling Enable Table Browse (future scenario)
If you enable this option now and complete a new full backup:
-
Restore logic:
In the Browse window, switch to Table View, and you can directly see all users and their tables. -
Precise restore:
You only need to select the specific table that was accidentally deleted. -
Automated auxiliary instance:
Commvault will automatically create a minimal temporary instance in the Staging Path.
It restores only the required system files and the tablespace containing the selected table, rather than the entire database. -
Advantages:
Significant disk space savings (possibly restoring only around 10% of the data), and Commvault automatically handles the export and import process.
The following article provides a more detailed explanation:
https://itnoesis.com/2020/09/20/oracle-rac-table-restore-using-commvault/
