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 without rolling forward

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Apr 2009
Posts: 23
Restore without rolling forward

DB2 v9.1

I've done a offline backup and now want to restore the datbase, without rolling forward the logs.

This is what I'm doing:
db2 restore db <database> from . taken at 20090330133907 replace existing without rolling forward

Message received:
SQL2537N Roll-forward is required following the Restore.

Why would I need to do a rollforward with a offline backup? Or is there another way to do this?

Thank you.

Reply With Quote
  #2 (permalink)  
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,398
It just means that the backup taken at 20090330133907 was not an offline backup. You can verify that by issuing an appropriate LIST HISTORY command or running db2ckbkp.
"It does not work" is not a valid problem statement.
Reply With Quote
  #3 (permalink)  
Registered User
Join Date: Oct 2004
Posts: 268

db2 "rollforward db <database> complete"
Reply With Quote
  #4 (permalink)  
Registered User
Join Date: Dec 2008
Posts: 76
Can't tell you why, but even an offline backup of a database configured for recovery logging must be rolled forward. If the database had circular logging it wouldn't require it.

db2 rollforward db <database> to end of backup and complete

will get the job done.
Reply With Quote

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