在RMAN里使用Transparent Encryption进行backup/recovery

测试环境
OS: windows xp professional
DB: Oracle 11.1.0.6

测试步骤:

1. 先打开wallet:
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "admin110";

如果wallet不存在,可以使用下面的命令创建,注意保护好这个master key:
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "admin110";

2.在RMAN里进行配置

RMAN> configure encryption for database on;

old RMAN configuration parameters:
CONFIGURE ENCRYPTION FOR DATABASE OFF;
new RMAN configuration parameters:
CONFIGURE ENCRYPTION FOR DATABASE ON;
new RMAN configuration parameters are successfully stored

3.执行备份

RMAN> backup tablespace users;

Starting backup at 09-JUN-09
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=E:ORACLEORADATAG11USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 09-JUN-09
channel ORA_DISK_1: finished piece 1 at 09-JUN-09
piece handle=E:ORACLEFLASH_RECOVERY_AREAG11BACKUPSET2009_06_09O1_MF_NNNDF_TAG20090609T170037_52W95W0Y_.BKP tag=TAG20090609T1
70037 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JUN-09

Starting Control File and SPFILE Autobackup at 09-JUN-09
piece handle=E:ORACLEFLASH_RECOVERY_AREAG11AUTOBACKUP2009_06_09O1_MF_S_689101245_52W964NZ_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUN-09

4.重启数据库
shudown immediate
startup mount

5. restore备份

RMAN> restore tablespace users;

Starting restore at 09-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=153 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to E:ORACLEORADATAG11USERS01.DBF
channel ORA_DISK_1: reading from backup piece E:ORACLEFLASH_RECOVERY_AREAG11BACKUPSET2009_06_09O1_MF_NNNDF_TAG20090609T17003
7_52W95W0Y_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/09/2009 17:02:21
ORA-19870: error while restoring backup piece E:ORACLEFLASH_RECOVERY_AREAG11BACKUPSET2009_06_09O1_MF_NNNDF_TAG20090609T17003
7_52W95W0Y_.BKP
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open

需要先打开wallet:
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "admin110";

再次尝试后OK

6.Recover and open database

RMAN> recover database;

Starting recover at 09-JUN-09
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 09-JUN-09

RMAN> alter database open;

database opened

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/100682/viewspace-1022935/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/100682/viewspace-1022935/