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;