[重慶思莊每日技術分享]-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;