Rollforward recovery...anot her question...

Raquel

During a ROLLFORWARD recovery, are the log datasets copied from the
archive log directory to the active log directory? I know the log datasets
are copied from archive log directory to active log directory during a
ROLLBACK (for example in a crash recovery), but was wondering if it is
the same during a ROLLFORWARD recovery too.

TIA
Raquel.

Nov 12 '05 #1

Subscribe Reply

1716

Knut Stolze

Raquel <ra************ ****@yahoo.com> wrote:

During a ROLLFORWARD recovery, are the log datasets copied from the
archive log directory to the active log directory? I know the log datasets
are copied from archive log directory to active log directory during a
ROLLBACK (for example in a crash recovery), but was wondering if it is
the same during a ROLLFORWARD recovery too.

I am not sure about the destination, but the archived logs are accessed and
used during a ROLLFORWARD operation.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #2

Bill

If you're using archive logging with the user exit enabled, archive logs
will be copied to the active log directory during rollforward, if your user
exit routine supports this function and you have not disabled this
capability.

Crash recovery does not touch your archive logs unless you have enabled
infinite logging. Log files needed for crash recovery and rollback remain
in you your active log directory.
"Raquel" <ra************ ****@yahoo.com> wrote in message
news:9a******** *************** ***@posting.goo gle.com...

During a ROLLFORWARD recovery, are the log datasets copied from the
archive log directory to the active log directory? I know the log datasets
are copied from archive log directory to active log directory during a
ROLLBACK (for example in a crash recovery), but was wondering if it is
the same during a ROLLFORWARD recovery too.

TIA
Raquel.

Nov 12 '05 #3

Raquel

Thank you very much Bill and Knut for your answers. Appreciate that.

Raquel.

Nov 12 '05 #4

Similar topics

2622

Rollforward recovery algorithm...

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...

DB2 Database

4385

SQL 1042c - unexpected system error occurred with rollforward recovery

by: Michelle | last post by:

Hi, I'm trying to rollforward my database to end of logs and complete, the first error message i get is - SQL6063N rollforward recovery on database X has stopped on node "0" due to change in log file size, when i re-issue the command I get the " unexpected system error occured" I also dropped the db and restored it again, but still getting the same errors.

DB2 Database

2638

container recovery

by: jignesh shah | last post by:

Hi all, Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards Jignesh

DB2 Database

3118

ROLLFORWARD QUESTION

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

DB2 Database

3410

Last commited transaction less then backup image timestamp after restore with rollforward?

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 .....

DB2 Database

5717

how to monitor restore process during rollforward ?

by: t2581 | last post by:

Hi, we are daily restore db "PRICE" with rollforward from server A into PRICE on server B Usually we restore from backup with timestamp of ~ 02:00 AM and applying logs till 7 AM (30-50 logs),restore process last 1 1/2 hr. Sometimes we need to restore till 10-11 am (80-90 log files). Restore at this case could last up to 5 hrs.

DB2 Database

5764

how to rollforward without userexit - SQL1268N

by: darnold | last post by:

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.

DB2 Database

2376

rollforward recovery & rollforward pending state

by: balubkp | last post by:

can u plz tell me the rollforward recovery & rollforward pending state concepts

DB2 Database

1816

ROLLFORWARD failed

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...

DB2 Database

10374

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10374

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

10114

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7651

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6880

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5548

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5686

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4331

transfer the data from one system to another through ip address

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

C# / C Sharp

3011

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General