日志文件被删除的恢复sql4970n

来源：互联网发布：开淘宝店怎么注册视频编辑：程序博客网时间：2024/06/05 06:15

1.有一个包括日志的备份。
2.将该备份里面的日志恢复出来。
db2 restore db zhouhuan logs from /opt/db2backup/ taken at 20100424162148 logtarget /opt/db2backup/
3.查询该备份文件
[db2inst1@oracle db2backup]$ db2ckbkp -h ZHOUHUAN.0.db2inst1.NODE0000.CATN0000.20100424162148.001

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- ZHOUHUAN
Server Database Alias -- ZHOUHUAN
Client Database Alias -- ZHOUHUAN
Timestamp -- 20100424162148
Database Partition Number -- 0
Instance -- db2inst1
Sequence Number -- 1
Release ID -- D00
Database Seed -- 7C172526
DB Comment's Codepage (Volume) -- 0
DB Comment (Volume) --
DB Comment's Codepage (System) -- 0
DB Comment (System) --
Authentication Value -- -1
Backup Mode -- 1
Includes Logs -- 1
Compression -- 1
Backup Type -- 0
Backup Gran. -- 16
Status Flags -- 21
System Cats inc -- 1
Catalog Partition Number -- 0
DB Codeset -- UTF-8
DB Territory --
LogID -- 1272095572
LogPath -- /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Backup Buffer Size -- 1572864
Number of Sessions -- 1
Platform. -- 12

The proper image file name would be:
ZHOUHUAN.0.db2inst1.NODE0000.CATN0000.20100424162148.001

[1] Buffers processed: ####

Image Verification Complete - successful.

查看LOGPATH一行，然后把恢复出来的日志文件放到里面去。

4.恢复数据库
db2 restore db zhouhuan incremental automatic from /opt/db2backup/ taken at 20100424162148

5.前滚数据库
db2 rollforward db zhouhuan to end of logs and complete

0 0