################################備份前準備#################################
***************************創建存放歸檔日誌和備份的目錄********************
[root@yan ~]# su - db2inst1
[db2inst1@yan ~]$ mkdir archivelog
[db2inst1@yan ~]$ mkdir log
[db2inst1@yan ~]$ mkdir backup
***************************創建測試資料庫和測試表***************************
db2 => create db yan
db2 => connect to yan
db2 => create table test (id int,name varchar(20),password varchar(20))
db2 => insert into test values (1,'zhu','yan')
***************************修改db2參數**************************************
db2 => update db cfg for yan using mirrorlogpath /home/db2inst1/archivelog--啟用mirror log
db2 => update db cfg for yan using userexit on --啟用用戶出口
db2 => update db cfg for yan using logretain on --啟用歸檔日誌
db2 => update db cfg for yan using trackmod on --啟用增量備份功能
db2 => backup db yan to /home/db2inst1/backup 這時資料庫處於掛起狀態,需要對資料庫備份一次,否則不能用
Backup successful. The timestamp for this backup image is : 20090807082755
###############################開始備份和還原################################
********************************冷備份和還原*********************************
db2 => backup db yan to /home/db2inst1/backup
Backup successful. The timestamp for this backup image is : 20090807083306
db2 => insert into test values (2,'hui','hui')
[火星人
]
DB2備份和還原已經有396次圍觀
http://coctec.com/docs/linux/show-post-53122.html
