Question: Tablespace recovery without logs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 22 Jun 2006 16:30 GMT

-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

Reply to this Message

UDBDBA - 22 Jun 2006 16:59 GMT

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

> -Is it possible to recover a tablespace just from a full offline backup
> and offline incremental backup?
[quoted text clipped - 4 lines]
> Thanks,
> Raj

Reply to this Message

ambrown64 - 22 Jun 2006 19:12 GMT

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:
jdoss@mercdatasys.com

Alan Brown
Mercury Data Systems
Phone: (336) 294-2828 Ext. 108
Mobile: (919) 946-0297
Fax: (336) 294-8852
abrown@mercdatasys.com

> Hi Raj:
>
[quoted text clipped - 12 lines]
> > Thanks,
> > Raj

Reply to this Message

Raj - 22 Jun 2006 21:45 GMT

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....)

Reply to this Message

UDBDBA - 27 Jun 2006 17:34 GMT

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

> 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....)

Reply to this Message

Raj - 27 Jun 2006 20:09 GMT

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

> Sure Raj. That's the whole point here.. The incremental will capture
> everything that has changed since the last full backup.
[quoted text clipped - 20 lines]
> > incremental????? ( logs between full backup and incremental are
> > missing....)

Reply to this Message

ambrown64 - 22 Jun 2006 19:12 GMT

> -Is it possible to recover a tablespace just from a full offline backup
> and offline incremental backup?
[quoted text clipped - 4 lines]
> Thanks,
> Raj

Reply to this Message

Art S. Kagel - 22 Jun 2006 19:58 GMT

> 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

Reply to this Message

Pierre Saint-Jacques - 23 Jun 2006 02:15 GMT

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/article.asp?p=169530&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

> -Is it possible to recover a tablespace just from a full offline backup
> and offline incremental backup?
[quoted text clipped - 4 lines]
> Thanks,
> Raj

Reply to this Message