1.首先开启归档日志模式
db2 update db cfg for testdb using logarchmeth1 disk:/db2cfg
获取db cfg相关日志配置信息:
db2 get db cfg for testdb|grep -i log:
Path to log files = /db2cfg/test/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000004.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
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:/db2cfg/
2.测试环境较为简单testdb中只有一张表
[test@demo sqllib]$ db2 "select * from tb1"
ID NAME
----------- ----------
1 yo
2 yo2
3 yo3
6 yo6
4 record(s) selected.
发起在线备份:
[test@demo sqllib]$ db2 backup db testdb online includ
1.首先开启归档日志模式db2 update db cfg for testdb using logarchmeth1 disk:/db2cfg获取db cfg相关日志配置信息:db2 get db cfg for testdb|grep -i log: Path to log files = /db2cfg...