重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12c透明加密 [打印本页]

作者: 郑全 时间: 2020-1-10 18:17
标题: 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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)