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.

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.

15 Replies

Sort By
Show More
  • Marianne's avatar
    Marianne
    Level 6
    15 years ago
    I don't understand why bplist on master server works fine but not from client. Same status 227 appears in bprd log.

    ONE more thing to check, are you attempting the restore as exactly the same user that performed the backup?

    See point 5 in this TechNote (ignore the redirected client restore) about oracle user:
    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.


    If the user is the same, I'm officially out of ideas. Hopefully someone else on the list has a solution.
    If not, your only option is to log a call with Symantec Support. 
  • Mekkalki's avatar
    Mekkalki
    Level 4
    15 years ago
    Hi,

    Sorry, we tried to run bplist command from different oracle user where we want to restore.
    Please find below output of bplist command from oracle user where we have taken rman backups
    ----------------------------------------------------------------------------------------------------------------------------------------------
    oradev@kdddev2:/usr/openv/netbackup/bin>bplist -C kdddev2 -t 4 -R /
    /cfc-3787241056-20100310-01_DEV
    /5sl884j3_1_1
    /cfc-3787241056-20100310-00_DEV
    /dfcon_DEV_5pl87v55_185_1.bak
    /dfcon_DEV_5ql87v56_186_1.bak
    /cfc-3787241056-20100309-02_DEV
    /cfc-3787241056-20100309-01_DEV
    /cfc-3787241056-20100309-00_DEV
    /5kl84s9c_1_2
    /5hl84gbo_1_2
    /5il84gbp_1_2
    /cfc-3787241056-20100308-02_DEV
    /5cl81pbd_1_2
    /5bl81pbc_1_2
    /cfc-3787241056-20100308-01_DEV
    /cfc-3787241056-20100308-00_DEV
    /5el8252q_1_2
    oradev@kdddev2:/usr/openv/netbackup/bin>
    ----------------------------------------------------------------------------------------------------------------------------------------------
    If you notice :\ is not there at the end of file name.

    ONE more thing to check, are you attempting the restore as exactly the same user that performed the backup?
    --- No, oracle users are different.

    Is it possible to do with diffierent user ? or oracle users should be same ?

    For restore operation we are conecting to rman catlog & target(i.e source database from we have taken backup) database & then auxiliary database (i.e where we want restore database) . All this command we are running from different oracle home where we want to restore.

    Is it required to run  rman database duplication command from oracle user where we have taken database backup?

    please advice,
    Mekkalki.
  • Marianne's avatar
    Marianne
    Level 6
    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.

  • Mekkalki's avatar
    Mekkalki
    Level 4
    15 years ago
    Hi,

    Thanks for update.

    It seems limitation with RMAN & netbackup that oracle user should be the same for oracle database clonning. because we have number of oracle instances which we are using for different purpose so keeping same user(i.e production server oracle user name for all servers & oracle instances it is not feasible) for all instances. And our requirement is to clone different oracle instances with production database which is having different oracle user.

    Is there any way or workaround to do backup from one oracle user & restore database with other oracle user ?

    Point 5 from http://seer.entsupport.symantec.com/docs/241957.htm note is confusing is it the workaround to restore as different oracle user ?
    or something else that we could not understand.

    Please can you explain.

    & if it is the workaround for restore as different user please give us steps to do that.

    Please advice,
    Mekkalki.
  • Marianne's avatar
    Marianne
    Level 6
    15 years ago
    You will have to give the TechNote to the System Adminitrator on the HP-UX server.
    As the restore will have to be done as the same user name that did the backup, the O/S admin will have to grant all the necessary permissions to allow access to files and folders on the taget database.
    Once the database can be started as the same user that did the backup, you should be able to perform the restore.
    Permissions will have to be changed to the new oracle user after the restore has completed successfully.