Configuring Password Encryption RMAN Backups and Perform Restore/Recovery on Different host

Configuring encrypted RMAN Backups and Perform Restore/Recovery on Different host

Encryption mode:  Password Encryption of Backups (Password mode)

This mode uses only password protection. Password should be provided when creating and restoring encrypted backups.

Use the "only" keyword at the end to use only password encryption.

 Perform encrypted RMAN Backup

·         Connect to database using RMAN and perform backup

 In the RMAN script before run block execute below command

 RMAN> set encryption on identified by 'rmanbkp123' only;

 

 

·         To perform restore/recovery on same host. Password should be provided in the RMAN block;

 Startup nomount

Restore the controlfile

Mount the database

Restore the database

Recover the database

Open the database 

Perform encrypted RMAN backup Restore / Recovery on different host

·         Copy the RMAN Disk backup to the destination server.

·         In case of the Tape backup, Tape should be accessible from destination server. 

·         Perform the restore. Here we are using Duplicate command with Disk Backup.

 Below are the steps and command for duplicate

 startup nomount;

rman auxiliary /

 set decryption identified by 'rmanbkp123';

run

{

ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE DISK;

DUPLICATE DATABASE TO DUPTEST BACKUP LOCATION '/stage/rman_bkp/' ;

} 

                Note: In case of Multitenant both CDB and PDB will be restored

 ·         In Case of Tape restore below is the sample RMAN run block.

Depends on the Backup solution SBT_TAPE parameter changes. (below is for EMC networker)

 set decryption identified by 'rmanbkp123';

run {

 ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE 'SBT_TAPE' parms 'ENV=(NSR_SERVER=<Backup Server Name>,NSR_CLIENT=oraprd01,NSR_DATA_VOLUME_POOL=<Pool Name>)';

 duplicate target database to DUPTEST until time 'SYSDATE-1' ;

 }