12c 验证RMAN加密备份

日常工作中，经常会遇到需要备份，然后异机恢复数据，提供测试数据。
为了保证数据的安全性，建议大家加密备份。

测试环境：Oracle 12c R1 RAC环境

1.备份脚本如下：

$cat rk_rman.sh #!/bin/sh#backup full  database and archivelog#filename:/home/oracle/rk_rman.sh#oracle user execute:sh /home/oracle/rk_rman.shrman target / <$

2.删除一个数据文件用来做测试

ASMCMD [+datadg/orcl/datafile] > lsSYSAUX.257.954539345SYSTEM.258.954539407UNDOTBS1.260.954539485UNDOTBS2.265.954539975USERS.259.962188425ASMCMD [+datadg/orcl/datafile] > rm USERS.259.962188425ASMCMD [+datadg/orcl/datafile] > 

3.恢复

RMAN> startupconnected to target database (not started)Oracle instance starteddatabase mountedRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of startup command at 12/08/2017 10:44:56ORA-01157: cannot identify/lock data file 6 - see DBWR trace fileORA-01110: data file 6: '+DATADG/ORCL/DATAFILE/users.259.962188425'RMAN> restore datafile 6;Starting restore at 08-DEC-2017 10:45:20allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=1 instance=orcl1 device type=DISKchannel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00006 to +DATADG/ORCL/DATAFILE/users.259.962188425channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_82_1_962188844.rmnRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 12/08/2017 10:45:22ORA-19870: error while restoring backup piece /u01/bak/db_fullbk_82_1_962188844.rmnORA-19913: unable to decrypt backupORA-28365: wallet is not openRMAN> set decryption identified by 'roidba';    --基于密码的加密备份executing command: SET decryptionRMAN> restore database; Starting restore at 08-DEC-2017 10:47:47using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00004 to +DATADG/ORCL/DATAFILE/undotbs1.260.954539485channel ORA_DISK_1: restoring datafile 00005 to +DATADG/ORCL/DATAFILE/undotbs2.265.954539975channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_83_1_962188844.rmnchannel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_83_1_962188844.rmn tag=BACKUP_FULLchannel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:07channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00003 to +DATADG/ORCL/DATAFILE/sysaux.257.954539345channel ORA_DISK_1: restoring datafile 00006 to +DATADG/ORCL/DATAFILE/users.259.962188425channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_82_1_962188844.rmnchannel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_82_1_962188844.rmn tag=BACKUP_FULLchannel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:45channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to +DATADG/ORCL/DATAFILE/system.258.954539407channel ORA_DISK_1: reading from backup piece /u01/bak/db_fullbk_81_1_962188844.rmnchannel ORA_DISK_1: piece handle=/u01/bak/db_fullbk_81_1_962188844.rmn tag=BACKUP_FULLchannel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:01:55Finished restore at 08-DEC-2017 10:50:35RMAN> recover database;Starting recover at 08-DEC-2017 10:50:51using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:02Finished recover at 08-DEC-2017 10:50:53RMAN> alter database open;Statement processed