定期在线全备
每隔1天备份归档
在线全备+备份归档就是了。
在线全备不用说吧
备份归档就是读取db2 get db cfg for db |grep -i log中first log日志的序列号以及后面的日志。日志序列号大于它的都备走就行了。

[db2inst1@zeasn-testdb C0000000]$ db2 get db cfg for blueport |grep -i “first log”
First log archive method (LOGARCHMETH1) = DISK:/db2/db/archive/

[db2inst1@zeasn-testdb C0000000]$ db2 get db cfg for blueport |grep -i “log”
Log retain for recovery status = NO
User exit for logging status = YES
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 2150
Active log space disk capacity (4KB) (LOG_DISK_CAP) = 0
Log file size (4KB) (LOGFILSIZ) = 10240
Number of primary log files (LOGPRIMARY) = 100
Number of secondary log files (LOGSECOND) = 100
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0004056.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) = 0
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
First log archive method (LOGARCHMETH1) = DISK:/db2/db/archive/
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) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Log pages during index build (LOGINDEXBUILD) = OFF
Log DDL Statements (LOG_DDL_STMTS) = NO
Log Application Information (LOG_APPL_INFO) = NO

[db2inst1@zeasn-testdb C0000000]$ pwd
/db2/db/archive/db2inst1/BLUEPORT/NODE0000/LOGSTREAM0000/C0000000/S000*.log

备份直接
cp -r /db2/db/archive/db2inst1/BLUEPORT/ /backup/

这样就行吗？

有没有事用的备份脚本可进行提供,谢谢 我不太懂

备份脚本貌似没有，一般都是备份软件备份

备份软件收费吗 可以推荐一下

db2自带的的backup和restore命令很强大，具体使用方式建议参考官网。备份策略一般是开启日志归档+每日在线全备(开启压缩),属于物理备份。