how point-in-time recovery

Posted by Pawan at June 17. 2008

Hi All,
Hope everyone is doing great as usual.

Is there anyone who did point-in-time recovery of database.
Please provide the steps for doing this?
Its must to know for me .....I am working with Bank thats.

Please reply ASAP

Thanks
Pawan

Re: how point-in-time recovery

Posted by Pawan at June 18. 2008

I read the IBM manual and did accordingly but not able to find desired output

I followed the below steps....

db2 backup database test online to /home/backup/ include logs
db2 restore database test from /home/backup/ into tltest without prompting

and then move the logs of test db to log path of tltest db,then

rollforward database tltest to 2008-06-12-22.30.56.000000 and complete

on executing below command facing below error

SQL1275N The stoptime passed to roll-forward must be greater than or equal to
"2008-06-17-17.00.15.000000", because database "TLTEST" on node(s) "0"
contains information later than the specified time.

when I execute below command ...its run successfully

rollforward database tltest to 2008-06-17-17.00.15.000000 and complete

but I want to data recovery till 2008-06-12-22.30.56.000000 or till perticular time in day??How I can do this?
What I need to follow ?

__________________
Regards
Pawan Kumar

Re: how point-in-time recovery

Posted by DB2 Specialist at June 19. 2008

Use RECOVER DATABASE command, in order to avoid these confusions.

Note: Recover Database command is an addition to v8

Re: how point-in-time recovery

Posted by Pawan at June 19. 2008

Can you tell me how to?

Re: how point-in-time recovery

Posted by perallis at April 22. 2009

To use recover command see the link below:

Using RECOVER command inspite of RESTORE and ROLLFORWARD command

DBA to DBA

Personal tools

Document Actions

how point-in-time recovery