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.