Forum Discussion

mmeeggaann's avatar
mmeeggaann
Level 5
15 years ago

Netbackup for SAP (restore)

Hi experts!, I'm trying to do SAP QAS refresh from PRD... We make a SAP PRD backup to disk first to have the data available to make restore to SAP QAS (after this is done, we able to copy the...
7.1.x and Earlier
Backup and Recovery
NetBackup
  • Will_Restore's avatar
    Will_Restore
    15 years ago

    Using the SAPDBA utility (NetBackup for SAP on Oracle databases only)

    To restore a partial database or full Oracle database, you must have a list of valid restores. Use the sapdbasystem to maintain the list of restores for specific tablespace or complete database restores.

    When the user restores either individual tablespaces or full databases, the user is prompted before an existing copy of the target file is deleted. sapdbathen invokes the brrestore command.

    brrestore submits the BID and file name list to the NetBackup for SAP backint interface. The backint interface cross-references the exact date and time to when the backup was made and uses NetBackup to recover the file. The backint interface monitors the progress of the restore and reports status back to brrestore.

    Upon completion, the backint interface saves a copy of the NetBackup restore logs for auditing purposes. sapdbathen provides required database recovery, such as media recovery, and restarts the database server.


    ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290217.pdf

     

Will_Restore's avatar
Will_Restore
Level 6
15 years ago

Using the SAPDBA utility (NetBackup for SAP on Oracle databases only)

To restore a partial database or full Oracle database, you must have a list of valid restores. Use the sapdbasystem to maintain the list of restores for specific tablespace or complete database restores.

When the user restores either individual tablespaces or full databases, the user is prompted before an existing copy of the target file is deleted. sapdbathen invokes the brrestore command.

brrestore submits the BID and file name list to the NetBackup for SAP backint interface. The backint interface cross-references the exact date and time to when the backup was made and uses NetBackup to recover the file. The backint interface monitors the progress of the restore and reports status back to brrestore.

Upon completion, the backint interface saves a copy of the NetBackup restore logs for auditing purposes. sapdbathen provides required database recovery, such as media recovery, and restarts the database server.


ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290217.pdf