db2 全量+增量备份数据
来源:互联网 发布:安卓变女声软件 编辑:程序博客网 时间:2024/05/22 14:39
db2 数据库备份策略
1. 全量+增量模式
此策略可以恢复到从全量开始任意一天的数据
db2 数据库备份
[db2inst1@localhost backup]$ db2 update db cfg using TRACKMOD on
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, all
applications must disconnect from this database before the changes become
effective.
--检查
[db2inst1@localhost backup]$ db2 get db cfg | grep TRACKMOD
Track modified pages (TRACKMOD) = ON
--全量备份
[db2inst1@localhost backup]$ db2 backup db sample to /opt/ibm/db2/backup
Backup successful. The timestamp for this backup image is : 20120209154203
--数据测试
[db2inst1@localhost backup]$ db2 "create table tmp_tab(id integer ) "
DB20000I The SQL command completed successfully.
[db2inst1@localhost backup]$ db2 "insert into tmp_tab(id) values(12)"
DB20000I The SQL command completed successfully.
[db2inst1@localhost backup]$ db2 "select * from tmp_tab"
ID
-----------
12
1 record(s) selected.
--增量备份
[db2inst1@localhost backup]$ db2 backup db sample incremental to /opt/ibm/db2/backup
Backup successful. The timestamp for this backup image is : 20120209154600
--模拟灾难
[db2inst1@localhost backup]$ db2 drop db sample
DB20000I The DROP DATABASE command completed successfully.
--方法一 (手工恢复,必须对全量文件+增量文件依次恢复)
[db2inst1@localhost backup]$ db2 restore db sample incremental from /opt/ibm/db2/backup taken at 20120209154600
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@localhost backup]$ db2 "connect to sample"
SQL1119N A connection to or activation of database "SAMPLE" cannot be made
because a previous restore is incomplete or still in progress. SQLSTATE=57019
[db2inst1@localhost backup]$ db2 restore db sample incremental from /opt/ibm/db2/backup taken at 20120209154203
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@localhost backup]$ db2 "connect to sample"
SQL1119N A connection to or activation of database "SAMPLE" cannot be made
because a previous restore is incomplete or still in progress. SQLSTATE=57019
[db2inst1@localhost backup]$ db2 restore db sample incremental from /opt/ibm/db2/backup taken at 20120209154600
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@localhost backup]$ db2 "connect to sample"
SQL1117N A connection to or activation of database "SAMPLE" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
--前滚数据库,使之可用
[db2inst1@localhost db2inst1]$ db2 ROLLFORWARD DATABASE sample TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH '(/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR)'
Rollforward Status
Input database alias = sample
Number of nodes have returned status = 1
Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2012-02-09-07.46.03.000000 UTC
DB20000I The ROLLFORWARD command completed successfully.
--方法二 (自动恢复,必须对全量文件+增量文件依次恢复)
[db2inst1@localhost backup]$ db2 restore db sample incremental automatic from /opt/ibm/db2/backup taken at 20120209154600
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@localhost backup]$ db2 ROLLFORWARD DATABASE sample TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH '(/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR)'
Rollforward Status
Input database alias = sample
Number of nodes have returned status = 1
Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2012-02-09-07.46.03.000000 UTC
DB20000I The ROLLFORWARD command completed successfully.
- db2 全量+增量备份数据
- mysql增量、全量备份
- mysql全量备份、增量备份
- Mysql 增量备份和全量备份
- mysql增量备份和全量备份
- SVN--全量备份与增量备份
- innobackupex全量备份+增量备份手记
- mysql 全量备份和增量备份
- Mysql的数据备份类型——物理备份与逻辑备份,全量与增量
- mysql全量、增量备份脚本
- mysql全量和增量备份脚本
- mysqldump备份脚本(全量+增量)
- xtrabackup全量+增量备份手记
- SVN全量和增量备份脚本
- 全备份、增量备份与差量备份
- 全备份,增量备份和差量备份
- 全备份、增量备份与差量备份
- DB2数据库全量备份1
- 10 个你需要了解的项目管理工具
- 第六章:Android组件之间的信使Intent
- 剖析“持续交付”:五个核心实践
- 图片上传到数据库
- javascript数组操作大全,数组方法总汇
- db2 全量+增量备份数据
- c++builder 动态创建控件及销毁
- MFC程序和Win32程序的关系
- mysql 记录
- Trustee
- 用过的linux命令
- SQL Server DATEADD() 函数
- 孕期拉肚子,哎,艰辛
- 对象的创建过程