OraFAQ Forum: Linux » expdp dumpfile owner/group change

Home » Infrastructure » Linux » expdp dumpfile owner/group change (datapump, 11g, Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

expdp dumpfile owner/group change [message #586023]

Sun, 02 June 2013 08:00

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!

Report message to a moderator

Re: expdp dumpfile owner/group change [message #586025 is a reply to message #586023]

Sun, 02 June 2013 08:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

change at OS level content of /etc/passwd and/or /etc/group file

Report message to a moderator

Re: expdp dumpfile owner/group change [message #586109 is a reply to message #586025]

Mon, 03 June 2013 08:09

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>All servers are working fine but one,
Compare & contrast those system that are working fine with the one that is not.

Report message to a moderator

Re: expdp dumpfile owner/group change [message #586114 is a reply to message #586025]

Mon, 03 June 2013 09:35

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!

Report message to a moderator

Previous Topic:	script to check if db is up and exit if it not
Next Topic:	oracle 10g for linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 02:00:12 CST 2025