日志文件被删除的恢复sql4970n

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