DB2的rollforward前滚恢复

本文深入探讨了DB2数据库的rollforward前滚恢复机制,详细阐述了如何在数据库故障后通过日志文件恢复到一致状态,确保数据完整性。通过实例解析了前滚恢复的过程,包括应用红日志、检查点和事务处理等关键步骤。
摘要由CSDN通过智能技术生成
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
  • 0
    点赞
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值