DB2数据库异地备份恢复注意事项

Db2恢复的事项：

1. db2 restore db dbname taken at timestamp on /dbpath  logtarget /dblog redirect

SQL1277W  A redirected restore operation is being performed.  Table space

configuration can now be viewed and table spaces that do not use automatic

storage can have their containers reconfigured.

DB20000I  The RESTORE DATABASE command completed successfully.

$(请使用restore完成的那个db2窗口做set tablespace containers 操作，也就是restore完后，接着做set tablespace containers ，否则数据库会认为没有连接)

$ db2 list tablespaces show detail查看下表空间状态

$ set tablespace container for ID using(device or file “/” pages)

$ restore db atm_db continue

这一步完了之后把/dblog产生的log文件cp到db的log路径下面，这样才能从log之中去回滚数据库

$ rollforward database dbname to end of logs and complete

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15082138/viewspace-620795/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15082138/viewspace-620795/