Re: Inappropriate ioctl for device

Try redirecting the stderr and stdout of the tar command to some log file like this:

svrmgrl <<EOT
connect internal
alter tablespace...
!tar cvf /backup/system01.tar /oradb/data1/system01.dbf \

    > /backup/tar_system.log 2>&1
alter tablespace...
EOT I've broken the line so you don't miss the end, but you'd probably not need to do that.

This way tar(1) doesn't need to know anything about the controlling terminal.

-Kevin

<susana73_at_hotmail.com> wrote in message news:8snl73$jes$1_at_nnrp1.deja.com...
> Hi,
>
> This question may not be oracle related. But I got this error when I
> try to do hot backup in a shell script.
>
> The script looks like this:
> #!/bin/sh
> /opt/oracle/product/8.1.6/svrmgrl <<EOF
> connect internal
> alter tablespace system begin backup;
> !tar cvf /backup/system01.tar /oradb/data1/system01.dbf
> alter tablespace system end backup;
> ...
> quit
> EOF
>
> When I execute the script on unix prompt, I got this:
> SVRMGR> Statement processed.
> SVRMGR> stty: : Inappropriate ioctl for device
> stty: : Inappropriate ioctl for device
> a /oradb/data1/system01.dbf 102408K
> SVRMGR> Statement processed.
>
> The tar command works fine but I would like to get rid of the stty
> error. I have Oracle 8.1.6 on Solaris 2.7.
>
> Thanks!
>
> Susan
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 19 2000 - 17:17:17 CDT