Forum Discussion

Mekkalki's avatar
Mekkalki
Level 4
15 years ago

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 ...
7.1.x and Earlier
Backup and Recovery
NetBackup
  • Marianne's avatar
    Marianne
    15 years ago
    Yes, 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.

Marianne's avatar
Marianne
Level 6
15 years ago
Problem in dbclient log:
Backup file <5cl81pbd_1_2> not found in NetBackup catalog

I can see in the dbclient log that the client name is kdddev2 - the same name that was used for the backup (output of bplist).
I can also see that the required image 5cl81pbd_1_2 does indeed show up in the bplist output:
5cl81pbd_1_2:\

The error 'not found in NetBackup catalog' was returned by bprd & bpdbm on the master server. We now need to see the bprd log on the master server for the same period (12:16 - 12:17). This will tell us how the master server is interpreting the restore request.

Please find and post the section in bprd log from the time that the incoming request is received from client's IP address.