急！如何恢復(fù)數(shù)據(jù)庫(kù)，大蝦指教

huyuhui001

1。tbs1、tbs2、tbs3是什么意思？自己定義的？
對(duì)，是自己定義的。在這里例子里面，表空間都是SMS，所以重定向的時(shí)候是path，tbs1也是一個(gè)目錄
2。還有我用的是SUSE LINUX 9操作系統(tǒng)，上邊的方法適合嗎？
適用，DB2 is DB2, no matter what platform。
3。set命令的是不是都作呀，
對(duì)，對(duì)每個(gè)表空間都做，要區(qū)分path，file和disk。

2easy4me

db2 "restore db cisfedb from /db2_backup taken at 20070617020002 redirect"
db2 "set tablespace containers for 0 using (path '/db2_backup/tbs1')"
db2 "set tablespace containers for 1 using (disk '/db2_backup/tbs2')"
db2 "set tablespace containers for 2 using (disk '/db2_backup/tbs3')"
db2 "set tablespace containers for 3 using (disk '/db2_backup/tbs4')"
db2 "set tablespace containers for 4 using (file '/db2_backup/tbs5')"
db2 "set tablespace containers for 5 using (file '/db2_backup/tbs6')"
db2 "set tablespace containers for 6 using (path '/db2_backup/tbs7')"
db2 "set tablespace containers for 7 using (disk '/db2_backup/tbs8')"
db2 "set tablespace containers for 8 using (disk '/db2_backup/tbs9')"
db2 "set tablespace containers for 9 using (path '/db2_backup/tbs10')"
db2 "restore db cisfedb continue"
第一種方法就是在備份路徑下自己mkdir 10個(gè)目錄，然后重定向

db2 "restore db cisfedb from /db2_backup taken at 20070617020002 redirect"
db2 "set tablespace containers for 0 using (path '/db2_db/db2inst1/NODE0000/SQL00001/SQLT0000.0')"
db2 "set tablespace containers for 1 using (disk '/dev/mapper/data_vg-db2_jf_dta01')"
db2 "set tablespace containers for 2 using (disk '/dev/mapper/data_vg-db2_dta01')"
db2 "set tablespace containers for 3 using (disk '/dev/mapper/data_vg-db2_idx01)"
db2 "set tablespace containers for 4 using (file '/db2_large/tbs_lob1.dat')"
db2 "set tablespace containers for 5 using (file '/db2_large/tbs_lob2.dat')"
db2 "set tablespace containers for 6 using (path '/db2_db/db2inst1/NODE0000/SQL00001/./db2_systmp')"
db2 "set tablespace containers for 7 using (disk '/dev/mapper/data_vg-db2_jf_idx01')"
db2 "set tablespace containers for 8 using (disk '/dev/mapper/data_vg-db2_dta02')"
db2 "set tablespace containers for 9 using (path '/db2_db/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE')"
db2 "restore db cisfedb continue"
第二種方法是通過(guò)list tablespace containers for 0\1\2 命令得到的路徑
還有file   disk的用法對(duì)嗎？
現(xiàn)在拿不準(zhǔn)不敢瞎做！

2easy4me

第二種方法中的
db2 "set tablespace containers for 3 using (disk '/dev/mapper/data_vg-db2_idx01)"
db2 "set tablespace containers for 4 using (file '/db2_large/tbs_lob1.dat')"
路徑后邊還應(yīng)該加上number of pages
這個(gè)number of pages是不是使用命令list tablespaces show detail
顯示出來(lái)的信息中“total pages”項(xiàng)呀

huyuhui001

第二種方法可以。
1。對(duì)于disk和file，要指定大小的，只有path是例外。比如
using (disk '/dev/mapper/data_vg-db2_jf_dta01' 20000)
2。file和disk的名字可以不必和源數(shù)據(jù)庫(kù)相同，只要對(duì)應(yīng)一樣的類型即可。特別對(duì)于disk，在目標(biāo)機(jī)器上要存在并能被實(shí)例用戶使用。比如
源機(jī)器上是/dev/mapper/data_vg-db2_jf_dta01
目標(biāo)機(jī)器可以是/dev/mapper/jf_dta01（名字可以不同，但/dev/mapper/jf_dta01在目標(biāo)機(jī)器上要有，實(shí)例用戶有權(quán)限用）

