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

ORACLE DBAѧϰ±Ê¼Ç ¹ÜÀí¹éµµÈÕÖ¾Îļþ

¹éµµÈÕÖ¾Îļþ£ºÊÇ´¦Óڷǻ£¨INACTIVE£©µÄ״̬µÄÖØ×öÈÕÖ¾ÎļþµÄ±¸·Ý¡£Ëü¶ÔORACLEÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÆðÖÁ¹ØÖØÒªµÄ×÷Óá£ÊÇÁª»úÖØ×öÈÕÖ¾ÎļþµÄÒ»¸ö¸±±¾£¬Óë±»¸´ÖƵijÉÔ±Íê³ÉÒ»Ñù£¬¼´ÖØ×ö¼Ç¼Ïàͬ£¬ÈÕÖ¾ÐòÁкÅÏàͬ¡£
 
Ò»¡¢Êý¾Ý¿âµÄ¹éµµÓë·Ç¹éµµÄ£Ê½£º
1£®  µ±Êý¾Ý¿â´¦ÓÚNOACRCHIVELOGģʽʱ£¬²»¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬Ö±½Ó¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿âÖ»ÄÜ´ÓÀý³Ìʧ°ÜÖнøÐлָ´¡£
ÌØµã£º
a.       ·¢ÉúÈÕÖ¾Çл»Ê±£¨alter system switch logfile£©£¬LGWRºǫ́½ø³Ì¿ÉÒÔÎÞÌõ¼þ¸²¸ÇÔ­À´µÄÒѾ­±äΪ·Ç»î¶¯µÄ£¨INACTIVE£©ÖØ×öÈÕÖ¾ÎļþµÄÄÚÈÝ¡£
b.       ½øÐÐÊý¾Ý¿â±¸·Ýʱ£¬±ØÐëÏÈʹÓÃSHUTDOWN »òÕßSHUTDOWN IMMEDIATEÃüÁîÏȹرÕÊý¾Ý¿â£¬È»ºó²ÅÄÜͨ¹ý²Ù×÷ϵͳ±¸·ÝËùÓеÄÎïÀíÎļþ¡£¼´À䱸·Ý¡£²»ÄܽøÐÐÁª»úµÄÈȱ¸·Ý¡£
c.       NOACRCHIVELOGģʽʱ£¬Ö»Äܱ£»¤Êý¾Ý¿âÃâÓÚÀý³Ìʧ°Ü£¬µ«²»Äܱ£»¤Êý¾Ý¿âÃâÓÚ½éÖÊʧ°Ü¡£
d.       NOACRCHIVELOGģʽ²»ÐèÒª¿¼ÂÇ´æ´¢¿Õ¼äµÄÎÊÌâ¡£
 
2£®  µ±Êý¾Ý¿â´¦ÓÚACRCHIVELOGģʽʱºò£¬ÏµÍ³Í¨¹ýºǫ́½ø³ÌARCnÀ´°ïÖúDBA×Ô¶¯Íê³É¶ÔÖØ×öÈÕÖ¾Îļþ½øÐй鵵£¬¹éµµÖ®ºó²Å¸²¸Ç¾ÉµÄÖØ×öÈÕÖ¾Îļþ£¬²¢½«Æä¸´ÖƵ½Ò»¸öÖ¸¶¨µÄλÖ㬳ÉΪ¹éµµÈÕÖ¾Îļþ£¬´ËʱÊý¾Ý¿â»¹ÄܽøÒ»²½´Ó½éÖÊʧ°ÜÖлָ´¡£¼´¿É½«Êý¾ÝµÄËðʧ¼õÉÙµ½×îС£¬¿ÉÓÃÐÔÌá¸ßµ½×î¸ß¡£
ÌØµã£º
a.       µ±ACRCHIVELOGģʽʱ¡£¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐÐÁª»úµÄÈȱ¸·Ý¡£
b.       µ±³öÏÖÊý¾ÝÎļþËð»µÊ±£¬³ýÁËSYSTEM±í¿Õ¼äµÄÊý¾ÝÎļþ£¬ÆäËû±í¿Õ¼ä¶¼¿ÉÒÔÔÚÊý¾Ý¿â´¦ÓÚOPENʱ»Ö¸´¡£
c.       Ö´ÐÐÊý¾Ý¿â±¸·Ýʱ£¬²»½ö¿ÉÒÔ½øÐÐÍê³É»Ö¸´£¬Ò²¿ÉÒÔÖ¸¶¨»Ö¸´µ½Ä³¸öÌØ¶¨µÄʱ¼äµã¡£
 
