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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Êý¾Ý¿â½á¹¹ºÍ¿Õ¼ä¹ÜÀí£¨Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢±í¿Õ¼ä¡¢¶Î¡¢Ä£Ê½ºÍģʽ¶ÔÏó£©
Ò»¸öORACLEÊý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ,±»´¦Àí³ÉÒ»¸öµ¥Î»¡£Ò»¸öORACLEÊý¾Ý¿âÓÐÒ»¸öÎïÀí½á¹¹ºÍÒ»¸öÂß¼½á¹¹¡£
ORACLEÂß¼Êý¾Ý¿â½á¹¹ÊÇÓû§ËùÉæ¼°µÄÊý¾Ý¿â½á¹¹¡£Ò»¸öORACLEÊý¾Ý¿âµÄÂß¼½á¹¹ÓÉÏÂÁÐÒòËؾö¶¨:
&nb ......
ORACLEÊý¾Ý¿âµÄÈÕÖ¾Îļþ$ORACLE_BASE/admin/orasid/bdump/alert_orasid.log¼Ç¼ÁËÖØ×÷ÈÕÖ¾µÄת»»£¬
Êý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ£¬Êý¾Ý¿â½á¹¹µÄ¸Ä±ä£¬»ØÍ˶εÄÐ޸ģ¬ËÀËø£¬ÄÚ²¿´íÎóµÈÐÅÏ¢.
Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¼ì²éÕâ¸öÎļþÓÐÎÞORA-´íÎ󲢶¨ÆڵضÔÕâ¸öÈÕÖ¾Îļþ½øÐд浵ÕûÀí ......
oracleÊý¾Ý¿âͨ¹ý¿ØÖÆÎļþ±£³ÖÊý¾Ý¿âµÄÍêÕûÐÔ£¬Ò»µ©¿ØÖÆÎļþ±»ÆÆ»µÊý¾Ý¿â½«ÎÞ·¨Æô¶¯£¬Òò´Ë½¨Òé²ÉÓöà·¿ØÖÆÎļþ»òÕß±¸·Ý¿ØÖÆÎļþµÄ·½·¨¡£
¿ØÖÆÎļþÊÇÊý¾Ý¿â½¨Á¢µÄʱºò×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÎļþ£¬Ö»ÄÜͨ¹ýʵÀý½øÐÐÐ޸ģ¬Èç¹ûÊÖ¶¯Ð޸ĵĻ°»áÔì³É¿ØÖÆÎļþÓëÎïÀíÐÅÏ¢²»·ûºÏ£¬´Ó¶øµ¼ÖÂÊý¾Ý¿â²»ÄÜÕý³£¹¤×÷¡£
oracleÊý¾Ý¿âͨ ......