對(duì)于命令的具體使用，可以參考
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

建議你現(xiàn)在自己的機(jī)器上把整個(gè)過(guò)程做一遍。

[ 本帖最后由 huyuhui001 于 2007-6-21 09:52 編輯 ]

2easy4me

db2 "restore db cisfedb from /db2_backup taken at 20070617020002 redirect"
db2 "set tablespace containers for 0 using (path '/db2_db/db2inst1/NODE0000/SQL00001/SQLT0000.0')"
db2 "set tablespace containers for 1 using (device '/dev/mapper/data_vg-db2_jf_dta01' 128000)"
db2 "set tablespace containers for 2 using (device '/dev/mapper/data_vg-db2_dta01' 256000)"
db2 "set tablespace containers for 3 using (device '/dev/mapper/data_vg-db2_idx01' 12800)"
db2 "set tablespace containers for 4 using (file '/db2_large/tbs_lob1.dat' 192000)"
db2 "set tablespace containers for 5 using (file '/db2_large/tbs_lob2.dat' 192000)"
db2 "set tablespace containers for 6 using (path '/db2_db/db2inst1/NODE0000/SQL00001/./db2_systmp')"
db2 "set tablespace containers for 7 using (device '/dev/mapper/data_vg-db2_jf_idx01' 64000)"
db2 "set tablespace containers for 8 using (device '/dev/mapper/data_vg-db2_dta02' 12800)"
db2 "set tablespace containers for 9 using (path '/db2_db/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE')"
db2 "restore db cisfedb continue"
我按照上邊的步驟作了，但是提示以下錯(cuò)誤
SQL1117N  A connection to or activation of database "CISFEDB" cannot be made
because of ROLL-FORWARD PENDING.  SQLSTATE=57019

2easy4me

是不是少做什么了，能不能幫我整理完整！謝謝了，總算restore successfully!

2easy4me

剛才沒(méi)有說(shuō)清楚，是restore完成后我connect to cisfedb然后抱錯(cuò)
SQL1117N  A connection to or activation of database "CISFEDB" cannot be made
because of ROLL-FORWARD PENDING.  SQLSTATE=57019

huyuhui001

你的數(shù)據(jù)庫(kù)是歸檔模式的，把源數(shù)據(jù)庫(kù)log拷貝到目標(biāo)數(shù)據(jù)庫(kù)，然后做一下這個(gè)
db2 rollforward database CISFEDB to end of logs using local time and complete

2easy4me

我快崩潰了，備機(jī)上有個(gè)20070618164606的備份，我用這個(gè)備份重新作了redirect
db2 "set tablespace containers for 6 using (path '/db2_db/db2inst1/NODE0000/SQL00001/./db2_systmp')"
db2 "set tablespace containers for 7 using (device '/dev/mapper/data_vg-db2_jf_idx01' 64000)"
做這兩步的時(shí)候又出來(lái)個(gè)新的錯(cuò)誤
SQL0298N  Bad container path.  SQLSTATE=428B2
我最后又執(zhí)行db2 rollforward database CISFEDB to end of logs using local time and complete
也提示錯(cuò)誤：SQL0104N  An unexpected token "using" was found following "LOGS".  Expected
tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601
心情沮喪到極點(diǎn)了！

huyuhui001

1.
db2 "set tablespace containers for 6 using (path '/db2_db/db2inst1/NODE0000/SQL00001/./db2_systmp')"
db2 "set tablespace containers for 7 using (device '/dev/mapper/data_vg-db2_jf_idx01' 64000)"
做這兩步的時(shí)候又出來(lái)個(gè)新的錯(cuò)誤
SQL0298N  Bad container path.  SQLSTATE=428B2

你要檢查6，7和原來(lái)的對(duì)應(yīng)關(guān)系是不是一樣，比如都是用的SMS或者DEVICE。
對(duì)于6，”/./db2_systmp“這里面有個(gè)”點(diǎn)“嗎？
對(duì)于7，device在目標(biāo)機(jī)器上正確么？
對(duì)于7，每次失敗重做的時(shí)候，要先untag一下

2。db2 ”rollforward database CISFEDB to end of logs and complete “

[ 本帖最后由 huyuhui001 于 2007-6-23 08:33 編輯 ]