[DB2]db2重定向恢复

本文主要是介绍[DB2]db2重定向恢复，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

概要：恢复文件原数据库名:TEST，恢复目标数据库名:TEST123，恢复文件目录：/home/db2inst1下，恢复方式：重定向（REDIRECT）

1.将TEST数据库的备份文件恢复到TEST123库

[root@db2 ~]# su - db2inst1

[db2inst1@db2 ~]$db2 RESTORE DATABASE TEST FROM '/home/db2inst1' TAKEN AT 20140910164553 INTO TEST123 REDIRECT WITHOUT ROLLING FORWARD
SQL1277W  A redirected restore operation is being performed.  Table space
configuration can now be viewed and table spaces that do not use automatic
storage can have their containers reconfigured.
DB20000I  The RESTORE DATABASE command completed successfully.

[db2inst1@db2 ~]$ db2pd -db TEST123 -tablespaces
Database Partition 0 -- Database TEST123 -- Active -- Up 0 days 00:36:04 -- Date 06/02/2015 05:15:24Tablespace Configuration:
Address            Id    Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe  LastConsecPg Name
0x00002AAB2B1D4B20 0     DMS  Regular 8192   4        Yes  4        1     1         Off 1        0          3            SYSCATSPACE
0x00002AAB2B1D6220 1     SMS  SysTmp  8192   128      Yes  128      1     1         On  1        0          127          

这篇关于[DB2]db2重定向恢复的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---