Oracle¹éµµ¹ÜÀí
Oracle°ÑÌîÂúµÄÁª»úÈÕÖ¾Îļþ¸´ÖƵ½Ò»¸ö»òÕß¶à¸ö·¾¶£¬Õâ¸ö¹ý³Ì½Ð¹éµµ£¬ÕâÑùÉú³ÉµÄÎļþ½Ð¹éµµÈÕÖ¾Îļþ£¬´æ·ÅÈÕÖ¾ÎļþµÄ·¾¶½Ð¹éµµÂ·¾¶£¨¹éµµÄ¿Â¼£©¡£Ò»¸öÊý¾Ý¿â¿ÉÒÔÓжà¸ö¹éµµ½ø³Ì£¬Óɳõʼ»¯²ÎÊýLOG_ARCHIVE_MAX_PROCESSES)¿ØÖÆ¡£¹éµµÊDZ¸·ÝºÍ»Ö¸´µÄ»ùʯ¡£ÔÚOracleÖУ¬¼¸ºõËùÓеı¸·ÝºÍ»Ö¸´¶¼ÊÇÒѹ鵵Ϊ»ù´¡µÄ¡£Èç¹ûÊý¾Ý¿âûÓÐÔËÐÐÔڹ鵵ģʽ£¬²úÉúµÄÈȱ¸·Ý½«±äµÃÎÞЧ£¬Ò²¾ÍÎÞ·¨»Ö¸´Êý¾Ý¿â¡£Èç¹ûÊý¾Ý¿âûÓÐÔËÐÐÔڹ鵵ģʽ£¬¼´Ê¹ÓÐÀ䱸·Ý´æÔÚ£¬ÎÒÃÇÒ²»á¶ªÊ§À䱸·ÝºóµÄÊý¾Ý¡£
·Ç¹éµµÄ£Ê½Ö»±£»¤ÊµÀýʧ°Ü(Instance fail)£¬²»±£»¤½éÖÊʧ°Ü(media failure)¡£µ±·¢Éú½éÖÊʧ°Üʱ£¬ÐèÒª»¹ÔÊý¾Ý¿âµÄÈ«±¸·Ý¡£
LOG_ARCHIVE_DESTÉèÖÃÒ»¸ö¹éµµÂ·¾¶¡£LOG_ARCHIVE_DEST_n£¨1£10£©ÉèÖöà¸ö·¾¶£¬²ÎÊýΪLOCATIONºÍSERVER¡£Ò²¿É°ÑÁª»úÈÕÖ¾Îļþ¹éµµµ½Ô¶³Ì·þÎñÆ÷¡£LOG_ARCHIVE_FORMAT£¨%sÈÕÖ¾ÐòÁкţ¬%tÏß³ÌË÷ºÅ£¬%dÊý¾Ý¿âID£¬%rÖØÖÃÈÕÖ¾ID£¬%a»î¶¯IDºÅ£¬%SÈÕÖ¾ÐòÁкţ¬´øÇ°ÖÃ0£¬%TÏßË÷ºÅ£¬´øÇ°µ¼0£©¿ØÖÆÁª»úÈÕÖ¾ÎļþµÄ¸ñʽ£¬È磺LOG_ARCHIVE_FORMAT £½'log%t_%s_%r.arc'¡£
²é¿´Êý¾Ý¿â¹éµµ×´Ì¬£ºARCHIVE LOG LIST;
¸É¾»¹Ø±ÕÊý¾Ý¿â£ºSHUTDOWN IMMEDIATE;
´ò¿ªÊý¾Ý¿â£ºOPEN DATABASE OPEN;
³õʱ»¯²ÎÊýÎļþËùÔÚĿ¼£º $Oracle_HOME/dbs
¸ù¾ÝSPFILEÉú³É³õʼ»¯²ÎÊýÎļþPFILE£ºCREATE PFILE= '$Oracle_HOME/dbs/initnbo.ora' from SPFILE = '$Oracle_HOME/dbs/SPFILEnbo.ora';
Æô¶¯Êý¾Ý¿âµ½mount״̬£ºSTARTUP MOUNT;
ÉèÖõÚÒ»¸ö¹éµµÂ·¾¶£ºALTER SYSTEM SET LOG_ARCHIVE_DEST_1 ='LOCATION=/A/B';
Êý¾Ý¿âÇл»µ½¹éµµÄ£Ê½£ºALTER DATABASE ARCHIVELOG;
²é¿´¹éµµÂ·¾¶£ºSHOW PARAMETER LOG_ARCHIVE_DEST;
Êý¾Ý¿âÇл»µ½·Ç¹éµµÄ£Ê½£ºALTER DATABASE NOARCHIVELOG;
ÊÖ¹¤¹éµµÈÕÖ¾Îļþ£ºALTER SYSTEM ARCHIVE LOG ALL;
¹éµµµ±Ç°µÄÁª»úÈÕÖ¾Îļþ£ºALTER SYSTEM ARCHIVE LOG CURRENT;
ÉèÖÃPFILE²ÎÊýÎļþ×Ô¶¯Æô¶¯¹éµµ½ø³Ì£ºLOG_ARCHIVE_START=TRUE;
ÊÖ¹¤Æô¶¯¹éµµ½ø³Ì£ºALTER SYSTEM ARCHIVE LOG START;
Ïà¹ØÎĵµ£º
ÔÚOracle¹ØÓÚʱ¼äÊôÐԵĽ¨±í
Example:
create table courses(
cid varchar(20) not null primary key,
cname varchar(20) not null,
ctype integer,
ctime date DEFAULT SYSDATE,
cscore float not null
)
insert into courses values('ss01','java',0,TO_DATE('2009-8-28','yyyy-mm-dd'),94)
insert into course ......
CmdÃüÁîÐÐÊäÈëlsnrctl½øÈë¼àÌýģʽ£¬Í¨¹ýset passwordÉèÖÃÃÜÂë¡£
ͨ¹ý change_password ÐÞ¸ÄÃÜÂë¡£
LSNRCTL> help
ÒÔϲÙ×÷¿ÉÓÃ
ÐǺŠ(*) ±íʾÐ޸ķû»òÀ©Õ¹ÃüÁ
start stop &nbs ......
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøÊ¹ÓÃÁË¡£¡£¡£
Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......
Oracle¶Ô±í×öÈ«±íɨÃèµÄʱºò
£¬»áɨÃèÍêHWMÒÔÏÂ
µÄÊý¾Ý¿é¡£Èç¹ûij¸ö±ídelete(delete²Ù×÷²»»á½µµÍ¸ßˮλ)ÁË´óÁ¿Êý¾Ý£¬ÄÇôÕâʱ¶Ô±í×öÈ«±íɨÃè¾Í»á×öºÜ¶àÎÞÓù¦£¬É¨ÃèÁËÒ»´ó¶ÑÊý¾Ý¿é£¬×îºó·¢ÏÖ¿éÀïÃæ¾ÓȻûÓÐÊý¾Ý¡£
ͨ³££¬ÔÚ¶Ô±í×öÁË´óÅúÁ¿delete²Ù×÷Ö®ºó£¬¾ÍÓ¦¸ÃÂíÉϽµµÍ±íµÄ¸ßˮ룬¿ÉÒÔʹÓÃshrink ÃüÁî»òÕßalter&n ......
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......