473,688 Members | 3,175 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Online Tablespace restore from incremental backups

Raj
How can we do an online restore of a tablespace using the incremental
backup's? we are on a partitioned database...

Also, how could we use backup copy made by the load (using the copy to
option in load) to revover the tablespace?

Thanks,
Raj

Feb 27 '06 #1
6 3670
Raj
or even an an offline restore of a tablespace using the incremental
backup's, i can't find this info anywhere online...

Feb 27 '06 #2
Ian
Raj wrote:
How can we do an online restore of a tablespace using the incremental
backup's? we are on a partitioned database...
See http://tinyurl.com/orcr6, and also db2ckrst command.
Also, how could we use backup copy made by the load (using the copy to
option in load) to revover the tablespace?

This is done automatically by ROLLFORWARD. It recalls the load copy
files and "replays" the loads.
Feb 27 '06 #3
Life is really hard !!!
For question 1 from a command line:
D:\SQLLIB\BIN>d b2 ? restore
RESTORE DATABASE source-database-alias { restore-options | CONTINUE |
ABORT }

restore-options:
[USER username [USING password]] [TABLESPACE [ONLINE] |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE] | LOGS [ONLINE] | COMPRESSION LIBRARY [ONLINE]]
[INCREMENTAL [AUTOMATIC | ABORT]] [USE {TSM | XBSA} [OPEN num-sess
SESSIONS]
[OPTIONS {options-string | options-filename}] |
FROM dir/dev [{,dir/dev} ... ] | LOAD shared-lib [OPEN num-sess SESSIONS]
[OPTIONS {options-string | options-filename}]] [TAKEN AT date-time]
[[TO target-directory] | [ON drive[{,drive}...][DBPATH ON drive]]]
[INTO target-database-alias] [LOGTARGET directory]
[NEWLOGPATH directory] [WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE HISTORY FILE] [REPLACE EXISTING] [REDIRECT]
[PARALLELISM n] [COMPRLIB lib-name] [COMPROPTS options-string]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]

So:
db2 retore db mystuff tablespace(that name) ONLINE INCREMENTAL AUTOMATIC from
.......
Automatic will then come back and prompt you for each image required in its
proper sequence.
For Question 2:
Retore your tablespace from the most recent backup prior to the load. It can
be full or incremental backup image.

D:\SQLLIB\BIN>d b2 ? rollforward
ROLLFORWARD DATABASE database-alias [USER username [USING password]]
[TO {isotime [ON ALL DBPARTITIONNUMS] [USING LOCAL TIME] | END OF LOGS
[On-DbPartitionNum-Clause]}] [AND {COMPLETE | STOP}] |
{COMPLETE | STOP | CANCEL | QUERY STATUS [USING LOCAL TIME]}
[On-DbPartitionNum-Clause] [TABLESPACE ONLINE | TABLESPACE (tblspace-name
[ {,tblspace-name} ... ]) [ONLINE]] [OVERFLOW LOG PATH (log-directory
[{,log-directory ON DBPARTITIONNUM db-partition-number} ... ])] [NORETRIEVE]
[RECOVER DROPPED TABLE dropped-table-id TO export-directory]

On-DbPartitionNum-Clause:
ON {{DBPARTITIONNU M | DBPARTITIONNUMS } (db-partition-number
[TO db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
{DBPARTITIONNUM | DBPARTITIONNUMS } (db-partition-number
[TO db-partition-number] , ...)]}

As the the tbspace rolls through the log, it will meet the load command with
the target of the copy to.
It will automatically access (make sure the path is available) and execute
the load then resume the roll forward.

HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Raj" <sp****@yahoo.c om> a écrit dans le message de news:
11************* ********@v46g20 00...legro ups.com...
How can we do an online restore of a tablespace using the incremental
backup's? we are on a partitioned database...

Also, how could we use backup copy made by the load (using the copy to
option in load) to revover the tablespace?

Thanks,
Raj


Feb 28 '06 #4
Raj
Thanks guys ...

Feb 28 '06 #5
Raj
Thanks guys ...

Feb 28 '06 #6
Raj
Thanks guys...

Feb 28 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
5432
by: Anurag | last post by:
Hello, I wish to find out the restore method for database that have been incrementally backed up and in the scenario where just the delta has been backed up. For example sake, let us assume the following 2 scenarios: (1) Delta Backup of database "delta_db" Full offline backup of database "delta_db" is taken on Dec 15 and then offline delta backup is taken every day till Dec 19. If "delta_db" crashes on Dec 20, what steps do I follow...
1
1528
by: Christos Kalantzis | last post by:
Hello, DB2 7.2 on AIX. I take online backups EVERY night and rsync my log folder every hour after running the DB2 ARCHIVE LOG command to make sure I dump the log buffer to a log file. Now the question...
0
3139
by: Willem | last post by:
Based on MK's TSI_SOON (http://www.trigeminal.com/)I've created a nifty little procedure that - whenever you compact you db you get an incremental backup copy. Given that you have a table with version information you get incremental backups on a per-version basis. SEE CODE BELOW Basic idea is: start TSISOON with the options: 1. "compact this db"
4
9472
by: manwiththeaxe.70 | last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now that the online backup includes the necessary log files. Is there a reason why I would need or want to go through the hassle of getting exclusive control of a db for an offline backup?
5
3109
by: kebuchan | last post by:
Hi all, I know this is possible in Oracle but has anyone done it in DB2 and could you maybe direct me to some documentation or let me know how I would go about doing it? In the oracle world you would basically need to do the following: 1. Set tablespace to backup mode 2. Copy associated data files to new directory/system
3
3214
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 included in backups) There are other tablespaces in this db as well There is retention logging I want to restore the userspace1 tablespace of sampledb into newdb on
7
2462
by: manobas | last post by:
I am getting -911 on online incremental or delta backup , anybody have any explanation, backups go to tsm. thanks
3
4372
by: dcruncher4 | last post by:
It is possible that we may be asked to restore a production tape, say 3 yrs later. We would prefer redirect restore for that. I am documenting a process to do a redirect restore. We take production backups via Legato. The big question is that how to get information about tablespace and containers from the tape backup. A search on this told me that db2ckbkp is the command to go for. I tested it on a backup residing on unix file system...
3
4448
by: Troels Arvin | last post by:
Hello, A DB2 v. 8 DMS tablespace ran full. Subsequently, almost all data in the tablespace has been deleted, but "LIST TABLESPACES SHOW DETAIL" keeps stating that the tablespace has 0 free pages. I've tried running a REORG on all remaining tables; that didn't help. Trying to create a table in the tablespace yields: bash-3.00$ db2 "create table foobar (x int not null) in s_problemspace" DB21034E The command was processed as an SQL...
0
8590
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8528
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9072
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8947
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8782
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8786
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7621
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4547
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
1950
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.