Question: Tablespace recovery without logs

[Raj]

-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

[UDBDBA]

Hi Raj:

1. cannot do tbsp level backup from full offline backup
2. cannot take incrementals without turning on trackmod db cfg which i
think has to be done after setting logretain/userexit to yes.

Vijay

Raj wrote:

-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

[ambrown64]

We are currently reaching out to people with skill/experience in the
Princeton Softech suite of archival tools. This is for a recurring and
large set of client needs.

It is not our company's style or intent to be intrusive, so please
disregard this if you are not interested. However, if this is an area
of skill and interest for you, please contact Jerry Doss:
jd***@mercdatas ys.com

Alan Brown
Mercury Data Systems
Phone: [phone] Ext. 108
Mobile: [phone]
Fax: [phone]
ab****@mercdata sys.com
Raj wrote:

-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

[ambrown64]

We are currently reaching out to people with skill/experience in the
Princeton Softech suite of archival tools. This is for a recurring and
large set of client needs.

It is not our company's style or intent to be intrusive, so please
disregard this if you are not interested. However, if this is an area
of skill and interest for you, please contact Jerry Doss:
jd***@mercdatas ys.com

Alan Brown
Mercury Data Systems
Phone: [phone] Ext. 108
Mobile: [phone]
Fax: [phone]
ab****@mercdata sys.com

UDBDBA wrote:

Hi Raj:

1. cannot do tbsp level backup from full offline backup
2. cannot take incrementals without turning on trackmod db cfg which i
think has to be done after setting logretain/userexit to yes.

Vijay

Raj wrote:

-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

[Art S. Kagel]

ambrown64 wrote:
<Job ad snipped>

It is not our company's style or intent to be intrusive, so please
disregard this if you are not interested. However, if this is an area
of skill and interest for you, please contact Jerry Doss:
Alan Brown
Mercury Data Systems

An yet, Misters Doss and Brown, you were very intrusive. Even to the point
of posting the identical message twice, at two different levels, to an
existing thread that you had no business joining, since you did not attempt
to add to the discussion at hand. This group accepts low volume job
postings if they are simple and have their own Subject which makes its
purpose clear. If you cannot keep to that, keep out.

Art S. Kagel

[Raj]

Vijay, Thanks for the reply
My second question was
Can we restore a table space using a full backup , incremental backup &
logs after incremental backup to a point in time after the
incremental???? ? ( logs between full backup and incremental are
missing....)

[Pierre Saint-Jacques]

I presume that if you have incremental, your db is already in
logretain=recov ery 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.c om> a écrit dans le message de news:
11************* *********@m73g2 00...legr oups.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

[UDBDBA]

Sure Raj. That's the whole point here.. The incremental will capture
everything that has changed since the last full backup.
So, your recovery chain would be:

FUll backup --> incremental backup ---> rollforward logs to the minimum
Point-in-time. The catch here is minimum point in time and make sure
you have logs for that.. once you are past the minimum PIT, then you
can bring the database online after finishing the rollforward
successfully to your PIT.

Try to use INCLUDE LOGS option while running backups so that you have
what's needed to cover minimum PIT.

DB2 9 (Code name Viper) has very good recovery / rebuild commands
making recovery a breeze... check them out..

Vijay

Raj wrote:

Vijay, Thanks for the reply
My second question was
Can we restore a table space using a full backup , incremental backup &
logs after incremental backup to a point in time after the
incremental???? ? ( logs between full backup and incremental are
missing....)

[Raj]

Thanks a lot for the reply....

Include logs is not available for offline backups?

So incase i don't have logs from mon to wednesday can i restore a
tablespace to a point on thursday using sunday's full and wednesdays
incremental backup's? and rollforward after applying the
incrementals???
(given that no operations are done that would affect Minimum recovery
time of tha tablespace)

Thanks,
Raj
UDBDBA wrote:

Sure Raj. That's the whole point here.. The incremental will capture
everything that has changed since the last full backup.
So, your recovery chain would be:

FUll backup --> incremental backup ---> rollforward logs to the minimum
Point-in-time. The catch here is minimum point in time and make sure
you have logs for that.. once you are past the minimum PIT, then you
can bring the database online after finishing the rollforward
successfully to your PIT.

Try to use INCLUDE LOGS option while running backups so that you have
what's needed to cover minimum PIT.

DB2 9 (Code name Viper) has very good recovery / rebuild commands
making recovery a breeze... check them out..

Vijay

Raj wrote:

Vijay, Thanks for the reply
My second question was
Can we restore a table space using a full backup , incremental backup &
logs after incremental backup to a point in time after the
incremental???? ? ( logs between full backup and incremental are
missing....)