AIX下DB2在线备份及恢复.doc

在线备份的意义在线意味者备份的时候,允许其他的连接,而不用停掉数据库。增量意味着,不需要每次备份一个超大的数据库。同时意味着你可以将数据库恢复到崩溃前的状态,而不是你最后一次备份时的状态,最大可能的减少数据损失。首先停止was服务远程登陆到DB2Servertelnet DB2Server IP断掉db2的连接1，su db2admin2，db2stop force 3，db2start4，db2设置在线备份参数（非第一次增量备份跳过此节）5，connect to stma user db2admin using db2admin6，update db cfg for stma using userexit on 7，update db cfg for stma using logretain on 8，update db cfg for stma using trackmod on 9，connect reset10，connect to datacdb user db2admin using db2admin11，update db cfg for datacdb using userexit on 12，update db cfg for datacdb using logretain on 13，update db cfg for datacdb using trackmod on 14，connect reset15，connect to roeee user db2admin using db2admin16，update db cfg for roeee using userexit on 17，update db cfg for roeee using logretain on 18，update db cfg for roeee using trackmod on 19，connect reset20，connect to rone user db2admin using db2admin21，update db cfg for rone using userexit on 22，update db cfg for rone using logretain on 23，update db cfg for rone using trackmod on 24，connect reset25，db2stop26，db2stop force27，db2start离线全备份（非第一次增量备份跳过此节）28，backup db stma user db2admin using db2admin to /db2_backup/stma with 1 buffers buffer 128 include logs29，backup db datacdb user db2admin using db2admin to /db2_backup/datacdb with 1 buffers buffer 12830，backup db roeee user db2admin using db2admin to /db2_backup/roeee with 1 buffers buffer 12831，backup db rone user db2admin using db2admin to /db2_backup/rone with 1 buffers buffer 128在线全备份（建议定期做一次）32，backup db stma user db2admin using db2admin online to /db2_backup/stma with 1 buffers buffer 128 include logs33，backup db datacdb user db2admin using db2admin online to /db2_backup/datacdb with 1 buffers buffer 128 include logs34，backup db roeee user db2admin using db2admin online to /db2_backup/roeee with 1 buffers buffer 128 include logs35，backup db rone user db2admin using db2admin online to /db2_backup/rone with 1 buffers buffer 128 include logs在线增量备份（建议经常做）36，backup db stma user db2admin using db2admin online incremental to /db2_backup/stma with 1 buffers buffer 128 include logs37，backup db datacdb user db2admin using db2admin online incremental to /db2_backup/datacdb with 1 buffers buffer 128 include logs38，backup db roeee user db2admin using db2admin online incremental to /db2_backup/roeee with 1 buffers buffer 128 include logs39，backup db rone user db2admin using db2admin online incremental to /db2_backup/rone with 1 buffers buffer 128 include logs恢复数据库40，db2 RESTORE db stma user db2admin using db2admin incremental automatic FROM /db2_backup/stma taken at 最新增量备份时间戳 LOGTARGET /db2_log/stma38，db2 RESTORE db datacdb user db2admin using db2admin incremental automatic FROM /db2_backup/stma taken at 最新增量备份时间戳 LOGTARGET /db2_log/datacdb39，db2 RESTORE db roeee user db2admin using db2admin incremental automatic FROM /db2_backup/stma taken at 最新增量备份时间戳 LOGTARGET /db2_log/roeee40，db2 RESTORE db rone user db2admin using db2admin incremental automatic FROM /db2_backup/stma taken at 最新增量备份时间戳 LOGTARGET /db2_log/rone注：“最新增量备份时间戳”为最后一次增量备份时间点回滚日志，置数据库为可用41，db2 rollforward db stma user db2admin using db2admin to end of logs and stop42，db2 rollforward db stma user db2admin using db2admin stop43，db2 rollforward db datacdb user db2admin using db2admin to end of logs and stop44，db2 rollforward db datacdb user db2admin using db2admin stop45，db2 rollforward db roeee user db2admin using db2admin to end of logs and stop46，db2 rollforward d