情况描述:DB2如果drop table T_M_COOP_TASK;删了一个表,是没办法恢复的,需要还原备份文件,从备份文件中拿出一份相对较新的文件在本地创建后,导出,再导入生产库:
步骤一、把服务器上备份文件《POSITION.0.DB2.NODE0000.CATN0000.20161216170755.001》下载到本机。注意不能改名,恢复时候需要用到次文件名的。
注意本地安装的DB2和服务器的DB2版本一致:
步骤二、创建一个本地的库:
步骤三、恢复脚本:
执行三个命令:
db2 create db dbname
db2 restore db dbname FROM E:\DB2\backup\ taken AT 20081016193629
db2 rollforward db dbname to end of logs and stop
加上主键:
db2 catalog db position as p1 at node nodename
从本地数据库导出到文本:
export to F:\hycode\initdata\T_M_REGION89.txt OF DEL select * from T_M_REGION
步骤四、从文本导入到生产库:
import from d:\gsxx.txt of del insert into tp_gsxx:
或者:import from d:\sy\ajxx.txt of del modified by compound=50 commitcount 200 insert into DB2INST2.tp_ajxx;
步骤一、把服务器上备份文件《POSITION.0.DB2.NODE0000.CATN0000.20161216170755.001》下载到本机。注意不能改名,恢复时候需要用到次文件名的。
注意本地安装的DB2和服务器的DB2版本一致:
步骤二、创建一个本地的库:
步骤三、恢复脚本:
执行三个命令:
db2 create db dbname
db2 restore db dbname FROM E:\DB2\backup\ taken AT 20081016193629
db2 rollforward db dbname to end of logs and stop
加上主键:
db2 catalog db position as p1 at node nodename
从本地数据库导出到文本:
export to F:\hycode\initdata\T_M_REGION89.txt OF DEL select * from T_M_REGION
步骤四、从文本导入到生产库:
import from d:\gsxx.txt of del insert into tp_gsxx:
或者:import from d:\sy\ajxx.txt of del modified by compound=50 commitcount 200 insert into DB2INST2.tp_ajxx;