创建删除测试表:
db2 backup db sample to /tmp
db2 "create table drop_test(id int) in USERSPACE1"
db2 "insert into drop_test values(1)"
db2 "drop table drop_test"
查看删除表DDL
db2 list history dropped table all for sample
DDL: CREATE TABLE "DB2INST1"."DROP_TEST" ( "ID" INTEGER )
IN "USERSPACE1"
恢复:
restore database sample rebuild with tablespace(USERSPACE1) from /tmp taken at 20110224043944 without rolling forward without prompting
问题出现,没有生成表的drop_test的数据文件
db2 rollforward database sample to end of logs and complete recover dropped table 0000000000007e4900020007
to
/tmp/_restore
最后只能做recover 恢复
recover database sample to 2011-02-24-04.41.13.490261 using local time
收起