andi,
sila cek utk perbandingan :)
#!/bin/sh
rm -rf tgl
date +%d-%Y-%m > tgl
read var_tgl < tgl
var_file="XXX_"$var_tgl
DUMP_FILE="/home/oracle/dmp/$var_file"
PAR_FILE="/home/oracle/dmp/XXX.TXT"
LOG_FILE="/home/oracle/dmp/$var_file"
echo "userid=user/passwd" > $PAR_FILE
echo "indexes=y" >> $PAR_FILE
echo "grants=y" >> $PAR_FILE
echo "statistics=none" >> $PAR_FILE
echo "constraints=y" >> $PAR_FILE
echo "recordlength=8192" >> $PAR_FILE
echo "compress=n" >> $PAR_FILE
echo "buffer=32768800" >> $PAR_FILE
echo "object_consistent=y" >> $PAR_FILE
echo "log=$LOG_FILE.log" >> $PAR_FILE
echo "file=$DUMP_FILE.dmp" >> $PAR_FILE
rm -rf /var/spool/mail/oracle
export ORACLE_HOME=/home/oracle/OraHome1
export ORACLE_SID=your_sid
/home/oracle/OraHome1/bin/exp parfile=$PAR_FILE
rm -rf $PAR_FILE
gzip "$DUMP_FILE.dmp"
--J
----- Original Message -----
From: "Andi Eko Prasetyo" <[EMAIL PROTECTED]>
To: <linux-programming@linux.or.id>
Sent: Tuesday, June 13, 2006 6:31 PM
Subject: [linux-programming] Shell Date
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.
Thx a lot for yr adv support.
--
Tks & Best regards,
Andi EP
IT Engineer
mailto:[EMAIL PROTECTED]
Send instant messages to your online friends http://asia.messenger.yahoo.com
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis
