rollforwaring a database which is NOT is rollforwarding state

[Knokmans]

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

[Bob [IBM]]

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" <kn******@nospam.com> wrote in message
news:41***********************@dreader15.news.xs4a ll.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

[Knokmans]

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]" <Bo******@canada.com> wrote in message
news:2t*************@uni-berlin.de...

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" <kn******@nospam.com> wrote in message
news:41***********************@dreader15.news.xs4a ll.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

[dbtoo_dbtoo]

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" <kn******@nospam.com> wrote in message news:<41*********************@dreader9.news.xs4all .nl>...

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]" <Bo******@canada.com> wrote in message
news:2t*************@uni-berlin.de...

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" <kn******@nospam.com> wrote in message
news:41***********************@dreader15.news.xs4a ll.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

[Pierre Saint-Jacques]

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

dbtoo_dbtoo wrote:

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" <kn******@nospam.com> wrote in message news:<41*********************@dreader9.news.xs4all .nl>...

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]" <Bo******@canada.com> wrote in message
news:2t*************@uni-berlin.de...

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" <kn******@nospam.com> wrote in message
news:41***********************@dreader15.news.x s4all.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

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