Ravi
a) The minimum rollforward PIT will be the last DDL statement for that
tablespace OR the last update that affected a table in the tablespace being
restored as well as a table in a tablespace that was NOT restored. If your
tablespace is self contained, e.g. the indexes and LOBs are in the same
tablespace and the modifications did not trigger any other tables to be
updated through a cascading delete or trigger then you will be OK. I am
assuming you are on a EE instance, there are a different set of rules for
EEE.
b) To recovery on a single table within a tablespace take a look at the IBM
Data Management Recovery Expert utility.
Hope this helps.
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
r x
<dbadb2udb@yahoo.
com> To
Sent by: [EMAIL PROTECTED]
owner-db2eug@Lugw cc
ash.org
Subject
[DB2EUG] Recovery of single table
01/09/2003 01:03 to point in time
AM
Please respond to
r x
<dbadb2udb@yahoo.
com>
Hi List,
Problem with recovery.
DB2 V7.2 AIX
We are trying to formulate a recovery strategy for our
shop.
One of the ares we want to address is recovery of a
single table data.
Let say i have backups ( could be online, offline,
tablespace ) taken at 1 AM.
Users have worked and at 5AM we want to revert all the
updates done after 2 AM to one
particular table only .( Recovery is not for all
tables )
I could think of the following things :
a) If the table is the only table in the tablespace ,
then tablespace backup
and recovery / rollforward to point in time would
suffice .
Query : Can i restore and rollfoward one Tablespace to
Point in time and not do
the other tablespaces ? Will the DB be consistent ?
b) If there are multiple tables in tablespace and i
want to recover only one table
in that TS , what could be the best possible strategy
?
Ideas please ...
Thanks ,
Ravi.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
