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博客 ” ,链接:http://blog.itpub.net/22661144/viewspace-1450993/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22661144/viewspace-1450993/