在线全备(以iadb数据库为例)
1 使用数据库日志归档模式
先查看日志模式
db2 get db cfg for iabd |grep -i log
结果如下:
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) = OFF
为循环日志模式
切换为归档模式
db2 update db cfg for iabd using LOGRETAIN ON
查看日志模式,结果为
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) = LOGRETAIN
2 指定归档日志路径
db2 update db cfg for iabd using LOGARCHMETH1 "disk:/home/db2inst1/arch_log"
再次查看日志模式,结果为
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:/archivelog/db_name_db_log/
3 此时数据库为备份暂挂状态,不可以被访问,需要做一次离线备份,是数据库脱离此状态
首先应确定没有应用链接该数据库
db2 list applications
然后进行备份
db2 backup db iabd to /backup ----可根据需要指定备份路径
备份成功 则返回一个时间戳
4 进行在线备份
db2 backup db iabd online to /backup include logs
备份成功 则返回一个时间戳
5 恢复数据库(我使用的是离线的备份来恢复)
db2 restore db iabd from /backup taken at 备份的时间戳 without rolling forward
(若不使用without rolling forward 则将使数据库置于前滚暂挂状态 ,数据库处于不访问状态 这样就需要使用rolling forward来前滚数据库是数据库恢复访问)
1 使用数据库日志归档模式
先查看日志模式
db2 get db cfg for iabd |grep -i log
结果如下:
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) = OFF
为循环日志模式
切换为归档模式
db2 update db cfg for iabd using LOGRETAIN ON
查看日志模式,结果为
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) = LOGRETAIN
2 指定归档日志路径
db2 update db cfg for iabd using LOGARCHMETH1 "disk:/home/db2inst1/arch_log"
再次查看日志模式,结果为
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:/archivelog/db_name_db_log/
3 此时数据库为备份暂挂状态,不可以被访问,需要做一次离线备份,是数据库脱离此状态
首先应确定没有应用链接该数据库
db2 list applications
然后进行备份
db2 backup db iabd to /backup ----可根据需要指定备份路径
备份成功 则返回一个时间戳
4 进行在线备份
db2 backup db iabd online to /backup include logs
备份成功 则返回一个时间戳
5 恢复数据库(我使用的是离线的备份来恢复)
db2 restore db iabd from /backup taken at 备份的时间戳 without rolling forward
(若不使用without rolling forward 则将使数据库置于前滚暂挂状态 ,数据库处于不访问状态 这样就需要使用rolling forward来前滚数据库是数据库恢复访问)