SEO

#1 (**permalink**) 04-29-2008, 08:26 PM

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

#2 (**permalink**) 04-29-2008, 08:26 PM

Hi!

You can do a rollforward to some point in time, for example.
You can see more at
http://publib.boulder.ibm.com/infoce.../r0001978.html

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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

#3 (**permalink**) 05-07-2008, 10:15 AM

On Apr 29, 5:15 pm, Gregor Kovac( <gregor.ko...@mikropis.si> 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

ROLLFORWARD failed