Ò»¡¢Êý¾Ý¿â¹éµµ²ÎÊý
 
ͨ¹ýARCHIVE LOG LIST ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½£»
1£®  LOG_ARCHIVE_DUPLIEX_DESTÓëLOG_ARCHIVE_DEST_n
LOG_ARCHIVE_DESTÓÃÓÚÖ¸¶¨µÚÒ»¸ö¹éµµÄ¿±êλÖã¨Ö÷¹éµµÄ¿±ê£©£¬n±íʾ¸´±¾ÊýÁ¿¡£Èç¹ûÖ»ÉèÖÃÒ»¸ö¸´±¾£¬µ±Õâ¸ö¸´±¾´íÎóʱºò£¬Ôò¿ÉÒÔͨ¹ýÆäËû¸´±¾±¸Óᣣ¨1<=n<=10£©
LOG_ARCHIVE_DUPLIEX_DESTÓÃÓÚÖ¸¶¨µÚ¶þ¸ö¹éµµÄ¿±êλÖ㨴ι鵵Ŀ±ê£©£¬
ÕâÁ½¸ö²ÎÊýµÄÏàÅųâµÄ£¬²»ÄÜͬʱ´æÔÚ¡£
2£®  Æô¶¯ºÍ½ûÓÃ×Ô¶¯¹éµµµÄ²ÎÊý


Ïà¹ØÎĵµ£º

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

Oracle ÖÐµÄ TO_DATE ºÍ TO_CHAR º¯Êý

oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý

¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢

 
Year(Äê):
yy
two digits(Á½Î»Äê)
08
 
yyy
three digits(ÈýλÄê)
008
 
yyyy
four digits(ËÄλÄê)
2008
 
 
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
 
mon
abbre ......

ORACLE REDO ¡¶ÉîÈëdz³öORACLEµÚÁùÕ¡·

RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......

oracleÊý¾Ý¿âѧϰ£¨ZT£©

 oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾­Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£ 
Ò»¡¢¶¨Î» 
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracle ......

oracle constraints(1)

  oracle µÄÔ¼ÊøÖ÷ÒªÊÇÔÚÒµÎñÂß¼­²ãÃæÎ¬»¤Êý¾ÝµÄÍêÕûÐÔ¡£Ö÷Ҫͨ¹ý³ÌÐòÔ±ÔÚÓ¦ÓóÌÐòÖÐ¹æ¶¨Ô¼Êø»òÕßͨ¹ý¶¨Òå´¥·¢Æ÷À´Î¬»¤Êý¾ÝÍêÕûÐÔ£¬×îºóÊÇͨ¹ýʹÓÃoracle×Ô´øµÄÔ¼ÊøÀ´Î¬»¤Êý¾ÝÍêÕûÐÔ¡£ÄÜʹÓÃoracle×Ô´øµÄÔ¼Êø´ïµ½ÒªÇó¾Í¾¡Á¿Ê¹ÓÃoracle×Ô´øµÄÔ¼Êø£¬ÒòΪʹÓô¥·¢Æ÷µÈÓû§×Ô¶¨ÒåÔ¼Êø¶¼»áÓ°ÏìÊý¾Ý¿âµÄÐÔÄÜ¡£ÀýÈ磺ʹÓô¥·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