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

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;