DB2數(shù)據(jù)庫(kù)備份與恢復(fù)詳解

1、DB2數(shù)據(jù)庫(kù)備份與恢復(fù)1. 備份1.1離線備份（必須在數(shù)據(jù)庫(kù)所在pc機(jī)進(jìn)行操作）STEP 1連接到要備份的數(shù)據(jù)庫(kù)（數(shù)據(jù)庫(kù)名：ncc）C:Documents and SettingsAdministrator>db2 connect to ncc user nccwykpi using nccwykpi;documents and Sett ings Mldnio ist rat or>db2 connec t to ncc mser nocwykpi us ing n cwykpi數(shù)據(jù)庫(kù)連接信息數(shù)據(jù)庫(kù)服務(wù)器=DB2ZNT 9-1-9SQL授權(quán)標(biāo)識(shí)NCCWVKPI本地?cái)?shù)捱庫(kù)別名=NC

2、CSTEP 2顯示數(shù)據(jù)庫(kù)應(yīng)用狀態(tài)C:Documents and SettingsAdministrator>db2 list applicationsC：'EjDocunients and Se11IngsXfidministrator>db2 list applications限標(biāo)識(shí)應(yīng)用程序名予應(yīng)用程序句柄應(yīng)用程序標(biāo)識(shí)數(shù)據(jù)庫(kù)名稱(chēng)代理序號(hào)NCCWVKPI db2bp.exena?*LOCAL.DB2.120206013824NCC1nDMINIST>db2evmg_DB2DET12 SS«LOCAL.DB2.12Q2&601&22NCC1NC

3、CREPdhZtaslfd1305«LOGAL.DB2.120206010521NCC1NCCREPdbZstnm1102*LOCftL.DB2.120206010520NCC1NCCREPpiiFepagent > xe1106*LOGftL.DB2.120206010516NCC1NCCUVMD 0DBC4DB21362AC100570.GE4CNCCWV1NCCD0MI>JDBC4DB21301AC10056F.G642NCCW¥1fiDMINIST>db2eung_DB2DET1243*LOCAL.DB2.120206605152NCCWV1NCC

4、»0MAI>db2tasl<d837*LOCAL.DB2.12020G0OS151NCGWV1NCCD0MAI>db2stnn1242«LOCAL.DB2.12020600515SNCCWY1NCCD0HAI>JDBC4DB21042AClM0b6F.G4&DNCCUV1STEP 3停掉數(shù)據(jù)庫(kù)應(yīng)用C:Documents and SettingsAdministrator>db2 force applications allC: XBocuments and Sett inin istpatoi*>db2 force applica

5、t ions allDB20000I FORCE APPLICATION 命令成功完成*W1024I該命令為異歩也可能木會(huì)立麗生奴*注意：由于該命令是異步的，所以在進(jìn)行備份的時(shí)候會(huì)出現(xiàn)以下錯(cuò)誤信息。此時(shí)可以再次 執(zhí)行 db2 force applications all 命令。Cs Do"Cu.nent s arid Sett Ing's dmiin 1s t rat or>db2 bac kup database ncc to d- XdbSxbickuipSQL1035N當(dāng)前正在使用數(shù)據(jù)庫(kù)。SQLSTATE=57019C= Docunents and Setting

