Logical Recovery During restore
User encountered a logical restore requesting logs prior to a level 0 backup's checkpoint time (log 26019 instead of expected 26054). The issue was resolved when the user realized active transactions existed at backup start time spanning multiple log files. The restore process correctly requires logs containing the beginning of these open transactions to enable rollback during recovery, even though they predate the checkpoint.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I am encountering a confusing issue at the moment regarding a restore of IDS10.
After running a physical restore, the logical restore is still asking for logs
prior to the level0 backup time.
Below are the details from the physical restore:
Please mount tape 1 on /database/archive/level0_prod and press Return to
continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 10.00.FC8
Archive date: Thu Apr 15 05:30:02 2010
User id: informix
Terminal id: /dev/pts/1
Archive level: 0
Tape device: /backup_dump/db_level0/level0_prod
Tape blocksize (in k): 64
Tape size (in k): 150000000
Tape number in series: 1
Archive Information
IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix Software, Inc.
Initialization Time 09/11/2007 14:38:01
System Page Size 2048
Version 14
Archive CheckPoint Time 04/15/2010 05:30:02
Once the physical restore finished, I ran a logical restore.
ontape -l
Roll forward should start with log number 26019
Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
continue
The first log logical log AFTER the checkpoint time set at the start of the
level0 backup, should be 26054. The logical restore is asking for log 26019.
What I dont understand is that the online log states: -
14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
14:37:12 Starting Log Position - 26054 0xab94018
So I dont understand why it needs to Start Logical Recovery at an older
log. Seems to recognize that the Log position is 26054.
Maybe I am missing something fundamental here. Can anybody offer any advice?
Thanks and regards,
Paul Ridding
Sorry, forgot to add. Below are the log backup times from the online log of the server that is being backed up. 03:32:43 Maximum server connections 1590 03:47:43 Fuzzy Checkpoint Completed: duration was 0 seconds, 1503 buffers not flushed. 03:47:43 Checkpoint loguniq 26019, logpos 0xa3e7744, timestamp: 0xec149638 03:47:43 Maximum server connections 1590 03:53:58 Logical Log 26019 Complete, timestamp: 0xec221710. 03:54:00 Logical Log 26019 - Backup Started 03:54:01 Logical Log 26019 - Backup Completed 03:54:02 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/etc/eventalert.sh 2 18 "Log Backup completed: 26019." "Logical Log 26019 - Backup Comple 03:54:05 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/etc/eventalert.sh 2 23 "Logical Log 26019 Comp lete, timestamp: 0xec221710." "Logical Log 04:00:50 Logical Log 26020 Complete, timestamp: 0xec32ef74. 04:00:51 Logical Log 26020 - Backup Started and... 05:30:02 Checkpoint Completed: duration was 0 seconds. 05:30:02 Checkpoint loguniq 26054, logpos 0xab94018, timestamp: 0xed0b3d8f 05:30:02 Maximum server connections 1590 05:30:03 Level 0 Archive started on rootdbs, logdbs, calydbs, phylogdbs 05:32:05 Logical Log 26054 Complete, timestamp: 0xed0f1abc. 05:32:06 Logical Log 26054 - Backup Started 05:32:07 Logical Log 26054 - Backup Completed 05:32:07 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/etc/eventalert.sh 2 18 "Log Backup completed: 26054." "Logical Log 26054 - Backup Comple 05:32:16 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/etc/eventalert.sh 2 23 "Logical Log 26054 Comp lete, timestamp: 0xed0f1abc." "Logical Log 05:36:45 Logical Log 26055 Complete, timestamp: 0xed18b4cd. 05:36:45 Logical Log 26055 - Backup Started 05:36:47 Logical Log 26055 - Backup Completed Regards, Paul
It's OK, figured it out. It is asking for an old log number because there was an open transaction, spanning multiple logs, at the time of the backup. Thanks Paul
The reason why it need a log which is before the the level 0 archive is
that when
the level 0 started there were active transactions. The archive requires
the log
with begin work of these transaction which are active during the archive
checkpoint,
just incase these transaction need to be rolled back.
EXAMPLE
=========
Logical log #10
Begin work transaction 1
Insert row 1
insert row 2
Start logical log #11
insert row 3
checkpoint which starts archive
insert row 4
rollback transaction #1
The archive will require log #10 because when the archive started
transaction #1 was active.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
> I am encountering a confusing issue at the moment regarding a restore of
> IDS10.
>
> After running a physical restore, the logical restore is still
> asking for logs
> prior to the level0 backup time.
>
> Below are the details from the physical restore:
>
> Please mount tape 1 on /database/archive/level0_prod and press Return to
> continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: IBM Informix Dynamic Server Version 10.00.FC8
> Archive date: Thu Apr 15 05:30:02 2010
> User id: informix
> Terminal id: /dev/pts/1
> Archive level: 0
> Tape device: /backup_dump/db_level0/level0_prod
> Tape blocksize (in k): 64
> Tape size (in k): 150000000
> Tape number in series: 1
>
> Archive Information
>
> IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> Software, Inc.
>
> Initialization Time 09/11/2007 14:38:01
> System Page Size 2048
> Version 14
> Archive CheckPoint Time 04/15/2010 05:30:02
>
> Once the physical restore finished, I ran a logical restore.
>
> ontape -l>
> Roll forward should start with log number 26019
> Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> continue
>
> The first log logical log AFTER the checkpoint time set at the start of
the
> level0 backup, should be 26054. The logical restore is asking for log
26019.
>
> What I don’t understand is that the online log states: -
>
> 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> 14:37:12 Starting Log Position - 26054 0xab94018
>
> So I don’t understand why it needs to “Start Logical Recovery” at an
older
> log. Seems to recognize that the Log position is 26054.
>
> Maybe I am missing something fundamental here. Can anybody offer any
advice?
>
> Thanks and regards,
> Paul Ridding
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The only thing I can think of is that you may have accidentally restored an earlier archive rather than the on you think you did??? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 15, 2010 at 1:51 AM, PAUL RIDDING <pridding@tt.com.au> wrote: > Sorry, forgot to add. Below are the log backup times from the online log of > the server that is being backed up. > > 03:32:43 Maximum server connections 1590 > 03:47:43 Fuzzy Checkpoint Completed: duration was 0 seconds, 1503 buffers > not > flushed. > 03:47:43 Checkpoint loguniq 26019, logpos 0xa3e7744, timestamp: 0xec149638 > > 03:47:43 Maximum server connections 1590 > 03:53:58 Logical Log 26019 Complete, timestamp: 0xec221710. > 03:54:00 Logical Log 26019 - Backup Started > 03:54:01 Logical Log 26019 - Backup Completed > 03:54:02 Process exited with return code 1: /bin/sh /bin/sh -c > /opt/informix/etc/eventalert.sh 2 18 "Log Backup completed: > 26019." "Logical Log 26019 - Backup Comple > 03:54:05 Process exited with return code 1: /bin/sh /bin/sh -c > /opt/informix/etc/eventalert.sh 2 23 "Logical Log 26019 Comp > lete, timestamp: 0xec221710." "Logical Log > 04:00:50 Logical Log 26020 Complete, timestamp: 0xec32ef74. > 04:00:51 Logical Log 26020 - Backup Started > > and... > > 05:30:02 Checkpoint Completed: duration was 0 seconds. > 05:30:02 Checkpoint loguniq 26054, logpos 0xab94018, timestamp: 0xed0b3d8f > > 05:30:02 Maximum server connections 1590 > 05:30:03 Level 0 Archive started on rootdbs, logdbs, calydbs, phylogdbs > 05:32:05 Logical Log 26054 Complete, timestamp: 0xed0f1abc. > 05:32:06 Logical Log 26054 - Backup Started > 05:32:07 Logical Log 26054 - Backup Completed > 05:32:07 Process exited with return code 1: /bin/sh /bin/sh -c > /opt/informix/etc/eventalert.sh 2 18 "Log Backup completed: > 26054." "Logical Log 26054 - Backup Comple > 05:32:16 Process exited with return code 1: /bin/sh /bin/sh -c > /opt/informix/etc/eventalert.sh 2 23 "Logical Log 26054 Comp > lete, timestamp: 0xed0f1abc." "Logical Log > 05:36:45 Logical Log 26055 Complete, timestamp: 0xed18b4cd. > 05:36:45 Logical Log 26055 - Backup Started > 05:36:47 Logical Log 26055 - Backup Completed > > Regards, > Paul > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e68ee262a612d60484462ff4
Happy morning to you too!
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Apr 15, 2010 at 3:02 AM, John Miller iii <miller3@us.ibm.com> wrote:
>
> The reason why it need a log which is before the the level 0 archive is
> that when
> the level 0 started there were active transactions. The archive requires
> the log
> with begin work of these transaction which are active during the archive
> checkpoint,
> just incase these transaction need to be rolled back.
>
> EXAMPLE
> =========
>
> Logical log #10
> Begin work transaction 1
> Insert row 1
> insert row 2
>
> Start logical log #11
> insert row 3
> checkpoint which starts archive
>
> insert row 4
> rollback transaction #1
>
>
> The archive will require log #10 because when the archive started
> transaction #1 was active.
>
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
>
> > I am encountering a confusing issue at the moment regarding a restore of
> > IDS10.
> >
> > After running a physical restore, the logical restore is still
> > asking for logs
> > prior to the level0 backup time.
> >
> > Below are the details from the physical restore:
> >
> > Please mount tape 1 on /database/archive/level0_prod and press Return to
> > continue ...
> >
> > Archive Tape Information
> >
> > Tape type: Archive Backup Tape
> > Online version: IBM Informix Dynamic Server Version 10.00.FC8
> > Archive date: Thu Apr 15 05:30:02 2010
> > User id: informix
> > Terminal id: /dev/pts/1
> > Archive level: 0
> > Tape device: /backup_dump/db_level0/level0_prod
> > Tape blocksize (in k): 64
> > Tape size (in k): 150000000
> > Tape number in series: 1
> >
> > Archive Information
> >
> > IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> > Software, Inc.
> >
> > Initialization Time 09/11/2007 14:38:01
> > System Page Size 2048
> > Version 14
> > Archive CheckPoint Time 04/15/2010 05:30:02
> >
> > Once the physical restore finished, I ran a logical restore.
> >
> > ontape -l> >
> > Roll forward should start with log number 26019
> > Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> > continue
> >
> > The first log logical log AFTER the checkpoint time set at the start of
> the
> > level0 backup, should be 26054. The logical restore is asking for log
> 26019.
> >
> > What I don’t understand is that the online log states: -
> >
> > 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> > 14:37:12 Starting Log Position - 26054 0xab94018
> >
> > So I don’t understand why it needs to “Start Logical Recovery” at an
> older
> > log. Seems to recognize that the Log position is 26054.
> >
> > Maybe I am missing something fundamental here. Can anybody offer any
> advice?
> >
> > Thanks and regards,
> > Paul Ridding
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e6d3cf1a3f42010484463599
The reason why it needs a log which is before the level 0 archive is that
when
the level 0 started there were active transactions. The archive requires
the logical log
with begin work for these open transaction which are active during the
archive checkpoint,
just incase these transaction need to be rolled back.
EXAMPLE
=========
Logical log #10
Begin work transaction 1
Insert row 1
insert row 2
Start logical log #11
insert row 3
checkpoint which starts archive
insert row 4
rollback transaction #1
The archive will require log #10 because when the archive started
transaction #1 was active.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
> I am encountering a confusing issue at the moment regarding a restore of
> IDS10.
>
> After running a physical restore, the logical restore is still
> asking for logs
> prior to the level0 backup time.
>
> Below are the details from the physical restore:
>
> Please mount tape 1 on /database/archive/level0_prod and press Return to
> continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: IBM Informix Dynamic Server Version 10.00.FC8
> Archive date: Thu Apr 15 05:30:02 2010
> User id: informix
> Terminal id: /dev/pts/1
> Archive level: 0
> Tape device: /backup_dump/db_level0/level0_prod
> Tape blocksize (in k): 64
> Tape size (in k): 150000000
> Tape number in series: 1
>
> Archive Information
>
> IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> Software, Inc.
>
> Initialization Time 09/11/2007 14:38:01
> System Page Size 2048
> Version 14
> Archive CheckPoint Time 04/15/2010 05:30:02
>
> Once the physical restore finished, I ran a logical restore.
>
> ontape -l>
> Roll forward should start with log number 26019
> Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> continue
>
> The first log logical log AFTER the checkpoint time set at the start of
the
> level0 backup, should be 26054. The logical restore is asking for log
26019.
>
> What I don’t understand is that the online log states: -
>
> 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> 14:37:12 Starting Log Position - 26054 0xab94018
>
> So I don’t understand why it needs to “Start Logical Recovery” at an
older
> log. Seems to recognize that the Log position is 26054.
>
> Maybe I am missing something fundamental here. Can anybody offer any
advice?
>
> Thanks and regards,
> Paul Ridding
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
John Miller iii wrote:
> The reason why it needs a log which is before the level 0 archive is that
> when
> the level 0 started there were active transactions. The archive requires
> the logical log
> with begin work for these open transaction which are active during the
> archive checkpoint,
> just incase these transaction need to be rolled back.
>
> EXAMPLE
> =========
>
> Logical log #10
> Begin work transaction 1
> Insert row 1
> insert row 2
>
> Start logical log #11
> insert row 3
> checkpoint which starts archive
>
> insert row 4
> rollback transaction #1
>
>
> The archive will require log #10 because when the archive started
> transaction #1 was active.
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
>
> > I am encountering a confusing issue at the moment regarding a restore of
> > IDS10.
> >
> > After running a physical restore, the logical restore is still
> > asking for logs
> > prior to the level0 backup time.
> >
> > Below are the details from the physical restore:
> >
> > Please mount tape 1 on /database/archive/level0_prod and press Return to
> > continue ...
> >
> > Archive Tape Information
> >
> > Tape type: Archive Backup Tape
> > Online version: IBM Informix Dynamic Server Version 10.00.FC8
> > Archive date: Thu Apr 15 05:30:02 2010
> > User id: informix
> > Terminal id: /dev/pts/1
> > Archive level: 0
> > Tape device: /backup_dump/db_level0/level0_prod
> > Tape blocksize (in k): 64
> > Tape size (in k): 150000000
> > Tape number in series: 1
> >
> > Archive Information
> >
> > IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> > Software, Inc.
> >
> > Initialization Time 09/11/2007 14:38:01
> > System Page Size 2048
> > Version 14
> > Archive CheckPoint Time 04/15/2010 05:30:02
> >
> > Once the physical restore finished, I ran a logical restore.
> >
> > ontape -l> >
> > Roll forward should start with log number 26019
> > Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> > continue
> >
> > The first log logical log AFTER the checkpoint time set at the start of
> the
> > level0 backup, should be 26054. The logical restore is asking for log
> 26019.
> >
> > What I don’t understand is that the online log states: -
> >
> > 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> > 14:37:12 Starting Log Position - 26054 0xab94018
> >
> > So I don’t understand why it needs to “Start Logical Recovery” at an
> older
> > log. Seems to recognize that the Log position is 26054.
> >
> > Maybe I am missing something fundamental here. Can anybody offer any
> advice?
> >
> > Thanks and regards,
> > Paul Ridding
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
I blame the volcano.
--
Cheers,
Obnoxio The Clown
http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John
Miller iii
Sent: Thursday, April 15, 2010 2:03 AM
To: ids@iiug.org
Subject: Re: Logical Recovery During restore [19700]
VGhlIHJlYXNvbiB3aHkgaXQgbmVlZCBhIGxvZyB3aGljaCBpcyBiZWZvcmUgdGhlIHRoZSBsZXZl
-----------------------^
Shouldn't that be G
l 0 archive is
that when
the level 0 started there were active transactions. The archive requires
the log
with begin work of these transaction which are active during the archive
checkpoint,
just incase these transaction need to be rolled back.
EXAMPLE
=========
Logical log #10
Begin work transaction 1
Insert row 1
insert row 2
Start logical log #11
insert row 3
checkpoint which starts archive
insert row 4
rollback transaction #1
The archive will require log #10 because when the archive started
transaction #1 was active.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
> I am encountering a confusing issue at the moment regarding a restore of
> IDS10.
>
> After running a physical restore, the logical restore is still
> asking for logs
> prior to the level0 backup time.
>
> Below are the details from the physical restore:
>
> Please mount tape 1 on /database/archive/level0_prod and press Return to
> continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: IBM Informix Dynamic Server Version 10.00.FC8
> Archive date: Thu Apr 15 05:30:02 2010
> User id: informix
> Terminal id: /dev/pts/1
> Archive level: 0
> Tape device: /backup_dump/db_level0/level0_prod
> Tape blocksize (in k): 64
> Tape size (in k): 150000000
> Tape number in series: 1
>
> Archive Information
>
> IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> Software, Inc.
>
> Initialization Time 09/11/2007 14:38:01
> System Page Size 2048
> Version 14
> Archive CheckPoint Time 04/15/2010 05:30:02
>
> Once the physical restore finished, I ran a logical restore.
>
> ontape -l>
> Roll forward should start with log number 26019
> Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> continue
>
> The first log logical log AFTER the checkpoint time set at the start of
the
> level0 backup, should be 26054. The logical restore is asking for log
26019.
>
> What I don’t understand is that the online log states: -
>
> 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> 14:37:12 Starting Log Position - 26054 0xab94018
>
> So I don’t understand why it needs to “Start Logical Recovery” at an
older
> log. Seems to recognize that the Log position is 26054.
>
> Maybe I am missing something fundamental here. Can anybody offer any
advice?
>
> Thanks and regards,
> Paul Ridding
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
_____
avast! Antivirus <http://www.avast.com>; : Outbound message clean.
Virus Database (VPS): 100415-0, 04/15/2010
Tested on: 4/15/2010 8:57:03 AM
avast! - copyright (c) 1988-2010 ALWIL Software.
Cheeky!
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, Apr 15, 2010 at 11:37 AM, John Miller iii <miller3@us.ibm.com>wrote:
>
> The reason why it needs a log which is before the level 0 archive is that
> when
> the level 0 started there were active transactions. The archive requires
> the logical log
> with begin work for these open transaction which are active during the
> archive checkpoint,
> just incase these transaction need to be rolled back.
>
> EXAMPLE
> =========
>
> Logical log #10
> Begin work transaction 1
> Insert row 1
> insert row 2
>
> Start logical log #11
> insert row 3
> checkpoint which starts archive
>
> insert row 4
> rollback transaction #1
>
>
> The archive will require log #10 because when the archive started
> transaction #1 was active.
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
>
> > I am encountering a confusing issue at the moment regarding a restore of
> > IDS10.
> >
> > After running a physical restore, the logical restore is still
> > asking for logs
> > prior to the level0 backup time.
> >
> > Below are the details from the physical restore:
> >
> > Please mount tape 1 on /database/archive/level0_prod and press Return to
> > continue ...
> >
> > Archive Tape Information
> >
> > Tape type: Archive Backup Tape
> > Online version: IBM Informix Dynamic Server Version 10.00.FC8
> > Archive date: Thu Apr 15 05:30:02 2010
> > User id: informix
> > Terminal id: /dev/pts/1
> > Archive level: 0
> > Tape device: /backup_dump/db_level0/level0_prod
> > Tape blocksize (in k): 64
> > Tape size (in k): 150000000
> > Tape number in series: 1
> >
> > Archive Information
> >
> > IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> > Software, Inc.
> >
> > Initialization Time 09/11/2007 14:38:01
> > System Page Size 2048
> > Version 14
> > Archive CheckPoint Time 04/15/2010 05:30:02
> >
> > Once the physical restore finished, I ran a logical restore.
> >
> > ontape -l> >
> > Roll forward should start with log number 26019
> > Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> > continue
> >
> > The first log logical log AFTER the checkpoint time set at the start of
> the
> > level0 backup, should be 26054. The logical restore is asking for log
> 26019.
> >
> > What I don’t understand is that the online log states: -
> >
> > 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> > 14:37:12 Starting Log Position - 26054 0xab94018
> >
> > So I don’t understand why it needs to “Start Logical Recovery” at an
> older
> > log. Seems to recognize that the Log position is 26054.
> >
> > Maybe I am missing something fundamental here. Can anybody offer any
> advice?
> >
> > Thanks and regards,
> > Paul Ridding
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e6471602fc1e1e04844ac98f
When cleaned up after conversion from Base64, John said:
The reason why it needs a log which is before the level 0 archive is
that when the level 0 started there were active transactions. The
archive requires the logical log with begin work for these open
transaction which are active during the archive checkpoint, just in case
these transaction need to be rolled back.
EXAMPLE
=========
Logical log #10
Begin work transaction 1
Insert row 1
insert row 2
Start logical log #11
insert row 3
checkpoint which starts archive
insert row 4
rollback transaction #1
The archive will require log #10 because when the archive started
transaction #1 was active.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
> I am encountering a confusing issue at the moment regarding a restore
> of IDS10.
>
> After running a physical restore, the logical restore is still asking
> for logs prior to the level0 backup time.
>
> Below are the details from the physical restore:
>
> Please mount tape 1 on /database/archive/level0_prod and press Return
> to continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: IBM Informix Dynamic Server Version 10.00.FC8
> Archive date: Thu Apr 15 05:30:02 2010
> User id: informix
> Terminal id: /dev/pts/1
> Archive level: 0
> Tape device: /backup_dump/db_level0/level0_prod
> Tape blocksize (in k): 64
> Tape size (in k): 150000000
> Tape number in series: 1
>
> Archive Information
>
> IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> Software, Inc.
>
> Initialization Time 09/11/2007 14:38:01
> System Page Size 2048
> Version 14
> Archive CheckPoint Time 04/15/2010 05:30:02
>
> Once the physical restore finished, I ran a logical restore.
>
> ontape -l>
> Roll forward should start with log number 26019
> Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> continue
>
> The first log logical log AFTER the checkpoint time set at the start
> of the level0 backup, should be 26054. The logical restore is asking
> for log 26019.
>
> What I don't understand is that the online log states: -
>
> 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> 14:37:12 Starting Log Position - 26054 0xab94018
>
> So I don't understand why it needs to "Start Logical Recovery" at an
> older log. Seems to recognize that the Log position is 26054.
>
> Maybe I am missing something fundamental here. Can anybody offer any
> advice?
{
On Thu, Apr 15, 2010 at 08:37, John Miller iii <miller3@us.ibm.com> wrote:
>
> The reason why it needs a log which is before the level 0 archive is that
> when
> the level 0 started there were active transactions. The archive requires
> the logical log
> with begin work for these open transaction which are active during the
> archive checkpoint,
> just incase these transaction need to be rolled back.
>
> EXAMPLE
> =========
>
> Logical log #10
> Begin work transaction 1
> Insert row 1
> insert row 2
>
> Start logical log #11
> insert row 3
> checkpoint which starts archive
>
> insert row 4
> rollback transaction #1
>
>
> The archive will require log #10 because when the archive started
> transaction #1 was active.
>
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 04/14/2010 10:36:51 PM:
>
> > I am encountering a confusing issue at the moment regarding a restore of
> > IDS10.
> >
> > After running a physical restore, the logical restore is still
> > asking for logs
> > prior to the level0 backup time.
> >
> > Below are the details from the physical restore:
> >
> > Please mount tape 1 on /database/archive/level0_prod and press Return to
> > continue ...
> >
> > Archive Tape Information
> >
> > Tape type: Archive Backup Tape
> > Online version: IBM Informix Dynamic Server Version 10.00.FC8
> > Archive date: Thu Apr 15 05:30:02 2010
> > User id: informix
> > Terminal id: /dev/pts/1
> > Archive level: 0
> > Tape device: /backup_dump/db_level0/level0_prod
> > Tape blocksize (in k): 64
> > Tape size (in k): 150000000
> > Tape number in series: 1
> >
> > Archive Information
> >
> > IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix
> > Software, Inc.
> >
> > Initialization Time 09/11/2007 14:38:01
> > System Page Size 2048
> > Version 14
> > Archive CheckPoint Time 04/15/2010 05:30:02
> >
> > Once the physical restore finished, I ran a logical restore.
> >
> > ontape -l> >
> > Roll forward should start with log number 26019
> > Please mount tape 1 on /backup/db_logical/llogs_prod and press Return to
> > continue
> >
> > The first log logical log AFTER the checkpoint time set at the start of
> the
> > level0 backup, should be 26054. The logical restore is asking for log
> 26019.
> >
> > What I don’t understand is that the online log states: -
> >
> > 14:37:12 Start Logical Recovery - Start Log 26019, End Log ?
> > 14:37:12 Starting Log Position - 26054 0xab94018
> >
> > So I don’t understand why it needs to “Start Logical Recovery” at an
> older
> > log. Seems to recognize that the Log position is 26054.
> >
> > Maybe I am missing something fundamental here. Can anybody offer any
> advice?
> >
> > Thanks and regards,
> > Paul Ridding
> >
> >
> >
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net,