473,396 Members | 1,683 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,396 software developers and data experts.

Rollforward-1

Hello,

I have a small confuction to rollforward logs after restore

i found thru list history command like this

Backup -1

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20071210035016001 N D S0001062.LOG S0001065.LOG
----------------------------------------------------------------------------
Comment: DB2 BACKUP WPSDBR ONLINE
Start Time: 20071210035016
End Time: 20071210035023
Status: A
----------------------------------------------------------------------------

backup-2

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20071211035017001 N D S0001070.LOG S0001075.LOG
----------------------------------------------------------------------------
Comment: DB2 BACKUP WPSDBR ONLINE
Start Time: 20071211035017
End Time: 20071211035042
Status: A
----------------------------------------------------------------------------

if i want to restore database from backup -1 then
1) which logs need to rollforward ?

if i want to restore database before 2 hours back to from Bakcup-2
in this situation what logs need to apply for rollforward

please give me ur suggestions

Thanks & Regards
Dec 18 '07 #1
0 1356

Sign in to post your reply or Sign up for a free account.

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...
2
by: satish mullapudi | last post by:
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...
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: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.