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.
·
Connect to database using RMAN and perform backup
RMAN> set encryption on identified by 'rmanbkp123' only;
·
To perform restore/recovery on same host. Password
should be provided in the RMAN block;
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.
rman auxiliary /
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
Depends on the Backup
solution SBT_TAPE parameter changes. (below is for EMC networker)
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' ;
}
