Solved

how to make oracle dump secured

Posted on 2014-11-19
8
175 Views
Last Modified: 2014-12-15
how to make oracle dump secured that no stranger can restore it
0
Comment
Question by:gadoontextile
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40454434
Though Data pump has introduced from Oracle 10g onwards, 10g data pump itself is in binary format, so reading it like traditional dump like cat dumpfile|string args may not work..

However over the time,Oracle has come up with masking feature from 11 onwards, there are parameters introduced in data pump export(encryption,data_map)

Remap_data is also a good feature introduced in 11g to mask the data columns where in you can use your own logic while mapping

Check out the article on tim halls site for illustration of the parameter here

http://oracle-base.com/articles/11g/data-pump-enhancements-11gr1.php
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40455759
Or....
Just zip it with password.
:p
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 40456807
don't let the strangers get their hands on it
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40457685
The simple answer is: Oracle does not provide a way to do what you asked for.  So, you need to use something like what Geert or Mike suggested: good security and/or controls in the operating system; use a file utility program like zip or a backup program that allows you to add password-protection to a file, etc.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40458123
>>The simple answer is: Oracle does not provide a way to do what you asked for

Sure, it does markgeer.. The 11g release parameter suggested in my comment does the same..
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40458219
Maybe the encryption parameter does that.  I haven't tried that, or read about that one.  (No one has asked for that feature here.)
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 40458252
In order to use Oracle encryption functionality you need the Oracle Advanced Security Option license .
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40458910
>>(No one has asked for that feature here.)

I am pretty sure mark,  the asker did ask about this. The question itself is about that..ok.. Let's not argue on this further.. I agree with mike. You do need license for this.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL 6 47
Oracle Public Synonyms and Privileges 2 50
PL/SQL Display based on value 4 17
Use of Exception to end a Loop 3 14
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now