6、fsistpatop>db2 force applications allDB20000I FORCE fiPPLICfiTlON 命令成功完成奮DB21024I該命令為異歩的*可能不會(huì)立即笙效禺STEP 4對(duì)數(shù)據(jù)庫(kù)進(jìn)行離線狀態(tài)下的備份C:Documents and SettingsAdministrator>db2 backup database ncc to d:db2backupC： J)ocu(Hnt£ and Sett Ings Adniinis tratcF>db2 backup database ncc to d：xdb2backup備份成功*此備粉映

7、像的時(shí)間戳記是：20120206094204注意：指定的備份文件的輸出目錄必須是已創(chuàng)建的，否則會(huì)報(bào)錯(cuò)。C：xDocunents and Setting?Adninistrator>db2 backup dtabse ncc to d：xdb2M)acK(up 2 0120209SQL2836H 文件或設(shè)備"d： sdh2backup0120209'1 的路徑無(wú)效*包址血亦6亦6上前而66626扭龐帀運(yùn)2辟,救 鬲 ooi文件 2012-2-0 9真 aSTEP 5查看備份歷史記錄C:Documents and SettingsAdministrator>db2 l

8、ist history backup all for nccC: M>ocumemts and Settings dm inis t rat or >db2 list history bac kup all for ncc 歹(I示ncc的歷史記錄文件匹配的文件條目數(shù)-40P對(duì)象時(shí)間戳記+序列類(lèi)型設(shè)備最早日志當(dāng)前日志備份標(biāo)識(shí)B D 2012Q20G085131000 FS0O0000S.LOG包含7表空閆：uaaui svscfiTSPftCE00002 USERSPACEl00093 NCCWVKPI 00004 NCCDONIAIN00009 NCCREPQ03Q6 NCCWV

9、MD 00007 SVSTOOLSPACE蛙釋=DB2 BACKUP NCC OFFLINE 開(kāi)如時(shí)間：201202060BS131結(jié)兎時(shí)間：2612020&0B5192 狀態(tài)皿E1D： 4820 位置:SQLCft信息sqlcaid : SQLCAsqlcahc: 136sqlc ode:-203&sqlerrnl: 13s(ilerFnfcc : d: db2 backupffqlsrrp : sqlubMUflsqleri*d : <1) QC2>0C3> 0<4> 0(5>0<6> 0sqluarn : <15<

10、;2><3><4><5><?><9><10>sqIs Cate:0P對(duì)象時(shí)間戳記*序列類(lèi)型i殳備最早日志當(dāng)前日志備份標(biāo)識(shí)B D 2012S2B608S243001 F D S0000000.LOG SB000000.LOG包含7表空冋】00031 SVSCiATSFACE00002 USERSPACE1S0Q03 HCCWYWPI00004 NCCDONAINB0005 NCCREP00006 NGCUVND?:態(tài)苛乘士口女去一開(kāi)M6007 SVSTOOLSPACEDBS BACKUP NCG OFFLINE :20

11、120206085243 |'sj. 20120206090512 :AE1D： 4821 位置：d: db2 XbackupOP對(duì)象時(shí)間戳記+序列類(lèi)型設(shè)備最早日志當(dāng)前日志備份標(biāo)識(shí)1 'biB D 28120206094204001F D S0000000.LOG S0000000.LOG包含?表空間：BD001GVSCfiTSPfiCEB0B02USERSFACE10R003NCCWVKPIQ»Q04NCCDOMfilNQ0Q05NGGREP03006NCGUVMDSOS07SVSTOOLSPfiCE冠卡：DB2 BACKUP NCC OFFLINE開(kāi)姑時(shí)1間:20

12、12020E094264結(jié)弟打間；2012020&095453態(tài)小ETD；-1822 位置：d: db2Sbackup1.2在線備份注意：如果要做在線的備份，要對(duì)兩個(gè)參數(shù)作修改：USEREXIT和LOGRETAIN將其修改為on,默認(rèn)是 off的，默認(rèn)使用日志模式，修改完參數(shù)后，可以變?yōu)闅w檔日志模式，啟用了 userexit做數(shù)據(jù)庫(kù)日志的歸檔。|STEP 1查看數(shù)據(jù)庫(kù)當(dāng)前的屬性C:Documents and SettingsAdministrator>db2 get db cfgC =吧nt荻 and SettingsMldiiioisCratarMbZ get db cfcr敘

13、捱年 的救據(jù)年配置頁(yè)集刀順屎 域碼碼家理順大 地代代國(guó)整理頁(yè) 庫(kù)庫(kù)庫(kù)庫(kù)臺(tái)庫(kù)動(dòng)態(tài)SQL查詢不理gi»rij:=CN=1208=(JTF-8 86=IDENTITY CALT_COLLftTE> =32768<DVN_QUEBV_MGMTJ DISABLE對(duì)此數(shù)據(jù)庫(kù)的發(fā)現(xiàn)支持<DISCOUEE_DB> = ENABLEDF目 續(xù)-數(shù)目 類(lèi)繼期項(xiàng)的數(shù) 化龍選值點(diǎn) 優(yōu)頻位 問(wèn)詢咼分 訪查鼻的 制苣輦省410留 限缺并在缺製保_TVPESJ NO <DFT_QUER¥OPT> 5<DFT_DEGREE> = 1CDFT_SQLMATHU

14、ARN> = NO<DFT_EEFRESH_AGE> = B的表類(lèi)型SVSTEh<NUM_FREQUALUES> 10<NUM_QUftHTILES> = 20備粉暫掛swr復(fù)原暫崔啟用的多貢文件分配VES韻辟牒岀口：oSTEP 2 設(shè)置 userexit、logretain 參數(shù)的狀態(tài)為 onC:Documents and SettingsAdministrator>db2 update db cfg for ncc using userexit onC:Documents and SettingsAdministrator>db2 up

15、date db cfg for ncc using logretain onG：Documents： and Settinjf&“dEiniw'tyntot'bdhZ force applications all DB2O009I FOPCE fiiPPLICfiTIOH 命令成功完成。DB2詭"I 該命令舟異歩虹可琵不會(huì)立即生奴*注意：修改配置參數(shù)必須是數(shù)據(jù)庫(kù)管理員，并且必須停掉全部應(yīng)用后更改才會(huì)生效。STEP 3連接需要備份的數(shù)據(jù)庫(kù)（注意）注意：此時(shí)由于數(shù)據(jù)庫(kù)處于backup pending狀態(tài)，所以必須做一次離線的全備才可以進(jìn)行數(shù)據(jù)庫(kù)連接。C:JJioc

16、uiiipents and 尊 ot t in gi s dm in is t Fat o r >db2 update db 密 f of ncc usiog userexit onSQL1092N ''HCCWyKPl “沒(méi)有執(zhí)行所請(qǐng)求的命令的權(quán)限°0= XDocunents and Settingsldministrator>db2 connect to ncc user db2adinin using d b2admin數(shù)據(jù)庫(kù)連接信息數(shù)據(jù)庫(kù)服務(wù)器=DB2/NT 9-1-9SQL授權(quán)標(biāo)識(shí)-DB2ADNEN本地?cái)?shù)據(jù)庫(kù)別名=NCCC : Docunient

17、s and Sett in g(s Ml dm in istpator>db2 update db cf g for ncc using us erex it UPIDB20Q00I UPDATE DATABASE CONFIGURATION 命令成功完成®SQL1363W為立即修改而提交的一個(gè)或多個(gè)參數(shù)耒動(dòng)態(tài)黃改。對(duì)于這些配置參數(shù)，必須在所 *應(yīng)用程序都與此數(shù)據(jù)庫(kù)斷開(kāi)連按之后,更改才會(huì)生效。C： SJJacunients and Sett 占update db cffor ncc usingf logjiretaii n onDB20000I UPDATE DATABASE

18、CONFIGURATION 命令成功完成*SQL1363W為立即修改而提交的一個(gè)或多個(gè)參數(shù)耒動(dòng)態(tài)更改。對(duì)于這些配置參數(shù)，必須在所有應(yīng)用程序都與此數(shù)據(jù)庫(kù)斷開(kāi)連接之后.更改才會(huì)生效。:Documents and Sett ingsMldiTiinisti*ator>db2 connec t to nccQL1116N由于BACKUP PENDING,不能執(zhí)行連接或激活數(shù)據(jù)障"NCC'% SQLSTATE-57019C: Documents and Sett ingsM:l|dmiinistratoii'>>db2 DB20O00I FORCE APPLI

19、CATION 命令或可売成心 DB2102I該齋令為異歩的，可館不會(huì)立耶生數(shù)。force applications allC:XDocuments and Settingsfldmin istratop>db2DB20000I FORCE APPLICATION 命令成功完成DB2102I該命令為異歩的，可罷不罷立即生數(shù)*force applicatiorns allC : "xDocuiients and Sett ingsSfidmin istrator>db2backup database ncc to d: Sdb2 Xbackup備份成功。此備扮映像的吋間戳記是

20、：2012020610441&C：documents and SettingsSfi<liinisti*fttor>db2 connect to ncc user nccukpi using n uuwykpi數(shù)據(jù)庫(kù)連接信息數(shù)據(jù)庫(kù)服童器-DB2/NT 9.1,9SQL授權(quán)標(biāo)識(shí)=NCCWVKPI本地顎謂庫(kù)另0名=NCCSTEP 4對(duì)數(shù)據(jù)庫(kù)進(jìn)行在線狀態(tài)下的備份C:Documents and SettingsAdministrator>db2 backup database ncconline to d:db2backup權(quán)標(biāo)識(shí)應(yīng)用程序名應(yīng)用程序應(yīng)用程序標(biāo)識(shí)數(shù)據(jù)庫(kù)代理壬口

21、1 -1予句柄名稱(chēng)序號(hào)NCCWVKPI db2bp.exe286*LOCAL.DB2.120206025739HCC1ADMINIST>dh2eumg_DB2DET301*LOCAL.DB2.120206025650NCC1NCCBEP db2taskd304*L0CAL.DB2.12020602566NCC1HOCREPdb2stnni295*LOCAL.DB2.1202BG025645NCC1NCCREPpnpepagent.exe297*L0CAL.DB2.120206025640NCC1NCCUVMD 0DBC4DB2299AC10057Q.G864NCCWV1ADMINIST&

22、gt;db2eung_DB2DET226*LOCAL.DB2.120206024421NCCWV1NCCDOMAl>db2ta£kd220*LOCAL.DB2.12020G02442UNCCUY1NCCD0MAI>db2stnm236*LOCAL.DB2.120206024419NCCWV1NCCD0MAI>JDBC4DB2231AC10056F.H2E6HCCWV1C： xDocunents and Sett IngsXAdmifiist rat or><db2 backup databasencc online tod:db2jackupC：xDoc

23、unents and Sett IngsMldmin1stratDF>db2 list applications備份成功*此備份映像的時(shí)間戳記是；201202061058571.3增量備份注意：必須要修改 trackmod為on狀態(tài)，并有一次完全備份。STEP 1修改trackmod 參數(shù)為on狀態(tài)C:Documents and SettingsAdministrator>db2 update db cfg for ncc using trackmod yesC:Bocuiwn and Settings dm In is t rat o r >db2 upda db cfs

24、for ncc usingr trackmod vesDB20000【UPDATE DATABASE CONFIGURATION 命今成功憲成*SQL1363W為立即修改而提交的一個(gè)或多個(gè)參數(shù)耒動(dòng)態(tài)更改。對(duì)于這些配置參數(shù)，必須在所 b應(yīng)用程序都與此數(shù)據(jù)庫(kù)斷開(kāi)連接之后.更改才會(huì)生效°STEP 2停掉數(shù)據(jù)庫(kù)應(yīng)用C:Documents and SettingsAdministrator>db2 force applications all:Docunents and Se tt in gs sfi dm in is trator>dh2 force applicat ions

25、艮丄久 R20300I FORCE APPLICATION 命令成功完成。B21024I該齋令壞異步虹可羅卞會(huì)立即黑效.STEP 3對(duì)數(shù)據(jù)庫(kù)進(jìn)行增量備份C:Documents and SettingsAdministrator>db2 backup database ncconline increment al delta to d:db2backup注意：在進(jìn)行增量備份之前需要做一次離線的全備。否則是backup pending狀態(tài)的。如若此時(shí)并未執(zhí)行一次離線的全備那么會(huì)出現(xiàn)下面的錯(cuò)誤。C ： XDocunents aod Set t ingis Mldmio is t Fat or

26、>db2 bac kup database ncc on line increment al de lta to d: db2 backupSQL2d2GH數(shù)據(jù)庫(kù)尚未配置為允許増量備份操作。原因碼煌B故:C： Docuncnts and Sett ing&xAdministracor>db2 backup database ncc to d:db2hackup備份成功此備份映像的時(shí)間戳記是：2012R206133232G： M)ocuments and Se11 in$rs Mlidmin is ti*ator >db2 backup dsitalxase ncc o

27、n line increinieot al de lta to d.: db2 Xbackup備份成功樣此備扮映像的時(shí)間戳記是；201202061334572. 恢復(fù)2.1恢復(fù)完全備份STEP 1查看備份歷史記錄C:Documents and SettingsAdministrator>db2 list history backup all for nccC:M>ocuments and SettingrsAdniinisti*itoi'>db2 list history backup all for ncc列示ncc的歷史記錄文件匹配的文件條目數(shù)-4Op對(duì)象時(shí)間戳記

28、+序列類(lèi)型設(shè)備最早日志當(dāng)前日志備份標(biāo)識(shí)B D 201202085131000 FS0Q030O0.LOG:包含?表空間； 附酗丄 SVSCATSPftCE00002 USERSPACE1 000Q3 NCCWYKPI 00004 NCCDOHAINB000S NCCBEP003Q6 NCCUVMD 00007 SVSTOOLSPACE?： DE2 BACKUP NCC OFFLINE 耶 2012B2Q608&131 廿間：2012B2B6M5132 態(tài)t AEID： 4S20 位置:SQLCA信息sqlcaid : SQLCAsqlcahc: 136sqlcode:-203&

29、sqlerrml： 13Sfilerrnc - d: db2 backupsqlerrp : sqlubMUfisqleri*d : <1) QC2>QC3> Q<4> 0(5>0C6> 0sqluarn :<2><3><4><5>(fc><?)<8><9><10><11>sqIs cate:0P對(duì)象時(shí)間戳記*序列類(lèi)型i殳備最早日志當(dāng)前日志備份標(biāo)識(shí)B D 2012S2B608S243001 F D S0000000.LOG SB000000.LO

30、G包含7表空冋】00031 SVSCiATSFACE00002 USERSPACE1S0Q03 HCCWYWPI00004 NCCDONAINB0005 NCCREP00006 NGCUVND?:態(tài)苛乘士口女去一開(kāi)M6007 SVSTOOLSPACEDBS BACKUP NCG OFFLINE :20120206085243 |'sj. 20120206090512 :AE1D： 4821 位置：d: db2 XbackupOP對(duì)象時(shí)間戳記+序列類(lèi)型設(shè)備最早日志當(dāng)前日志備份標(biāo)識(shí)1 'biB D 28120206094204001F D S0000000.LOG S0000000

31、.LOG包含?表空間：BD001GVSCfiTSPfiCEB0B02USERSFACE10R003NCCWVKPIQ»Q04NCCDOMfilNQ0Q05NGGREP03006NCGUVMDSOS07SVSTOOLSPfiCE冠卡：DB2 BACKUP NCC OFFLINE開(kāi)姑時(shí)1間:2012020E094264結(jié)弟打間；2012020&095453態(tài)小ETD；-1822 位置：d: db2SbackupSTEP 2停掉數(shù)據(jù)庫(kù)應(yīng)用C:Documents and SettingsAdministrator>db2 force applications all:Docuf

32、nents and Settistrator>db2 restoi*e database nee f i*om d:dh2hacup tat 20120206094201QL1035N當(dāng)前正左使用數(shù)據(jù)庫(kù)。SQLSTfiTE=57019：Docunents and S ettIngs M） dmin istrat or>db2 force applicat ions allB20MBI FORCE APPLICATION 命令成功完成亍B21024I該命令為異歩陽(yáng)，可罷卞會(huì)立節(jié)笙效。STEP 3恢復(fù)某個(gè)時(shí)間點(diǎn)的數(shù)據(jù)C:Documents and SettingsAdministrat

33、or>db2 restore database ncc from d:db2backup taken at 20120206094204xDocunents and Set t Ings dm in isti*atOF>db2 restore database ncc Fpoe d: db2 b*c kup taken at 20120206094204SQL2539W警告|正在復(fù)原至與備扮映像數(shù)據(jù)陣相同的觀有數(shù)據(jù)庫(kù)。數(shù)據(jù)庫(kù)文件將被刪瓠要繼續(xù)嗎？y,、DB20000I RESTOBE DATABASE 命令成功気成*STEP 4回滾到日志結(jié)束（可不執(zhí)行，即不恢復(fù)日志）C:Docum

34、ents and SettingsAdministrator>db2 rollforward database ncc to end of logs and stop:sDocunents and Sett ingrsSAdninistraCDF>db2 force Applictions allB20000I FORCE APPLICATION 命令成功完成。B21024I該命令為異步的，可籠不會(huì)立即生效:XDocunent and Set1;ingisMlldmiii 1st rat or>db2 rollforward database mcc to end of 1

35、gs 曰Hid stop2.2恢復(fù)增量備份STEP 1連接數(shù)據(jù)庫(kù)C:Documents and SettingsAdministrator>db2 connect to ncc user nccwykpi using nccwykpiC： Docunents and S e 11 in g s Mi dm int is t i*at o r >db2 connect to ncc user nccwykpi us ing n ccwykpi數(shù)據(jù)庫(kù)連接信息數(shù)據(jù)庫(kù)服看器=»B2/NT ?a,9SQL授權(quán)標(biāo)識(shí)=NCCWYKPI本地?cái)?shù)捱庫(kù)別名 NCCSTEP 2顯示數(shù)據(jù)庫(kù)應(yīng)用狀態(tài)

