By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

Question: Tablespace recovery without logs

P: n/a
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

Jun 22 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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


Jun 22 '06 #2

P: n/a
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***@mercdatasys.com

Alan Brown
Mercury Data Systems
Phone: (336) 294-2828 Ext. 108
Mobile: (919) 946-0297
Fax: (336) 294-8852
ab****@mercdatasys.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


Jun 22 '06 #3

P: n/a
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***@mercdatasys.com

Alan Brown
Mercury Data Systems
Phone: (336) 294-2828 Ext. 108
Mobile: (919) 946-0297
Fax: (336) 294-8852
ab****@mercdatasys.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


Jun 22 '06 #4

P: n/a
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
Jun 22 '06 #5

P: n/a
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....)

Jun 22 '06 #6

P: n/a
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


Jun 23 '06 #7

P: n/a
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....)


Jun 27 '06 #8

P: n/a
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....)


Jun 27 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.