473,326 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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

Jun 22 '06 #1
8 2449
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Andrew E | last post by:
I just took over DBA responsibilities for an Oracle 8i database running on Linux. Although I've been working with relational databases for some time, I'm a bit green on Oracle so forgive me. My...
1
by: Vikrant | last post by:
On my DB2/UDB system, some tablespace 'Minimum recovery time' is 2000-11-19 or some '1999-10-04' or different, for some tablespace theres is no 'Minimum recovery time' , what does it tell me? ...
2
by: Trent | last post by:
Hello, all. I have the following production DB2 environment. DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003 standard edition. My first question is regard with...
4
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions...
3
by: hikums | last post by:
Source/Production system: AIX 5.2, DB2 8.2 I have a full backup of sample db taken on 05/01/2006(logs included in backups) I have a tablespace backup of userspace1 taken on 05/03/2006(logs...
2
by: Raghava | last post by:
hi all, i was working on DB2 and came across an issue. i.e. can a tablespace be rollforwarded to POINT-IN-TIME? the scenario is as follows: i created a data base and a tablespace in it. i have...
4
by: Raj | last post by:
For tablespace level recovery of the db is the following strategy good enough? Sunday's Table - Full offline backup Mondays incremental to tape Monday's offline incremental backup + Monday's logs...
7
by: satish mullapudi | last post by:
Hi All, I am using Db2 UDB v 8.2 on RHEL . I have performed a load operation on a table. Now that tablespace has been switched into RESTORE PENDING state. Now I can only read the data in the...
1
by: Sam Durai | last post by:
Env: DB2 v9.1 Server / Win XP. DB is enabled for Archival Logging. Was playing around with rebuild tablespace feature. My database 'CARD' has tablespace named t1,t2,t3. Taken couple of...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.