473,322 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

ROLLFORWARD failed

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
Jun 27 '08 #1
2 1783
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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Jun 27 '08 #2
On Apr 29, 5:15 pm, Gregor Kovac( <gregor.ko...@mikropis.siwrote:
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.
Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Raquel | last post by:
I have asked a similar question before, but am still not very clear on this......expecting some insights on this one.... Ok, so these are the two pieces of information regarding archived logs...
1
by: Steven | last post by:
Ok W2K DB2 v8.1 fix pack 5. On production I took a an online backup of production and copied it over to my staging environment. restored the production database on top of staging database...
1
by: Juan Norton | last post by:
Got DB2 v8.2 WUE -Machine A runnig XP -Machine B " 2003 server I have the following error trying to do a hand rollforward on machice B: db2 => rollforward database BD to end of logs...
2
by: shenanwei | last post by:
DB2 V8.1.5 on Windows. When I execute ROLLFORWARD after a Restore. C:\db2 ROLLFORWARD db sample to END OF LOGS overflow log path(C:\LOGS\) Rollforward Status Input database alias ...
3
by: t2581 | last post by:
Hi , I run restore with rollforward In job in output, last commited transaction time less then backup image time Is it normal ? RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT...
3
by: t2581 | last post by:
Hi, we are daily restore db "PRICE" with rollforward from server A into PRICE on server B Usually we restore from backup with timestamp of ~ 02:00 AM and applying logs till 7 AM (30-50...
3
by: jadionne | last post by:
I am doing a rollforward and want to query the status of the rollforward. I issue the command: DB2 Rollforward database namdwh query status. I get the following error: C:\Documents and...
3
by: EC | last post by:
We have two DB2 servers are supposed to be a replicate of each other with a database of the same name. I want to do a 'db2 db backup online... include logs' on the first server, and do a 'db2...
0
by: shorti | last post by:
We are running DB2 UDB 8.1 fp 14 on AIX using archival logging and online backups. I was running some disaster tests and found my database restore was not restoring to the latest active log. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.