. /home/oracle/.profile_orcl1

FNM=orcl1exp_`date +%a`

exp system/******** full=y file=/u03/app/oracle/archive/orcl1/$FNM.dmp
log=/u03/app/oracle/archive/orcl1/$FNM.log compress=n consistent=y direct=y

SRC=/u03/app/oracle/archive/orcl1
TRG=/u01/oracle/backup/orcl1

scp $SRC/$FNM.dmp $TRG/$FNM.dmp
scp $SRC/$FNM.log $TRG/$FNM.log

Mir M. Mirhashimali
Oracle Systems Manager
Web Services, Rice University
(713) 348-6365



Imtiaz wrote:

>Dear All,
>
>If anybody has a complete database exporting script which changes the date itself everyday of the export files created.
>
>I have tried with date variable but its not taking in the export parameter file it is taking the file name as date itself not the date value.
>
>
>Parameter file
>=============
>full=y
>file=(/depndata4/Backup/ansdb3009_01.dmp,/depndata4/Backup/ansdb3009_02.dmp,/depndata4/Backup/ansdb3009_03.dmp)
>filesize=2147483648
>log=/depndata4/Backup/ansdb3009.log
>buffer=3000000
>statistics=none
>
>I want the above date should change by itself everyday.
>
>Thanks in advance.
>
>
>Mohammed Imtiaz
>Systems Administrator,
>
>Al Ansari Exchange
>Tel: (+971) 2-6227888 (extn) 511
>Mobile: (+971) 50-7724165
>Fax: (+971) 2-6224794
>E-Mail: [Email address protected]
>URL: http://www.alansariuae.com
>------------------------------------------------------------------------------
>Islam Teaches : "Do not sniff at food like animals."
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>.
>
>
>

Oracle LazyDBA home page