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 rman backup on tape & restore in same database.

But when we are tring to duplicate database with other instance (which is on same server but in different oracle home) using rman. We are getting  following error.
========================================================
ORA-19870: error reading backup piece dfcon_DEV_5ql87v56_186_1.bak
ORA-19507: failed to retrieve sequential file, handle="dfcon_DEV_5ql87v56_186_1.bak", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <dfcon_DEV_5ql87v56_186_1.bak> not found in NetBackup catalog
=========================================================

Please note since it is on same server we have software installed for netbackup client & oracle agent. We have done "oracle linking with veritas" for new oracle home.

Please advice,
Mekkalki.

  • 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.

15 Replies