Re: Backup/Archive
Posted in 2000
A user on IDS 7.30.UC7 under Linux couldn't find onbar/onarchive and asked how to run an unattended online archive. The advice: use ontape, fed with blank input (e.g. `echo "\\n\\n" | ontape ...`) so it answers its interactive prompts and runs unattended; onbar would require setting up a storage manager such as ISM, which is extra work. Caveat raised: this only works cleanly if the archive fits on one tape — otherwise you must script around ontape's prompts (e.g. with expect plus a tape autoloader) to swap volumes.
Topics: Backup & Restore, Platform-Specific Issues, Versions, Editions & End-of-Life
From: "Joe Terry" <jterry@xmission.com>
>
>Help ---
>
>I am using IDS 7.30.UC7 on a Linux box and am having a great deal of
>trouble
>trying to find out what Informix tool/utility is required to do an
>unattended online backup/archive of the database. The CD talks about
>onbar,
>onarchive, etc. -- these are not available with this version (I can not
>find
>them!, onbar responds with not available). I have looked at the Informix
>web site, but this seems to take me in circles. Could someone point me in
>the right direction? Thanks in advance for your help.
echo "\\n\\n" | ontape
?
For onbar, you need to set up a storage manager. ISM should be there, but
it's a bit of work.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
What does
echo "\\n\\n" | ontape do?
Joe Terry
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message
news:8tv2rm$fki$1@news.xmission.com...
>
> From: "Joe Terry" <jterry@xmission.com>
> >
> >Help ---
> >
> >I am using IDS 7.30.UC7 on a Linux box and am having a great deal of
> >trouble
> >trying to find out what Informix tool/utility is required to do an
> >unattended online backup/archive of the database. The CD talks about
> >onbar,
> >onarchive, etc. -- these are not available with this version (I can not
> >find
> >them!, onbar responds with not available). I have looked at the Informix
> >web site, but this seems to take me in circles. Could someone point me in
> >the right direction? Thanks in advance for your help.
>
> echo "\\n\\n" | ontape
>
> ?
>
> For onbar, you need to set up a storage manager. ISM should be there, but
> it's a bit of work.
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
"Joe Terry" <jterry@xmission.com> writes:
> What does
> echo "\\n\\n" | ontape do?
Exactly what was asked for: "unattended online backup/archive of the
database".
--
Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412
Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142
President, CEO Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B
"Joe Terry" <jterry@xmission.com> writes:
> What does
>
> echo "\\n\\n" | ontape do?
Echo two newlines, pipe those to ontape.
Thomas
Ronald Cole wrote:
>
> "Joe Terry" <jterry@xmission.com> writes:
> > What does
> > echo "\\n\\n" | ontape do?
>
> Exactly what was asked for: "unattended online backup/archive of the
> database".
Provided it fits on one tape. :>
-Rich
"Rich Hall" <rhall@theramp.net> wrote in message
news:3A0783B3.656D@theramp.net...
> Ronald Cole wrote:
> >
> > "Joe Terry" <jterry@xmission.com> writes:
> > > What does
> > > echo "\\n\\n" | ontape do?
> >
> > Exactly what was asked for: "unattended online backup/archive of the
> > database".
>
> Provided it fits on one tape. :>
>
> -Rich
Yep.
Or, you can write scripts to process the console output of ontape and switch
tape drives when each tape fills up. It works, as long as your operators
remember to fill each drive daily.
Doug
Doug Agnew wrote:
>
> "Rich Hall" <rhall@theramp.net> wrote in message
> news:3A0783B3.656D@theramp.net...
> > Ronald Cole wrote:
> > >
> > > "Joe Terry" <jterry@xmission.com> writes:
> > > > What does
> > > > echo "\\n\\n" | ontape do?
> > >
> > > Exactly what was asked for: "unattended online backup/archive of the
> > > database".
> >
> > Provided it fits on one tape. :>
> >
> > -Rich
>
> Yep.
>
> Or, you can write scripts to process the console output of ontape and switch
> tape drives when each tape fills up. It works, as long as your operators
> remember to fill each drive daily.
>
> Doug
Which is exactly what we did using expect and 4mm autoloaders. We have
occasionally encoutered errors where expect didn't know what to expect,
but in general it was a pretty solid solution. We don't have operators,
instead we used to rotate the tape duties through the admins. Powerful
incentive for getting the script right, when you're also the guy who
gets paged at 3:00AM for the failure!
-Rich