标题: DB2 restore 后rollforward的怪现象 [打印本页] 作者: 007linxx 时间: 2005-01-04 14:50 标题: DB2 restore 后rollforward的怪现象 1、数据库做的online备份；
2、重定向恢复后做rollforward，第一次开始rollforward时用的是end of logs，没有successful，提示next日志没有找到；以online备份后产生的归档日志的时间戳为基准，重新指定roll至的时间点，提示必须滚到end of logs，可是俺想roll到某个特定的时间点啊，滚到end of logs时间太长太长了；
3、从QUERY STATUS得到的提示看，数据库已经roll完了online backup阶段产生的日志，并给出了最近一次事务commit的时间点；
4、但是，connect时还是提示处于rollforward pending状态；
5、奇怪的事情出现了；俺在重新执行rollforward to end of logs(还是那些个数量的日志）时同时connect数据库，居然connect上了，roll的那个界面出现了数据库正在使用的报错；
$ db2 connect to prd
Database Connection Information
Database server = DB2/AIX64 7.2.9
SQL authorization ID = DB2PRD
Local database alias = PRD
$ db2 get db cfg for prd
..................................................
Backup pending = NO
Database is consistent = NO
Rollforward pending = DATABASE
Restore pending = YES
Multi-page file allocation enabled = NO
...................................................
$ db2 list applications show detail
Auth Id Application Name Appl. Application Id
Seq# Number of Coordinating Coordinator Status
Status Change Time DB Name DB Path
Handle
Agents Node Number pid/thread
------------------------------ -------------------- ---------- -----------------
------------- ---- ---------- ------------ --------------- ---------------------
--------- -------------------------- -------- --------------------
DB2PRD db2bp 22 *LOCAL.db2prd.050
104053448 0001 1 0 45508 UOW Waiting
Not Collected PRD /db2/PRD/db2prd/NODE0000/SQL00001/
$ db2 force applications all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
$ db2 list applications show detail
SQL1611W No data was returned by Database System Monitor. SQLSTATE=00000
$ db2 backup db prd to /dev/rmt3 with 8 buffers buffer 512
SQL2406N The BACKUP cannot be performed because the database needs to be
rolled forward. SQLSTATE=57019
$ db2 connect to prd
SQL1117N A connection to or activation of database "RD" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
$ db2 "rollforward db prd stop
>; "
SQL1035N The database is currently in use. SQLSTATE=57019
$ db2 "rollforward db prd complete"
SQL1035N The database is currently in use. SQLSTATE=57019
一旦俺把应用都force掉，再重新connect时，又开始提示：
SQL1117N A connection to or activation of database "RD" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
RD" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019