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

oracleµÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELOG
2.ʹÓÃARCHIVE LOG LIST ÃüÁî
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /data/oracle/product/10.2.0/db_1//dbs/arch
Oldest online log sequence     739
Current log sequence           741
¶þ¡£Ê²Ã´ÊÇOracle¹éµµÄ£Ê½£¿
  OracleÊý¾Ý¿âÓÐÁª»úÖØ×öÈÕÖ¾£¬Õâ¸öÈÕÖ¾ÊǼǼ¶ÔÊý¾Ý¿âËù×öµÄÐ޸ģ¬±ÈÈç²åÈ룬ɾ³ý£¬¸üÐÂÊý¾ÝµÈ£¬¶ÔÕâЩ²Ù×÷¶¼»á¼Ç¼ÔÚÁª»úÖØ×öÈÕÖ¾Àï¡£Ò»°ãÊý¾Ý¿âÖÁÉÙÒªÓÐ2¸öÁª»úÖØ×öÈÕÖ¾×é¡£µ±Ò»¸öÁª»úÖØ×öÈÕÖ¾×鱻дÂúµÄʱºò£¬¾Í»á·¢ÉúÈÕÖ¾Çл»£¬ÕâʱÁª»úÖØ×öÈÕÖ¾×é2³ÉΪµ±Ç°Ê¹ÓõÄÈÕÖ¾£¬µ±Áª»úÖØ×öÈÕÖ¾×é2дÂúµÄʱºò£¬ÓֻᷢÉúÈÕÖ¾Çл»£¬È¥Ð´Áª»úÖØ×öÈÕÖ¾×é1£¬¾ÍÕâÑù·´¸´½øÐС£
  Èç¹ûÊý¾Ý¿â´¦Óڷǹ鵵ģʽ,Áª»úÈÕÖ¾ÔÚÇл»Ê±¾Í»á¶ªÆú. ¶øÔڹ鵵ģʽÏ£¬µ±·¢ÉúÈÕÖ¾Çл»µÄʱºò£¬±»Çл»µÄÈÕÖ¾»á½øÐй鵵¡£±ÈÈ磬µ±Ç°ÔÚʹÓÃÁª»úÖØ×öÈÕÖ¾1£¬µ±1дÂúµÄʱºò£¬·¢ÉúÈÕÖ¾Çл»£¬¿ªÊ¼Ð´Áª»úÖØ×öÈÕÖ¾2£¬ÕâʱÁª»úÖØ×öÈÕÖ¾1µÄÄÚÈݻᱻ¿½±´µ½ÁíÍâÒ»¸öÖ¸¶¨µÄĿ¼Ï¡£Õâ¸öĿ¼½Ð×ö¹éµµÄ¿Â¼£¬¿½±´µÄÎļþ½Ð¹éµµÖØ×öÈÕÖ¾¡£
  Êý¾Ý¿âʹÓù鵵·½Ê½ÔËÐÐʱ²Å¿ÉÒÔ½øÐÐÔÖÄÑÐÔ»Ö¸´¡£
1.¹éµµÈÕ־ģʽºÍ·Ç¹éµµÈÕ־ģʽµÄÇø±ð
·Ç¹éµµÄ£Ê½Ö»ÄÜ×öÀ䱸·Ý,²¢ÇÒ»Ö¸´Ê±Ö»ÄÜ×öÍêÈ«±¸·Ý.×î½üÒ»´ÎÍêÈ«±¸·Ýµ½ÏµÍ³³ö´íÆÚ¼äµÄÊý¾Ý²»Äָܻ´.
¹éµµÄ£Ê½¿ÉÒÔ×öÈȱ¸·Ý,²¢ÇÒ¿ÉÒÔ×öÔöÁ¿±¸·Ý,¿ÉÒÔ×ö²¿·Ö»Ö¸´.
ÓÃARCHIVE LOG LIST ¿ÉÒԲ鿴ÆÚģʽ״̬ʱ¹éµµÄ£Ê½»¹ÊǷǹ鵵ģʽ.
Èý¡£ÅäÖÃÊý¾Ý¿âµÄ¹éµµÄ£Ê½
¸Ä±ä·Ç¹éµµÄ£Ê½µ½¹éµµÄ£Ê½:
1)SQL>SHUTDOWN NORMAL/IMMEDIATE;
2)SQL>START MOUNT;
3)SQL>ALTER DATABASE ARCHIVELOG;
4)SQL>ALTER DATABASE OPEN;
5)SQL>×ö


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÖÐÐòÁÐÓ÷¨½²½â

ÐòÁÐ(SEQUENCE)ÊÇÐòÁкÅÉú³ÉÆ÷£¬¿ÉÒÔΪ±íÖеÄÐÐ×Ô¶¯Éú³ÉÐòÁкţ¬²úÉúÒ»×éµÈ¼ä¸ôµÄÊýÖµ(ÀàÐÍΪÊý×Ö)¡£ÆäÖ÷ÒªµÄÓÃ;ÊÇÉú³É±íµÄÖ÷¼üÖµ£¬¿ÉÒÔÔÚ²åÈëÓï¾äÖÐÒýÓã¬Ò²¿ÉÒÔͨ¹ý²éѯ¼ì²éµ±Ç°Öµ£¬»òʹÐòÁÐÔöÖÁÏÂÒ»¸öÖµ¡£
´´½¨ÐòÁÐÐèÒªCREATE SEQUENCEϵͳȨÏÞ¡£ÐòÁеĴ´½¨Óï·¨ÈçÏ£º
CREATE SEQUENCE ÐòÁÐÃû
[INCREMENT BY n]
[ST ......

Oracle ¸ôÀ뼶±ð

¸ôÀ뼶±ð£¨isoation level£©
 
¸ôÀ뼶±ð¶¨ÒåÁËÊÂÎñÓëÊÂÎñÖ®¼äµÄ¸ôÀë³Ì¶È¡£
¸ôÀ뼶±ðÓë²¢·¢ÐÔÊÇ»¥ÎªÃ¬¶ÜµÄ£º¸ôÀë³Ì¶ÈÔ½¸ß£¬Êý¾Ý¿âµÄ²¢·¢ÐÔÔ½²î£»¸ôÀë³Ì¶ÈÔ½µÍ£¬Êý¾Ý¿âµÄ²¢·¢ÐÔÔ½ºÃ¡£
 
ANSI/ISO SQ92±ê×¼¶¨ÒåÁËһЩÊý¾Ý¿â²Ù×÷µÄ¸ôÀ뼶±ð£º
δÌá½»¶Á£¨read uncommitted£©
Ìá½»¶Á£¨read committed£© &n ......

Oracle³£ÓÃSqlÓï¾ä

1. ´´½¨ÊÓͼ£º
CREATE OR REPLACE VIEW SM_V_UNIT_AUTH AS
SELECT T2.UNIT_ID,
        T2.SUPER_UNIT_ID,
        T1.AUTH_ID,
        T1.AUTH_NAME,
        T1.A ......

ÔÚRedhat 5 ÉÏ°²×°Oracle 10g

     ³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
      ±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......

Oracle×Ö·û´®º¯Êý

 1.ASCII 
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý; 
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual; 
A A ZERO SPACE 
--------- --------- --------- --------- 
65 97 48 32
2.CHR 
¸ø³öÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