Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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 &#8211;e oracle¿ªÊ¼½¨Á¢oracleÓû§µÄCrontabÎļþ¡£ÆäÄÚÈÝΪ£º
00 17 * * 1-5 "/usr/oracle/backup.sh"
´æÅÌÍ˳öºó£¬Äã»á·¢ÏÖÔÚ/var/spool/cron/crontabsÖÐÐÂÔöÁËÒ»¸öÃûΪoracleÎļþ£¬Æä×÷ÓÃÊÇÔÚÖÜÒ»ÖÁÖÜÎåÿÌìµÄ17:00ÔËÐÐ&#8220;/usr/oracle/backup.sh&#8221;¡£
µ½´Ë´ó¹¦¸æ³É£¬ÏµÍ³»á½«Ã¿´Î±¸·ÝµÄÐÅϢͨ¹ýmailµÄÐÎʽ·¢Ë͸øoracleÓû§¡£
ÔÚ½øÐÐÒÔÉϲÙ×÷ʱ£¬½¨Ò齫/var/spool/cron/c


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì (Æß) SDPЭÒé

Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖЭÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀЭÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

LinuxµÄÍøÂçÅäÖÃ

LinuxµÄÍøÂçÅäÖÃ
Redhat LinuxµÄÍøÂçÅäÖ㬻ù±¾ÉÏÊÇͨ¹ýÐ޸öÅäÖÃÎļþÀ´ÊµÏֵģ¬ËäȻҲ¿ÉÒÔÓÃifconfigÀ´ÉèÖÃIP£¬ÓÃrouteÀ´ÅäÖÃĬÈÏÍø¹Ø£¬ÓÃhostnameÀ´ÅäÖÃÖ÷»úÃû£¬µ«ÊÇÖØÆôºó»á¶ªÊ§¡£
Ïà¹ØµÄÅäÖÃÎļþ
    /ect/hosts ÅäÖÃÖ÷»úÃûºÍIPµØÖ·µÄ¶ÔÓ¦
    /etc/sysconfig/network ÅäÖÃÖ ......

LinuxÔö¼Óswap¿Õ¼ä


½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó ¡¡¡¡½ñÌìºöÈ»·¢ÏÖ´úÀí·þÎñÆ÷²»ÄÜʹÓÃÁË£¬ÉÏÈ¥Ò»¿´£¬squidµÄ¶Ë¿Ú¼àÌýStopµôÁË£¬²é¿´ÈÕÖ¾£¬ÈçÏ´íÎó
¡¡¡¡localhost kernel: Out of Memory: Killed process 785 (squid).
¡¡¡¡ÍøÉÏgoogleһͨ£¬Ã»ÓÐÈκÎÓмÛÖµµÄ½á¹û£¬×Ô¼ºÕÒÆäË ......

linux ³õѧÃüÁî

1.ϵͳÐÅÏ¢ÏÔʾÃüÁî # uname -a               # ²é¿´ÄÚºË/²Ù×÷ϵͳ/CPUÐÅÏ¢
# head -n 1 /etc/issue   # ²é¿´²Ù×÷ϵͳ°æ±¾
# cat /proc/cpuinfo      # ²é¿´CPUÐÅÏ¢
# hostname   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