ÔÚlinuxÖÐʹÓÃcrontabʵÏÖ¶ÔoracleµÄ¶¨Ê±±¸·Ý
¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪoracle£¬Êý¾Ý¿âµÄÓû§Îªscott£¬Æä¿ÚÁîΪtrigger£¬
OracleÊý¾Ý¿âµÄ²ÎÊý$ORACLE_HOMEΪ/usr/oracle£¬$ORACLE_SIDΪoracle1£¬ÔòʵÏÖ²½ÖèÈçÏ£º
1¡¢½¨Á¢ÊµÏÖ±¸·ÝµÄshell
ÔÚ/usr/oracleÖÐÓÃviÃüÁÁ¢Îļþbackup.sh£¬ÆäÄÚÈÝΪ:
ORACLE_HOME=/usr/oracle; <br>export ORACLE_HOME;
ORACLE_SID=oracle1;
export ORACLE_SID;
D=$(date +%y%m%d);<br>export D;
/usr/oracle/bin/exp scott/trigger file=/usr/oracle/${D}.dmp owner=scott
×¢Ò⣺ÕâÀïD=$(date +%y%m%d); ÊÇÈ·±£Äãÿ¸ö±¸·ÝÎļþÒÔÈÕÆÚÃû×Ö.ÀýÈç:060814.dmp 060815.dmp
Èç¹ûÏëÿÌì°Ñ±¸·ÝÎļþ¸²¸ÇÄÇô°Ñ ${D}.dmp ÕâÀïÓù̶¨µÄÃû×ÖÀýÈç: backup.dmp
ʹÓÃchmodÃüÁîÐÞ¸Äbackup.shµÄÊôÐÔΪ¿ÉÖ´ÐУº
chmod +x backup.sh
µ½´Ë£¬¾ßÓб¸·Ý¹¦ÄܵĿÉÖ´ÐÐÎļþ£¨shell£©backup.shÒѾ½¨³É¡£ÆäÖ´Ðнá¹ûÊǽ«scottËùÓµÓеÄORACLE¶ÔÏ󱸷ݵ½/usr/oracleÖеÄbackup.dmpÖУ¬¶ÁÕß¿ÉÒÔÖ±½ÓÔËÐÐËüÀ´¿´¿´Ð§¹û¡£ÖµµÃ×¢ÒâµÄÊÇ£¬backup.shÖÐOracleµÄÁ½¸ö»·¾³²ÎÊýÒ»¶¨ÒªÉùÃ÷£¬·ñÔòϵͳ»á±¨´í¡£ÏÂÒ»²½½«¿ªÊ¼½¨Á¢oracleÓû§µÄCrontabÎļþ¡£
2¡¢²é¿´CrontabµÄʹÓÃȨÏÞ
ʹÓ󬼶Óû§£¨root£©µÄÉí·ÝµÇ¼£¬ÔÚ/usr/var/adm/cronÏÂͨ¹ýviÃüÁî²é¿´cron.denyÎļþ£¬Èç¹ûÊý¾Ý¿âµÄÓµÓÐÕßoracle±»ÁÐÔÚÀïÃæ£¬½«Æäɾ³ý¼´¿É¡£
3¡¢½¨Á¢oracleµÄCrontabÎļþ
ÓÃoracleÓû§µÇ¼£¬Í¨¹ýʹÓÃÃüÁîcrontab –e oracle¿ªÊ¼½¨Á¢oracleÓû§µÄCrontabÎļþ¡£ÆäÄÚÈÝΪ£º
00 17 * * 1-5 "/usr/oracle/backup.sh"
´æÅÌÍ˳öºó£¬Äã»á·¢ÏÖÔÚ/var/spool/cron/crontabsÖÐÐÂÔöÁËÒ»¸öÃûΪoracleÎļþ£¬Æä×÷ÓÃÊÇÔÚÖÜÒ»ÖÁÖÜÎåÿÌìµÄ17:00ÔËÐГ/usr/oracle/backup.sh”¡£
µ½´Ë´ó¹¦¸æ³É£¬ÏµÍ³»á½«Ã¿´Î±¸·ÝµÄÐÅϢͨ¹ýmailµÄÐÎʽ·¢Ë͸øoracleÓû§¡£
ÔÚ½øÐÐÒÔÉϲÙ×÷ʱ£¬½¨Ò齫/var/spool/cron/c
Ïà¹ØÎĵµ£º
MD5Ëã·¨³£³£±»ÓÃÀ´ÑéÖ¤ÍøÂçÎļþ´«ÊäµÄÍêÕûÐÔ£¬·ÀÖ¹Îļþ±»È˴۸ġ£MD5 È«³ÆÊDZ¨ÎÄÕªÒªËã·¨£¨Message-Digest Algorithm 5£©£¬´ËËã·¨¶ÔÈÎÒⳤ¶ÈµÄÐÅÏ¢Öðλ½øÐмÆË㣬²úÉúÒ»¸ö¶þ½øÖƳ¤¶ÈΪ128λ£¨Ê®Áù½øÖƳ¤¶È¾ÍÊÇ32룩µÄ“Ö¸ÎÆ”£¨»ò³Æ“±¨ÎÄÕªÒª”£©£¬²»Í¬µÄÎļþ²úÉúÏàͬµÄ±¨ÎÄÕªÒªµÄ¿ÉÄÜÐÔÊǷdz£·Ç³£Ö® ......
linuxĿ¼¼Ü¹¹
/ ¸ùĿ¼
/bin ³£ÓõÄÃüÁî binary file µÄÄ¿錄
/boot ´æ·ÅϵͳÆô¶¯Ê±±ØÐë¶ÁÈ¡µÄµµ°¸£¬°üÀ¨ºËÐÄ (kernel) ÔÚÄÚ
/boot/grub/menu.lst &n ......
linuxÏÂÍü¼ÇÁËmysqlµÄrootÓû§ÃÜÂë½â¾ö°ì·¨£º
¡¡¡¡Ò»¡¢ÒÔϵͳµÄrootÓû§£¨Ê²Ã´£¬ÄãµÄϵͳµÄrootÓû§ÃÜÂëÒ²ÍüÁË¡£ÄÇÖ»ºÃ¿´ÎÒÁíÍâһƪlinuxÏÂÍü¼ÇrootÓû§µÄ½â¾ö°ì·¨ÁËÏȽâ¾öÕâ¸öÎÊÌ⣩µÇ½ϵͳ£¬½øÈëÖÕ¶Ë
¡¡¡¡[root@localhost /]#
¡¡¡¡¶þ¡¢É±µômysql½ø³Ì
¡¡¡¡·½·¨1¡¢[root@localhost /]#killall mysqld
¡¡¡¡·½·¨2¡ ......
½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó ¡¡¡¡½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó
¡¡¡¡localhost kernel: Out of Memory: Killed process 785 (squid).
¡¡¡¡ÍøÉÏgoogleһͨ£¬Ã»ÓÐÈκÎÓмÛÖµµÄ½á¹û£¬×Ô¼ºÕÒÆäË ......
תÌû×Ô£ºhttp://bbs.61job.cn/space/viewspacepost.aspx?postid=4489
ÔÚLinuxÖв»¹ÜÄãÊÇ×ö·þÎñÆ÷»¹ÊÇÖ»ÊÇÆ½³£Ê¹Óã¬ÉÏÍø¿Ï¶¨¶¼ÊÇ×îÖØÒªºÍ²»¿ÉȱÉÙµÄÒ»¸öÒòËØÖ®Ò»£¬
ËùÒÔ¾ÍÉæ¼°µ½ËüµÄip gateway dnsµÈnetworkÅäÖúÍʹÓᣵ«ÊÇÉèÖÃlinuxÍøÂçµÄ·½·¨ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖ£ºÊ¹ÓÃÃüÁîÐ޸ģ¨Ö±½Ó¼´Ê±ÉúЧ,ÖØÆôʧЧ£©
&n ......