Backup with exp command on daily basis...
Dear All,
I have an Oracle 11gR2 Linux based server. Server contains about 4 database users.
I need to backup these 4 users on daily basis. For this I log on to the server, run exp command and in parameters provide path of the parameter file. Backup is created in the folder defined in the parameter file. Also i have to change the file daily to change name of the backup dmp and log files.
These are the contents of parameter file:
FILE=c:\BSS_28_07_10m.dmp
LOG=c:\BSS_28_07_10m.log
OWNER=
TRAVEL,
STD_UNIV,
LOG,
INVENTORY
COMPRESS=Y
ROWS=Y
INDEXES=Y
STATISTICS=NONE
This is the command for exp
exp user/pass@web parfile=e:\db_backup\exp-production.txt
Is there any possibility to schedule this routine automatically performing the backup daily and changing the file name itself.
Please help
Imran