08-05-2015 08:06 PM
Hi guys,
How do I restore a SAP database from tape library? I've search through internet and didn't get the info that I need.
We are planning to do test restoration from tape tomorrow.
From what I have tried, I open backup, archive and restore console and choose "specify the Netbackup machine and Policy type".
Than select Policy type for restore to SAP with all the correct client source and destination.
I can see all the backup including tape. Under the schedule type I can see User Backup and Full Backup.
For User Backup I can see all folder listed however for Full Backup there is an error "Unable to obtain list of files using specified search criteria".
Is this the correct way to restore from tape? Any script that I need to amend in order to do the restoration?
Thanks
Solved! Go to Solution.
08-06-2015 05:45 AM
You can restore any backup from SAP side, its just a qustion of specifying the right backup ID in SAP.
brrestore -b xxxxxxx.aft -m full
where xxxxxxx.aft is the backup id created by SAP backup (look in the sapbackup directory). Netbackup will via backint retrive the mathing data.
08-06-2015 12:22 AM
I assume you got SAP on Oracle. If not, this reply does not apply
You can't use the GUI to restore SAP databases.
From the sap system you restore using the SAP command : brrestore
See : Symantec NetBackup 7.6 for SAP Administrator's Guide
http://www.symantec.com/docs/DOC6482
Page 82
08-06-2015 12:42 AM
Hi Nicolai,
From the guide, how to determine whether the command trigger restore from tape? because the "last" command indicate that the restore will look for last successfull backup. Last successfull backup should be in the disk not tape.
I want to try restore a month ago backup that is in the tape right now.
Thanks
08-06-2015 01:51 AM
NBU will restore from the primary copy of the backup.
You can use bpimagelist command on the master server to extract a list of image-id's for the SAP client:
bpimagelist -client <name> -pt SAP -d <start-date> -e <end-date> -idonly
To check the amount of copies for the image and the location, use the command for image-id identified above:
bpimagelist -backupid <image-id> -L
You can then promote a copy to primary to restore from.
bpimage: -npc <copy #> -backupid <image-id>
08-06-2015 05:45 AM
You can restore any backup from SAP side, its just a qustion of specifying the right backup ID in SAP.
brrestore -b xxxxxxx.aft -m full
where xxxxxxx.aft is the backup id created by SAP backup (look in the sapbackup directory). Netbackup will via backint retrive the mathing data.
08-11-2015 07:31 PM
Sorry for late update,
After perform the restoration from disk, I've tried using the same method for tape only after I've verify that the backup is already on tape.
When the restoration begin, on the activity monitor I able to see that the restoration is taken from tape with media ID.
Restoration complete successfully without any error.
Thanks guys.
08-11-2015 11:04 PM
Glad to hear - thanks for marking a solution.