请问DB2的数据如何恢复？

谢谢楼上的，我再试一下收起

或者只用automatic参数看看：
db2 restore db cisfedb iincremental automatic from /db2_backup/cisfedb/0/db2inst1/NODE0000/CATN0000 taken at 20090903020010收起

db2ckrst -d cisfedb -t 20090903020010 -r database

按照上面命令运行产生的恢复建议操作收起

报错是因为上一次还原没有成功结束，所以数据库不可用。
关于备份和恢复建议你操作前先做好功课。DB2china上有很多这方面的精品文章，你搜索一下。
例如：http://www.db2china.net/club/thread-562-1-1.html收起

要使用什么命令才能让恢复的数据库起作用啊？:Q收起

现在根据网上查的资料，使用命令
db2 restore db cisfedb incremental from /db2_backup/cisfedb/0/db2inst1/NODE0000/CATN0000 taken at 20090903020010

然后提示， the restore databse command completed successfully.

但我使用db2 connect to cisfedb

还是报:
A connection to or activetion of databse "CISFEDB" cannot be made.
because a previous restore is incomplete SQLSTATE=57019收起

有没有高手再发表一下意见啊，谢谢!收起

刚才在网上查到一句命令，用了一下，好象还是有问题
db2 restore database cisfedb from /db2_backup taken at 20070623200059 redirect without rolling forward

现在使用db2 connect to cisfedb命令，报这样的错误了
connecting to a database is not permitted within a logical unit of work
when the connect type 1 setting is in use

问题还是没解决收起

那db2untag应该怎么写？:L
所有的都untag掉？ 还是有其它的写法?收起

通过以下语句建表空间的
drop tablespace TBS_IDX4K;
CREATE REGULAR TABLESPACE TBS_IDX4K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_idx01'50M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;
drop tablespace TBS_LOB1;
CREATE LARGE TABLESPACE TBS_LOB1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE
         USING (FILE '/db2_large/tbs_lob1.dat'6000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF32K         
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000;
drop tablespace TBS_LOB2;
CREATE LARGE TABLESPACE TBS_LOB2 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE
         USING (FILE '/db2_large/tbs_lob2.dat'6000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF32K
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000;

drop tablespace TBS_8K;
CREATE REGULAR TABLESPACE TBS_8K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_dta02'100M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF8K
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;
         
CREATE SYSTEM TEMPORARY TABLESPACE TBS_systmp IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 4096 MANAGED BY SYSTEM         USING ('/db2_systmp')
         EXTENTSIZE 8
         BUFFERPOOL IBMDEFAULTBP;
DROP TABLESPACE TEMPSPACE1;

DROP TABLESPACE TBS_IDX_CISA_E, TBS_TABLE_CISA_E;

CREATE REGULAR TABLESPACE TBS_TABLE_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_jf_dta01'500M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;


CREATE REGULAR TABLESPACE TBS_IDX_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_jf_idx01'250M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;


drop tablespace userspace1;

CREATE REGULAR TABLESPACE USERSPACE1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_dta01'1000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;收起