SAP redo logs restore

[jinxnbu]

Hi 

I am pretty new when it comes to setting up SAP with Netbackup.. We are backing up SAP redo logs using SAP policy type, while trying to perform a restore I found out that SAP restores cannot be done via netbackup console. I want to perform a test restore of files which were backed up couple of days back. How can i get this done ?

I read the admin guide and it gives an example as below 

brrestore -d util_file -b last -m full

I understand the command above restores the last full, but what if i want to restore from a specific date and time ?

Thanks in advance. 

[Nicolai]

You use brrestore -b xxxxxxxx.anf -m full where xxxxxxxx.and is the backup files create by brbackup and located in the sapbackup folder

http://help.sap.com/saphelp_nw70/helpdata/en/46/ce0440a832e369e10000000a155106/content.htm

https://help.sap.com/saphelp_nwpi71/helpdata/en/47/2358a49a59550ee10000000a114a6b/content.htm

Please do all the restore traning you can get away with. It will help the day you need to restore it for real :)

[jinxnbu]

Hi Nicolai,

I went over the link you provided and the various examples shown. 

• brrestore -a 200-220

  Restores the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory

I have the following queries.

1) Is there no way to intiiate the restore from netbackup ? using bprestore ?

2) Even in the above link the examples dont seem to help in a case where I am targetting to retore from a particular date rather than the last full.

Can you please advice on this scenario.

Thanks

[Marianne]

If the backup was done with SAP agent using SAP br commands, you need to restore using SAP commands and utilities.
You cannot use NBU commands for normal filesystem restores.

For SAP and other agent backups, NBU is merely doing scheduling, media management and image catalog.
The DB or Application utilities is used for backups and restores.

You need SAP documentation for your brrestore queries...

[Nicolai · Accepted solution]

1: No. bprestore is for file backups. All database backup is internaly another backup type (proxy backups). Meaning Netbackup has integration with the application running the actual backup, in this case SAP Brtools. Netbackup is just a pipe for sending and reciving data.

2: SAP has a status page of avaiable backups. For each backup there will also be a backup progress file in /oracle/SID/sapbackup. That's the same file you specify while restoring. 

http://help.sap.com/saphelp_nw73/helpdata/en/47/55556a124f458889b8cdd8fa9003b5/content.htm

https://saphowto.wordpress.com/2006/10/15/sap-basis-daily-check-list/