oracle µÄredoºÍundo
À´×Ôhttp://www.inthirties.com/thread-239-1-1.html
ÔÚÕâÀï»á½éÉÜUNDO£¬REDOÊÇÈçºÎ²úÉúµÄ£¬¶ÔTRANSACTIONSµÄÓ°Ï죬ÒÔ¼°ËûÃÇÖ®¼äÈçºÎÐͬ¹¤×÷µÄ¡£
ʲôÊÇREDO
REDO¼Ç¼transaction logs£¬·ÖΪonlineºÍarchived¡£ÒÔ»Ö¸´ÎªÄ¿µÄ¡£
±ÈÈ磬»úÆ÷Í£µç£¬ÄÇôÔÚÖØÆðÖ®ºóÐèÒªonline redo logsÈ¥»Ö¸´ÏµÍ³µ½Ê§°Üµã¡£
±ÈÈ磬´ÅÅÌ»µÁË£¬ÐèÒªÓÃarchived redo logsºÍonline redo logsÇø»Ö¸´Êý¾Ý¡£
±ÈÈ磬truncateÒ»¸ö±í»òÆäËûµÄ²Ù×÷£¬Ïë»Ö¸´µ½Ö®Ç°µÄ״̬£¬Í¬ÑùÒ²ÐèÒª¡£
ʲôÊÇUNDO
REDOÊÇΪÁËÖØÐÂʵÏÖÄãµÄ²Ù×÷£¬¶øUNDOÏà·´£¬ÊÇΪÁ˳·ÏúÄã×öµÄ²Ù×÷£¬±ÈÈçÄãµÃÒ»¸öTRANSACTIONÖ´ÐÐʧ°ÜÁË»òÄã×Ô¼ººó»ÚÁË£¬ÔòÐèÒªÓÃROLLBACKÃüÁî»ØÍ˵½²Ù×÷֮ǰ¡£»Ø¹öÊÇÔÚÂß¼²ãÃæÊµÏÖ¶ø²»ÊÇÎïÀí²ãÃæ£¬ÒòΪÔÚÒ»¸ö¶àÓû§ÏµÍ³ÖУ¬Êý¾Ý½á¹¹£¬blocksµÈ¶¼ÔÚʱʱ±ä»¯£¬±ÈÈçÎÒÃÇINSERTÒ»¸öÊý¾Ý£¬±íµÄ¿Õ¼ä²»¹»£¬À©Õ¹ÁËÒ»¸öеÄEXTENT£¬ÎÒÃǵÄÊý¾Ý±£´æÔÚÕâеÄEXTENTÀÆäËüÓû§ËæºóÒ²ÔÚÕâEXTENTÀï²åÈëÁËÊý¾Ý£¬¶ø´ËʱÎÒÏëROLLBACK£¬ÄÇôÏÔÈ»ÎïÀíÉϽ²ÕâEXTENT³·ÏúÊDz»¿ÉÄܵģ¬ÒòΪÕâô×ö»áÓ°ÏìÆäËûÓû§µÄ²Ù×÷¡£ËùÒÔ£¬ROLLBACKÊÇÂß¼Éϻعö£¬±ÈÈç¶ÔINSERTÀ´Ëµ£¬ÄÇôROLLBACK¾ÍÊÇDELETEÁË¡£
COMMIT ÒÔǰ£¬³£Ï뵱ȻµØÈÏΪ£¬Ò»¸ö´óµÄTRANSACTION£¨±ÈÈç´óÅúÁ¿µØINSERTÊý¾Ý£©µÄCOMMIT»á»¨·Ñʱ¼ä±È¶ÌµÄTRANSACTION³¤¡£¶øÊÂʵÉÏÊÇûÓÐÊ²Ã´Çø±ðµÄ£¬
ÒòΪORACLEÔÚCOMMIT֮ǰÒѾ°Ñ¸ÃдµÄ¶«Î÷дµ½DISKÖÐÁË£¬
ÎÒÃÇCOMMITÖ»ÊÇ
1£¬²úÉúÒ»¸öSCN¸øÎÒÃÇTRANSACTION£¬SCN¼òµ¥Àí½â¾ÍÊǸøTRANSACTIONÅŶӣ¬ÒÔ±ã»Ö¸´ºÍ±£³ÖÒ»ÖÂÐÔ¡£
2£¬REDOдREDOµ½DISKÖУ¨LGWR£¬Õâ¾ÍÊÇlog file sync£©£¬¼Ç¼SCNÔÚONLINE REDO LOG£¬µ±ÕâÒ»²½·¢Éúʱ£¬ÎÒÃÇ¿ÉÒÔ˵ÊÂʵÉÏÒѾÌá½»ÁË£¬Õâ¸öTRANSACTIONÒѾ½áÊø£¨ÔÚV$TRANSACTIONÀïÏûʧÁË£©
3£¬SESSIONËùÓµÓеÄLOCK£¨V$LOCK£©±»ÊÍ·Å¡£
4£¬Block Cleanout£¨Õâ¸öÎÊÌâÊDzúÉúORA-01555: snapshot too oldµÄ¸ù±¾ÔÒò£© ROLLBACK ROLLBACKºÍCOMMITÕýºÃÏà·´£¬ROLLBACKµÄʱ¼äºÍTRANSACTIONµÄ´óСÓÐÖ±½Ó¹ØÏµ¡£ÒòΪROLLBACK±ØÐëÎïÀíÉϻָ´Êý¾Ý¡£COMMITÖ®ËùÒԿ죬ÊÇÒòΪORACLEÔÚCOMMIT֮ǰÒѾ×÷Á˺ܶ๤×÷£¨²úÉúUNDO£¬ÐÞ¸ÄBLOCK£¬REDO£¬LATCH·ÖÅ䣩£¬
ROLLBACKÂýÒ²ÊÇ»ùÓÚÏàͬµÄÔÒò¡£
ROLLBACKȇ
1£¬»Ö¸´Êý¾Ý£¬DELETEµÄ¾ÍÖØÐÂINSERT£¬INSERTµÄ¾ÍÖØÐÂDELETE£¬UPDATEµÄ¾ÍÔÙUP
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»´ÎÆæ¹ÖµÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ¾Àú¡£
SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> conn / as sysdba
Co ......
°²×°ORACLEʱ£¬ÈôûÓÐΪÏÂÁÐÓû§ÖØÉèÃÜÂ룬ÔòÆäĬÈÏÃÜÂëÈçÏ£º
Óû§Ãû/ÃÜÂë
µÇ¼Éí·Ý
˵Ã÷
sys/change_on_install
SYSDBA»òSYSOPER
²»ÄÜÒÔNORMALµÇ¼£¬¿É×÷ΪĬÈϵÄϵͳ¹ÜÀíÔ±
system/manager
SYSDBA»òNORMAL
²»ÄÜÒÔSYSOPERµÇ¼£¬¿É×÷ΪĬÈϵÄϵͳ¹ÜÀíÔ±
sysman/oem_temp
sysman ΪomsµÄÓû§Ãû
scott/ ......
×¢£ºÏÂÃæÖ»ÊÇÎÒ´ÖÁӵļǼһÏ£¬×Ô¼ºÔÚ¿ª·¢ÖÐËùѧµÄÒ»²¿·Ö×ÊÁÏ£¡
1£® µÚÒ»¡¢ÊÇÏÂÔØÒ»¸ö“Oracle9i¿Í»§¶Ë¾«¼ò°æ.exe”¿Í»§¶Ë£¬È»ºó°ÑËü°²×°µ½CÅÌÏÂÃæ¡£
È»ºó°ÑÎÒÃÇ×Ô¼ºÅäÖúõĔ tnsnames.ora”Îļþ£¬¸´¸ÇC:\oracle\ora90\network\adminÏÂÃæµÄtnsnames.oraÎļþ¡£
2£® ÔÚVS2005¿ª·¢¹¤¾ßÖ ......
±¾ÎIJ¢²»×¼±¸½éÉÜÈ«²¿µÄoracleº¯Êý£¬µ±Ç°ÇéÊÆÏ£¬°³Ò²»¹Ã»Õâ¸öʱ¼ä£¬ÐèҪѧϰµÄ¶«Î÷Ì«¶àÁË£¬Òª°Ñ¶àÊýʱ¼ä»¨ÔÚѧϰ¾³£ÄÜÓÃÉϵļ¼Êõ·½Ãæ:)£¬ËùÒÔÈç¹ûÊÇ×¼±¸ÉîÈëÁ˽âËùÓÐoracleº¯ÊýµÄÅóÓÑ£¬»¹ÊÇÈ¥¹Ø×¢£ºOracle SQL Reference¹Ù·½Îĵµ¸ü¿¿Æ×һЩ¡£
¡¡¡¡±¾Îĸü¶à½«»á½éÉÜÈý˼ÔÚÈÕ³£Öо³£»áÓõ½µÄ ......