Missing Log for Rollforward

DB_N00b · #1 (**permalink**) 08-15-11, 08:13

hello there!

I have a problem. I made a redirected restore and now i want to make the rollforward to make the database accessable.

Quote:

db2 "rollforward db rmdwh query status"

Rollforward Status

Input database alias = databasedwh
Number of nodes have returned status = 1

Node number = 0
Rollforward status = DB working
Next log file to be read = S0000014.LOG
Log files processed = -
Last committed transaction = 2011-01-01-03.00.00.000000 UTC

Quote:

db2 "rollforward db database stop"
SQL1276N Database "Database" cannot be brought out of rollforward pending state
until roll-forward has passed a point in time greater than or equal to
"2011-01-01-03.00.00.000000 UTC", because node "0" contains information later
than the specified time.

DB_N00b · #2 (**permalink**) 08-15-11, 08:15

Now I read something about the rollforward stop command.
I have no chance to get the log file back. is there an other way to make the database running? I am thankful for each help.

db2girl · #3 (**permalink**) 08-15-11, 16:59

What db2 version are you using? Check if the logs were included with this backup image.

przytula_guy · #4 (**permalink**) 08-16-11, 02:49

if it was an offline backup - you can rollforward stop
if online ?? or included in backup - specify the logpath to extract the logs while restoring or rerun the restore with option logs - will only extract logs

DB_N00b · #5 (**permalink**) 08-16-11, 03:12

The log was lost and so I was not able to made a restore ...
Thank you for your help.

skchandra · #6 (**permalink**) 08-16-11, 03:36

Quote:

if it was an offline backup - you can rollforward stop
if online ?? or included in backup - specify the logpath to extract the logs while restoring or rerun the restore with option logs - will only extract logs

To add more info on what przytula_guy said, information on backup image can be extracted by using,

Code: