Rekans, terima kasih atas bantuan nya, skrg sdh clear semua dan bisa running well, mengrnai pemakaian RMAN juga saya pakai, hanya ini untuk HOT backup aja.
-- Tks & Best regards, Andi EP IT Engineer mailto:[EMAIL PROTECTED] Wednesday, June 14, 2006, 8:39:50 AM, you wrote: > 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: <[email protected]> > 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
