Oracle Flashback ¼¼Êõ×ܽá
Oracle Flashback ¼¼Êõ×ܽá
Flashback ¼¼ÊõÊÇÒÔUndo segmentÖеÄÄÚÈÝΪ»ù´¡µÄ£¬ Òò´ËÊÜÏÞÓÚUNDO_RETENTON²ÎÊý¡£ÒªÊ¹ÓÃflashback µÄÌØÐÔ£¬±ØÐëÆôÓÃ×Ô¶¯³·Ïú¹ÜÀí±í¿Õ¼ä¡£
ÔÚOracle 10gÖУ¬ Flash back¼Ò×å·ÖΪÒÔϳÉÔ±£º Flashback Database£¬ Flashback Drop£¬Flashback Query(·ÖFlashback Query,Flashback Version Query£¬ Flashback Transaction Query ÈýÖÖ) ºÍFlashback Table¡£
Ò»£® Flashback Database
Flashback Database ¹¦Äܷdz£ÀàËÆÓëRMANµÄ²»ÍêÈ«»Ö¸´£¬ Ëü¿ÉÒÔ°ÑÕû¸öÊý¾Ý¿â»ØÍ˵½¹ýÈ¥µÄij¸öʱµãµÄ״̬£¬ Õâ¸ö¹¦ÄÜÒÀÀµÓÚFlashback log ÈÕÖ¾¡£ ±ÈRMAN¸ü¿ìËٺ͸ßЧ¡£ Òò´ËFlashback Database ¿ÉÒÔ¿´×÷ÊDz»ÍêÈ«»Ö¸´µÄÌæ´ú¼¼Êõ¡£ µ«ËüÒ²ÓÐijЩÏÞÖÆ£º
1. Flashback Database ²»Äܽâ¾öMedia Failure£¬ ÕâÖÖ´íÎóRMAN»Ö¸´ÈÔÊÇΨһѡÔñ
2. Èç¹ûɾ³ýÁËÊý¾ÝÎļþ»òÕßÀûÓÃShrink¼¼ÊõËõСÊý¾ÝÎļþ´óС£¬Õâʱ²»ÄÜÓÃFlashback Database¼¼Êõ»ØÍ˵½¸Ä±ä֮ǰµÄ״̬£¬Õâʱºò¾Í±ØÐëÏÈÀûÓÃRMAN°Ñɾ³ý֮ǰ»òÕßËõС֮ǰµÄÎļþ±¸·Ýrestore ³öÀ´£¬ È»ºóÀûÓÃFlashback Database Ö´ÐÐʣϵÄFlashback Datbase¡£
3. Èç¹û¿ØÖÆÎļþÊÇ´Ó±¸·ÝÖлָ´³öÀ´µÄ£¬»òÕßÊÇÖؽ¨µÄ¿ØÖÆÎļþ£¬Ò²²»ÄÜʹÓÃFlashback Database¡£
4. ʹÓÃFlashback DatabaseËøÄָܻ´µ½µÄ×îÔçµÄSCN£¬ È¡¾öÓëFlashback LogÖмǼµÄ×îÔçSCN¡£
Flashback Database ¼Ü¹¹
Flashback Database Õû¸ö¼Ü¹¹°üÀ¨Ò»¸ö½ø³ÌRecover Writer(RVWR)ºǫ́½ø³Ì£¬Flashback Database LogÈÕÖ¾ ºÍFlash Recovery Area¡£Ò»µ©Êý¾Ý¿âÆôÓÃÁËFlashback Database£¬ ÔòRVWR½ø³Ì»áÆô¶¯£¬¸Ã½ø³Ì»áÏòFlash Recovery AreaÖÐдÈëFlashback Database Log£¬ ÕâЩÈÕÖ¾°üÀ¨µÄÊÇÊý¾Ý¿éµÄ " Ç°¾µÏñ(before image)"£¬ ÕâÒ²ÊÇFlashback Database ¼¼Êõ²»ÍêÈ«»Ö¸´¿éµÄÔÒò¡£
[oracle@dba ~]$ ps -ef|grep rvw
oracle 12620 12589 0 13:21 pts/1 00:00:00 grep rvw
ÆôÓÃFlashback Database
Êý¾Ý¿âµÄFlashback Database¹¦ÄÜȱʡÊǹرյģ¬ÒªÏëÆôÓÃÕâ¸ö¹¦ÄÜ£¬¾ÍÐèÒª×öÈçÏÂÅäÖá£
1. ÅäÖÃFlash Recovery Area
ÒªÏëʹÓÃFlashback Database£¬ ±ØÐëʹÓÃFlash Recovery Area£¬ÒòΪFlashback Database LogÖ»Äܱ£´æÔÚÕâÀï¡£ ÒªÅäÖõÄ2¸ö²ÎÊýÈçÏ£¬Ò»¸öÊÇ´óС£¬Ò»¸öÊÇλÖá£Èç¹ûÊý¾Ý¿âÊÇRAC£¬flash recovery area ±ØÐëλÓÚ¹²Ïí´æ´¢ÖС£Êý¾Ý¿â±ØÐë´¦ÓÚarchivelog ģʽ.
ÆôÓÃFlash Recovery Area£º
SQL>AL
Ïà¹ØÎĵµ£º
OracleÐÔÄÜÓÅ»¯¼¼ÇÉ
http://tech.it168.com/db/o/2006-06-15/200606151715426.shtml
1.Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
1.RULE(»ùÓÚ¹æÔò) 2.COST(»ùÓڳɱ¾) 3.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊ ......
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......
ÎÒÃǶ¼ÖªµÀÔÚOracleÖÐÿÌõSQLÓï¾äÔÚÖ´ÐÐ֮ǰ¶¼ÐèÒª¾¹ý½âÎö£¬ÕâÀïÃæÓÖ·ÖΪÈí½âÎöºÍÓ²½âÎö¡£ÄÇôÕâÁ½ÖÖ½âÎöÓкβ»Í¬Ö®´¦ÄØ£¿ËüÃÇÓÖ·Ö±ðÊÇÈçºÎ½øÐнâÎöÄØ£¿OracleÄÚ²¿½âÎöµÄ²½ÖèÓÖÊÇÈçºÎ½øÐеÄÄØ£¿ÏÂÃæÎÒÃǾÍÕâЩ»°Ìâ½øÐй²Í¬Ì½ÌÖ¡£ ÔÚOracleÖдæÔÚÁ½ÖÖÀàÐ͵ÄSQLÓï¾ä£¬Ò»ÀàΪDDLÓï¾ä£¬ËûÃÇÊÇ´ÓÀ´²»»á¹²ÏíʹÓõģ¬Ò²¾ÍÊÇÿ´ÎÖ´ ......
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃ漸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨. ......