概要:恢复文件原数据库名: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:24
Tablespace 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