Password-Mode Decryption RMAN Backup

For security reasons, after making an encryption RMAN backups, we can decrypt our backups using the same password of the backup.

Step 1: trying to decrypt an encrypted backup without putting the password

RMAN> alter tablespace users offline immediate;
using target database control file instead of recovery catalog
Statement processed
RMAN>
RMAN> restore tablespace users;
Starting restore at 28-OCT-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 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 00007 to /u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/12.2.0/dbhome_1/dbs/030bs0ts_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/28/2020 16:45:15
ORA-19870: error while restoring backup piece /u01/app/oracle/product/12.2.0/dbhome_1/dbs/030bs0ts_1_1
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
RMAN>

Step 2: Set password for decryption:

RMAN> SET DECRYPTION IDENTIFIED BY "oracle_4U" ;
executing command: SET decryption
RMAN>
RMAN> restore tablespace users;
Starting restore at 28-OCT-20
using channel ORA_DISK_1
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 00007 to /u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/12.2.0/dbhome_1/dbs/030bs0ts_1_1
channel ORA_DISK_1: piece handle=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/030bs0ts_1_1 tag=FULL_ENCRYPTION_BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 28-OCT-20
RMAN> recover tablespace users;
Starting recover at 28-OCT-20
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 28-OCT-20
RMAN> alter tablespace users online;
Statement processed

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply