Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how to make oracle dump secured

Posted on 2014-11-19
8
Medium Priority
?
183 Views
Last Modified: 2014-12-15
how to make oracle dump secured that no stranger can restore it
0
Comment
Question by:gadoontextile
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 38

Expert Comment

by:Geert Gruwez
ID: 40456807
don't let the strangers get their hands on it
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
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 1000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

704 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