重定向恢复DB2操作指引

如果DB2镜像的数据库存储路径与目标恢复的路径不一致，需要用重定向的方式恢复数据库，否则会出现报错。如下是直接恢复时的报错：SQL20321NStoragepathscannotbeprovidedbecausethedatabaseisnotenabledforautomaticstorage.SQLSTATE=55062解决方法：表示需要恢复的OS环境中的路径不满足原镜像主机恢复时所需的路径，需要将数据库恢复的命令中on修改为to，并且需要增加重定向指令：执行后出现如下提示：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查看每个表空间的容器情况： 标识出的未恢复的新的路径，

需要手动配置。标识出的路径是源镜像的数据路径，但目标服务器无法提供此路径，所以会出错。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数量，例如：db2"settablespacecontainersfor3using(file'/fangys_db/fangys_tbs.dbf'10000)"通过”db2listtablespacecontainersfor3showdetail可”以查看 page数量。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完成后继续 restoredb2"restoredatabasePRODHRcontinue"C:\ProgramFiles\IBM\SQLLIB\BIN>db2"restoredatabasePRODHRcontinue"DB20000I TheRESTOREDATABASEcommandcompletedsuccessfully.db2getdbcfgforprodhrC:\ProgramFiles\IBM\SQLLIB\BIN>db2getdbcfgforprodhr⋯Backuppending

=NOAllcommittedtransactionshavebeenwrittentodisk

=NORollforwardpendingRestorepending

=DATABASE=NO⋯前滚日志：（如果生成镜像无日志输出，则无需此步骤，需通过查看

dbcfg的状态判断）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连接数据库C:\ProgramFiles\IBM\SQLLIB\BIN>db2connecttoprodhrDatabaseConnectionInformationDatabaseserver SQLauthorizationID =ADMINIST...Localdatabasealias =PRODHR查看数据库位置：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出师表两汉：诸葛亮先帝创业未半而中道崩殂，今天下三分，益州疲弊，此诚危急存亡之秋也。然侍卫之臣不懈于内，忠志之士忘身于外者