Hai.....
I have a database....... ..... i took an online
backup for tht.....
After tht mistakenly i dropped the database....... ... now i dont have
the logs also....... now after i restore the database it will be in
rollforward pending state........ when i am rollforwarding it is saying
cannot rollforward.... .... can anyone tell me how to bring the database
back again........ 5 1940
Gladiator wrote: Hai.....
I have a database....... ..... i took an online backup for tht..... After tht mistakenly i dropped the database....... ... now i dont have the logs also....... now after i restore the database it will be in rollforward pending state........ when i am rollforwarding it is saying cannot rollforward.... .... can anyone tell me how to bring the database back again........
Unfortunately, an online backup requires that you rollforward to at
least a point in time right after the backup. The only other option is
to have IBM reset your log control file. This will give you access to
the data, but the database will be unsupported after that. You will
have to export, drop, recreate and import/LOAD your data.
jdokos wrote: Gladiator wrote: Hai.....
I have a database....... ..... i took an online backup for tht..... After tht mistakenly i dropped the database....... ... now i dont have the logs also....... now after i restore the database it will be in rollforward pending state........ when i am rollforwarding it is saying cannot rollforward.... .... can anyone tell me how to bring the database back again........
Unfortunately, an online backup requires that you rollforward to at least a point in time right after the backup. The only other option is to have IBM reset your log control file. This will give you access to the data, but the database will be unsupported after that. You will have to export, drop, recreate and import/LOAD your data.
Thanks for the reply....
Can u elaborate ur
explanation.... ......plssss/............... ..
"Gladiator" <vk************ @gmail.com> wrote in message > Thanks for the reply....
Can u elaborate ur explanation.... ......plssss/............... ..
Always specify INCLUDE LOGS in your online backup. It will only include the
logs that were active during the backup, but that is all you need for point
in time recovery of an online backup.
For your explanation:
There is a possibility with online backup that a transaction mofifies data
"to be entered" in the backup as well as modifies a table/tablespace whose
image is already in the backup.
That's why you must be 1) in logretain=recov ery and always provide access to
the logs that were active when backing up, to the db after restore for roll
forward.
As Mark specifies further, use the include logs option in your command to
stay on the safe side.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gladiator" <vk************ @gmail.com> a écrit dans le message de news: 11************* *********@c74g2 00...legr oups.com... jdokos wrote: Gladiator wrote: > Hai..... > > I have a database....... ..... i took an online > backup for tht..... > After tht mistakenly i dropped the database....... ... now i dont have > the logs also....... now after i restore the database it will be in > rollforward pending state........ when i am rollforwarding it is saying > cannot rollforward.... .... can anyone tell me how to bring the database > back again........
Unfortunately, an online backup requires that you rollforward to at least a point in time right after the backup. The only other option is to have IBM reset your log control file. This will give you access to the data, but the database will be unsupported after that. You will have to export, drop, recreate and import/LOAD your data. Thanks for the reply....
Can u elaborate ur explanation.... ......plssss/............... ..
Pierre Saint-Jacques wrote: For your explanation: There is a possibility with online backup that a transaction mofifies data "to be entered" in the backup as well as modifies a table/tablespace whose image is already in the backup. That's why you must be 1) in logretain=recov ery and always provide access to the logs that were active when backing up, to the db after restore for roll forward. As Mark specifies further, use the include logs option in your command to stay on the safe side. HTH, Pierre.
-- Pierre Saint-Jacques SES Consultants Inc. 514-737-4515 "Gladiator" <vk************ @gmail.com> a écrit dans le message de news: 11************* *********@c74g2 00...legr oups.com... jdokos wrote: Gladiator wrote: > Hai..... > > I have a database....... ..... i took an online > backup for tht..... > After tht mistakenly i dropped the database....... ... now i dont have > the logs also....... now after i restore the database it will be in > rollforward pending state........ when i am rollforwarding it is saying > cannot rollforward.... .... can anyone tell me how to bring the database > back again........
Unfortunately, an online backup requires that you rollforward to at least a point in time right after the backup. The only other option is to have IBM reset your log control file. This will give you access to the data, but the database will be unsupported after that. You will have to export, drop, recreate and import/LOAD your data. Thanks for the reply....
Can u elaborate ur explanation.... ......plssss/............... ..
thanks a lot every one...
regards...
kamal This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Arijit Chatterjee |
last post by:
Dear Friends,
I don't know anybody has asked this question before or not.But I need
a support urgently.How to take online backup in MS Sql server 2000.
Thanks
Arijit Chatterjee
|
by: Almund Sebi |
last post by:
(Using UDB 7.2 FP11). Given this output from LIST BACKUP HISTORY FOR
MYDB: (It's an online backup image)
> Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
> -- --- ------------------ ---- --- ------------ ------------ --------------
> B D 20040217102712001 N D S0000194.LOG S0000196.LOG
> ----------------------------------------------------------------------------
and:
|
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?
|
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 disaster recovery
|
by: Konstantin Andreev |
last post by:
Hello.
Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible.
But... what can I do with "online backup", really ? What is it needed for ? I do not see any possibility to use this backup. Please, share your knowledge, if you can.
Yes, I've read that since version 8.2 there is an option "INCLUDE LOSG" for "online...
| |
by: Al |
last post by:
We have a production DB that is running DB2 v8 fix pak 8. Some of
configuration parameter on the primary DB config file is:
Logretain = NO
Userexit = NO
Logarchmeth1 = Disk:/aa/bb/ccc/
when I ran: db2 backup DB <DBNAMEonline
the command ran successful, I ran db2ckbkp on the backup, result is
successful.
|
by: aj |
last post by:
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
|
by: michael.spoden |
last post by:
Hi,
how can I fix lock-waits during an online backup? Is an online backup
in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux.
The command to perform the backup is: db2 backup db BPEDB online to /
var/tmp
During the backup the application hangs on just one table
|
by: heyzulu59 |
last post by:
I thought that an online backup could always be run while other
processes with the database went about their business. However today I
noticed that certain processes in my production database were in a
lock-wait state because of the online backup. Why is this happening? I
had to kill the online backup to free up about six other processes
that were blocked.
Application handle = 508
Application ID ...
|
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...
|
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,...
| |
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...
|
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...
|
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...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |