Oracle?????????????????
???????????? ???????[ 2012/12/14 11:15:41 ] ????????
????????????????У???????????????????????????????????????????????????飬?????????????????????????????????????????????????ο??????????е????????????????????á???????????????л??????????????Sun Solaris??????????????????Oracle????????????????export??
???????????
?????????????????????????????????????£?
????export??????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????μ??????????????export????????exp userid file??
???????У?userid???÷??username/userpassword????Oracle?е??????/???userid?????exp????????????file????????????λ?ü??????
????ftp?? ????????????????????????????????????????????????????????????IP?????????????????????????????ftp?????????????????????????????????.netrc?????????????и????????????????????????д???.netrc??????????????????????????????????????.netrc??????????????ftp?????????????????????ftp???????
????-i?????ж????????????????????
????-n???????????????????????
???????????“-i”???????????????
????crontab??cron??????????????/etc/rc.local?????С?cron???/var/spool/cron/crontabs/???е????????? ?????е????????????????????????ɡ????????????crontab???????????????????crontab???????/var/spool /cron/crontabs?У?????????????????£????????crontab??????Oracle?????????????????Oracle??
????cron??????????????????????????У? /usr/var/adm/cron/cron.deny??/usr/var/adm/cron/cron.allow??????????????е?????????????crontab???????????????е???????????crontab???crontab?????????????
????crontab -l??????????crontab??????????
????crontab -r????crontabs????????????crontab?????
????crontab -e?????????crontab?????
????crontab??????????6????Σ??5???????趨?Σ???6????????е???????η????? minutes??hours??day of month??month??day of week?????????????Tab????????????“*”???????????????п????????Χ?????? ??????????????????????????????????????????????????????????Χ????С?
?????????????
?????趨????????????Oracle????????mistest????????test????????????/export/home/oracle/backup??????????????testbackup????????????????????£?
????ORACLE-HOME=/export/home/oracle/815??export ORACLE-HOME ????ORACLE-SID=ora815??export ORACLE-SID ????rm /export/home/oracle/backup/* ????rq=?date +“%m%d”? ????/export/home/oracle/815/bin/exp mistest/test file=/export/home/oracle ????/backup/exp$rq.dmp log=/exoport/home/oracle/backup/exp$rq.log
???????????????Oracle?????????????3?????????????????4????佨???????????????????????????????????????????е??????????? testbackup??д??????“chmod +x testbackup”???????????????????
??????????
????????????????????????????/data/oradata/newbackup?? ?????????Oracle??????????/export/home/oracle???????.netrc??????趨???????????IP????????????????????oraclebk?? ?????testbk2??.netrc??????????
????machine x.x.x..x ????login oraclebk ????password testbk2 ????macdef init ????bin ????lcd /export/home/oracle/backup ????cd /data/oradata/backup ????mput * ????bye
????????? ?3??????????????????????????4?????????????init?????5???????????????????6??????????????????????7???????????????????????8?????????????????/export/home/oracle/backup???μ??????????????????????/data /oradata/backup???£????????????ftp???????.netrc?????д??????????“chmod 600 .netrc”??????????????????????
??????????
??????????oracle??????????????????“crontab -e”??дcrontab?????????????????????oracle??????????£?
????10 23 * * * /export/home/oracle/testbackup ????30 23 * * * ftp -i x.x.x.x
???????????1????????????????23??10????ж?????????????2????????????????23??????ftp???????????????????????(?????????????????????IP?????????)??
????Oracle????????Oracle?????????“crontab -e”????????????????????????“crontab-l”????????crontab????????????/var/spool/cron/crontabs???2?????????????Oracle?????
????????????????????????????????????????????????????????????????????????????Oracle???????????????????????????????????????????????????????????????????????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11