服务器 频道

关于分区数据库的备份与恢复

  【IT168 服务器学院】关于分区数据库的备份和恢复:
  备份:
  db2_all ''<<+0<db2 backup db sample online to /home/db2inst1/db2backup/online''
  db2_all ''<<-0<db2 backup db sample online to /home/db2inst1/db2backup/online''

  恢复:
  db2_all ''<<+0<db2 restore db sample from /home/db2inst1/db2backup/online''
  db2_all ''<<-0<db2 restore db sample from /home/db2inst1/db2backup/online''
  >>也可以并行
    备份
    db2_all "<<+0< db2 backup db sample online to /home/db2inst1/db2backup/online"
    db2_all "||<<-0< db2 backup db sample online to /home/db2inst1/db2backup/online"
    恢复:
    db2_all "<<+0< db2 restore db sample from /home/db2inst1/db2backup/online"
    db2_all "||<<-0< db2 restore db sample from /home/db2inst1/db2backup/online"

  前滚:
  db2_all ''<<+0<db2 rollforward db sample to end of logs on all partitionnums and stop''
  执行此命令之前,要把所需要的日志放置到指定目录上,具体可参考单节点数据库的备份、恢复与前滚
  

0
相关文章