Solved

restore db2 online backup without the log file ?

Posted on 2004-08-07
3
1,105 Views
Last Modified: 2009-12-16
Hi,
   Is there any possible way to restore db2 online backup image without the
log file ? In fact, the database seems to restore successfully but stays in
"roll-forward pending" state. After cancel the rollforward, and it moved to
"restore pending" state.
Thanks !

regards,
kuahkg

0
Comment
Question by:kuahkg
3 Comments
 
LVL 13

Accepted Solution

by:
ghp7000 earned 250 total points
ID: 11752235
if you are missing or dont have the active log file, then I think you need to contact IBM support to be able to restore the database. I don't think the database manager will allow access since it cannot guarantee the consistency of the database.
I have not encountered this problem, but I would try to restore the database with the 'WITHOUT ROLLING FORWARD' clause.
I would also try to rollforward the database the the last known point in time. To find this out, issue
db2 rollforward database <name> query status, but I suspect you will need IBM support.

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now