环境:
Os:Centos 7
DB:V11.5.6
1.查看数据库是否处于归档模式
[db2inst1@host135 SQL00001]$ db2 get db cfg for db_hxl|grep LOGARCH First log archive method (LOGARCHMETH1) = OFF Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF Options for logarchmeth1 (LOGARCHOPT1) = Second log archive method (LOGARCHMETH2) = OFF Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF Options for logarchmeth2 (LOGARCHOPT2) =
2.创建归档目录
[root@host135 tmp]# su - db2inst1
[db2inst1@host135 ~]$ mkdir arch
[db2inst1@host135 arch]$ pwd
/home/db2inst1/arch
3.为数据库设置归档
[db2inst1@host135 arch]$db2 update db cfg for db_hxl using LOGARCHMETH1 "disk:/home/db2inst1/arch" ##单独某个库归档
4.重启
[db2inst1@host135 arch]$db2stop force
[db2inst1@host135 arch]$db2start
5.需要进行备份
db2 => connect to db_hxl SQL1116N A connection to or activation of database "DB_HXL" failed because the database is in BACKUP PENDING state. SQLSTATE=57019 [db2inst1@host135 backup]$ db2 backup database db_hxl>/home/db2inst1/backup/db_hxl.bak 再次链接 db2 => connect to db_hxl Database Connection Information Database server = DB2/LINUXX8664 11.5.6.0 SQL authorization ID = DB2INST1 Local database alias = DB_HXL
6.手工归档
[db2inst1@host135 LOGSTREAM0000]$ db2 archive log for db db_hxl
DB20000I The ARCHIVE LOG command completed successfully.
7.新创建数据库查看是否会归档
[db2inst1@host135 C0000000]$ db2
db2 create db db_hxl01 using codeset utf-8 territory CN
发现新建的库不会启用归档的
[db2inst1@host135 backup]$ db2 get db cfg for db_hxl01|grep LOGARCH First log archive method (LOGARCHMETH1) = OFF Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF Options for logarchmeth1 (LOGARCHOPT1) = Second log archive method (LOGARCHMETH2) = OFF Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF Options for logarchmeth2
需要手工设置归档
[db2inst1@host135 arch]$db2 update db cfg for db_hxl01 using LOGARCHMETH1 "disk:/home/db2inst1/arch"
标签:db2inst1,db,host135,设置,归档,db2,arch From: https://www.cnblogs.com/hxlasky/p/17986410