oracle±¸·Ý»Ö¸´µÄÎÊÌâ

Ó¦Óû·¾³ÊÇA»ú£¬ÔÚB»úÉϽ¨Á˸öÓëA»úÒ»ÑùµÄÊý¾Ý¿â£¬²¢ÇÒ»Ö¸´ÁËÇ°¼¸Ìì´ÓA»úÉÏÀ䱸ÏÂÀ´µÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþµÈ£¬ÏÖÔÚA»úÉÏÓй鵵ÈÕÖ¾£¬ÎÒÏëÓÃÕâЩ¹éµµÈÕÖ¾»Ö¸´µ½B»úÉÏ£¬ÒªÔõô×öÄØ£¿

---

沒試過¡£
ÓÃdata guard¾Í¿ÉÒÔ×Ô動實現這種²Ù×÷ÁË¡£

---

àÅ£¬Èç¹ûÏë·½±ãµã¾ÍʹÓÃdata guard

---

ÒýÓÃ

Ó¦Óû·¾³ÊÇA»ú£¬ÔÚB»úÉϽ¨Á˸öÓëA»úÒ»ÑùµÄÊý¾Ý¿â£¬²¢ÇÒ»Ö¸´ÁËÇ°¼¸Ìì´ÓA»úÉÏÀ䱸ÏÂÀ´µÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþµÈ£¬ÏÖÔÚA»úÉÏÓй鵵ÈÕÖ¾£¬ÎÒÏëÓÃÕâЩ¹éµµÈÕÖ¾»Ö¸´µ½B»úÉÏ£¬ÒªÔõô×öÄØ£¿

ÄãÕâЩ¹éµµÊÇ´ÓÉÏ´ÎÀ䱸ÒÔºó¶¼ÊÇÁ¬ÐøµÄô£¬Èç¹ûÊÇ£¬¿ÉÒÔÖ±½Ó¿½±´µ½ÉÏ´ÎÀ䱸·ÝÏÂÀ´µÄ¹éµµÄ¿Â¼ÀȻºórecover database using backup controlfile until cancel ¾Í¿ÉÒÔß·¡£

Èç¹ûÖмäÓжϵôµÄ¡£¾Í²»ÐÐÁË£¬

---

學習ÁË

---

Ö´ÐÐrecover database using backup controlfile until cancelºó£¬
Ìáʾ£º
ORA£­00279£ºchange 16148394126 generated at 09/29/2009 08:33:39 needed for thread 1
ora-00289:suggestion : d:\oracle\ora92\rdbms\arc01001.001
ora-00280:change 16148394126 for thread 1 is in sequence #1001

specify log { <ret>=suggested | filename |auto |cancel}

ÎÒÑ¡Ôñauto,½Ó×ÅÌáʾ£º
ora_00326:log begins at change 16155126914,need earlier change 16148394126
ora-00334:archived log:'D:\oracle\ora92\rdbms\ARC01001.001'

ÎÊÌ⣺ÎÒ¿´ÁËÎҵĹ鵵ÈÕÖ¾£¬ÒѾ­µ½ÁËARC01004.001£¬Ò²¾ÍÊÇ˵»¹ÓÐARC01002.001¡¢ARC01003.001¡¢ARC01004.001