If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > recoverying a database to an early point of time not working

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-10, 02:57
shoujs shoujs is offline
Registered User
 
Join Date: Dec 2010
Posts: 1
recoverying a database to an early point of time not working

hi all,
I did these steps in my test envrionment:
1) db2 backup db sample online to d:\db_backup include logs
// the image is 20101217152834
// the log s***12.log is included in the image.
2) db2 insert into test values(‘abc’, 20)
3) db2 restored db sample from d:\db_backup taken at 20101217152834 logtarget d:\temp
//the log s***12.log is extracted to the d:\temp
4) db2 rollforward db sample to 2010-12-17-15.00.00 overflow log path (d:\temp) and stop

then I tested the restored db. I find the new record ('abc', 20) is stored in the test. I suppose this record is removed after a restore operation.
I find the s***12.log and the current active log s***13.log is processed for in the restore operation.

I just want it process the included log and restore back to an early point of time? Any suggestions why it does not work?
byt i am using db2 v8.1
Reply With Quote
  #2 (permalink)  
Old 12-17-10, 08:02
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
The ROLLFORWARD command assumes the timestamp is in UTC, unless you specify USING LOCAL TIME.
Reply With Quote
  #3 (permalink)  
Old 12-18-10, 21:57
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by shoujs View Post
I just want it process the included log
The time is in UTC as n_i said or you can do:

3) db2 restored db sample from d:\db_backup taken at 20101217152834 logtarget d:\temp
3a) remove all logs from the active log dir (move them somewhere else or delete if they're not needed)
4) db2 rollforward db sample to end of logs overflow log path (d:\temp) and stop
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On