DB2恢复

最新推荐文章于 2019-04-04 11:09:04 发布

最新推荐文章于 2019-04-04 11:09:04 发布 · 1.2k 阅读

文章标签：

#DB2

当遇到恢复数据库时出现ROLL-FORWARD错误（SQL57019），可以使用DB2的RESTORE命令结合日志路径进行数据库恢复。首先指定数据库名称和日志源路径，然后执行日志回滚到结束，从而完成恢复过程。

恢复数据库报ROLL-FORWARD错误（SQL57019），则执行日志回滚

restore db dbname from 路径 taken at *** logtarget 路径

日志路径即DATABASE DIRECTORY+SQLLOGDIR（通过list database directory on /home/db2inst1获取）

还原后执行 rollforward db dbname to end of logs and stop

注意这是在线备份数据库造成的错误，离线没有此错误抛出注意文件夹的权限允许日志写入另附上恢复时出现的异常情况： SQL2581N Restore is unable to extract log files or restore a log directory from the backup image to the specified path. Reason code rc. Explanation An error occurred while attempting to extract a log file from the backup image. This could be because one of the following reasons: 1 The backup image does not include logs. 2 The log target path specified could be full or invalid. 3 A log file name in the backup image matches a log file which already exists in the log target path. 4 There was an I/O error while trying to write the file. 5 The primary log directory on disk contains log files that will be destroyed by restore. 6 The mirror log directory on disk contains log files that