DB2数据库回滚方法及回滚实例



1、还原数据库
db2 restore db dc from /db2_backup/dc taken at 20121102142900 with 1 buffers buffer 256

2、回滚数据库，1>和2>只执行其一。

1>、作用是将数据库回滚到最新日志时间
db2 rollforward db dc to end of logs and stop

2>、作用将数据库回滚到指定时间
db2 rollforward db dc to 2012-11-08-14.05.27 using local time

3、完成数据库回滚
db2 rollforward db dc stop

4、下面是一个还原数据库并进行回滚的一个例子。

$ db2stop force
SQL1064N  DB2STOP processing was successful.
$ db2start
SQL1063N  DB2START processing was successful.
$ db2 restore db dc from /db2_backup/dc taken at 20121102142900 with 1 buffers buffer 256
SQL2539W  Warning!  Restoring to an existing database that is the same as the backup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
DB20000I  The RESTORE DATABASE command completed successfully.