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 > restore database with logs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-24-09, 10:11
homer15 homer15 is offline
Registered User
 
Join Date: Jun 2009
Posts: 3
restore database with logs

i'm trying to restore an offline backup and i have the log files from the period since the backup was taken. when i point the restore wizard to the place where i have the logs saved, it gives me an error saying it can't extract the logfiles.

is there a specific structure the logs should have? right now i just have them saved in a directory called db2logs.
Reply With Quote
  #2 (permalink)  
Old 06-24-09, 11:04
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Sounds like your backup image contains logs as well. If that is the case, make sure that that directory is empty as it will extract those logs there by itself.

In the future it would be helpful if you have identified your OS, dblevel, what command you ran exactly and an exact error message.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #3 (permalink)  
Old 06-24-09, 11:05
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Offline backups cannot contain logs. Only online backups can.

Andy
Reply With Quote
  #4 (permalink)  
Old 06-24-09, 11:08
homer15 homer15 is offline
Registered User
 
Join Date: Jun 2009
Posts: 3
this backup is an offline backup, so no logs are really needed.
if i restore it, will i be able to roll through the logs that i have archived?

it's a windows 2003 server, db2 8.1 fp 16. i used the restore wizard to do this.
Reply With Quote
  #5 (permalink)  
Old 06-24-09, 11:13
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Quote:
Originally Posted by ARWinner
Offline backups cannot contain logs. Only online backups can.

Andy
Right, I need to read and not speed read. Thank you.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #6 (permalink)  
Old 06-24-09, 11:13
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
If the RESTORE command does NOT contain the clause "WITHOUT ROLLING FORWARD", then you should be able to rollforward through the logs. I have never tried this, but it looks like it should work.

Andy
Reply With Quote
  #7 (permalink)  
Old 06-24-09, 11:26
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
If you are using wizard, what options are you selecting (have never used wizard before) What is the exact error message
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #8 (permalink)  
Old 06-24-09, 12:00
homer15 homer15 is offline
Registered User
 
Join Date: Jun 2009
Posts: 3
sorry, i don't have the error. i tried it without restoring the logs, and then just rolled forward through them and it worked fine. thanks.
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