Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: ROLLFORWARD...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 8835 of 9520
Post > Topic >>

Re: ROLLFORWARD failed

by satish mullapudi <satishmullapudi84@[EMAIL PROTECTED] > May 5, 2008 at 07:01 AM

On Apr 29, 5:15 pm, Gregor Kovac( <gregor.ko...@[EMAIL PROTECTED]
> wrote:
> Hi!
>
> You can do a rollforward to some point in time, for example.
> You can see more
athttp://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=...
>
> If you have 100 logs and your 45th is corrupted, then none from that one
> will be used, because if it was DB2 can not guarantee you that the
> database is in consistent state.
>
> Best regards,
>         Kovi
>
> satish mullapudi pravi:
>
> > Hi,
> > Am facing a tough situation & the scenario goes like this:
> > I have scheduled online backup on a db. The online backup is scheduled
> > to run daily at 12 in the night. Now am to restore the same db in
> > another server . I have with me the backup image & 50 logs which I
> > need to rollforward. When am trying to restore it is working fine &
> > the db goes into ROLLFORWARD PENDING state as expected. When am trying
> > to ROLLFORWARD the db, it is saying that the 45th log is corrupted, so
> > rollforward operation failed. Now, is there any process, so that I can
> > restore the maximum amount of data as much as possible from the logs.
>
> > Pls help me out...
>
> > satish
>
> --
> ____________________________
> |http://kovica.blogspot.com|
> -----------------------------~-~-~-~-~-~-~-~-~-~-
> |  In A World Without Fences Who Needs Gates?   |
> |              Experience Linux.                |
> -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Yupes...that ight work but I still have a small query here. How to
know the timestamp from where to ROLLFORWARD so as to get the data in
1to 45th logs.
 




 3 Posts in Topic:
ROLLFORWARD failed
satish mullapudi <sati  2008-04-29 02:21:06 
Re: ROLLFORWARD failed
=?ISO-8859-1?Q?Gregor_Kov  2008-04-29 14:15:51 
Re: ROLLFORWARD failed
satish mullapudi <sati  2008-05-05 07:01:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 21:23:47 CST 2008.