ra*******@yahoo.com (Steven) wrote in message news:<10**************************@posting.google. com>...
Ok W2K DB2 v8.1 fix pack 5.
On production I took a an online backup of production and copied it
over to my staging environment.
restored the production database on top of staging database redirect.
I copied over all the log files from production box to a temp
directory.
restore was complete with redirect and staging went into roll forward
pending.
RAN:
db2 rollforward db staging to end of logs com complete overflow log
path (d:\temp\logs)
got the following error
SQL1276N Database "WSWSTAGE" cannot be brought out of rollforward
pending
state until roll-forward has passed a point in time greater than or
equal to
"2004-09-30-14.58.53.000000", because node "0" contains information
later than
the specified time.
RAN:
db2 rollforward db staging query status
Rollforward Status
Input database alias = wswstage
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB working
Next log file to be read = S0103402.LOG
Log files processed = -
Last committed transaction = 2004-09-25-18.16.23.000000
can not rollforward complete and that log file is in the temp\logs
directory.
Any one have any idea why this would happen and what I could do to get
back my database.
Y need to copy all the active log to your local directory also..