Rollforward after online backup

[Steven]

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.

[richard]

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..