Mekkalki
15 years agoLevel 4
Rman database duplication failed on same server with different oracle home.
Hi,
We have netbackup 6.5 server software installed on windows 2003 machine and netbackup 6.5 client + oracle agent installed on unix 11.23 v2 .
On unix client we are able to take database ...
- 15 years agoYes, the oracle user doing the restore has to be the same as the user that performed the backup.
See TechNote mentioned previously:
http://seer.entsupport.symantec.com/docs/241957.htm
5. The name of the Oracle user on the alternate client has to be the same as on the source client. (THIS IS VERY IMPORTANT).Regarding point 5 and having different oracle users:In the normal Oracle configuration, the Oracle binary has the SetUID attribute (chmod 4751 or 6751).
It is possible is to take off the SetUID and create the same UNIX account as on the "Source Client". Start Oracle as this "Source" Oracle user and perform the restore in that way. There are several problems to navigate (access to data directories, audit directories
and dump directories), but it does work (it makes things easier if both users have the same group ID).After the restore is complete, the file permissions should be checked (or ownership changed) before restarting the instance as the "Target" Oracle user.