1.查找WALLET的目录

sql>CT WRL_TYPE,WRL_PARAMETER,STATUS,WALLET_TYPE FROM V$ENCRYPTION_WALLET;

FILE /u01/app/oracle/admin/orcl/wallet NOT_AVAILABLE UNKNOWN

2.建立WALLET的目录

mkdir -p/u01/app/oracle/admin/orcl/wallet

3.创建KEYSTORE文件

sql>nister key management

create keystore '/u01/app/oracle/admin/orcl/wallet' identified by oracle_4U;

4.打开KEYSTORE文件

sql>nister key management

set keystore open identified by oracle_4U;

5.创建master 加密key

sql>administer key management

set key identified by oracle_4U

with backup using 'for_sztech';

6.打开加密备份

rman>configure encryption for database on;

7.执行透明加密备份

rman>backup tablespace users;

ITPub博客

[重庆思庄每日技术分享]-oracle 12c透明加密