36、C:Documents and SettingsAdministrator>db2 list applicationsC：M)ocunents and Settingadministi*aC0F>db2 list applications聶器標(biāo)識(shí)應(yīng)用程序名應(yīng)用程序句柄應(yīng)用程序標(biāo)識(shí)數(shù)據(jù)庫(kù)名稱(chēng)代理序號(hào)NCCWVKPI db2bp.exe223*LOCA1.DB2.1202 06054053NCC1ADMINIST>dh2eumg_DB2DET208*LOCAL.DB2.12020605345?NCC1NCCREPdb2taskd20?*LOCAL.DB2U202Q6053456N

37、CC1NCCREPdb2stpim»LOCAL.DB2.1202B&0&345NCC1NCCREPpmiepagent .exe205*L0CAL.DB2.120206053454NCC1ADMIMIST>dh2evmg_DB2»ET202MLOCAL.DB2.12020&Q53243NCCWY1NCCDOMn>db2taskd201«U»CAL. DB2.12 B2K053 242NCCWV1NCCDOMAI>db2stnm*L OC A L. DB2.12 020 3 2 41NCCWY1NCCDOMAI &

38、gt;JDBC4DB2199AC1M056F-G5B4HCCWV1STEP 3停掉數(shù)據(jù)庫(kù)應(yīng)用C:Documents and SettingsAdministrator>db2 force applications allC：SDocuments and SettingoXAdnin±strator>db2 force applicat ions all DB200001 FORCE APPLICATION 命令成功完成DB21024I該命令為異歩的，可能不會(huì)立即生效&STEP 4恢復(fù)增量備份C:Documents and SettingsAdministrator

