Thanks a lot !
My problem was the fact that I tried to restore on a Linux machine a backup
made on a UNIX machine. The INFORMIX server version was the same.
The problem was the OS, in fact.
Backup with ontape is recommended only when the restore is made on the same
machine.

Carmen

----- Original Message -----
From: "S.Dhayanidhi" <sdhaya@hotmail.com>
To: <informix-list@iiug.org>
Sent: Monday, January 12, 2004 6:35 AM
Subject: Re: database restore with ontape -r on Informix Online Dynamic
Server 7.31 on Linux


> Here is my cute little code.. for unattended tape restore.
> We do restore to our development everyday and it works fine.
>
>
> # ------------------------------------------------------------------
> echo " ********************************************"
> echo " * Tape Restore Utility (For Single Tape ) *"
> echo " ********************************************"
> # ------------------------------------------------------------------
> echo " "
> echo " Press Enter to Continue or CTRL-C to Abort \c"
> read con
> echo "Please wait Shutting Down Engine..."
> echo "y\ny\n" | onmode -k
> echo "\nPlease wait Restoring..."
> echo "\ny\nn\nn\nn\n" | ontape -r
> while true
> do
> engstatus=`onstat - | awk '{ print $5 } '`
> case $engstatus in
> *Fast) echo "Online Engine is Recovering...";
> sleep 50;;
> *On-Line) grantdba;
> echo "Engine in Online Mode....Ready to Use...";
> exit;;
> *Quiescent) echo "Engine is Quescient mode... Making Online";
> cd etc;
> onmode -m;
> cp onconfig.null onconfig;
> ontape -s -L 0 -B prime;
> cp onconfig.tape onconfig;
> cd;;
> *for) echo "Engine is Off Line.. Starting Engine";
> oninit;
> exit;;
> *) echo "Cannot find Engine Status..";
> exit;;
> esac
> done
>

sending to informix-list