ontape dubts
A user setting up ontape backups on IDS 9.4 (Windows) asked what TAPESIZE to use for DAT72 tapes, whether one shared log tape plus daily level-0s was sensible, and why 'ontape -a' didn't seem to free logs. Replies: set TAPESIZE to roughly the tape capacity in KB (e.g. ~72,000,000, or less than the real capacity); use 'ontape -c' for continuous logical-log backup, stopping it before the level-0 and restarting on a fresh tape afterwards; 'ontape -a' only backs up dirty logs once and exits, though it can be driven from ALARMPROGRAM instead. Keep paired archive/log tapes (about two weeks of logs) so an older archive can still be rolled forward. Level-0 archives can be taken online with users connected.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to everyone,
I´m implementing a ontape backup system on Informix IDS 9.4 but I have
several questions:
I) I use DAT72 tapes. Which is the right TAPESIZE I must write to onconfig?
II) I suppose to do one tape per each weekday to do the level 0 (zero) using
"ontape -s -L 0" command and only one tape to do automatic log's backup
using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do level
zero backups and only one to do log's backup. After each level zero backup I
will put the same log's backup tape of the last day.
I tried it but it seems to me that the ontape -a does not move logs and
the informix logs fill up quickly.
Is it correct to use ontape -c?
Thanks in advance for all your answers.
Regards,
Pedro Ivo
--0016367ed634b0b305046542e8a6
You can do something like this:
Monday - create level 0 archive (ontape -s -L 0) on tape "MonArc" and
after that start continous logical log backup (ontape -c) on tape "MonLogs"
Tuesday - the same procedure with tapes "TueArc" and "TueLogs"
Wednesday - the same procedure; tapes "WedArc" and "WedLogs"
...
Saturday - the same procedure, tapes "SatArc" and "SatLogs"
As you can see, you need 6*2 tapes (i.e. 12)
Or you can use e.g. 3 pairs of tapes and use it round robin:
Create archive on tape "1Arc" and continous logical log backup on tape
"1Log"
The same procedure; tapes "2Arc" and "2Log"
The same procedure; tapes "3Arc" and "3Log"
Then, again, 1st pair of tapes.
Yes, it is more than correct to use continous logical log backup.
HTH
Hrvoje
Pedro Ivo wrote:
> Hi to everyone,
>
> I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> several questions:
>
> I) I use DAT72 tapes. Which is the right TAPESIZE I must write to onconfig?
>
> II) I suppose to do one tape per each weekday to do the level 0 (zero) using
> "ontape -s -L 0" command and only one tape to do automatic log's backup
> using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do level
> zero backups and only one to do log's backup. After each level zero backup I
> will put the same log's backup tape of the last day.
>
> I tried it but it seems to me that the ontape -a does not move logs and
> the informix logs fill up quickly.
>
> Is it correct to use ontape -c?
>
> Thanks in advance for all your answers.
>
> Regards,
>
> Pedro Ivo
>
> --0016367ed634b0b305046542e8a6
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
Thanks Hrvoje Zokovic.
But, when I create the level 0 at Tuesday the logs at "1LOG" will no more
necessary because they actions will already be stored on the tables at
"2Arc", am I right? So why I need also to do a logs backup daily?
I forgot to say that I'm using Informix on a Windows 2003 server.
Regards,
Pedro Ivo
2009/3/16 Hrvoje Zokovic <hzokovic.iiug@gmail.com>
> You can do something like this:
> Monday - create level 0 archive (ontape -s -L 0) on tape "MonArc" and
> after that start continous logical log backup (ontape -c) on tape "MonLogs"
> Tuesday - the same procedure with tapes "TueArc" and "TueLogs"
> Wednesday - the same procedure; tapes "WedArc" and "WedLogs"
> ....
> Saturday - the same procedure, tapes "SatArc" and "SatLogs"
> As you can see, you need 6*2 tapes (i.e. 12)
>
> Or you can use e.g. 3 pairs of tapes and use it round robin:
> Create archive on tape "1Arc" and continous logical log backup on tape
> "1Log"
> The same procedure; tapes "2Arc" and "2Log"
> The same procedure; tapes "3Arc" and "3Log"
> Then, again, 1st pair of tapes.
>
> Yes, it is more than correct to use continous logical log backup.
> HTH
> Hrvoje
>
> Pedro Ivo wrote:
> > Hi to everyone,
> >
> > I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> > several questions:
> >
> > I) I use DAT72 tapes. Which is the right TAPESIZE I must write to
> onconfig?
> >
> > II) I suppose to do one tape per each weekday to do the level 0 (zero)
> using
> > "ontape -s -L 0" command and only one tape to do automatic log's backup
> > using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do
> level
> > zero backups and only one to do log's backup. After each level zero
> backup I
> > will put the same log's backup tape of the last day.
> >
> > I tried it but it seems to me that the ontape -a does not move logs and
> > the informix logs fill up quickly.
> >
> > Is it correct to use ontape -c?
> >
> > Thanks in advance for all your answers.
> >
> > Regards,
> >
> > Pedro Ivo
> >
> > --0016367ed634b0b305046542e8a6
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e64987c0f8e31c0465433d58
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Pedro Ivo
> Sent: Monday, March 16, 2009 4:13 PM
> To: ids@iiug.org
> Subject: ontape dubts [15172]
>
> Hi to everyone,
>
> I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> several questions:
>
> I) I use DAT72 tapes. Which is the right TAPESIZE I must write to
> onconfig?
TAPESIZE 72000000 # Maximum amount of data to put on tape
You could go a bit higher, I'd expect.
>
> II) I suppose to do one tape per each weekday to do the level 0 (zero)
> using
> "ontape -s -L 0" command and only one tape to do automatic log's backup
> using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do level
> zero backups and only one to do log's backup. After each level zero backup
> I
> will put the same log's backup tape of the last day.
>
> I tried it but it seems to me that the ontape -a does not move logs and
> the informix logs fill up quickly.
>
> Is it correct to use ontape -c?
Yup, just remember to stop the ontape -c, before you start the ontape -s and
restart it with a new tape when you're done with the full backup. You'll also
need to watch for when you may need to change tapes if a log tape fills up
during continuous log backup.
--EEM
>
> Thanks in advance for all your answers.
>
> Regards,
>
> Pedro Ivo
>
> --0016367ed634b0b305046542e8a6
>
>
> **************************************************************************
> *****
> Forum Note: Use "Reply" to post a response in the discussion forum.
ontape -c starts continuous logical log backup. The tape file is kept openand ontape runs continuously. Whenever a logical log fills it is copied to
the tape and freed (assuming there are no open transactions in it at the
time).
ontape -a starts an instantaneous logical log backup. It copies any dirtylogs to tape and exits. You can use this command through the ALARMPROGRAM
to emulate a continuous logical log backup without tying up a tape drive or
depending on the ontape -c to not be interrupted. See my package utils3_ak
for example script and executable ALARMPROGRAMs.
Art
On Mon, Mar 16, 2009 at 5:12 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
> Hi to everyone,
>
> I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> several questions:
>
> I) I use DAT72 tapes. Which is the right TAPESIZE I must write to onconfig?
>
> II) I suppose to do one tape per each weekday to do the level 0 (zero)
> using
> "ontape -s -L 0" command and only one tape to do automatic log's backup
> using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do level
> zero backups and only one to do log's backup. After each level zero backup
> I
> will put the same log's backup tape of the last day.
>
> I tried it but it seems to me that the ontape -a does not move logs and
> the informix logs fill up quickly.
>
> Is it correct to use ontape -c?
>
> Thanks in advance for all your answers.
>
> Regards,
>
> Pedro Ivo
>
> --0016367ed634b0b305046542e8a6
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
--001636427371acd8020465446ff9
Hi,
May I do the level zero backup ("ontape -s -L 0") with people connected to
the database? I did not find it on any book.
Regards,
Pedro Ivo
--001636920027ff485a046545050f
You can do all levels of backup with people connected to the database.
The backup image will contain a snapshot of the system at the instant you
started the backup.
If you restore you can apply the logical logs generated after that instant.
If there are any open transactions after you restore Level 0 + Level 1 (if
any) + Level 2 (if any) + Logical logs (if any) those transactions will be
rollback and the system will return to a consistent stage.
Regards.
On Mon, Mar 16, 2009 at 11:43 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
> Hi,
>
> May I do the level zero backup ("ontape -s -L 0") with people connected to
> the database? I did not find it on any book.
>
> Regards,
>
> Pedro Ivo
>
> --001636920027ff485a046545050f
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--001636c5b8effd0162046545f5cc
You always need two weeks worth of logical logs. If the most recent archive
is not usable for some reason you can always use the previous archive and
roll forward two week's worth of logical logs from the two log tapes.
Art
On Mon, Mar 16, 2009 at 5:36 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
> Thanks Hrvoje Zokovic.
>
> But, when I create the level 0 at Tuesday the logs at "1LOG" will no more
> necessary because they actions will already be stored on the tables at
> "2Arc", am I right? So why I need also to do a logs backup daily?
>
> I forgot to say that I'm using Informix on a Windows 2003 server.
>
> Regards,
>
> Pedro Ivo
>
> 2009/3/16 Hrvoje Zokovic <hzokovic.iiug@gmail.com>
>
> > You can do something like this:
> > Monday - create level 0 archive (ontape -s -L 0) on tape "MonArc" and
> > after that start continous logical log backup (ontape -c) on tape
> "MonLogs"
> > Tuesday - the same procedure with tapes "TueArc" and "TueLogs"
> > Wednesday - the same procedure; tapes "WedArc" and "WedLogs"
> > ....
> > Saturday - the same procedure, tapes "SatArc" and "SatLogs"
> > As you can see, you need 6*2 tapes (i.e. 12)
> >
> > Or you can use e.g. 3 pairs of tapes and use it round robin:
> > Create archive on tape "1Arc" and continous logical log backup on tape
> > "1Log"
> > The same procedure; tapes "2Arc" and "2Log"
> > The same procedure; tapes "3Arc" and "3Log"
> > Then, again, 1st pair of tapes.
> >
> > Yes, it is more than correct to use continous logical log backup.
> > HTH
> > Hrvoje
> >
> > Pedro Ivo wrote:
> > > Hi to everyone,
> > >
> > > I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> > > several questions:
> > >
> > > I) I use DAT72 tapes. Which is the right TAPESIZE I must write to
> > onconfig?
> > >
> > > II) I suppose to do one tape per each weekday to do the level 0 (zero)
> > using
> > > "ontape -s -L 0" command and only one tape to do automatic log's backup
> > > using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do
> > level
> > > zero backups and only one to do log's backup. After each level zero
> > backup I
> > > will put the same log's backup tape of the last day.
> > >
> > > I tried it but it seems to me that the ontape -a does not move logs and
> > > the informix logs fill up quickly.
> > >
> > > Is it correct to use ontape -c?
> > >
> > > Thanks in advance for all your answers.
> > >
> > > Regards,
> > >
> > > Pedro Ivo
> > >
> > > --0016367ed634b0b305046542e8a6
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0016e64987c0f8e31c0465433d58
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
--0016369891d5627bc0046546b6f3
Absolutely! Informix was the first database to permit live, completely
online archives back in 1990.
Art
On Mon, Mar 16, 2009 at 7:43 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
> Hi,
>
> May I do the level zero backup ("ontape -s -L 0") with people connected to
> the database? I did not find it on any book.
>
> Regards,
>
> Pedro Ivo
>
> --001636920027ff485a046545050f
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
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.
--0016e64e9c0ef2d3c4046546c4d8
Pedro Ivo
Isso ja é possivel desde os remotos tempos de versão 5 .... do IDS.
Au revoir.
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape dubts [15187]
> Date: Mon, 16 Mar 2009 21:48:56 -0400
>
> Absolutely! Informix was the first database to permit live, completely
> online archives back in 1990.
>
> Art
>
> On Mon, Mar 16, 2009 at 7:43 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
>
> > Hi,
> >
> > May I do the level zero backup ("ontape -s -L 0") with people connected to
> > the database? I did not find it on any book.
> >
> > Regards,
> >
> > Pedro Ivo
> >
> > --001636920027ff485a046545050f
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> 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.
>
> --0016e64e9c0ef2d3c4046546c4d8
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
More than messagescheck out the rest of the Windows Live.
http://www.microsoft.com/windows/windowslive/
Pedro Ivo ... (reading your name, I guess you read portuguese, if not, please
tell me).
Qual eh a capacidade que a fita DAT72 aceita ?
Se por ex for 40 GB , então coloqe no TAPESIZE do Onconfig ao menos 38000000
(38 milhoes de Kbytes).
Se a tua instancia de BD for maior que 38 Gb, então será requisitada segunda,
terceira .... fita qundo for executado o ontape -s -L 0.
Se vc tiver outra fita (tipo FITADAT) para a qual vc possa direcionar o
'continuous log' melhor ainda.
O ideal é vc ter backup log de pelo menos 3 archives , para garantir restore.
Best regards. Roberto FErronato
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ontape dubts [15186]
> Date: Mon, 16 Mar 2009 21:44:53 -0400
>
> You always need two weeks worth of logical logs. If the most recent archive
> is not usable for some reason you can always use the previous archive and
> roll forward two week's worth of logical logs from the two log tapes.
>
> Art
>
> On Mon, Mar 16, 2009 at 5:36 PM, Pedro Ivo <pedroivomz@gmail.com> wrote:
>
> > Thanks Hrvoje Zokovic.
> >
> > But, when I create the level 0 at Tuesday the logs at "1LOG" will no more
> > necessary because they actions will already be stored on the tables at
> > "2Arc", am I right? So why I need also to do a logs backup daily?
> >
> > I forgot to say that I'm using Informix on a Windows 2003 server.
> >
> > Regards,
> >
> > Pedro Ivo
> >
> > 2009/3/16 Hrvoje Zokovic <hzokovic.iiug@gmail.com>
> >
> > > You can do something like this:
> > > Monday - create level 0 archive (ontape -s -L 0) on tape "MonArc" and
> > > after that start continous logical log backup (ontape -c) on tape
> > "MonLogs"
> > > Tuesday - the same procedure with tapes "TueArc" and "TueLogs"
> > > Wednesday - the same procedure; tapes "WedArc" and "WedLogs"
> > > ....
> > > Saturday - the same procedure, tapes "SatArc" and "SatLogs"
> > > As you can see, you need 6*2 tapes (i.e. 12)
> > >
> > > Or you can use e.g. 3 pairs of tapes and use it round robin:
> > > Create archive on tape "1Arc" and continous logical log backup on tape
> > > "1Log"
> > > The same procedure; tapes "2Arc" and "2Log"
> > > The same procedure; tapes "3Arc" and "3Log"
> > > Then, again, 1st pair of tapes.
> > >
> > > Yes, it is more than correct to use continous logical log backup.
> > > HTH
> > > Hrvoje
> > >
> > > Pedro Ivo wrote:
> > > > Hi to everyone,
> > > >
> > > > I´m implementing a ontape backup system on Informix IDS 9.4 but I have
> > > > several questions:
> > > >
> > > > I) I use DAT72 tapes. Which is the right TAPESIZE I must write to
> > > onconfig?
> > > >
> > > > II) I suppose to do one tape per each weekday to do the level 0 (zero)
> > > using
> > > > "ontape -s -L 0" command and only one tape to do automatic log's backup
> > > > using "ontape -a". So I will have 6 (Monday yo Saturday) tapes to do
> > > level
> > > > zero backups and only one to do log's backup. After each level zero
> > > backup I
> > > > will put the same log's backup tape of the last day.
> > > >
> > > > I tried it but it seems to me that the ontape -a does not move logs and
> > > > the informix logs fill up quickly.
> > > >
> > > > Is it correct to use ontape -c?
> > > >
> > > > Thanks in advance for all your answers.
> > > >
> > > > Regards,
> > > >
> > > > Pedro Ivo
> > > >
> > > > --0016367ed634b0b305046542e8a6
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --0016e64987c0f8e31c0465433d58
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> 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.
>
> --0016369891d5627bc0046546b6f3
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=
en-us