39、>db2 restore database ncc incremental automatic from d:db2backup taken at 20120206133457C： Docunent£ and Sett ingsdministFatoF>db2 restore database ncc incremental aut nnatic f iron d： xdb2Xbackup taken at 29i 292061335?SQL2539U警告|正在復(fù)康至與備扮映像數(shù)據(jù)陣相同的觀有數(shù)據(jù)庫(kù)。數(shù)據(jù)庫(kù)文件將被刪除。 參繼續(xù)嗎？ S） yDB20B00E RESTOR

40、E DATABASE 命令成功完成*STEP 5回滾到日志結(jié)束（可不執(zhí)行，即不恢復(fù)日志）C:Documents and SettingsAdministrator>db2 rollforward database ncc to end of logs and stopC：SDocuRients aod SettingisSAdniRist*atoF>db2 i*oIlfdatabase ncc to end of 1 ogs and stop3. 檢查備份完整性當(dāng)備份完成后，使用 db2ckbkp命令不僅可以用來(lái)檢查DB2數(shù)據(jù)庫(kù)備份文件的完整性，而且還可以用來(lái)查詢 DB2數(shù)據(jù)庫(kù)備份

41、文件的元數(shù)據(jù)。同時(shí)可以使用 db2ckbkp h備份文件 來(lái)檢 查DB2數(shù)據(jù)庫(kù)備份的類(lèi)型。3.1使用db2ckbkp hv備份文件 命令來(lái)查看DB2數(shù)據(jù)庫(kù)備份的類(lèi)型C:DocumentsandSettingsAdministrator>db2ckbkp-hd:db2backupNCCODB2.N0DE0000.CATN0000.20120206133232.001孕圜號(hào)屛綁呦 2, 335, 860 KB 001 文件 2012-2-5 1,. kC： ocunents and Settistrator>db2ckbkp -h d ：XbackupUCC.R-DB2 »N

