Re: Informix ontape and tape changer
Hi Gary,
I just did a small test with expect and after this I think it will
solve our (client's) problem. Thank you very much for your advice!
Many regards,
Stephan.
Gary.Cherneski@MCI.Com wrote:
>
> In article <6t3g2v$j3l$1@news00.btx.dtag.de>,
> triple-p.sst@t-online.de wrote:
> > Hi,
> > I hope you can provide a solution for our (respectively our client's)
> > problem. At first the hard-/software environment:
> >
> > * Sun Enterprise 3000
> > * 4mm tape changer (max. 5 tapes, each max. of 4 GB)
> > * Solaris 2.5
> > * Informix OnLine 7.24
> >
> > The backup ceremony :-) is controlled by a script which cpio's the file
> > system on the 1st tape, switches to the 2nd tape with a special command,
> > and then starts the ontape for backing up the database system.
> > Now, the database grew and exceeded the tape size, so ontape prompts
> > for a 2nd tape and waits for confirmation - 'til the morning!
> >
> > How can we convince (more or less elegant) Informix's ontape to switch
> > to the 3rd tape in the changer to backup the whole database system in
> > one go without waiting for the administrator? Or how do you handle this
> > kind of problem? (BTW, we were told that there's is no possibility to
> > use compressed device with the hardware mentioned above.)
[snip]
>
>
> We had a similar problem where we had to use multiple tapes in order to
> complete an archive and we didn't want to have to manually send the commands
> to advance the tapes. I wrote a tool in Expect to accomplish this task (see
> below.) Expect is a TcL-based toolkit that performs interactive command
> interpretation. So it will be necessary for you to install Expect but it
> will be well worth the effort.
>
> Hope this solves your problem.
>
> Gary D. Cherneski
> Sr. DBA/Consultant
> (719) 535-3633
> garyc@rmi.net
>
> Here is the script:
>
> #!/usr/local/bin/expect-5.22/expect -f
> #
> # SCRIPT: perform_archive.exp
> # WRITTEN BY: Gary D. Cherneski
> # DESCRIPTION: This expect script will run the ontape -s -L 0 command and
> # respond to the prompts encountered. This assumes that the
> # tape juke box is loaded with tapes and ready to run.
>
> set force_conservative 0 ;# set to 1 to force conservative mode even if
> ;# script wasn't run conservatively originally
> if {$force_conservative} {
> set send_slow {1 .1}
> proc send {ignore arg} {
> sleep .1
> exp_send -s -- $arg
> }
> }
>
> set timeout -1
> spawn ontape -s -L 0
> match_max 100000
>
> while 1 {
> expect {
> eof {break}
> "Please mount tape 1 *" {send "\\r"}
> "Please mount tape \\[2-4] *" {exec mt -f /dev/rmt/3 rewoffl;\\
> sleep 180; send "\\r"}
> }
> }
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
--
Stephan Stresing
Media Systeme
Gesellschaft fuer Druck & Verlag mbH
Suedwestpark 48
D-90449 Nuernberg
Phone +49 911 6809-113
Fax +49 911 6809-110
eMail triple-p.sst@t-online.de
WWW http://www.mediasys.triple-p.com