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

Oracle´Ó·Ç¹éµµÄ£Ê½±ä³É¹éµµÄ£Ê½

http://www.cuijie.net.cn/?cat=6
¸ü¸ÄÊý¾Ý¿âµÄ¹éµµÄ£Ê½ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬ÔÚmountģʽÏÂÐ޸쬼òÒª²½Öè
1   ÒÔshutdown immediate ·½Ê½¹Ø±ÕÊý¾Ý¿â
2  Æô¶¯ÊµÀýµ½mount״̬
3  ¸ü¸ÄÔËÐÐģʽ²¢´ò¿ªÊý¾Ý¿â
²Ù×÷²½Ö裺
1   µÇ¼Êý¾Ý¿â²é¿´Êý¾Ý¿âµÄ¹éµµ×´Ì¬
     SQL> archive log list;
     Èç¹û³öÏÖÐÅÏ¢£º
     Database log mode              No Archive Mode
     Automatic archival             Disabled
     ÔòΪ·Ç¹éµµÄ£Ê½
2  ¹Ø±ÕÊý¾Ý¿â
     SQL>shutdown immediate;
3   Æô¶¯Êý¾Ý¿âµ½mount״̬
     SQL>startup mount;
4   Æô¶¯¹éµµÄ£Ê½
     SQL>alter database archivelog;       (·Ç¹éµµÄ£Ê½Îª£ºalter database noarchivelog)
  
5   ´ò¿ªÊý¾Ý¿â
     SQL>alter database open;
      ²é¿´¹éµµÄ£Ê½×´Ì¬
     SQL>archive log list
      Èç¹û³öÏÖÐÅÏ¢£º
      Database log mode              Archive Mode
      Automatic archival             Enabled
      ³É¹¦¸Ä³É¹éµµÄ£Ê½
http://uplinux.com/online/dodev/sjk/2009/1103/243.html
OracleÊý¾Ý¿â¿ÉÒÔÔËÐÐÔÚ2ÖÖģʽÏÂ:¹éµµÄ£Ê½(archivelog)ºÍ·Ç¹éµµÄ£Ê½(noarchivelog)
¹éµµÄ£Ê½¿ÉÒÔÌá¸ßOracleÊý¾Ý¿âµÄ¿É»Ö¸´ÐÔ£¬Éú²úÊý¾Ý¿â¶¼Ó¦¸ÃÔËÐÐÔÚ´ËģʽÏ£¬¹éµµÄ£Ê½Ó¦¸ÃºÍÏàÓ¦µÄ±¸·Ý²ßÂÔÏà½áºÏ£¬Ö»Óй鵵ģʽûÓÐÏàÓ¦µÄ±¸·Ý²ßÂÔÖ»»á´øÀ´Âé·³¡£
±¾Îļòµ¥½éÉÜÈçºÎÆôÓú͹رÕÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
1.shutdown normal»òshutdown immediate¹Ø±ÕÊý¾Ý¿â
[oracle@jumper oracle]$ sqlplus "/ as sysdba"


Ïà¹ØÎĵµ£º

ORACLE ×óÓÒÁ´½Ó

Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
     £¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......

Oracle & SUN£¬ÑϾþµÄÌôÕ½£¨Ò»£©

      ½ñÌì²Î¼ÓÁËOracle & SUNºÏ²¢ºóµÚÒ»´ÎÓëºÏ×÷»ï°é¼°¿Í»§µÄÍ¨Æø»á¡£Õû¸ö»áÒ鏸ÎҵĸоõÊÇ£ºOracleÐÛÐIJª²ª£¬SUNÒâÆø·ç·¢£¬¶øÎÒ×Ô¼º£¬ÐÄ»³ã·ã·¡£       OracleÓÐÁËSUN£¬ÄÇô´ÓÓ²¼þµ½Èí¼þOracleµÄ²úÆ·Ïß¾ÍÊ®·ÖÆë±¸ÁË¡£Oracle°ëÄêÇ°ÍÆ³ö11gR2 for linux£¬½Ó×Åfor solar ......

linuxÉÏʹÓÃrlwrap ½â¾öoracle¿ÉÒÔÉÏϼü²é¿´ÃüÁî

linux ÉϵÄoracle sqlplus ²»ÄÜÀûÓà ÉÏ, Ï ¼üÀ´²é¿´ÃüÁËÑË÷µ½½â¾öÎÊÌâµÄ°ì·¨£¬ÕûÀíÈçÏÂ
°²×°Èí¼þrlwrap¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣬¸ÃÈí¼þÊÇÓÃcдµÄ³ÌÐò
¹Ù·½ÏÂÔØµØÖ·£ºhttp://utopia.knoware.nl/~hlub/uck/rlwrap/
°²×°¹ý³Ì£º
ÎÒÃÇÒ²¿ÉÒԲ鿴½âѹºóµÄtar°ü£¬²é¿´README°ïÖúÎļþ
shell>tar -zxvf rlwrap-0.36.tar.gz
sh ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......

oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë

oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
/**
*
* ˵Ã÷£º
* £¨1£©±¾ÀýʹÓÃJDBC_ODBCÇŽøÐÐÊý¾Ý¿âÁ¬½Ó£¬¹Ê´ËÐèÒªODBCÊý¾ÝÔ´
* £¨2£©±¾ÀýÖÐSQLΪ¸üÐÂÓï¾ä£¬¹Ê´ËʹÓÃÔØÌåµÄexecuteUpdate·½·¨£¬²¢ÇÒ·µ»ØÊÜÓ°Ïì¼Ç¼Êý
* (3) ÅäÖÃÁ¬½ÓORACLEµÄodbcÊý¾ÝÔ´ora
*/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