Re: Shell script Backup Server Oracle Linux

magicalex_at_inwind.it (hal9000) wrote in
news:1h1bcvm.19tpebg1vf60a4N%magicalex_at_inwind.it:

> I have programmed a shell script to do the backup to server Oracle on
> linux system.
> Here it is the script
> '--
> #!/bin/sh
> set ORACLE_HOME=/usr/oracle/9.0/
> export ORACLE_HOME
> echo "The backup is beginning"
> /usr/app/oracle/9.2/bin/exp system/oraclesystem full=y
> file=/home/oracle/exp/dati.dmp log=/home/oracle/exp/datilog.txt
> tar -cvf /dev/st0 exp
> echo "backup ended, have a nice day"
> ---
> I used a crontab to the the backup every day at 5.00 AM.
> But every day, the script do not run and the mail corresponding says
> ---
> Message 206 not found; No message file for product=RDBMS, facility=EXP:
> Release 9.2.0.4.0 - Production on Mon Jul 4 03:12:00 2005
>
> Copyright (c) 1982, 2002, Oracle
>
> Invalid format of Export utility name
>
> Verify that ORACLE_HOME is properly set
>
> Export terminated unsuccessfully
>
> EXP-00000: Message 0 not found; No message file for product=RDBMS,
> facility=EXPexp/
> exp/datilog.txt
> exp/dati.dmp
> exp/dati.dmp.gz
> exp/dati310505.dmp
> exp/dati.dmpgz
> backup finito, have a nice day
> --
> Any hints?

as 1st line in script

env > /tmp/oracle.env

Verify that ORACLE_HOME is properly set
Verify that ORACLE_HOME is properly set
Verify that ORACLE_HOME is properly set
Verify that ORACLE_HOME is properly set
Verify that ORACLE_HOME is properly set

You appear to be clue resistant.

After it bombs again, again, inspect /tmp/oracle.env for "proper" environment. Received on Sun Aug 14 2005 - 19:56:10 CDT