Oracle 加密详解
整理:天外飞猪 yl465003982@outlook.com
select * from v$rman_encryption_algorithms;
ALGORITHM_ID ALGORITHM_NAME ALGORITHM_DESCRIPTION
IS_ RES
------------ --------------------
---------------------------------------------------------------- --- ---
1 AES128 AES 128-bit key
YES NO
2 AES192 AES 192-bit key
NO NO
3 AES256 AES 256-bit key
NO NO
rman 口令模式加密
加密
set encryption on identified by 'oracle' only;
备份数据库
set encryption off;
解密
set decryption identified by 'oracle';
透明加密模式:
col WRL_PARAMETER for a40
select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS
-------------------- ---------------------------------------- ------------------
file /u01/app/oracle/admin/ocm/wallet CLOSED
sqlnet.ora 文件中添加:
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u01/wa
llet)))
创建透明加密密钥:
alter system set encryption key authenticated by oracle;
col WRL_PARAMETER for a40
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS