On Tue, Jun 13, 2006 at 06:31:12PM +0700, Andi Eko Prasetyo wrote:
> Mas2,
> minta tlg untuk maslah programming di shell, saya ingin backup data di
> oracle dengan mendapatkan waktu nya sekalian, berikut script nya
> 
> exportdir=/home/oracle/backup
> file=$exportdir/GA.dmp
> date '+%m/%d/%y' > tgl
> mv -f $file.gz $file+$tgl.gz
> /opt/app/bin/exp GA/[EMAIL PROTECTED] file='/home/oracle/backup/GA.dmp' 
> log='/home/oracle/backup/GA.log' owner=GA
> gzip /home/oracle/backup/GA.dmp
> 
> tapi file nya tidak ada tgl saat backup, mohon pencerahan nya.

Kalo udah bikin variabel ya mbok dipake, hehehe. Dan urutan
perintahnya coba diperhatikan, jgn direname sebelum filenya ada.

exportdir="/home/oracle/backup"
tgl=`date '+%m/%d/%y'`          # bedakan backtick ` dan quote '
file="${exportdir}/GA-${tgl}.dmp"
logfile="${exportdir}/GA-${tgl}.log"
/opt/app/bin/exp GA/[EMAIL PROTECTED] file="${file}" log="${logfile}" owner=GA
gzip "${file}"

Untuk debugging shell scripts, jalankan dg -x, misalnya (kalo Bourne
shell scripts): sh -x namascript.sh, biar tau what's going on.

Ronny

Attachment: signature.asc
Description: Digital signature

Kirim email ke