How to restore a on-line backup to a different SID?

[Former Member]

We have a on-line backup of DEV.

We want to rstore it to another instance called TST.

We have a procedure for this on Oracle but not useful.

Would you please share your experience?

Thanks!

[Former Member · Accepted solution]

Hi Jennifer,

you have to use the tool brdb6brt to create a script for your redirected restore.

create script:

brdb6brt -bm retrieve - replace QSID=ZSID

(has to be modified: e.g. path,...)

check restore script and fs:

brdb6brt -bm CHECK -ip <scriptname>

start restore:

db2 -tvf xxx.scr

...you can find detailed information at:

- http://service.sap.com/instguides

- select product

- installation

- system copy for ...

regards

Sascha

[Former Member · Accepted solution]

Sascha:

Thanks!

How about a cold (offline) backup from the source?

Thanks !

[Former Member · Accepted solution]

I know how it works on oracle, maxdb and mssql, but I it won't work on db2...or I don't know how.

The backup (also the offline backup) only saves the content and the configuration of the database, not the files. While restoring, the files are generated, the db is registered at the dbm,...

It's the easier way to use the scripts above.

I also like oracle better

Regards,

Sascha

[Former Member]

Hi Jennifer

see the recovery procedures described in

DB2 Version 9 for Linux, UNIX, and Windows

<a href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/db2hae90.pdf">Data Recovery and High Availability Guide and Reference</a>

Using program

brdb6brt

is the proper procedure for performing your redirected restore .

An offline backup works as well .

Best regards

dirk