42、ODEMEDIA HEADER REflCHED：Server Database NaneNCCServer Databaise AliasNCCClient Database AliasNCCTinestamp20120206133232Database PartiNumberQInstanceDB2Sequence Number1Release IDB00Database Seed 4EE3G6CEDE Coniment1 s202QDB Connent (UoliiineJDB Connent1s Codepage <Systen>2020DB Comment (System

43、)Autlientication Ualue32Backup NodeaIncludes Logs0Compression0Baclkup0Baclkup Gran.0Status Fl呂醪31System Cats inc1Catalog PartitIon Number0DB CodesetUTF-8DB Territori/Log ID1328195797LogPath一一 D:db2dataSDB2NODE0006sSQL000aiXSQLOGDIRSBackup Buffer Size-141280Number of Sessions1Platform5The pro per ima

44、ge f ile name wouild be:NCC.0.DD2.HODE0000.CATN000,20120206133232,0011 Buffers processed：ItnttttttttttttiltttttlttttHtttttlttttttttttttilftttNftttHtttttttttttttttttttltttttlttttHttttnttWitttttltttttttilttttnttUtltntitttttttilttttNftttNtInasfe Uerif ication Gonplets - successful r注意：我們可以通過(guò)上述輸出中的Backu

45、p Mode0Backup Iypc0Backup Gilani«0來(lái)確定備份的類(lèi)型。三個(gè)關(guān)鍵字的說(shuō)明如下： Backup Mode 0 offline（脫機(jī)備份h 1 - online（聯(lián)機(jī)備份） Backup Type 0 - fiilK全備份 3 tablespace（表空間級(jí)備份） Backup Gran. 0 notmaK正常備份）* 16 - incremental（增曜備份）48 - dclta（增量 delta 備份）incremental和delta的說(shuō)明如下：其中incrcmcntalf增債備份）和ckka（增章delta備份）的說(shuō)明如下*0 incrcmental（i«*備份）:增量備苗是最近-次成功的完余爺檢時(shí)慮之后的數(shù)據(jù)庫(kù) 操作的剔本.因?yàn)槊總€(gè)塔豪備份都包骨卜次増廉策份的內(nèi)容，所以也稱(chēng)為累 積備份°最近一次成