rollforwaring a database which is NOT is rollforwarding state

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Knokmans - 21 Oct 2004 12:31 GMT

Hi,

All of this is still a test envinonment, but has to go on production....
I restore a database a database the follwing way
db2 restore db <database> from <directory. taken at <timestamp> replace
existing
Then i only rollforward the (minumum) logs which are needed for recovery
db2 rollforward db <database> to end of logs and complete

The database in NOT in any pending state anymore
No connections to that database are made from now.
Later that day i want to rollforward some extra logfiles which are available
(later than backup timestamp)

But when invoking
db2 rollforward db <database> to end of logs and complete
gives the follwing error:
SQL1261N Database "<database>" is not in rollforward pending state on
node(s)
"0", so it does not need to be rolled forward on these nodes.

Is this someway possible ?? Maybe another syntax ??
I don't want to do a restore again and then do a rollforward of all logs....

Knokmans

Signature

---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

Reply to this Message

Bob [IBM] - 21 Oct 2004 13:51 GMT

As far as I know, once you say "and complete" you are telling DB2 that you are finished
rolling forward and it will start creating a new log chain. You are not allowed to roll
forward through this database again as it stands at that point-in-time. You would need to
restore once again and roll-forward. Your other option is to leave the db in roll forward
pending state (no 'and complete'), however this will not allow connections, as you know.

Signature

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position -
ask my cat!]

> Hi,
>
[quoted text clipped - 21 lines]
>
> Knokmans

Reply to this Message

Knokmans - 25 Oct 2004 14:58 GMT

OK that's clear

Knokmans

Signature

> As far as I know, once you say "and complete" you are telling DB2 that you
> are finished
[quoted text clipped - 34 lines]
>>
>> Knokmans

Reply to this Message

dbtoo_dbtoo - 25 Oct 2004 20:32 GMT

Let's say we have logretain set to recovery and we have luxury to take
offline backups every night at 2AM. How can we restore to a point in
time at 11AM the next day, should it be necessary. When we restore an
offline backup image, the database will not be kept in rollforward
pending state. How do we tell DB2 to rollforward all logs from 2AM to
11AM?

Thanks

> OK that's clear
>
[quoted text clipped - 38 lines]
> >>
> >> Knokmans

Reply to this Message

Pierre Saint-Jacques - 25 Oct 2004 23:57 GMT

Your restore command as a default option of WITH ROLLING FORWARD even
with an offline image because you are in LOGRETAIN=RECOVERY.
Just restore and when complete issue your roll forward command to a
point in time.
Should you need to restore and you do not want to roll forward, you MUST
issue WITHOUT ROLLING FORWARD.

If you take an online backup, then the restore will ALWAYS be a db that
is in ROLL FORWARD PENDING and it must be rollled forward to AT LEAST
the timestamp of the end of the backup. That info is in your recovery
history file.

Also, if you do this thru the Control Center, then you can get a command
that will do all of this as you want it to .
HTH, Pierre

> Let's say we have logretain set to recovery and we have luxury to take
> offline backups every night at 2AM. How can we restore to a point in
[quoted text clipped - 47 lines]
>>>>
>>>>Knokmans

Signature

Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Reply to this Message