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
Ïà¹ØÎĵµ£º
¿ª·¢Êý¾Ý¿âÓ¦Óã¬Ñ¡ÔñÒ»¸öºÃµÄÊý¾Ý¿âÊǷdz£ÖØÒªµÄ¡£±¾ÎÄ´ÓһЩ·½Ãæ±È½ÏÁËSQL ServerÓëOracle¡¢DB2ÈýÖÖÊý¾Ý¿â£¬ÎªÄãÑ¡ÔñÊý¾Ý¿âÌṩһЩ²Î¿¼¡£
¡¡¡¡
¡¡¡¡¿ª·ÅÐÔ
¡¡¡¡SQL Server
¡¡¡¡Ö»ÄÜÔÚWindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT se ......
Êý¾Ý¿âÖо³£ÓÃ0,1 À´±êʶij×ֶΣ¬×÷Ϊ¿ª·¢ÈËÔ±¿ÉÄÜÖªµÀËüµÄÒâÒ壬µ«ÎÒÃÇÈÃËüÏÔʾÔÚGridÁбíÉϱØÐëÏÔʾËüµÄʵ¼Êº¬Ò壬һ°ãÎÒÃÇ¿ÉÒÔÔÚ´úÂëÖжÁÊý¾ÝԴʱ¿ÉÒÔ×÷´¦Àí£¬Í¬Ê±ORACLEÖÐÓÃdecodeÒ²ÊDz»´í·½·¨¡£
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
......
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆת´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁÈ¡Ò»¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´Ð ......
±¾ÎĽéÉÜÁËÈçºÎÀûÓÃsqlplus copy ÃüÁîÔÚÁ½¸öÊý¾Ý¿â¼äתÒÆÊý¾Ý
ÎÞÐèÓõ½dblink, Á½¸öÊý¾Ý¿â¼ä²»ÐèÖ±½ÓͨѶ£¬µ±È»£¬ÐèÒªÓÐÒ»¸öclient¶ÎÄÜͬʱÒÔsqlplusÁ¬½Óµ½Á½¸öÊý¾Ý¿â
ÎÊÌâµÄÌá³ö
ÂÛ̳ÉÏÓÐÈËÌá³öÕâÑùµÄÎÊÌ⣺
¼ÙÉèÓÐÁ½¸öÊý¾Ý¿â,·Ö±ð´¦ÓÚÁ½¸ö²»Í¬µÄÍøµ«ÓÐÒ»¸ö¿Í»§»ú°²ÁËÁ½¿éÍø¿¨¿ÉÒÔͬʱÁ¬µ½Á½¸öÊý¾Ý¿âÇëÎÊÈç¹û²»Í¨¹ýÔÚ¿ ......
×¢£ºÏÂÃæÖ»ÊÇÎÒ´ÖÁӵļǼһÏ£¬×Ô¼ºÔÚ¿ª·¢ÖÐËùѧµÄÒ»²¿·Ö×ÊÁÏ£¡
1£® µÚÒ»¡¢ÊÇÏÂÔØÒ»¸ö“Oracle9i¿Í»§¶Ë¾«¼ò°æ.exe”¿Í»§¶Ë£¬È»ºó°ÑËü°²×°µ½CÅÌÏÂÃæ¡£
È»ºó°ÑÎÒÃÇ×Ô¼ºÅäÖúõĔ tnsnames.ora”Îļþ£¬¸´¸ÇC:\oracle\ora90\network\adminÏÂÃæµÄtnsnames.oraÎļþ¡£
2£® ÔÚVS2005¿ª·¢¹¤¾ßÖ ......