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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.