Home » Infrastructure » Linux » expdp dumpfile owner/group change (datapump, 11g, Solaris)
icon9.gif  expdp dumpfile owner/group change [message #586023] Sun, 02 June 2013 08:00 Go to next message
darkmage0707077
Messages: 3
Registered: June 2013
Location: USA
Junior Member
Hello,

We've just upgraded our backup scheme from using exp to datapump. All servers are working fine but one, which instead of producing dumpfiles owned by <username> or even owner=oracle group=<username>, produces dumpfiles owned by oracle with group=dba. This prevents us from being able to automatically gzip/tar the dumpfiles to save space. What can we do to change what owner/group the dumpfiles are produced by (<username> has read/write permissions granted - via assigned role - to itself same as the others, we login to Oracle/expdp using <username>, and the dumpfile directory is owned by <username> with ACL/chmod permissions set to rwx for everyone, with ACL including <username> specifically just to be sure.).

Thank you!
Re: expdp dumpfile owner/group change [message #586025 is a reply to message #586023] Sun, 02 June 2013 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 23188
Registered: January 2009
Senior Member
change at OS level content of /etc/passwd and/or /etc/group file
icon5.gif  Re: expdp dumpfile owner/group change [message #586109 is a reply to message #586025] Mon, 03 June 2013 08:09 Go to previous messageGo to next message
darkmage0707077
Messages: 3
Registered: June 2013
Location: USA
Junior Member
Alright, forgive my ignorance, but I've never handled these files before. Is there a particular line associated with datapump that I should be looking for, or one that I should add?

[Updated on: Mon, 03 June 2013 08:10]

Report message to a moderator

Re: expdp dumpfile owner/group change [message #586110 is a reply to message #586109] Mon, 03 June 2013 08:23 Go to previous messageGo to next message
BlackSwan
Messages: 23188
Registered: January 2009
Senior Member
>All servers are working fine but one,
Compare & contrast those system that are working fine with the one that is not.
Re: expdp dumpfile owner/group change [message #586114 is a reply to message #586025] Mon, 03 June 2013 09:35 Go to previous message
darkmage0707077
Messages: 3
Registered: June 2013
Location: USA
Junior Member
Alright, I've figured it out: we have to add git bit to the desired directory:

$ chmod g+s <directory>
$ ls -ltrh

drwxrwsr-x+ 3 <username> <username> 1.0K May 1 12:25 <directory>

$ cd <directory>
$ expdp <login> directory=datapump dumpfile=export1.dmp logfile=export1.log
$ ls -ltrh
-rw-rw---- 1 oracle <username> 4.0K June 3 10:00 export1.dmp
-rw-rw---- 1 oracle <username> 617 June 3 10:00 export1.log

Thanks for the help, BlackSwan!
Previous Topic: script to check if db is up and exit if it not
Next Topic: oracle 10g for linux
Goto Forum:
  


Current Time: Sat Dec 27 04:17:35 CST 2014

Total time taken to generate the page: 0.10662 seconds