RMAN 備份集若落入他人手中,等同資料庫被盜。Oracle 10.2+ Enterprise Edition 提供 **備份集加密**,最簡單方式是 **密碼模式 (`SET ENCRYPTION ON IDENTIFIED BY ... ONLY`)**。本文完整演示:建立測試表空間/表 → 設定加密演算法 → 加密備份 → 模擬災難 → 還原驗證 (含錯誤密碼失敗案例)。
-- 版本: 11.2.0.4 EE
-- 相容參數
SHOW PARAMETER compatible; -- 11.2.0.4.0
-- 支援加密演算法
SELECT algorithm_name FROM v$rman_encryption_algorithms;
-- AES128 (預設), AES192, AES256
-- 調整為最強 AES256
CONFIGURE ENCRYPTION ALGORITHM 'AES256';
CREATE TABLESPACE rman_test DATAFILE '/u01/app/oracle/oradata/orcl/rman_test01.dbf' SIZE 100M;
CREATE TABLE chf.t_rman_test TABLESPACE rman_test AS SELECT * FROM dba_objects;
-- 86,721 筆資料
RMAN> SET ENCRYPTION ON IDENTIFIED BY 'StrongPassw0rd!' ONLY;
RMAN> BACKUP DATAFILE 5; -- 只備份測試表空間檔案
-- 輸出片段
channel ORA_DISK_1: starting full datafile backup set
piece handle=/u01/backup/2023_01_28/o1_mf_nnndf_TAG20230128T230115_bdkyfvlw_.bkp
tag=TAG20230128T230115 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
關鍵語法:
RMAN> SQL 'ALTER DATABASE DATAFILE 5 OFFLINE';
-- OS 層刪除
RMAN> RESTORE DATAFILE 5;
-- 未設定解密密碼 → 失敗
RMAN-03002: failure of restore command
ORA-19870: error restoring backup piece
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
RMAN> SET DECRYPTION IDENTIFIED BY 'StrongPassw0rd!';
RMAN> RESTORE DATAFILE 5;
-- 成功還原
RMAN> RECOVER DATAFILE 5;
RMAN> SQL 'ALTER DATABASE DATAFILE 5 ONLINE';
RMAN> SET DECRYPTION IDENTIFIED BY 'WrongPassword';
RMAN> RESTORE DATAFILE 5;
-- ORA-19913: unable to decrypt backup
-- ORA-28365: wallet is not open (實為密碼錯誤)
| 模式 | 指令 | 金鑰管理 | 適用場景 |
|---|---|---|---|
| 透明加密 | `CONFIGURE ENCRYPTION FOR DATABASE ON;` | TDE Wallet (自動開啟/手動開啟) | 日常自動備份、無需人工干預 |
| 密碼模式 | `SET ENCRYPTION ON IDENTIFIED BY 'pwd' ONLY;` | 人工保管密碼 | 異地備份、雲端儲存、第三方媒體、審計要求 |
| 雙重模式 | `SET ENCRYPTION ON IDENTIFIED BY 'pwd';` (無 ONLY) | Wallet + 密碼雙重 | 最高安全等級,二者其一即可解密 |