How do I Create a CRON JOB to take a DAILY FULL EXPORT at 10.30 p.m.of the 9.2 database on Sun 5.8 on Solaris?
Create a CRON JOB to take a DAILY FULL EXPORT at 10.30 p.m.of the 9.2 database on Sun 5.8 on Solaris.
I have to take FULL EXPORT of the ORACLE 9.2 database DAILY at 10.30 p.m.
I have to automate this process on Solaris as a cron job which should include the EXP command with parameters and make it work today. This is URGENT.
How do I set the environment? cron env and my Korn Shell env
How do I include username and password? - oracle login information for the EXP command
I am beginner with cron jobs. What should be the cron job command for DAILY EXPORT at 10.30 p.m.?
After the export is done, I want to move the dmp file to a backup server. How do I do this?
You need to do 3 things:
1) Create a BASH file (something like the Batch file in Wondows) to execute the exp command and move the files to the new location. Since this location is on another server, that I assume to be a Windows Server, you may need to mout it first (http://www.cyberciti.biz/faq/access-windows-shares-from-linux/).
1.1) BASH file should look like this:
<exp command you normally use. don't forget the user/password parameter>
mv /my/expdaily.dmp <backup server location>
mv /my/expdaily.log <backup server location>
2) Edit contrab file in order to Schedule the execution of the BASH file you created on step 1. This is the tricky part, for you, I think.
2.1) Edit the crontab file in "/etc" folder.
2.2) Add a line, at the end of the file, looking like this: 30 10 * * 1-7 <command (BASH file) you create>
2.3) Save crontab.
Hope this helps. From you physical location, I believe you have the hole afternoon to implement this and run some tests.
Best of luck!