DB2异机导入备份数据
请教，我从其他DB2数据库中的备份整个库然后导入到现在测试库实例中。一直无法导入，我看到网上有论坛中提到要与之前备份数据库的文件路径一致，然后我创建了跟之前备份数据库中的一样的文件目录。依然不能导入DB2数据。[db2inst1@localhost ~]$ db2 restore database qydb fr...显示全部
查看其它 12 个回答alan9668的回答
回复 4# 新数科技
非常感谢您的指导。根据您的指导我做了如下操作。[db2inst1@localhost ~]$ db2 restore database qydb from /home/db2backup/ taken at 20150727010015
SQL2523W Warning! Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version. The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL1051N The path "/db2data/qydb/data" does not exist or is not valid.
SQLSTATE=57019
从操作中来看发现好像还是错误的。
非常感谢您的指导。根据您的指导我做了如下操作。[db2inst1@localhost ~]$ db2 restore database qydb from /home/db2backup/ taken at 20150727010015
SQL2523W Warning! Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version. The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL1051N The path "/db2data/qydb/data" does not exist or is not valid.
SQLSTATE=57019
从操作中来看发现好像还是错误的。
浏览2801