By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Rollforward-1

P: 3
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
Share this question for a faster answer!
Share on Google+

Post your reply

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