IDS Forum

Re: Backup - restore IDS 7.31 on Solaris and Win N

Posted By: Art Kagel
Date: Tuesday, 15 September 2009, at 11:30 a.m.

In Response To: Backup - restore IDS 7.31 on Solaris and Win NT (KURT VAN GOMPEL)

Kurt,

Version and platform information are always helpful to get an answer that is
useful to you. For example, if you are running IDS v 11.50 you can roll
forward the logical logs after a physical restore of an external (or
offline) backup, yes. If you are using an earlier release then, no.

BTW, you should be aware that except for the oldest versions of IDS (version
info about what you have would help again) you can take an external backup
of the IDS instance without taking the engine offline at all! You just have
to execute a checkpoint and block the engine from modifying the disk image
while the disks are being copied. This is accomplished with the 'onmode -c
block' command. Once the disks have been copied, or if you are using
mirrored disks, once the mirrors have been broken so you can make the backup
copy from the emancipated mirrors, you release the instance to resume
writing to disk with 'onmode -c unblock'. If you are using the separated
mirror copies for the backup process, then you would reestablish the mirrors
once the copy operation has completed and let them catch up.

While it seems that you are aware of this, it can't hurt to note that
offline and external backups are not required, though they are often faster
than online backups, IDS is capable of taking archives while online as well.

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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 Tue, Sep 15, 2009 at 8:30 AM, KURT VAN GOMPEL <
kvangompel@caami-hziv.fgov.be> wrote:

> Hello,
>
> We take offline backups, this means we shut down the instance and then take
> a
> copy of the datafiles and config-files.
> Logical logs are backued up via 'ontape -c'.
>
> Is it possible, using the backed up logical logs, to rollforward the
> database
> after a restore?
>
> Thanks in advance for your answers!
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0015174a047a23c6e304739f77ae

Messages In This Thread

• Backup - restore IDS 7.31 on Solaris and Win NT
  KURT VAN GOMPEL -- Tuesday, 15 September 2009, at 8:30 a.m.
  • Re: Backup - restore IDS 7.31 on Solaris and Win N
    John Miller iii -- Tuesday, 15 September 2009, at 10:50 a.m.
    • Re: Backup - restore IDS 7.31 on Solaris and Win N
      KURT VAN GOMPEL -- Tuesday, 15 September 2009, at 11:54 a.m.
    • Re: Backup - restore IDS 7.31 on Solaris and Win N
      KURT VAN GOMPEL -- Wednesday, 16 September 2009, at 12:44 p.m.
  • Re: Backup - restore IDS 7.31 on Solaris and Win N
    Art Kagel -- Tuesday, 15 September 2009, at 11:30 a.m.
    • Re: Backup - restore IDS 7.31 on Solaris and Win N
      KURT VAN GOMPEL -- Tuesday, 15 September 2009, at 11:55 a.m.
      • Re: Backup - restore IDS 7.31 on Solaris and Win N
        John Miller iii -- Tuesday, 15 September 2009, at 1:09 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.