RMAN

RMAN in Oracle

ENCRYPT and Decryption Backup

export oracle_sid=mydb

rman target sys/oracle

rman>set encryption on identified by azar only;

rman>configure encryption for tablespace users on;

rman>backup tablespace users;

rman>sql 'alter tablespace users offline';

rman>restore tablespace users; -->error

rman>set decryption identified by azar;

rman>restore tablespace users;

rman>recover tablespace users;

rman>sql 'alter tablespace users online';