I have restored a clients database using a redirected restore. However,
it is in a roll forward pending state. When I try to to a roll forward
to end of the logs, I get
SQL1268N Roll-forward recovery stopped due to error "1" while
retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N
message. And they are in the log directory
I have tried changing userexit to no, and logretain to recovery.
Is there a way to roll forward without the customer's user exit
program? or pehaps there is something else I have missed here?
Regards
Dave Arnold 18 5762 da*****@carreke r.com wrote: I have restored a clients database using a redirected restore. However, it is in a roll forward pending state. When I try to to a roll forward to end of the logs, I get SQL1268N Roll-forward recovery stopped due to error "1" while retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N message. And they are in the log directory I have tried changing userexit to no, and logretain to recovery.
Is there a way to roll forward without the customer's user exit program? or pehaps there is something else I have missed here?
Regards Dave Arnold
Checkout "overflow log path" option in rollforward command.
Keith Ponnapalli
adv_dba at yahoo dot com
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator da*****@carreke r.com wrote: I have restored a clients database using a redirected restore. However, it is in a roll forward pending state. When I try to to a roll forward to end of the logs, I get SQL1268N Roll-forward recovery stopped due to error "1" while retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N message. And they are in the log directory I have tried changing userexit to no, and logretain to recovery.
Is there a way to roll forward without the customer's user exit program? or pehaps there is something else I have missed here?
Regards Dave Arnold
Checkout "overflow log path" option in rollforward command.
Keith Ponnapalli
adv_dba at yahoo dot com
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator
Keith,
Thanks for the suggestion. I tried this as well, with the same results.
Here is the ouput.
I should have mentioned that the original and target databases are both
version 7.
Any other suggestions?
C:\PROGRA~1\SQL LIB\BIN>db2 rollforward database ae12sym to end of logs
overflow
log path (F:\DB2\NODE000 0\SQL00001\SQLO GDIR )
SQL1268N Roll-forward recovery stopped due to error "1" while
retrieving log
file "S0047041.L OG" for database "AE12SYM" on node "0".
Dave
Have you tried moving logs to directory other than "logpath" and using
overflow log path option?
Keith Ponnapalli
adv_dba at yahoo dot com
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator da*****@carreke r.com wrote: Keith, Thanks for the suggestion. I tried this as well, with the same results. Here is the ouput. I should have mentioned that the original and target databases are both version 7. Any other suggestions?
C:\PROGRA~1\SQL LIB\BIN>db2 rollforward database ae12sym to end of logs overflow log path (F:\DB2\NODE000 0\SQL00001\SQLO GDIR ) SQL1268N Roll-forward recovery stopped due to error "1" while retrieving log file "S0047041.L OG" for database "AE12SYM" on node "0".
Dave da*****@carreke r.com wrote: I have restored a clients database using a redirected restore. However, it is in a roll forward pending state. When I try to to a roll forward to end of the logs, I get SQL1268N Roll-forward recovery stopped due to error "1" while retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N message. And they are in the log directory I have tried changing userexit to no, and logretain to recovery.
Is there a way to roll forward without the customer's user exit program? or pehaps there is something else I have missed here?
Regards Dave Arnold da*****@carreke r.com wrote: I have restored a clients database using a redirected restore. However, it is in a roll forward pending state. When I try to to a roll forward to end of the logs, I get SQL1268N Roll-forward recovery stopped due to error "1" while retrieving log....
I have all of the logs, including the one mentioned in the SQL1268N message. And they are in the log directory I have tried changing userexit to no, and logretain to recovery.
Is there a way to roll forward without the customer's user exit program? or pehaps there is something else I have missed here?
Regards Dave Arnold
*************** *******
Try using NORETRIEVE on ROLLFORWARD if you want to use end-of-logs.
Try NORETRIEVE option of ROLLFORWARD command if you want to use
end-of-logs syntax when you know the situations suits it .
Good idea. I did just try that using both fully qualified path and
relative path; I still get the same error result.
Any other suggestions? I have not even been able to find any
information on what error "1" is
Dave
NORETRIEVE is not a suppported option on ver 7. I am guessing it was
added in vsersion 8.
Good idea though, thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Raquel |
last post by:
I have asked a similar question before, but am still not very clear on
this......expecting some insights on this one....
Ok, so these are the two pieces of information regarding archived logs
during a rollforward recovery in a recoverable database:
1. OVERFLOWLOGPATH configuration parameter can specify a location for
DB2 to find log files that are needed for rollforward operations.
2. The database configuration file parameter...
|
by: Steven |
last post by:
Ok W2K DB2 v8.1 fix pack 5.
On production I took a an online backup of production and copied it
over to my staging environment.
restored the production database on top of staging database redirect.
I copied over all the log files from production box to a temp
directory.
restore was complete with redirect and staging went into roll forward
pending.
|
by: shenanwei |
last post by:
DB2 V8.1.5 on Windows.
When I execute ROLLFORWARD after a Restore.
C:\db2 ROLLFORWARD db sample to END OF LOGS overflow log path(C:\LOGS\)
Rollforward Status
Input database alias = sample
Number of nodes have returned status = 1
|
by: t2581 |
last post by:
Hi ,
I run restore with rollforward
In job in output, last commited transaction time less then backup image
time
Is it normal ?
RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT 20050610095841 TO
"D:" INTO PR_READ NEWLOGPATH "D:\DB2_FILES\PR_READ\LOG" WITH 2 BUFFERS
BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING
.....
|
by: EC |
last post by:
We have two DB2 servers are supposed to be a replicate of each other
with a database of the same name. I want to do a 'db2 db backup
online... include logs' on the first server, and do a 'db2 restore db
to ... logtarget...' on the second server, and then rollforward ONLY
those logs that were included in the backup image. Both databases may
have the same DB id because of previous restores. However, the second
server might have additional...
| |
by: satish mullapudi |
last post by:
Hi,
Am facing a tough situation & the scenario goes like this:
I have scheduled online backup on a db. The online backup is scheduled
to run daily at 12 in the night. Now am to restore the same db in
another server . I have with me the backup image & 50 logs which I
need to rollforward. When am trying to restore it is working fine &
the db goes into ROLLFORWARD PENDING state as expected. When am trying
to ROLLFORWARD the db, it is saying...
|
by: Patrick Finnegan |
last post by:
The db2 diag log shows the last log file archived was S0011941.LOG.
cat db2diag.log| grep -i archived
MESSAGE : Successfully archived log file S0011938.LOG to USEREXIT from
MESSAGE : Successfully archived log file S0011939.LOG to USEREXIT from
MESSAGE : Successfully archived log file S0011940.LOG to USEREXIT from
MESSAGE : Successfully archived log file S0011941.LOG to USEREXIT from
However the db config examined after archive...
|
by: Patrick Finnegan |
last post by:
Running db2 8.2 ON aIX 5.3.
We have a third party USEREXIT program that periodically hangs for
some unknown reason.
Db2 generates error message to the diag log.
MESSAGE : Successfully archived log file S0011930.LOG to USEREXIT
from
|
by: shorti |
last post by:
We are running DB2 UDB 8.1 fp 14 on AIX using archival logging and
online backups. I was running some disaster tests and found my
database restore was not restoring to the latest active log. Online
backup include logs. For this test I created a disaster where we lost
the database about 30 minutes after the last backup. Current archive
and active logs were saved off and I ran a Restore of the latest
backup and rollforward to the end 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: 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,...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 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...
| |