清理DB2的归档日志

页面导航:首页 > 数据库 > DB2 > 清理DB2的归档日志

清理DB2的归档日志

来源: 作者: 时间:2016-01-23 11:15 【

DB2归档日志的相关信息保存在恢复历史文件中,可以通过 db2 list history [email protected]:~ db2 list history archive log all for ggyyList History File for ggyyNumber of ma...

DB2归档日志的相关信息保存在恢复历史文件中,可以通过 db2 list history 命令查看。 
 
[email protected]:~> db2 list history archive log all for ggyy 
 
List History File for ggyy 
 
Number of matching file entries = 6 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235553 1 D S0000038.LOG C0000007 
---------------------------------------------------------------------------- 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100103235553 
End Time: 20100103235553 
Status: A   www.2cto.com  
---------------------------------------------------------------------------- 
EID: 80 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000038.LOG 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235553 N S0000038.LOG 
---------------------------------------------------------------------------- 
---------------------------------------------------------------------------- 
Comment: ARCHIVE LOG 
Start Time: 20100103235553 
End Time: 20100103235553 
Status: A 
---------------------------------------------------------------------------- 
EID: 81 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235608 1 D S0000039.LOG C0000007 
---------------------------------------------------------------------------- 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100103235608 
End Time: 20100103235608 
Status: A 
---------------------------------------------------------------------------- 
EID: 82 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000039.LOG 
 
...... 
 
清除这些信息,需要使用 db2 prune history 命令。该命令会清除指定时间戳及之前的所有条目(不只是归档日志的)。默认情况下,系统不会清除最近一次全备之后的归档日志信息。 
 
[email protected]:~> db2 prune history 20100103235553 
SQL1024N A database connection does not exist. SQLSTATE=00000 
[email protected]:~> db2 connect to ggyy   www.2cto.com  
 
Database Connection Information 
 
Database server = /LINUX 9.7.0 
SQL authorization ID = DB2INST1 
Local database alias = GGYY 
 
[email protected]:~> db2 prune history 20100103235553 
DB20000I The PRUNE command completed successfully. 
[email protected]:~> db2 list history archive log all for ggyy | head -20 
 
List History File for ggyy 
 
Number of matching file entries = 6 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235553 1 D S0000038.LOG C0000007 
---------------------------------------------------------------------------- 
 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100103235553 
End Time: 20100103235553 
Status: A 
---------------------------------------------------------------------------- 
EID: 80 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000038.LOG 
 
[email protected]:~> db2 list history backup all for ggyy 
 
List History File for ggyy 
 
Number of matching file entries = 0 
 
对数据库进行一次全备,再次尝试清除: 
 
[email protected]:~> db2 backup db ggyy online to /data/backup 
 
Backup successful. The timestamp for this backup image is : 20100104004121 
 
[email protected]:~> db2 connect to ggyy   www.2cto.com  
 
Database Connection Information 
 
Database server = DB2/LINUX 9.7.0 
SQL authorization ID = DB2INST1 
Local database alias = GGYY 
 
[email protected]:~> db2 prune history 20100103235553 
DB20000I The PRUNE command completed successfully. 
[email protected]:~> db2 list history archive log all for ggyy | head -20 
 
List History File for ggyy 
 
Number of matching file entries = 5 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235608 1 D S0000039.LOG C0000007 
---------------------------------------------------------------------------- 
 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100103235608 
End Time: 20100103235608 
Status: A 
---------------------------------------------------------------------------- 
EID: 82 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000039.LOG 
 
通过使用 and delete 参数,可以在清理条目的同时删除对应的归档日志文件。 
 
[email protected]:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007 
total 48 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:56 S0000039.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:56 S0000040.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-04 00:41 S0000041.LOG 
[email protected]:~> db2 prune history 20100103235608 and delete 
DB20000I The PRUNE command completed successfully.   www.2cto.com  
[email protected]:~> db2 list history archive log all for ggyy | head -20 
 
List History File for ggyy 
 
Number of matching file entries = 3 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100103235618 1 D S0000040.LOG C0000007 
---------------------------------------------------------------------------- 
 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100103235618 
End Time: 20100103235618 
Status: A 
---------------------------------------------------------------------------- 
EID: 84 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000040.LOG 
 
[email protected]:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007 
total 36 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:56 S0000040.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-04 00:41 S0000041.LOG 
 
可以看到,归档日志文件S0000039.LOG已被删除,但S0000038.LOG还存在,因为之前已经清除了S0000038.LOG的相关条目。 
尝试同时清除S0000040.LOG和S0000041.LOG: 
 
[email protected]:~> db2 list history archive log all for ggyy | tail -15 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100104004127 1 D S0000041.LOG C0000007 
---------------------------------------------------------------------------- 
 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100104004127 
End Time: 20100104004128 
Status: A   www.2cto.com  
---------------------------------------------------------------------------- 
EID: 86 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000041.LOG 
 
[email protected]:~> db2 prune history 20100104004127 and delete 
DB20000I The PRUNE command completed successfully. 
[email protected]:~> db2 list history archive log all for ggyy | head -20 
 
List History File for ggyy 
 
Number of matching file entries = 1 
 
 
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID 
-- --- ------------------ ---- --- ------------ ------------ -------------- 
X D 20100104004127 1 D S0000041.LOG C0000007 
---------------------------------------------------------------------------- 
 
---------------------------------------------------------------------------- 
Comment: 
Start Time: 20100104004127 
End Time: 20100104004128 
Status: A   www.2cto.com  
---------------------------------------------------------------------------- 
EID: 86 Location: /data/palog/db2inst1/GGYY/NODE0000/C0000007/S0000041.LOG 
 
[email protected]:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007/ 
total 24 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG 
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-04 00:41 S0000041.LOG 
 
S0000041.LOG依然存在,因为它是全备之后生成的。如果想要强制清除,可以使用 with force option 参数。 
 
[email protected]:~> db2 prune history 20100104004127 with force option and delete 
DB20000I The PRUNE command completed successfully. 
[email protected]:~> db2 list history archive log all for ggyy | head -20 
 
List History File for ggyy 
 
Number of matching file entries = 0 
 
[email protected]:~> ls -l /data/palog/db2inst1/GGYY/NODE0000/C0000007/ 
total 12   www.2cto.com  
-rw-r----- 1 db2inst1 db2iadm1 12288 2010-01-03 23:55 S0000038.LOG 
 
注意,这里连带着将数据库全备的条目也删除了,但备份文件还在: 
 
[email protected]:/data/backup> db2 list history backup all for ggyy 
 
List History File for ggyy 
 
Number of matching file entries = 0 
 
[email protected]:/data/backup> ls -l /data/backup 
total 99994 
-rw------- 1 db2inst1 db2iadm1 102293504 2010-01-04 00:41 GGYY.0.db2inst1.NODE0000.CATN0000.20100104004121.001 
 
此外,使用 db2 prune logfile 命令可以清除活动日志目录下的在线归档日志文件,但对离线归档日志文件无效,这里不再赘述。
 
 
 
作者 jackytang520
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<