ENCRYPTION in EXPDP and IMPDP datapump jobs in Oracle

 

ENCRYPTION in EXPDP and IMPDP datapump jobs in Oracle

During the EXPDP job we can implement more security with dump file. so that other will not able to restore it.

we can use ENCRYPTION_MODE parameter with EXPDP, it will provide us additional encryption with backup.

Note:

1. feature is used with Enterprise edition of Oracle.

2. Compatibility for DUAL and transparent use is minimum 11.0.0 compatibility.

ENCRYPTION_MODE has following option

ENCRYPTION_MODE = [DUAL | PASSWORD | TRANSPARENT]

PASSWORD: It use excryption_password during export and import.

TRANSPARENT: It use wallet, With open wallet you can export or import.

DUAL: Create a dump file that either import with password or Oracle wallet which ever specified during export(DEFAULT use both PASSWORD or TRANSPARENT)

Example of EXPDP and IMPDP

expdp username/password directory=dbbackup dumpfile=test.dmp logfile=test.log
encryption=all encryption_mode=password encryption_password=test tables='test';

impdp username/password directory=dbbackup dumpfile=test.dmp logfile=test.log encryption_password=test;