473,386 Members | 1,790 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,386 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 2453
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: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.