Re: Shell script Backup Server Oracle Linux

"hal9000" <magicalex_at_inwind.it> wrote in message 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?
> Regards.
> ALEX
Should be like this :
#!/bin/sh
export ORACLE_HOME=/usr/oracle/9.0/
echo "The backup is beginning"
...

Matthias Received on Mon Aug 15 2005 - 05:49:02 CDT