DB2开启归档日志

1.查看是否开启归档https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ db2 get db cfg for testdb1 |grep -i LOGARCHMETH1
 First log archive method                 (LOGARCHMETH1) = OFF
 Archive compression for logarchmeth1    (LOGARCHCOMPR1) = OFF
 Options for logarchmeth1                  (LOGARCHOPT1) =

2.为了保证归档顺利，先停止应用连接

[db2inst1@db01 ~]$ db2 force applications all 
DB20000I  The FORCE APPLICATION command completed successfully.
DB21024I  This command is asynchronous and may not be effective immediately.

3.开启归档

https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ db2 update db cfg for testdb1 using LOGARCHMETH1 "DISK:/db2data/archivelog"
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

4.要使得归档生效，需要重启db2

https://www.cndba.cn/hbhe0316/article/4765

https://www.cndba.cn/hbhe0316/article/4765

https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ db2stop force
08/03/2019 20:00:18     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst1@db01 ~]$ db2start 
08/03/2019 20:00:27     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2inst1@db01 ~]$ db2 connect to testdb1
SQL1116N  A connection to or activation of database "TESTDB1" cannot be made 
because of BACKUP PENDING.  SQLSTATE=57019

5.第四步连接的时候报错，需要对数据库进行一次全备https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ mkdir /db2data/backup
[db2inst1@db01 ~]$ db2 backup db testdb1 to /db2data/backup/

Backup successful. The timestamp for this backup image is : 20190803200150

6.验证是否可以连接成功https://www.cndba.cn/hbhe0316/article/4765https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ db2 connect to testdb1

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.1.0
 SQL authorization ID   = DB2INST1
 Local database alias   = TESTDB1

7.验证是否可以成功归档

https://www.cndba.cn/hbhe0316/article/4765

https://www.cndba.cn/hbhe0316/article/4765

[db2inst1@db01 ~]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
[db2inst1@db01 ~]$ db2 archive log for db testdb1
DB20000I  The ARCHIVE LOG command completed successfully.

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle