By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

Rollforward after online backup

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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..
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.