东西 发表于 2009-09-19 10:37

请教:关于informix大批量数据的导出与导入

现在机器上有多个实例，其中有一个实例数据量大概有５００万，现在想把它备份出来．有以下几种方案
１：以前都是使用的零级备份，但是这种方法恢复的时候回影响到别的实例的使用．
２：如果使用dbexport话，dbimport的时候肯定会长事务．
３：使用dbschema把结构先导出来，然后根据select * from systables where tabid >99的结果把所有的表都unload出来，
　　导入的时候先把库结构恢复，再使用onpload把unl导进去

不知道大家是不是有什么别的方案能有又快有好的备份恢复：）

Fly_Tiger 发表于 2009-09-19 14:40

东西 发表于 2009-09-19 15:56

使用onunload工具是不是也可以啊?

xxyyy 发表于 2009-09-19 16:10

dbexport就可以，导入的时候dbimport不要加-l参数就可以不启用事务，当然也就不会长事务。导入完毕，再用ontape命令把数据库改为日志模式就可以了，这个是最简单的方法

东西 发表于 2009-09-21 09:09

dbexport导入的话如果数据量比较大的话会很慢吧,我试着用onunload导了一把,但是报下面这样的信息,这样恢复的时候会不会有问题?

Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.
Warning: The given database or table contains column(s) of user defined
datatype. Onload and Onunload do not handle such data types. The load may not
be successful or may not load back the correct data.

liaosnet 发表于 2009-09-21 09:44

回复 #5 东西 的帖子

可能会有问题~~这里提示的是你的库/表里有自定义的字段类型..导入的话可能存在门题..
页: [1]
查看完整版本: 请教:关于informix大批量数据的导出与导入