DB2 Restore Issue

[Former Member]

Hello all,

Iam building a new system with Backup-restore method. Source SID and target SID are different. The steps that I performed for this are as below,

1.Online backup of Source system

2.Installed a new SAP system (Now in restore backup phase)

3.I restored the DB as per the command mentioned below,

Source SID: SD1 Target SID - SD2

RESTORE DATABASE SD1 from D:\DB2backup ON D:\db2\SD2\sapdata1, D:\db2\SD2\sapdata2,D:\db2\SD2\sapdata3, D:\db2\SD2\sapdata4, D:\db2\SD2\sapdata5, D:\db2\SD2\sapdata6, D:\db2\SD2\sapdata7, D:\db2\SD2\sapdata8  INTO SD2 NEWLOGPATH D:\db2\SD2\log_dir\NODE0000\

4.After a hour, restore completed successfully

5.After this I have applied the archive logs to get the database out from Roll-forward pending state, from command,

db2 rollforward db SD2 to end of logs and complete

6.Roll forward is not yet completed, now it says,

Input Database Alias                              : SD2

No of nodes  have returned  status           :1

Node number                                         : 0

Rollforward status                                    : DB working

Next log file to be read                             : S0147920.log

Log files processed                                   : S0147842.log - S0147896.log

Last committed transaction                         : 2013-11-23-02.14.27.000000 UTC

NOTE: Log files present in the directory are S0147842.log to S0147920.log

Also I have put the logs passed the above committed transaction time.

Kindly advise,

Thanks,

Regards,

Irfan

[hugo_amo · Accepted solution]

Hi Irfan,

For the use of the rollforward command, have a look at this document:

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

The time needed for a rollforward depends on their location (if they are on type or on disk) and the number of them. So, it could take a while.

Regards,

hugo

[Former Member]

Thanks all. Managed to restore with re-direct restore method:)

[former_member182505]

Hi  Irfan

As you are restoring on diffrant system

have you used redirect restore method?

Thanks

Sadiq

[Former Member]

Yes Sadiq, am restoring in a different system.

No am not using the redirect restore method.

Just used the above said commands.Are the commands fine?

Thanks,

Regards,

Irfan

[former_member182505]

Hi Irfan

That is the issue . on SAP DB2 whenever we doing in different SID we are using redirect restore method .

So you have to use the same.

check the system copy guide and below link.

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

Thanks

Sadiq