OracleÅàѵ֮Âà ÉÇÍ·
Õâ´ÎÈ¥ÉÇÍ·ÊǸøÉÇÍ·µçÐŽ²¿Î,Ö÷½²ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯,ΪÆÚ4Ìì.´ÓÂÞºþÆû³µÕ¾³ö·¢,×ßÉîÉǸßËÙ,´óÔ¼4,5¸öÖӾ͵½ÉÇÍ·ÁË.
³ö·¢Ê±ÊÇ°øÍí,³µ×ÓÔÚÉîÉǸßËÙÐнø,ϦÑôÎ÷Ï£¬ÂäÈÕµÄÓà»ÔÕÕÓ³ÔÚ¹«Â·Á½±ßµÄÇðÁê,ɽÌÁÉÏ£¬¿´ÉÏÈ¥ºÜÃÀ¡£ÉîÉǸßËٴ󲿷ÖÊÇÑØן£°¶ÏßòêÑÑ£¬ËùÒÔ£¬ÓÐʱÔÚ³µÉϾÍÄܹ»¿´µ½º££¬ÂäÈÕµÄÓà»ÔÕÕÔÚ´óº£ÉÏ£¬²¨¹âÁÛÁÛ£¬¼ÓÖ®º£·çÏ°Ï°£¬ÊÇÎÒϲ»¶µÄÄÇÖָоõ¡£ÎÒûÓÐÐÄ˼¹Û¿´³µÉϵĵçÓ°£¬´ó²¿·Öʱ¼äÎÒ¶¼ÊÇ´ò¿ª³µ´°£¬±¥ÀÀº£°¶·ç¹â¡£¹«Â·Á½±ßºÜ¶àСɽ£¬²»¸ß£¬µ«¿´ÉÏÈ¥ºÜºÃÍ棬ºÃ±È¼ÒÏçºóÃæµÄСɽ£¬Ð¡µÄʱºòÎÒÃǾ³£ÅÀÉÏÈ¥Í棬»òÔÚɽÆÂÀïÍæÈüÅÜ£¬¿´ËµÚÒ»¸ö´ÓɽÏÂÅܵ½É½¶¥£¬´Óɽ¶¥Åܵ½É½ÎÑ¡£Í¯ÄêµÄ»¶ÀÖÏÖÔÚºÜÄÑÖØÊ°£¬ÎÒÖ»ÄÜÒÐ×ųµ´°£¬³Á½ûÔÚͯÄ껶ÀֵĻØÒäÖС£
½øÈëÉÇÍ·ÊÐÇø£¬ÓÃæÒ²ÊÇÒ»×ùбÀË÷´óÇÅ£¬ÉÇÍ·µçÐŵÄÖì¿¡·åÖ÷ÈÎÔÚ³µÕ¾µÈºò¶àʱ£¬Ê±¼äÒÑÊÇÍíÉÏ9µã¶àÁË£¬ÎÒÃÇÔÚÒ»¼Ò²ÍÌü³ÔÍê·¹£¬ÖìÖ÷ÈξͿª³µËÍÎÒµ½Áúºþ±ö¹Ý¡£
ÉÇÍ·µçÐŵÄÅóÓÑ£¬²Î¼Ó´Ë´ÎÅàѵµÄ¶¼±È½ÏÄêÇᣬ¹À¼ÆºÜ¶à´Ó´óѧ±ÏÒµ³öÀ´Ã»¶à¾Ã£¬ËùÒÔÎÊÌâÒ²ÌرðµÄ¶à£¬¿ÎÌÃÆø·ÕÈÈÁÒ£¬ÓÐʱ²îµãû°ÑÎÒ¸ãÃÉ¡£ºÇºÇ£¬ÄêÇáÈË×ÜÊǺÜÓм¤Ç飬¼ÇµÃÔÚ½²ORACLE SQLÓÅ»¯Ê±£¬ºÜ¶àѧԱֱ½Ó½«ËûÃÇƽʱ¾õµÃºÜÂýµÄÎÊÌâSQL·¢¸øÎÒ£¬ÈÃÎÒÇÐÇÐʵʵµØÌå»áµ½ÁËÏÖ³¡×öÓÅ»¯µÄ¹¤×÷Æø·Õ¡£¿É±ðС¿´ÕâЩÄêÇáС»ï×Ó°¡£¬ËûÃǸø³öµÄÎÊÌâÄѶȶ¼²»Ð¡ÍÛ£¬¸Õ´ÓѧУ³öÀ´£¬»¹´ø×ÅÄǹɴòÆÆɳ¹øÎʵ½µ×µÄѧϰ¾¢¶ù¡£ºÇºÇ£¬²»¹ý£¬ËûÃÇÒ²ÓÐһЩ±¦¹óµÄÍæÒâ¶ù£¬ÓÐÒ»¿î¿ÉÒÔÔÚ¾ÖÓòÍøÄÚ·Ö·¢ÎļþµÄÈí¼þ£¬½Ð“·É¸ë´«Ê锣¬ÒÔ¼°Ò»¿î¿ÉÒÔ´Ó¸÷¸öÖն˿´µ½ÀÏʦµÄµçÄÔÆÁÄ»µÄ½ÌѧÈí¼þ£º“HtScreen”,ÎÒ¾õµÃ¾ÍÌرðµÄºÃ£¬ÎÒÌØÒ⿽ÏÂÀ´ÁË£¬ËäÈ»ÊǵÁ°æ£¬µ«ÎÒ¾ö¶¨ÔÚÎÒÒÔºóµÄ¿ÎÌÃÉϲÉÓÃÕâ¿îÈí¼þ(ÎÒ֮ǰ²ÉÓÃNetMeeting£¬µ«Î¢ÈíµÄÕâ¸ö¶«¶«ÔÚÁ¬½ÓÓû§¶àÁ˵ÄÇé¿öÏ£¬²Ù×÷ÌرðµØÂý£¬ÐÔÄܲ»ºÃ¡£¶øHtScreenÔòÊÇÇáÁ¿¼¶µÄ£¬ËüÏ൱ÓÚ½«ÀÏʦµÄÖն˹㲥³öÈ¥£¬¼´Ê¹50¸öѧԱÁ¬½ÓÉÏÄãµÄµçÄÔ£¬Ò²¸Ð¾õ²»µ½±äÂý).
×ÜÌåÀ´½²£¬Õâ´ÎµÄÅàѵʵսЧ¹ûÊÇ×îºÃµÄ£¡Ð¡»ï×ÓÃÇѧµÃÆð¾¢£¬Ïû»¯ÎüÊÕÒ²¿ì¡£µçÐŵÄÖìÖ÷ÈÎÓÐÒâ½øÐеÚ2´ÎÕâÑùµÄÅàѵ¡£
ƽ³£ÎÒÊÇÔÚÁúºþ±ö¹Ý³Ô·¹£¬¾ÆµêµÄ¸÷ÖÖ¸÷ÑùµÄµãÐĵ¹Ê±ºÜ¶à£¬Ê²Ã´Óã½Èѽ£¬ÓãÍèѽ£¬Å£ÈâÍèѽ£¬³¦·ÛµÈµÈ£¬¾Ý˵¶¼ÊÇÉÇÍ·µÄÌØɫС³Ô£¬¿ÉÊÇûÓÐÀ±Î¶£¬ºÜÓе㲻ºÏÎҵĿÚζ¡£ÓÚÊÇÍí²ÍÒ»°ãÊÇÖìÖ÷ÈνÓÎÒµ½ÍâÃæ³Ô¡£ÎÒÃÇ¿ª³µµ½º£±õ·£¬´ó¸Åÿ¸ö±õº£µÄ³ÇÊж¼»áÓйۺ£³¤ÀÈ°É£¬ÉÇÍ·Ò²²»ÀýÍâ¡£ÎÒÃÇÑ¡ÁËÒ»¼Ò¿¿º£±ßµÄ²ÍÌü£¬ÔÚ¶þÂ¥£¬»ù
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
1¡¢´ÓrootÓû§Çл»µ½oracleÓû§
#su - oracle
2¡¢ÀûÓÃnologÑ¡ÏîÆô¶¯sql*plus¹¤¾ß³ÌÐò
$slqplus /nolog
3¡¢ÀûÓÃsysdbaÉí·ÝÆô¶¯oracleÊý¾Ý¿â
sql>connect / as sysdba
sql>startup
4¡¢Æô¶¯Êý¾Ý¿âµÄ¼àÌýÆ÷listener
$lsnrctl start
»ò
$lsnrctl
lsnrctl>start
5¡¢¹Ø±ÕoracleÊý¾Ý¿â¼àÌý
$lsnrctl stop
6¡ ......
1£©¡¢¹¹ÔìʵÀý£º
ÎÒÃÇÒѾ´´½¨ºÃÊý¾Ý¿âÓû§test_user£¬Ï±ߴæÔÚtest_table±íºÍtest_procedure´æ´¢¹ý³Ì¡£ÎÒÃÇÒѾ´´½¨ºÃÒ»¸ö¿ÕµÄ´úÀíÊý¾Ý¿âÓû§agent_user¡£
2£©¡¢µÇ¼test_userÓû§£¬½«test_userϱíµÄselectȨÏ޺ʹ洢¹ý³ÌµÄexcuteȨÏÞ¸³¸ø´úÀíÓû§agent_user¡£
SQL>GRANT select ON test_table TO agent_user;
SQL ......
lob×ֶβ»ÄÜ×ögroup by£¬¶øunionÖÐÐèҪʹÓÃgroup by¹ýÂ˵ôÖظ´¼Í¼£¬ËùÒÔ²»ÐÐ ¡£ ÓÃunion all¾Í¿ÉÒÔÁË¡£
Áí£ºunion ºÍ union allÇø±ð£º
UNIONÔÚ½øÐбíÁ´½Óºó»áɸѡµôÖظ´µÄ¼Ç¼£¬ËùÒÔÔÚ±íÁ´½Óºó»á¶ÔËù²úÉúµÄ½á¹û¼¯½øÐÐÅÅÐòÔËË㣬ɾ³ýÖظ´µÄ¼Ç¼ÔÙ·µ» ......