DB2 recovery to same RBA twice in a row.

Sultan Shareef

DB2 recovery to same RBA twice in a row.
It is observed that when we recover a Tablespace to the same RBA twice in
a row with out any other operation on that tablespace.
First time the recovery goes fine to the expected point.
Second time the RBA picked is not what you are intending but is one prior
to what you have specified.

Can any one help me in understand why DB2 does not allow to fall back to
the same RBA second time.

This happend to us at our DR site since we do not take images immediately
after recovery in the drill situation.

Thanks,
S.K. Sultan Shareef
Database Administration
EDS-Xerox
Rochester , NY. 14623.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

cass cheng

Re: DB2 recovery to same RBA twice in a row.
(in response to Sultan Shareef)

Hi Sultan, I disagree with this. Perhaps there is mismatch set up for the DR  you are talking about.  Even you recover so many times it should go fine.  Pass the messages you are obtaining for both the recovery. Any DSN messages will be helpful. BTW have you checked the data whether they are same or not. Have you checked the PIT? Any wasy wait for IBM's Rogger Miller. He can have the correct answer. How is your environment?

 

With thanks

Cass


--

___________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ivan Losada

Recover to rba
(in response to cass cheng)
Hello,
We have to recover a tablespace to a point of time, or near this point of
time. This point of time is marked with a archive log (without mode
quiesce). We have no quiesce point near this point of time, only a full
image copy with shrlevel change some minutes before.
And now the questions:
How we could find a quiesce point, or a point with no read/write UR's in
that tablespace to make the data consistent after the recover to rba?
There would be any other problem?

Thanks

Ivan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bill Gallagher

Re: Recover to rba
(in response to Ivan Losada)
Ivan,

I would think that running a REPORT RECOVERY utility against the tablespace
in question would give you an indication of periods where there were no
update UOW's. You should be able to then pick an RBA during one of these
"quiet times" that's close to the point-of-time you need to recovery to.

-------------------------------------------------------
Bill Gallagher
Database Administrator
Information Technology
Infrastructure / Operations
Phoenix Life Insurance Company
860-403-1773
[login to unmask email]



"Ivan Losada"
<[login to unmask email] To:
[login to unmask email]
OM> cc:
Sent by: "DB2 Subject: Recover to rba
Data Base
Discussion List"
<[login to unmask email]
ORG>
12/13/2004 11:14
AM
Please respond to
"DB2 Database
Discussion list
at IDUG"




Hello,
We have to recover a tablespace to a point of time, or near this point of
time. This point of time is marked with a archive log (without mode
quiesce). We have no quiesce point near this point of time, only a full
image copy with shrlevel change some minutes before.
And now the questions:
How we could find a quiesce point, or a point with no read/write UR's in
that tablespace to make the data consistent after the recover to rba?
There would be any other problem?

Thanks

Ivan

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm







***********************************************************************************
CONFIDENTIAL: This communication, including attachments, is intended only for
the exclusive use of addressee and may contain proprietary, confidential
and/or privileged information. If you are not the intended recipient, you are
hereby notified that you have received this document in error, and any use,
review, copying, disclosure, dissemination or distribution is strictly
prohibited. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this communication and destroy any and
all copies of this communication.

***********************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm