DB2恢復(fù)誤刪除表的實(shí)際操作代碼示例
作者：佚名
我們今天是要和大家一起分享的是DB2恢復(fù)誤刪除表的正確操作，以下就是文章DB2恢復(fù)誤刪除表的正確操作對(duì)的詳細(xì)內(nèi)容介紹，望大家借鑒。
我們今天主要向大家講述的是DB2恢復(fù)誤刪除表的實(shí)際操作代碼，你如果對(duì)DB2恢復(fù)誤刪除表的實(shí)際操作代碼有興趣的話你就可以點(diǎn)擊以下的文章進(jìn)行觀看了，以下就是文章對(duì)其實(shí)際操作代碼段的描述，望大家在瀏覽之后會(huì)對(duì)其有更深的了解。
刪除刪除
做了一次恢復(fù)誤刪除表的測(cè)試，具體過程如下：
- DB2 ALTER TABLESPACE USERSPACE2 DROPPED TABLE RECOVERY ON
- DB2 "list history dropped table all for cdbiold"
- DB2 backup db cdbiold to /databk with 2 buffers buffer 512
- DB2 "delete from DC_BILL_STATUS where count_time='20080731'"
- DB2 drop table DC_BILL_STATUS
- DB2 "select TBSPACE,DROP_RECOVERY from syscat.tablespaces where owner='DB2ADMIN'"
- DB2 "list history dropped table all for cdbiold"
- Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
- D T 20090317165133 000000000039210b00020006
- "DB2ADMIN"."DC_BILL_STATUS" resides in 1 tablespace(s):
- 00001 USERSPACE1
- Comment: DROP TABLE
- Start Time: 20090317165133
- End Time: 20090317165133
- Status: A
- EID: 39
- DDL: CREATE TABLE "DB2ADMIN"."DC_BILL_STATUS" ( "COUNT_TIME" VARCHAR(8) NOT NULL ,
- "ORG_CODE" VARCHAR(8) NOT NULL , "BILL_TYPE" VARCHAR(40) NOT NULL , "FLAG" CHAR(1) NOT NULL WITH DEFAULT 'N' ,
- "OPER" VARCHAR(64) NOT NULL WITH DEFAULT ' ' , "UP_FLAG" CHAR(1) NOT NULL WITH DEFAULT 'N' ) IN "USERSPACE1" ;
- DB2 force applications all
- DB2 restore db cdbiold from /databk taken at 20090317
- DB2 rollforward db cdbiold to end of logs and stop recover dropped table 000000000039210b00020006 to /databk
- DB2 "select count(*) from DC_BILL_STATUS where count_time='20080731'"
- DB2 import from /databk/NODE0000/data of del insert into DC_BILL_STATUS
以上的相關(guān)內(nèi)容就是對(duì)DB2恢復(fù)誤刪除表的介紹，望你能有所收獲。
【編輯推薦】
責(zé)任編輯：佚名
來源：
IT168
