Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

OracleÓû§±í¿Õ¼ä±¦µä

Oracle»¹ÊDZȽϳ£Óõģ¬ÓÚÊÇÎÒÑо¿ÁËÒ»ÏÂOracleÓû§±í¿Õ¼ä£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£ÔÚÎÒÃÇΪ΢ÈíµÄNTFS·ÖÇø¸ñʽÖеÄÓû§´ÅÅÌÅä¶î¹ÄÕƵÄʱºò£¬OracleÊý¾Ý¿âÖÐÒ²ÒѾ­ÊµÏÖÁËÓû§´ÅÅÌÅä¶îµÄ¼¼Êõ¡£¿ÉÒÔ½èÖú±í¿Õ¼ä£¬À´¶ÔÓû§½øÐдÅÅÌÅä¶î¹ÜÀí¡£ÀûÓñí¿Õ¼äµÄÓû§´ÅÅÌÅä¶î£¬¿ÉÒÔʵÏֺܶ๦ÄÜ¡£
Èç¿ÉÒÔÀûÓÃÓÃ ......

´ó¼ÒÒ»ÆðÀ´ÌÖÂÛOracle±í¿Õ¼äµÄ´´½¨

ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëԭʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæʵÏÖ¡£¾ßÌå ......

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