db2数据库中,启用归档日志:第一次启用归档日志时,需要给数据库做一次全备份
Db2 backup db XXXX to /../../../,之后就可以执行db2 update db cfg for XXXX using logretain recovery,将数据库的备份模式调整为归档了,那么在db2 10.5中是否有logretain参数的设置呢?
如果没有,那此功能要如何实现呢?
你是说LOGARCHMETH1 吧,把它设置成LOGRETAIN就启用归档日志了:
$ db2level
DB21085I This instance or install (instance name, where applicable: "db2v105")
uses "64" bits and DB2 code release "SQL10055" with level identifier
"0606010E".
Informational tokens are "DB2 v10.5.0.5", "s141128", "IP23626", and Fix Pack
"5".
Product is installed at "/opt/IBM/db2/V10.5".
$ db2 get db cfg | grep -i 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) =
收起