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

DB2 OFFLINE备份恢复问题

谢谢大家解答我的问题，小弟不胜感激。我做了一个离线备份db2 => backup database mydb to /app_db_p1/fullbk with5 buffers buffer 50 parallelism 3 compress excludelogs without promptingBackup successful. The timestamp for this backup image is: 20150602091946...显示全部

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

我做了一个离线备份

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

查看其它 1 个回答wangzhiqiang77的回答

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备份恢复问题

查看其它 1 个回答wangzhiqiang77的回答

回答者

wangzhiqiang77 最近回答过的问题

回答状态