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

Oracle×Ô¶¯±¸·Ý

1¡¢Ð´BATÎļþ
------------------------------------------------------------------------------------------------------
if "%time:~0,1%"==" " (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-0%time:~1,1%%time:~3,2%%time:~6,2%) else (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-%time:~0,2%%time:~3,2%%time:~6,2%)
exp ORACLEµÄÓû§Ãû/ÃÜÂë@·þÎñÃû owner=(Òªµ¼³öµÄÓû§Ãû)  file=%backup_file%.dmp log=%backup_file%.log
rar a %backup_file%.rar *.dmp *.log
xcopy "aaa_"%backup_file%.rar Z:\
del *.dmp
del *.log
-------------------------------------------------------------------------------------------------------
¸ÃÎļþµ¼³öÖÁ·ÅÖÃBATÎļþµÄÎļþ¼ÐÏ£¬ÎļþÃûΪµ¼³öµÄʱ¼ä
rarÃüÁîÊÇѹËõ±¸·ÝÎļþºÍÈÕÖ¾
xcopyÊǸ´ÖƵ¼³öµÄÎļþµ½ÁíÒ»¸ö´æ·ÅλÖã¬ÈôÊÇÍøÂçÉϵÄÆäËûÓ²ÅÌ£¬½¨ÒéÏȽ¨ºÃÓ³Éä
2¡¢½«RAR.EXE·ÅÔÚºÍBATÎļþͬһ¸öÎļþ¼ÐÏÂ
3¡¢ÈôÒª×Ô¶¯±¸·Ý£¬Ìí¼ÓÈÎÎñ¼Æ»®¡¾¿ªÊ¼¡¿—¡·¡¾¸½¼þ¡¿—¡·¡¾ÏµÍ³¹¤¾ß¡¿—¡·¡¾ÈÎÎñ¼Æ»®¡¿
×öÏàÓ¦µÄÉèÖü´¿É
ÐèҪעÒâµÄÊÇ£¬batµÄÎļþÃûÇв»¿ÉÈ¡ÃûΪexp.bat£¬·ñÔò»á²»Í£µÄÖ´ÐУ¬Ò»Ö±Ë¢ÆÁ£¬ÒòΪºÍOracleĬÈϵÄͬÃûÁË¡£
ÎÒÒ»¿ªÊ¼ÎÞÒâÈ¡ÁËÕâ¸öÃû×Ö£¬Ò»Ö±Ë¢ÆÁ£¬ÅªµÃÎҺܲ»½â


Ïà¹ØÎĵµ£º

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

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

ÓÃORACLE½¨Á¢Êý¾Ý¿â£¨Ïê½â£©


Êý¾Ý¿â½á¹¹ºÍ¿Õ¼ä¹ÜÀí£¨Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢±í¿Õ¼ä¡¢¶Î¡¢Ä£Ê½ºÍģʽ¶ÔÏó£©
   Ò»¸öORACLEÊý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ,±»´¦Àí³ÉÒ»¸öµ¥Î»¡£Ò»¸öORACLEÊý¾Ý¿âÓÐÒ»¸öÎïÀí½á¹¹ºÍÒ»¸öÂß¼­½á¹¹¡£
   ORACLEÂß¼­Êý¾Ý¿â½á¹¹ÊÇÓû§ËùÉæ¼°µÄÊý¾Ý¿â½á¹¹¡£Ò»¸öORACLEÊý¾Ý¿âµÄÂß¼­½á¹¹ÓÉÏÂÁÐÒòËؾö¶¨:
  &nb ......

¡¾×ª¡¿ORACLEµÄÈÕÖ¾¹ÜÀí

ORACLEÊý¾Ý¿âµÄÈÕÖ¾Îļþ$ORACLE_BASE/admin/orasid/bdump/alert_orasid.log¼Ç¼ÁËÖØ×÷ÈÕÖ¾µÄת»»£¬
    Êý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ£¬Êý¾Ý¿â½á¹¹µÄ¸Ä±ä£¬»ØÍ˶εÄÐ޸ģ¬ËÀËø£¬ÄÚ²¿´íÎóµÈÐÅÏ¢.
   
    Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¼ì²éÕâ¸öÎļþÓÐÎÞORA-´íÎ󲢶¨ÆڵضÔÕâ¸öÈÕÖ¾Îļþ½øÐд浵ÕûÀí ......

oracle¿ØÖÆÎļþ¹ÜÀí


oracleÊý¾Ý¿âͨ¹ý¿ØÖÆÎļþ±£³ÖÊý¾Ý¿âµÄÍêÕûÐÔ£¬Ò»µ©¿ØÖÆÎļþ±»ÆÆ»µÊý¾Ý¿â½«ÎÞ·¨Æô¶¯£¬Òò´Ë½¨Òé²ÉÓöà·¿ØÖÆÎļþ»òÕß±¸·Ý¿ØÖÆÎļþµÄ·½·¨¡£ 
¿ØÖÆÎļþÊÇÊý¾Ý¿â½¨Á¢µÄʱºò×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÎļþ£¬Ö»ÄÜͨ¹ýʵÀý½øÐÐÐ޸ģ¬Èç¹ûÊÖ¶¯Ð޸ĵĻ°»áÔì³É¿ØÖÆÎļþÓëÎïÀíÐÅÏ¢²»·ûºÏ£¬´Ó¶øµ¼ÖÂÊý¾Ý¿â²»ÄÜÕý³£¹¤×÷¡£
oracleÊý¾Ý¿âͨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