Forum Discussion

PQuicken's avatar
PQuicken
Level 3
14 years ago

Restore SAP Backups using RMAN

Hi   we are trying to do a desaster recovery test for SAP on Oracle. After having done successful backups the sap admin tries to recover the oracle database based on the backups we did with the b...
  • Nicolai's avatar
    14 years ago

    There is a difference in policy type using Oracle RMAN or SAP RMAN. Oracle is using type 4 and SAP uses type 17. Make sure you use SAP brtools or RMAN, but don't mix them. If you do a bpimagelist of the object in question field 8 of the IMAGE line will show you the recorded client type.

    http://www.symantec.com/docs/TECH5584

    Update:

    Also set the Netbackup variables when restoring using brtools:

    setenv NB_ORA_SAP=dummy   (force client type 17)
    setenv SAP_CLIENT={client}
    setenv NB_ORA_CLIENT={client}

     init{SID}.sap   
        backup_dev_type = rman_util
        rman_filesperset = 64
        rman_parms = "BLKSIZE=65536 ENV=(NB_ORA_SAP=dummy, SAP_CLIENT={client}, NB_ORA_CLIENT={client})"
        util_par_file = init{SID}.utl