el sallam 3alikom



i am using the following script to backup the database and then upload it on a storage machine,as i don't have a free space now in the database, i need to take the backup on several times (incremental)

the script

rm -i /oracle/backup/*.dmp
export NLS_LAMG=AMERICAN_AMERICA.AR8ISO8859P6
export ORACLE_SID=OFSA
exp system/palmsystem123 full=y file=/oracle/backup/ofsa_exp_bkp_$1.dmp log=/ora
cle/backup/ofsa_exp_bkp_$1.log
banner EXPORT done
echo "Export Finished @:-"
date

السلام عليكم

تعمل على بيئة لينكس

أتفضل الحل

http://www.araboug.org/ib/index.php?showtopic=22307

السلام عليكم من فضلك قم باختيار الكل وانقله لبرنامج الورد ثم اضغط مفتاحي
الموجودين بيسار لوحة المفاتيح لتقرأ الموضوع بشكل يسهل فهمهCONTROL+SHIVT
if you are looking to a scheduale incremental (Hot) backup in linux you have first to tell us which linux you use? , the Enterprise Linux Red Hat 4 and all releases have the crontab tool, this tool allows you to make schedule your incremental backup tasks, follow these steps and ensha allah your issue will resoloved:
1- you have to create a shel for your backup script, it's so easy to write a shel if you can't you can get a copy for any other shel then modify it with new shel name and write all your script contents, then save it on specified directory such as /d01/scripts/inc_backup.sh
2- now you have 2 ways to take the schedule incremental backup:
A) From RHEL follow that: goto Applications -> system tools -> Task Scheduler
it's very simple tool you have to select the shedule task (inc_backup.sh) from it's
directory, then check the times for that backup.
*** you can also make this backup many times a day.
From Linux terminal there are a tool called crontab, this is the same Task
Scheduler on A), but here you have to edit it and you can follow this way:
$ crontab -l Display list of crontab entries
$ crontab -e Edit crontab to modify / add / remove entry (ies)
$ crontab -r remove all crontab entrie (dangrous)
now open your admin user on the server and do that:
$ crontab -e (then press the INSERT key from keyboard, it will be avaliable to write
new crontab entry, i will give you example valid in all Linux and UNIX OSs)
# stopPROD
0 22 * * 1,2,3,4,7 /home/applprod/scripts/stopPROD.sh
this is a crontab entry
now let's try to understand it:
1- # stopPROD is the crontab entry name (no effect)
2- 0 here is the minuits (observe in UNIX the minuits before the hour)
3- 22 here is the hour (from 2 & 3) means the shel will run at 22:00
4- the first * means this script (shel) will run all the months
5- the second * means this scripts (shel) will run all the weeks
6- the values of 1,2,3,4,7 means the shel will run only is those week days whenever (1= Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 7=Sunday) also you can write * means all the week days.
7- /home/applprod/scripts/stopPROD.sh this is the path of the shel which will running.

now i finish
so easy
are you happy? i am here to make you happy
if there were any unclear syntax or misunderstanding please feed back
good louck
Mohamed Tawfik
Oracle8i,9i&10G DBA OCP
Oracle APPS. DBA
RHEL4 Admin.
[email protected]