I presume that if you have incremental, your db is already in
logretain=recovery and maybe also it is archiving its logs. You also have
TRACKMOD=ON in the db cfg. If not you are toast!
The following is from the link shown below:
http://www.phptr.com/articles/articl...&seqNum=5&rl=1
« On the other hand, if you wanted to restore just a tablespace named TBSP1
in a database named SAMPLE from an incremental backup image stored in a
directory named BACKUPS on logical disk drive E: while the database is
online, you could do so by executing a RESTORE command that looks something
like this:
RESTORE DATABASE SAMPLE
USER DB2ADMIN USING IBMDB2
TABLESPACE (TBSP1) ONLINE
INCREMENTAL
FROM E:\BACKUPS »You'll notice that there's no specification as to the form
or origin of the image.I would also add the AUTOMATIC to the incremental
parm.I do not think there's a restriction on restoring only a tablespace
from full or incremental db images.I know that if there is no incremental,
you can restore any subset of a db from its full backup image.I don't see
why this should not be possible.All you have to ensure is that you do
restore the incremental and then roll the logs you have as far as you
need.HTH, Pierre.-- Pierre Saint-JacquesSES Consultants
Inc.514-737-4515"Raj" <sp****@yahoo.com> a écrit dans le message de news:
11**********************@m73g2000cwd.googlegroups. com...
-Is it possible to recover a tablespace just from a full offline backup
and offline incremental backup?
If not possible
-Can we recover tablespace from Full backup , Wednesdays incremental
backup (logs before wednesday are lost) to a point in time on Friday
Thanks,
Raj