See answers folded in your question. HTH, Pierre Pierre Saint-Jacques IBM Certified Solutions Expert - Administration SES Consultants Inc. [EMAIL PROTECTED] ----- Original Message ----- From: "r x" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 1:03 AM Subject: [DB2EUG] Recovery of single table to point in time
> 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 ? ########### Absolutely. You will need to take a backup of the tblsp after the roll forward. The tblsp will be in backup pending and it must be done. However, that tablespace backup can be done on line. > > 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 > ? ########### Restore the tblsp on your test machine, export the data out of that table, load replace the data in your target table. > > 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
