Backup restoration

[Former Member]

Hi,   We have here SAP ECC6.0 EHP on Windows 2008r2, Daily we taking Backup via DB13 as Scheduled.   Now we are in planning to Verify the Taken Backups are in Good Condition.   For That We have Installed New Server With Win2k8 r2 and SAP too.

Want to know further restoration steps, Please suggest.

[former_member264034 · Accepted solution]

Hi,

Please review the system copy guide for restore procedures(Page 62 IBM DB2 LUW specific)

(Page 64.Restore your database)

https://service.sap.com/~sapidb/011000358700000887092012E

Kind Regards,
Aidan

[Former Member · Accepted solution]

Hi Aidan,

Your shared Guide is Very much useful, thanks for revert.

[former_member182505 · Accepted solution]

HI Swapz,

There are to case to restore

1- On the same SID

2- On different SID

Let Us know your plan for restore so we will help you,

Thanks

Sadiq

[Former Member · Accepted solution]

Hi Sadiq,

We have Production system with SID PRO and the test systems SID is PR1.

We have daily backup file and the logs too. want to restore this Backup on Different System which has Same Operating System.

Only SID is Different ! Please suggest the steps. 

[former_member182505 · Accepted solution]

HI Swapz

Please fallow the standard system copy guide for DB2 ,

On that check the redirect restore method , below link will also help you,

Redirected Restore Tool - BC R/3 Database Guide: DB2 Universal Database for UNIX & Windows -...

http://www.ibm.com/developerworks/data/library/techarticle/dm-0911sapdb2redirectedrestore/

Note 122222 - DB2 UDB: Redirected Restore via DB2 CLP

Check and let us know if you face any issue

Thanks

Sadiq 

[Former Member · Accepted solution]

Hi Sadiq,

in your shared link syntax are not seems properly...

it  looks like -- S##############################

[former_member182505 · Accepted solution]

Hi

you can google Redirected Restore, and you will get the link,

from Service market place download the system copy guide

Thanks

Sadiq

[Former Member · Accepted solution]

Hi Sadiq,

I have downloaded the Guide from shared Service Market Place.

After reading some pages I have a query, My Test Server should be installed first and then restoration step has to be done ? OR While installing (SAP) a test Server I can Provide Taken backup ?

Please Suggest the Steps.

[former_member182505 · Accepted solution]

Hi swapz

Start installation using sapinst and chose system copy option , it will ask you to use backup/restore method

But before you have to generate redirect restore script on the source system which will be used for restore 

Thanks

Sadiq

[Former Member · Accepted solution]

Hi Sadiq,

We have generated Redirect Restore Script on Production system.

What content has to be Edited ? to run this script on Newly Installed SAP System.

Please suggest.