论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2005-01-04 14:50 |只看该作者 |倒序浏览

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

有高手愿意详细解释一下不？