shellscripting question

jigarlakhani · November 14, 2005, 2:02pm

I have been �commissioned� to write a shellscript to automate Oracle cold refeshes.. right now we perform about 20 refresh each 300gb in size which takes up our time. my goal is to write a shellscript which can be executed by a user on serverA to refresh any of the 7 databases on ServerA. I am trying to figure out how to tell the script how based on SID that is passed with the script how to figure out which mountpoints/directories are owned by that sid?

any ideas?

mschwage · November 15, 2005, 11:37pm

find /path -xdev -user ID -print

(Not sure what an SID is, I assume it's related to a UNIX UID, which is the ID in the find command above).

jigarlakhani · November 16, 2005, 2:50pm

actually Sid is an Oracle_SID.. A databasename.

dangral · November 16, 2005, 3:16pm

Are you saying that you have a unix user for each SID?

mschwage · November 16, 2005, 3:32pm

Objects (directories and files) in the UNIX filesystem are owned by UID's. If you want to find anything in them, you need to have a mapping between SID's and UID's somewhere.