Forum Discussion

GvdW's avatar
GvdW
Level 2
10 years ago
Solved

SAP redirected database restore using brrestore/rman_util failing

We are trying to restore the backup of an SAP Oracle database on an alternative client. The backups are made through brtools using the rman_util option.

I followed the directions for mentioned in the Netbackup SAP guide. I'm able to list the backup images using bplist and restores of the control-file through backint works. But when we want to restore the datafiles through rman we get the following errors:

channel sbt_1: ORA-19870: error while restoring backup piece HC2_beqfhgua.16701_1
ORA-19507: failed to retrieve sequential file, handle="HC2_beqfhgua.16701_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

The restore job is visible on the media-server and failed with error-code 2811 and the following information:

08.04.2015 14:35:10 - begin Restore
08.04.2015 14:35:11 - restoring image IMAGENAME
08.04.2015 14:35:11 - requesting resource @aaaab
08.04.2015 14:35:12 - Info bprd(pid=9188) Restoring from copy 1 of image created 04/05/15 00:12:00 from policy SAP_HPUX_DB_ONLINE
08.04.2015 14:35:12 - granted resource MediaID=@aaaab;DiskVolume=PureDiskVolume;DiskPool=DP-p02bck-Dedup;Path=PureDiskVolume;StorageServer=nb-servername;MediaServer=nb-servername
08.04.2015 14:35:14 - Error bpbrm(pid=8816) bpcd on hc2db00.domain.name exited with status 39: client name mismatch   
08.04.2015 14:35:14 - Info tar32(pid=0) done. status: 39: client name mismatch       
08.04.2015 14:35:14 - Error bpbrm(pid=8816) client restore EXIT STATUS 39: client name mismatch     
08.04.2015 14:35:15 - restored image IMAGENAME - (client name mismatch(39)); restore time 0:00:04
08.04.2015 14:35:17 - end Restore; elapsed time: 0:00:07
SAP policy restore error(2811)

Found technote TECH193578, but this one is telling me that it only works for file_util, not rman_util.

7.5
Agent for SAP Applications
Backup and Recovery
HP-UX
NetBackup
Restore
  • GvdW's avatar
    GvdW
    10 years ago

    We found the solution for this problem.

    We had to set the env variable SAP_CLIENT to the source client. We assumed this was not needed, because it was also set in the initSID.utl and initSID.sap files.
    When this env variable was set, the restore continued without any problems.

  • Mr_Zimmerman's avatar
    Mr_Zimmerman
    Level 3
    10 years ago

    Hi GdvW,

    Is a standard file restore from the same soruce client to the same destination client working or does that aslo produce an error code 39?

  • GvdW's avatar
    GvdW
    Level 2
    10 years ago

    Standard file restores are working and a restore of the controlfile through backint is also working.

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    But when we want to restore the datafiles through rman .....

    If the policy to backup the data was SAP policy, you cannot use rman to restore.

    Same utility used for backup must be used for restore.

  • GvdW's avatar
    GvdW
    Level 2
    10 years ago

    @Marianne

    We didn't use rman itself, but rman was used from the SAP BRTools. I know you cannot use rman directly, because the backuptype is different.

  • GvdW's avatar
    GvdW
    Level 2
    10 years ago

    We found the solution for this problem.

    We had to set the env variable SAP_CLIENT to the source client. We assumed this was not needed, because it was also set in the initSID.utl and initSID.sap files.
    When this env variable was set, the restore continued without any problems.