May you want to restore an Oracle database Backup, in an other environment and you know data for customers should be very secure. So Oracle have many solution a secure a backup.
RMAN supports three encryption modes:
- Transparent mode:
- Password mode:
- Dual mode
In our example, we will make a full database backup with the Password mode encryption.
Step 1: Connect to RMAN and set the password:
RMAN> SET ENCRYPTION ON IDENTIFIED BY "oracle_4U" only;
executing command: SET encryption
Step 2: Make a full backup
RMAN> backup database tag 'Full_encryption_Backup' ;
Starting backup at 28-OCT-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=57 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 28-OCT-20
channel ORA_DISK_1: finished piece 1 at 28-OCT-20
piece handle=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/030bs0ts_1_1 tag=FULL_ENCRYPTION_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 28-OCT-20
Starting Control File and SPFILE Autobackup at 28-OCT-20
piece handle=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/c-1613867185-20201028-00 comment=NONE
Finished Control File and SPFILE Autobackup at 28-OCT-20
RMAN>
Note: We have a full database backup encrypted with the password mode.
Enjoy!
Google+
Facebook
