467,200 Members | 1,009 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,200 developers. It's quick & easy.

Rollforward after online backup

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
  • viewed: 8593
Share:
1 Reply
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.

Similar topics

1 post views Thread by Juan Norton | last post: by
18 posts views Thread by darnold@carreker.com | last post: by
3 posts views Thread by EC | last post: by
reply views Thread by smujifor | last post: by
2 posts views Thread by satish mullapudi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.