db2不同路径还原问题 SQLSTATE=57019 SQL1051N

来源：互联网发布：中国工业软件市场规模编辑：程序博客网时间：2024/06/06 08:42

-------------------------------一下服务器中操作-------------------------------------------------
db2 => db2stop force
DB20000I DB2STOP命令成功完成。
db2 => db2start
DB20000I DB2START命令成功完成。
db2 => backup db sem to D:\myZone

备份成功。此备份映像的时间戳记是：20140718100400

-------------------------------------------一一下为本地操作-------------------------------------
C:\Program Files\IBM\SQLLIB\BIN>db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400
SQL1051N 路径 "e:\bak" 不存在。 SQLSTATE=57019

C:\Program Files\IBM\SQLLIB\BIN>db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400 ON "e:\bak" DBPATH ON "D:\BACKUP" INTO SEM
SQL1052N 数据库路径 "D:\BACKUP" 不存在。

C:\Program Files\IBM\SQLLIB\BIN>db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400 ON "e:\bak" DBPATH ON "D:\BACKUP" INTO SEM
SQL1052N 数据库路径 "D:\BACKUP" 不存在。

C:\Program Files\IBM\SQLLIB\BIN>db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400
SQL1051N 路径 "e:\bak" 不存在。 SQLSTATE=57019

C:\Program Files\IBM\SQLLIB\BIN>db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400 ON "e:\bak" DBPATH ON "D:\BACKUP" INTO SEM
SQL1052N 数据库路径 "D:\BACKUP" 不存在。

C:\Program Files\IBM\SQLLIB\BIN>DB2 restore database SEM from "d:/sem_db_backup_2014-7-18" taken at 20140718100400 on "D:\BACKUP" dbpath on "d:" into SEM
DB20000I RESTORE DATABASE命令成功完成。

C:\Program Files\IBM\SQLLIB\BIN>db2 ROLLFORWARD DATABASE SEM TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH ('d:\sem_db_backup_2014-7-18')

前滚状态

输入数据库别名 = SEM
节点数已返回状态 = 1

节点号 = 0
前滚状态 = 未暂挂
下一个要读取的日志文件 =
已处理的日志文件 = -
上次落实的事务 = 2014-07-18-02.04.21.000000 UTC

DB20000I ROLLFORWARD命令成功完成。

C:\Program Files\IBM\SQLLIB\BIN>
==================================================================================
总结如下：
“同盘符”还原：
①还原数据：
db2 restore db SEM FROM d:\sem_db_backup_2014-7-18 taken at 20140718100400
②还原日志：
db2 ROLLFORWARD DATABASE SEM TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH ('d:\sem_db_backup_2014-7-18')

==================================================================================
不“同盘符”还原：
①还原数据：
restore database SEM from "d:/sem_db_backup_2014-7-18" taken at 20140718100400 on "D:\BACKUP" dbpath on "d:" into SEM
②还原日志：
db2 ROLLFORWARD DATABASE SEM TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH ('d:\sem_db_backup_2014-7-18')

0 0