重定向恢復DB2操作指引

如果DB2鏡像的數(shù)據庫存儲路徑與目標恢復的路徑不一致，需要用重定向的方式恢復數(shù)據庫，否則會出現(xiàn)報錯。如下是直接恢復時的報錯：SQL20321NStoragepathscannotbeprovidedbecausethedatabaseisnotenabledforautomaticstorage.SQLSTATE=55062解決方法：表示需要恢復的OS環(huán)境中的路徑不滿足原鏡像主機恢復時所需的路徑，需要將數(shù)據庫恢復的命令中on修改為to，并且需要增加重定向指令：執(zhí)行后出現(xiàn)如下提示：SQL1277W Aredirectedrestoreoperationisbeingperformed. Tablespaceconfigurationcannowbeviewedandtablespacesthatdonotuseautomatic storagecanhavetheircontainersreconfigured.DB20000I TheRESTOREDATABASEcommandcompletedsuccessfully.分析表空間：C:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacesTablespacesforCurrentDatabaseTablespaceID =0Name =SYSCATSPACEType =SystemmanagedspaceContents =Allpermanentdata.Regulartablespace.State =0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID =1Name =TEMPSPACE1Type =SystemmanagedspaceContents =SystemTemporarydataState =0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID =2Name =USERSPACE1Type =SystemmanagedspaceContents =Allpermanentdata.Regulartablespace.State =0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID

=3NameTypeContentsState

=AMWAY4=Systemmanagedspace=SystemTemporarydata=0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID

=4NameTypeContentsState

=TEMP_SPACE=Systemmanagedspace=UserTemporarydata=0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID

=5NameTypeContentsState

=AMWAY4_LARGE=Systemmanagedspace=Allpermanentdata.Regulartablespace.=0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefinedTablespaceID

=6NameTypeContentsState

=SYSTOOLSPACE=Systemmanagedspace=Allpermanentdata.Regulartablespace.=0x2001100Detailedexplanation:RestorependingStoragemustbedefinedStoragemaybedefined查看每個表空間的容器情況： 標識出的未恢復的新的路徑，

需要手動配置。標識出的路徑是源鏡像的數(shù)據路徑，但目標服務器無法提供此路徑，所以會出錯。C:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor0TablespaceContainersforTablespace0ContainerID=0Name=C:\DB2\NODE0000\SQL00001\SQLT0000.0Type=PathTablespaceContainersforTablespace1ContainerID =0Name =C:\DB2\NODE0000\SQL00001\SQLT0001.0Type =PathTablespaceContainersforTablespace2ContainerID =0Name =C:\DB2\NODE0000\SQL00001\SQLT0002.0Type =PathC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor3showdetailTablespaceContainersforTablespace3ContainerID =0Name =E:\Tablespaces\PRODHRType =PathTotalpages =0Useablepages =0Accessible =NoC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor4showdetailContainerID =0Name =E:\Tablespaces\PRODHR_TEMP_SPACEType =PathTotalpages =0Useablepages =0Accessible =NoC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor5showdetailTablespaceContainersforTablespace5ContainerID =0Name =E:\Tablespaces\PRODHR_LARGEType =PathTotalpages =0Useablepages =0Accessible =NoC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor6showdetailTablespaceContainersforTablespace6ContainerID =0Name =C:\DB2\NODE0000\SQL00001\SYSTOOLSPACEType =PathTotalpages =0Useablepages =0Accessible =No用如下命令修改新合適的路徑：db2"settablespacecontainersfor3using(path'C:\DB2\Tablespaces\PRODHR')"db2"settablespacecontainersfor4using(path'C:\DB2\Tablespaces\PRODHR_TEMP_SPACE')"db2"settablespacecontainersfor5using(path'C:\DB2\Tablespaces\PRODHR_LARGE')"成功會返回如下結果：DB20000I TheSETTABLESPACECONTAINERScommandcompletedsuccessfully.錯誤的例子：如果類型是 file時，需要指定 file文件的page數(shù)量，例如：db2"settablespacecontainersfor3using(file'/fangys_db/fangys_tbs.dbf'10000)"通過”db2listtablespacecontainersfor3showdetail可”以查看 page數(shù)量。C:\ProgramFiles\IBM\SQLLIB\BIN>db2"settablespacecontainersfor3using(file'C:\DB2\PRODHR'100)"SQL0298NBadcontainerpath. SQLSTATE=428B2C:\ProgramFiles\IBM\SQLLIB\BIN>db2"settablespacecontainersfor3using(path'C:\DB2\Tablespaces\PRODHR'100)"SQL0104NAnunexpectedtoken"100"wasfoundfollowing"<character-string>".Expectedtokensmayinclude:")". SQLSTATE=42601完成后繼續(xù) restoredb2"restoredatabasePRODHRcontinue"C:\ProgramFiles\IBM\SQLLIB\BIN>db2"restoredatabasePRODHRcontinue"DB20000I TheRESTOREDATABASEcommandcompletedsuccessfully.db2getdbcfgforprodhrC:\ProgramFiles\IBM\SQLLIB\BIN>db2getdbcfgforprodhr?Backuppending

=NOAllcommittedtransactionshavebeenwrittentodisk

=NORollforwardpendingRestorepending

=DATABASE=NO?前滾日志：（如果生成鏡像無日志輸出，則無需此步驟，需通過查看

dbcfg的狀態(tài)判斷）db2rollforwarddatabasePRODHRtoendoflogsandcompleteoverflowlogpath(C:\DB2\data)C:\ProgramFiles\IBM\SQLLIB\BIN>db2rollforwarddatabasePRODHRtoendoflogsandcompleteoverflowlogpath(C:\DB2\data)InputdatabasealiasNumberofnodeshavereturnedstatus

RollforwardStatus=PRODHR=1NodenumberRollforwardstatus

=0=notpendingNextlogfiletoberead

=Logfilesprocessed

=S0790330.LOG-S0790330.LOGLastcommittedtransaction DB20000I TheROLLFORWARDcommandcompletedsuccessfully.再次查看配置 :db2getdbcfgforprodhrBackuppending =NOAllcommittedtransactionshavebeenwrittentodisk =YESRollforwardpending =NORestorepending =NO連接數(shù)據庫C:\ProgramFiles\IBM\SQLLIB\BIN>db2connecttoprodhrDatabaseConnectionInformationDatabaseserver SQLauthorizationID =ADMINIST...Localdatabasealias =PRODHR查看數(shù)據庫位置：C:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor3showdetailTablespaceContainersforTablespace3ContainerID =0Name =C:\DB2\Tablespaces\PRODHRType =PathTotalpages =1Useablepages =1Accessible =YesC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor4showdetailTablespaceContainersforTablespace4ContainerID =0Name =C:\DB2\Tablespaces\PRODHR_TEMP_SPACEType =PathTotalpages =1Useablepages =1Accessible =YesC:\ProgramFiles\IBM\SQLLIB\BIN>db2listtablespacecontainersfor5showdetailTablespaceContainersforTablespace5ContainerID =0Name =C:\DB2\Tablespaces\PRODHR_LARGEType =PathTotalpages =3130Useablepages =3130Accessible =Yes出師表兩漢：諸葛亮先帝創(chuàng)業(yè)未半而中道崩殂，今天下三分，益州疲弊，此誠危急存亡之秋也。然侍衛(wèi)之臣不懈于內，忠志之士忘身于外者