数据库恢复出错处理

 

 进行数据库恢复的时候使用以下的命令：

    db2 restore db oadb user db2admin using db2admin

 

 恢复完成以后执行命令db2时报如下的错误：

$ db2 connect to oadb user db2inst3 using 3

SQL1117N  A connection to or activation of database "OADBE" cannot be made

because of ROLL-FORWARD PENDING.  SQLSTATE=57019

 

 解决办法如下：

P570:>db2 rollforward db oadb to end of logs and stops

或者

P570:>db2 rollforward db oadb to end of logs and complete

(db2 rollforward db oadb user db2inst3 using 3 to end of logs and complete )

恢复到指定时间点：
P570:>db2 " rollforward db oadbe to 2008-11-09-11:57.00 using local time and stop"

 

                                Rollforward Status

 

Input database alias                   = db

Number of nodes have returned status   = 1

 

Node number                            = 0

Rollforward status                     = not pending

Next log file to be read               =

Log files processed                    =  -

Last committed transaction             = 2005-11-20-10.59.23.000000

 

DB20000I  The ROLLFORWARD command completed successfully.