ÔÚ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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
·þÎñÆ÷ͻȻ³öÏÖ¹«ÍøÍøÂ粻ͨ¡£»¹ºÃÓÐÅäÁ½¸öIP£¬Ò»¹«Íø£¬Ò»ÄÚÍø£¬ÄÚÍø¿Éͨ£¬Í¨¹ýÄÚÍøÁ¬½Óµ½·þÎñÆ÷ÉÏ ¡£²é¿´ÈÕÖ¾£¬dmesg£¬·¢ÏÖÓÐÕâÑùÒ»Ìõ£º
Sep 9 14:34:36 slave kernel: NETDEV WATCHDOG: eth0: transmit timed out
/etc/init.d/network restart ÍøÂç·þÎñÖØÆôһϣ¬»Ö¸´Õý³£¡£
µ½google²éÕÒ×ÊÁÏ£¬·¢ÏÖÒ²ÓÐÒ»ÑùµÄÎÊ ......
Grubfordos Òýµ¼linuxµÄ·½·¨
·½·¨Ò»
Errorcheck off
Configfile /menu.lst
Configfile /boot/grub/menu.lst
Configfile /grub/menu.lst
Find –set-root –ignore-floppies –ignore-cd /menu.lst
Configfile /menu.lst
Find –set-root –ignore-floppies –ignore-cd /root/grub/m ......
1.ϵͳÐÅÏ¢ÏÔʾÃüÁî # uname -a # ²é¿´ÄÚºË/²Ù×÷ϵͳ/CPUÐÅÏ¢
# head -n 1 /etc/issue # ²é¿´²Ù×÷ϵͳ°æ±¾
# cat /proc/cpuinfo # ²é¿´CPUÐÅÏ¢
# hostname ......