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

1710

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

2619

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

4382

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

2636

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

5716

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

5761

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

1815

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

10475

Problem With Comparison Operator <=> in G++

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

C / C++

10250

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

10222

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

9068

AI Job Threat for Devs

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

Career Advice

5463

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

5585

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

4139

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

3757

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2938

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