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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Stream ÊÇOracle µÄÏûÏ¢¶ÓÁÐ(Ò²½ÐOracle Advanced Queue)¼¼ÊõµÄÒ»ÖÖÀ©Õ¹Ó¦ÓᣠOracle µÄÏûÏ¢¶ÓÁÐÊÇͨ¹ý·¢²¼/¶©Ôĵķ½Ê½À´½â¾öʼþ¹ÜÀí¡£Á÷¸´ÖÆ(Stream replication)Ö»ÊÇ»ùÓÚËüµÄÒ»¸öÊý¾Ý¹²Ïí¼¼Êõ£¬Ò²¿ÉÒÔ±»ÓÃ×÷Ò»¸ö¿ÉÁé»î¶¨ÖƵĸ߿ÉÓÃÐÔ·½°¸¡£ Ëü¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âÖ®¼äÊý¾Ý¿â¼ ......
DML(Manipulation):Êý¾Ý²Ù×÷ÓïÑÔ
CRUD
DDL(Definition): Êý¾Ý¶¨ÒåÓïÑÔ,Óë±í£¬Ë÷Òý£¬Í¬Òå´ÊÓйØ
create,alter,drop,rename,truncate(Çå¿Õ)
DCL(Control): Êý¾Ý¿ØÖÆÓïÑÔ£¬ÓëȨÏÞÓйØ
grant,revoke
TCL(Transaction Control): ÊÂÎñ¿ØÖÆÓïÑÔ,ÓëÊÂÎñÓйØ
commit,rollback,savepoint
==========================
´æ´¢ ......
¸ôÀë¼¶±ð£¨isoation level£©
¸ôÀë¼¶±ð¶¨ÒåÁËÊÂÎñÓëÊÂÎñÖ®¼äµÄ¸ôÀë³Ì¶È¡£
¸ôÀë¼¶±ðÓë²¢·¢ÐÔÊÇ»¥ÎªÃ¬¶ÜµÄ£º¸ôÀë³Ì¶ÈÔ½¸ß£¬Êý¾Ý¿âµÄ²¢·¢ÐÔÔ½²î£»¸ôÀë³Ì¶ÈÔ½µÍ£¬Êý¾Ý¿âµÄ²¢·¢ÐÔÔ½ºÃ¡£
ANSI/ISO SQ92±ê×¼¶¨ÒåÁËһЩÊý¾Ý¿â²Ù×÷µÄ¸ôÀë¼¶±ð£º
δÌá½»¶Á£¨read uncommitted£©
Ìá½»¶Á£¨read committed£© &n ......
Union£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Union All£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬°üÀ¨Öظ´ÐУ¬²»½øÐÐÅÅÐò£»
Intersect£¬¶ÔÁ½¸ö½á¹û¼¯½øÐн»¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Minus£¬¶ÔÁ½¸ö½á¹û¼¯½øÐвî²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò¡£
¿ÉÒÔÔÚ×î ......