db2开启归档日志
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1、 查看默认情况下的设置：
db2 get db cfg for db_name |grep -i log
结果如下：
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) = OFF
默认情况为循环日志
2、更改为归档日志：
db2 update db cfg for db_name using LOGRETAIN ON
运行后结果如下：
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) = LOGRETAIN、
更改归档目录:
db2 update db cfg for db_name using LOGARCHMETH1 "disk:/archive/db_name_db_log"
运行后结果如下：
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) =
DISK:/archivelog/db_name_db_log/
3、手工归档方法：
db2 archive log for db db_name
（但前提是没数据库连接，很奇怪，不知道为什么）
如下：
[db2inst1@home SQLOGDIR]$ db2 connect to fangys
Database Connection Information
Database server = DB2/LINUX 8.2.9
SQL authorization ID = DB2INST1
Local database alias = FANGYS
[db2inst1@home SQLOGDIR]$ db2 archive log for db fangys
SQL1493N The application is already connected to an active database.
-------不知道为什么不行！！！！
[db2inst1@home SQLOGDIR]$ db2 connect reset
DB20000I The SQL command completed successfully.
[db2inst1@home SQLOGDIR]$ db2_ps
Node 0
UID PID PPID C STIME TTY TIME CMD
db2inst1 6608 6607 0 21:30 pts/1 00:00:00 db2sysc 0
root 6609 6608 0 21:30 pts/1 00:00:00 db2ckpwd 0
root 6610 6608 0 21:30 pts/1 00:00:00 db2ckpwd 0
root 6611 6608 0 21:30 pts/1 00:00:00 db2ckpwd 0
root 6612 6608 0 21:30 pts/1 00:00:00 db2pmd 0
db2inst1 6613 6608 0 21:30 pts/1 00:00:00 db2gds 0
db2inst1 6615 6608 0 21:30 pts/1 00:00:00 db2ipccm 0
db2inst1 6616 6608 0 21:30 pts/1 00:00:00 db2tcpcm 0
db2inst1 6617 6608 0 21:30 pts/1 00:00:00 db2resync 0
db2inst1 6620 6608 0 21:30 pts/1 00:00:00 db2hmon ,0,0,0,1,0,0,0,0,1e014,2,0,1,9fe0,0x113a0000,0x113a0000,15fc000,58004,2,f800a
db2inst1 6618 6613 0 21:30 pts/1 00:00:00 db2srvlst 0
db2inst1 8502 6613
0 22:50 pts/1 00:00:00 db2agent (instance) 0
db2inst1 8748 6613 0 23:07 pts/1 00:00:00 db2agent (idle) 0
db2inst1 8831 6613 0 23:17 pts/1 00:00:00 db2agent (idle) 0
db2inst1 9026 6613 0 23:27 pts/1 00:00:00 db2agent (idle) 0
db2inst1 9124 6613 0 23:34 pts/1 00:00:00 db2agent (idle) 0
db2inst1 9125 6613 0 23:34 pts/1 00:00:00 db2agent (idle) 0
db2inst1 6873 6615 0 21:46 pts/1 00:00:00 db2agent (instance) 0
[db2inst1@home SQLOGDIR]$ db2 archive log for db fangys
DB20000I The ARCHIVE LOG command completed successfully.
----------------这样就行了，很奇怪