1）设置循环归档模式
# db2 "update db cfg using LOGARCHMETH1 DISK:/home/db2inst1/archivelog";
2）连接报错
# db2 connect to sample
SQL1116N A connection to or activation of database "SAMPLE" cannot be made
because of BACKUP PENDING. SQLSTATE=57019
3）离线备份
# db2 backup db sample to "/disk2/db2_data/"
Backup successful. The timestamp for this backup image is : 20130722050810
4）再次连接 成功
# db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
参数 FAILARCHPATH 故障转移日志归档路径，当 LOGARCHMETH1 指定的归档路径无效时，归档到 FAILARCHPATH 指定的路径。
# db2 backup db sample to "/disk2/db2_data/"
Backup successful. The timestamp for this backup image is : 20130722050810
4）再次连接 成功
# db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
参数 FAILARCHPATH 故障转移日志归档路径，当 LOGARCHMETH1 指定的归档路径无效时，归档到 FAILARCHPATH 指定的路径。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22661144/viewspace-1450993/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
DB2 恢复误删除的表
请登录后发表评论
登录
全部评论
