DB2 LUW v8.2 FP 14 RHAS 2.1
I have a DB2 online DB backup that was done w/ the INCLUDE LOGS
option. I am interested in restoring that backup, and rolling
forward ONLY the logs contained in the backup and no more, then
bringing the DB online.
I do not want to use a userexit to try and retrieve additional
logs - I only want to roll forward the logs in the backup. (In
case you haven't guessed, I am restoring a test version of my
prod DB).
I have some questions about the commands I would use to accomplish
this. Lets say my DB name and instance name are foo.
My DB backup file is FOO.0.foo.NODE0 000.CATN0000.20 070319020726.00 1
First, the restore:
db2 restore db foo taken at 20070319020726 logtarget /tmp
If I were to use the LOGS option after the DB name in the restore
command, ONLY the logs would be retrieved from the backup image and
placed in /tmp, and the DB restore would not take place. Correct?
By specifying LOGTARGET (and not using LOGS), this will cause the
DB image to be restored AND the logs in the image to be placed
in /tmp. Correct?
Now I'm interested in doing the roll-forward. I can't just
db2 rollforward db foo to end of logs and stop
because my userexit will come into play, and the rollforward is
not being informed about the logs in /tmp. I need a PIT.
I need the minimum PIT for the roll-forward. So, I can do this:
db2 rollforward db foo stop
SQL1276N Database "FOO" cannot be brought out of rollforward pending
state until roll-forward has passed a point in time greater than or
equal to "2007-03-19-06.30.35.000000 ", because node "0" contains
information later than the specified time.
Is there another way to establish the minimum PIT? I'm trying to
automate the process of restoring and rolling forward. IBM is
assuming that eyes and fingers are issuing these commands.
So, armed w/ my PIT, I do this:
db2 "rollforwar d db foo to 2007-03-19-06.30.35.000000 overflow log path
/tmp)"
What is the purpose of overflow log path? Is it to indicate where logs
should be written when/if they are retrieved? OR is it to indicate
where to look for logs that are needed for the roll forward?
After I try this, DB2 complains about being unable to retrieve a log
that is outside the range of those stored w/ my online backup, and I
scratch my head for a few more minutes.....
Would using RECOVER DATABASE be a better idea for what I am trying to do?
Any help appreciated.
thanks
aj 4 20446
aj wrote:
[...]
>
So, armed w/ my PIT, I do this:
db2 "rollforwar d db foo to 2007-03-19-06.30.35.000000 overflow log path
/tmp)"
I think it should be:
rollforward db foo to end of logs and stop overflow log path ( /tmp )
[...]
/Lennart
OK - I'll give it a try.
The RESTORE command puts logs S0016355.LOG and S0016356.LOG in /tmp.
So apparently 16355 and 16356 are stored in the backup image.
db2 rollforward db foo to end of logs and stop overflow log path (/tmp)
SQL1268N Roll-forward recovery stopped due to error "1" while
retrieving log file "S0016357.L OG" for database "FOO" on node "0".
And the DB is still in rollforward pending mode...
WHY is it going after 16357?
Any other ideas?
thanks
aj
Lennart wrote:
aj wrote:
[...]
>> So, armed w/ my PIT, I do this: db2 "rollforwar d db foo to 2007-03-19-06.30.35.000000 overflow log path /tmp)"
I think it should be:
rollforward db foo to end of logs and stop overflow log path ( /tmp )
[...]
/Lennart
Maybe this will help the next guy. This pretty much explains it: http://www-1.ibm.com/support/docview...id=swg21209404
They key is to specify the NORETRIEVE option of the ROLLFORWARD
DATABASE command. This will prevent DB2 UDB from trying to
obtain potentially missing transaction logs elsewhere.
aj
aj wrote:
OK - I'll give it a try.
The RESTORE command puts logs S0016355.LOG and S0016356.LOG in /tmp.
So apparently 16355 and 16356 are stored in the backup image.
db2 rollforward db foo to end of logs and stop overflow log path (/tmp)
SQL1268N Roll-forward recovery stopped due to error "1" while
retrieving log file "S0016357.L OG" for database "FOO" on node "0".
And the DB is still in rollforward pending mode...
WHY is it going after 16357?
Any other ideas?
thanks
aj
Lennart wrote:
>aj wrote: [...]
>>> So, armed w/ my PIT, I do this: db2 "rollforwar d db foo to 2007-03-19-06.30.35.000000 overflow log path /tmp)"
I think it should be:
rollforward db foo to end of logs and stop overflow log path ( /tmp )
[...]
/Lennart
I'm doing this every night (script and a reidrected restore)
restore db xxxx from yyyyy taken at zzzzzz to path into newdb
logtarget aaaa newlogpath aaaa REDIRECT WITHOUT PROMPTING;
set tablespace containers hhhh;
restore db bbbb continue;
rollforward db cccc to end of logs and stop overflow log path (/tmp);
so..I wonder why it doesn't work for you ? I'm running db2 udb v8 with
fixpak 10
/roger This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andre |
last post by:
Hi,
I have a database (or better: used to have) and backup consisting of
- the initial (complete) database
- all log files since then (or so I thought)
After making a data entry error I wrote the log to the backup and
tried a point of time restore.
Unfortunately that failed with the message
"The log in this backup set begins at LSN xxx,...
|
by: Grisha Golberg |
last post by:
Hi all,
I am trying to move a database from one machine to another.
I backed up in offline mode, then I do a restore (without
rolling forward), which
finishes successfully but with warning 2529 (what's that?)
After that db2syscs hogs pretty much all available memory
on the machine whenever I attempt to connect to the database,
with no...
|
by: Jimmy Chen |
last post by:
Recently I've done a db2 backup and restore/recovery, but the process
for recovering the database was different than what I thought to be.
here is what I did:
DB2 is set in online mode
- backup -
* backup db2 in full
* insert record
|
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...
|
by: Andy K |
last post by:
Hi ,
I'm wondering what's going on with a restore I'm trying to do .
My DB2 version is a 7.2 on a Linux RH ES 2.1 .
I've copy a recent backup that was on NAS for a test on my machine .
I then restore the backup without creating a database with the simple
command line "db2 restore backup DBNAME".
| |
by: paul |
last post by:
Hi,
i made an attempt to restore a online backup made with include logs option.
But when i rollforward the db, i can't pout it online because it always ned
log file. I tried the option to rollforward to end of logs and to point in
time.
In the doc, it is said taht with 'include logs', i can restore without any
log file.
Someone know how can...
|
by: Raj |
last post by:
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
|
by: Konstantin Andreev |
last post by:
Hello, everybody.
I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with
Examples", but still unable to answer this simple question.
I need to perform the full database backup for at least these two goals:
- to restore data onto developers' database system.
- to ensure...
|
by: Bill E. |
last post by:
I'm trying to restore a database backed up a production machine onto
my development machine. I don't want to restore the transaction logs
(there are two) because they are far too large and are unnecessary for
what I'm doing. I would be happy to simply create one new log in my
development environment. Therefore, I backed up the database...
|
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...
|
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. ...
| |
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |