rollforwaring a database which is NOT is rollforwarding state

**Bob [IBM]** · Nov 12 '05, 09:34 AM

Re: rollforwaring a database which is NOT is rollforwarding state

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.

--

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!]

"Knokmans" <knokmans@nospa m.com> wrote in message
news:41779e9d$0 $88479$e4fe514c @dreader15.news .xs4all.nl...[color=blue]
> 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
>
>
> --
>
>
> ---------------------------------------------------------------------
> "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
>
>
>[/color]

**Knokmans** · Nov 12 '05, 09:36 AM

Re: rollforwaring a database which is NOT is rollforwarding state

OK that's clear

Knokmans

--

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

"Bob [IBM]" <BobAtIBM@canad a.com> wrote in message
news:2tppaeF22t 19nU1@uni-berlin.de...[color=blue]
> 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.
>
> --
>
> 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!]
>
> "Knokmans" <knokmans@nospa m.com> wrote in message
> news:41779e9d$0 $88479$e4fe514c @dreader15.news .xs4all.nl...[color=green]
>> 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
>>
>>
>> --
>>
>>
>> ---------------------------------------------------------------------
>> "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
>>
>>
>>[/color]
>
>[/color]

**dbtoo_dbtoo** · Nov 12 '05, 09:37 AM

Re: rollforwaring a database which is NOT is rollforwarding state

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

"Knokmans" <knokmans@nospa m.com> wrote in message news:<417d0727$ 0$133$e4fe514c@ dreader9.news.x s4all.nl>...

[color=blue]
> OK that's clear
>
> Knokmans
>
> --
>
>
> ---------------------------------------------------------------------
> "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
>
>
> "Bob [IBM]" <BobAtIBM@canad a.com> wrote in message
> news:2tppaeF22t 19nU1@uni-berlin.de...[color=green]
> > 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.
> >
> > --
> >
> > 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!]
> >
> > "Knokmans" <knokmans@nospa m.com> wrote in message
> > news:41779e9d$0 $88479$e4fe514c @dreader15.news .xs4all.nl...[color=darkred]
> >> 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
> >>
> >>
> >> --
> >>
> >>
> >> ---------------------------------------------------------------------
> >> "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
> >>
> >>
> >>[/color]
> >
> >[/color][/color]

**Pierre Saint-Jacques** · Nov 12 '05, 09:37 AM

Re: rollforwaring a database which is NOT is rollforwarding state

Your restore command as a default option of WITH ROLLING FORWARD even
with an offline image because you are in LOGRETAIN=RECOV ERY.
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

dbtoo_dbtoo wrote:[color=blue]
> 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
>
>
>
>
> "Knokmans" <knokmans@nospa m.com> wrote in message news:<417d0727$ 0$133$e4fe514c@ dreader9.news.x s4all.nl>...
>
>
>
>[color=green]
>>OK that's clear
>>
>>Knokmans
>>
>>--
>>
>>
>>---------------------------------------------------------------------
>>"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
>>
>>
>>"Bob [IBM]" <BobAtIBM@canad a.com> wrote in message
>>news:2tppaeF2 2t19nU1@uni-berlin.de...
>>[color=darkred]
>>>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
>>>connection s, as you know.
>>>
>>>--
>>>
>>>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!]
>>>
>>>"Knokmans" <knokmans@nospa m.com> wrote in message
>>>news:41779e9 d$0$88479$e4fe5 14c@dreader15.n ews.xs4all.nl.. .
>>>
>>>>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
>>>>
>>>>
>>>>--
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>"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
>>>>
>>>>
>>>>
>>>
>>>[/color][/color][/color]

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

rollforwaring a database which is NOT is rollforwarding state

rollforwaring a database which is NOT is rollforwarding state

Comment

Comment

Comment

Comment