软件开发数据库 Db2备份离线备份

DB2 OFFLINE备份恢复问题

谢谢大家解答我的问题，小弟不胜感激。

我做了一个离线备份

db2 => backup database mydb to /app_db_p1/fullbk with5 buffers buffer 50 parallelism 3

compress excludelogs without prompting

Backup successful. The timestamp for this backup image is: 20150602091946

db2 => rollforward database mydb complete <<-----这是什么意思

db2 => rollforward database mydb stop <<-----这是什么意思

db2 => rollforward db mydb to end of backup and stop <<-----这是什么意思

db2 =>
rollforward db mydb to 2015-05-26-xx.xx.xx.000000 using local time and stop <<-----这是什么意思，

主要是这个时间点恢复，我怎么才能查到我的离线备份可以恢复到什么时间点？

这是我归档的history

db2 => list history archive log all for mydb

List History File for mydb

Number of matching file entries = 16

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602022056 1 D S0000000.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602022056

End Time: 20150602080908

Status: A

----------------------------------------------------------------------------

EID: 4 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000000.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602080905 1 D S0000001.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602080905

End Time: 20150602082357

Status: A

----------------------------------------------------------------------------

EID: 5 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000001.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602082356 1 D S0000002.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602082356

End Time: 20150602085039

Status: A

----------------------------------------------------------------------------

EID: 6 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000002.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602082356 N S0000001.LOG

----------------------------------------------------------------------------

Comment: ARCHIVE LOG

Start Time: 20150602082356

End Time: 20150602082356

Status: A

----------------------------------------------------------------------------

EID: 7

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085019 1 D S0000003.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085019

End Time: 20150602085042

Status: A

----------------------------------------------------------------------------

EID: 8 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000003.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085028 1 D S0000004.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085028

End Time: 20150602085542

Status: A

----------------------------------------------------------------------------

EID: 9 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000004.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085511 1 D S0000005.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085511

End Time: 20150602085645

Status: A

----------------------------------------------------------------------------

EID: 10 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000005.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085518 1 D S0000006.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085518

End Time: 20150602085653

Status: A

----------------------------------------------------------------------------

EID: 11 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000006.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085529 1 D S0000007.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085529

End Time: 20150602085654

Status: A

----------------------------------------------------------------------------

EID: 12 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000007.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085614 1 D S0000008.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085614

End Time: 20150602085655

Status: A

----------------------------------------------------------------------------

EID: 13 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000008.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085626 1 D S0000009.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085626

End Time: 20150602085658

Status: A

----------------------------------------------------------------------------

EID: 14 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000009.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602085637 1 D S0000010.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602085637

End Time: 20150602091932

Status: A

----------------------------------------------------------------------------

EID: 15 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000010.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602092256 1 D S0000011.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602092256

End Time: 20150602093625

Status: A

----------------------------------------------------------------------------

EID: 17 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000011.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602093624 1 D S0000012.LOG C0000000

----------------------------------------------------------------------------

Comment:

Start Time: 20150602093624

End Time: 20150602095214

Status: A

----------------------------------------------------------------------------

EID: 18 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000/S0000012.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602102519 1 D S0000011.LOG C0000002

----------------------------------------------------------------------------

Comment:

Start Time: 20150602102519

End Time: 20150602102527

Status: A

----------------------------------------------------------------------------

EID: 24 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000002/S0000011.LOG

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

X D 20150602113046 1 D S0000011.LOG C0000003

----------------------------------------------------------------------------

Comment:

Start Time: 20150602113046

End Time: 20150602113056

Status: A

----------------------------------------------------------------------------

EID: 28 Location: /app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000003/S0000011.LOG

这个是我的备份history

db2 => list history backup all for mydb

List History File for mydb

Number of matching file entries = 6

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

B D 20150602091946001 F D S0000011.LOG S0000011.LOG

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: DB2 BACKUP MYDB OFFLINE

