Forum Discussion

kkhoo's avatar
kkhoo
Level 5
9 years ago

DB backup test restore exercise

hi gurus, need your advise what is the approach when doing test restore on db backup.. thanks.
7.6
Backup and Recovery
Linux
NetBackup
  • Marianne's avatar
    Marianne
    9 years ago

    There is no documented 'correct approach'.

    This is my approach:

    The dba/server team will need to ensure that a suitable test machine exists with correct specs and OS, Oracle and NBU client software installed and oracle linking done. 
    Ensure comms are working correctly between master, media and test machine. 
    Run test Oracle backup to ensure everything is working correctly as far as Oracle and NBU config and comms are concerned.

    Oracle redirected restore needs you to enable alternate client restore on the master with altnames files (see manual) and for the dba to initiate the restore using source client name.
    See  NetBackup for Oracle Administrator's Guide  for detailed instructions.

kkhoo's avatar
kkhoo
Level 5
9 years ago

Hi michael,

thanks for your reply.

actually, the test restore is to check the integrity of our db backup.

oracle database. and yes, our intent is to setup an alternate client.

but my question is what is the correct approach? thanks again