Start Time: 20150602091946

End Time: 20150602091959

Status: A

----------------------------------------------------------------------------

EID: 16 Location: /app_db_p1/fullbk

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

B D 20150602093603001 N D S0000011.LOG S0000011.LOG

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: DB2 BACKUP MYDB ONLINE

Start Time: 20150602093603

End Time: 20150602093626

Status: I

----------------------------------------------------------------------------

EID: 19 Location: /app_db_p1/fullbk

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

R D 20150602095234001 F S0000011.LOG S0000011.LOG 20150602091946

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: RESTORE MYDB NO RF

Start Time: 20150602095234

End Time: 20150602095537

Status: A

----------------------------------------------------------------------------

EID: 20 Location:

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

R D 20150602101236001 F 20150602091946

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: RESTORE MYDB WITH RF

Start Time: 20150602101236

End Time: 20150602101521

Status: A

----------------------------------------------------------------------------

EID: 21 Location:

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

R D 20150602112239001 F 20150602091946

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: RESTORE MYDB WITH RF

Start Time: 20150602112239

End Time: 20150602112532

Status: A

----------------------------------------------------------------------------

EID: 25 Location:

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

R D 20150602114242001 F 20150602091946

----------------------------------------------------------------------------

Contains 4 tablespace(s):

00001 SYSCATSPACE

00002 USERSPACE1

00003 SYSTOOLSPACE

00004 APPTS01

----------------------------------------------------------------------------

Comment: RESTORE MYDB WITH RF

Start Time: 20150602114242

End Time: 20150602114524

Status: A

----------------------------------------------------------------------------

EID: 29 Location:

关注1

参与3

2同行回答
全部行业
全部行业 软件开发 IT咨询服务
|
按赞同排序
按时间排序

新数科技IT顾问北京新数科技有限公司

常用的 rollforward 参数有以下几个：
QUERY STATUS，主要查询数据库当前状态。
STOP，特指 rollforward 完成，这样就不能在执行任何别的 rollforward 操作了，除非重新 restore 然后 rollforward。
CANCEL，取消 rollforward 操作，使进行 rollforward 中的数据库退出 rollforward pending 状态。
POINT IN TIME，rollforward 到某一特定时间点。
END OF LOGS，rollforward 到活动日志的末尾。
ONLINE，使表空间级的 rollforward 在执行时处于 online 状态，允许其他指向数据库的连接。
在分区数据环境中，rollforward 操作必须执行在某个分区上，以下简单进行介绍：
point-in-time rollforward 会在所有的 partition 上执行。
END OF LOGS rollforward，如果有 ON DATABASE PARTITION 参数，rollforward 只在指定 partition 上运行，如果没有指定 partition，那么会在所有 partition 上生效。
end of backup 会影响所有的 partition。收起

IT咨询服务 · 2015-06-03

wangzhiqiang77软件开发工程师北京文德

db2 => rollforward db mydb to 2015-06-02-09.52.14.000000 using local time and stop overflow log path("/app_db_p1/archivelog/db2inst1/MYDB/NODE0000/LOGSTREAM0000/C0000000")
SQL4970N Rollforward recovery stopped on the database named "MYDB" because
the rollforward utility cannot reach the specified stop point (end-of-log or
point-in-time) on the following database partitions: "0".

日志我是有的。为什么还报到达不了指定的时间点收起

软件开发 · 2015-06-03

DB2 OFFLINE备份恢复问题

2同行回答
全部行业
全部行业 软件开发 IT咨询服务
|
按赞同排序
按时间排序

提问者

相关问题

相关资料

相关文章

问题状态

DB2 OFFLINE备份恢复问题

2同行回答全部行业全部行业软件开发IT咨询服务|按赞同排序按时间排序

提问者

相关问题

相关资料

相关文章

问题状态

2同行回答
全部行业
全部行业软件开发 IT咨询服务
|
按赞同排序
按时间排序