¿ÉÒÔ½ÓÊÜËü£¬Ò²¿ÉÒÔ¸ü¸ÄËü¡£µ½´ïÒªÈûָ´Í£Ö¹µÄʱ¼äµãʱ£¬ÇëÊäÈë CANCEL£¬¶ø²»Òª½ÓÊÜÎļþÃû¡£Õ⽫ֹͣ»Ö¸´¡£
Íê³É´Ë²Ù×÷ºó£¬±ØÐëʹÓà RESETLOGS Ñ¡Ïî´ò¿ªÊý¾Ý¿â¡£ÓÉÓÚÊý¾Ý¿âµ±Ç°ÕýÔÚÖ´ÐÐÁíһʵÀý»¯²Ù×÷£¬Òò´ËÐèÒªÖØÖÃÖØ×öÈÕÖ¾ÐòÁкš£
´ò¿ª¸ÃÊý¾Ý¿âºó£¬¼ì²éÔ¤¾¯ÈÕÖ¾ÖеÄÏûÏ¢¡£Í¨¹ýÕâÖÖ·½Ê½£¬¿ÉÒÔ»ñÖª»Ö¸´ÊÇ·ñÒѳɹ¦¡£ÒªÔÚ»Ö¸´¹ý³ÌÖÐ×Ô¶¯Ó¦ÓÃÖØ×öÈÕÖ¾Îļþ£¬¿ÉÒÔʹÓà SQL*Plus SET AUTORECOVERY ON ÃüÁÔÚ»Ö¸´Ìáʾ·ûÏÂÊäÈë AUTO£¬»òÕßʹÓà RECOVER AUTOMATIC ÃüÁî¡£
»ùÓÚʱ¼äºÍ¸ü¸ÄµÄ²»ÍêÈ«»Ö¸´
»ùÓÚʱ¼äºÍ¸ü¸ÄµÄ²»ÍêÈ«»Ö¸´Óë»ùÓÚÈ¡ÏûµÄ»Ö¸´ÀàËÆ£¬Çø±ðÔÚÓÚʹÓò»Í¬±ê×¼À´Ö¸¶¨Í£Ö¹»Ö¸´µÄʱ¼ä¡£»ùÓÚʱ¼äµÄ»Ö¸´Ê¹ÓÃÔÚ RECOVER ÃüÁîµÄÃüÁîÐÐÖÐÖ¸¶¨µÄʱ¼äÀ´»ñÖªºÎʱֹͣ¡£»ùÓÚ¸ü¸ÄµÄ»Ö¸´Ê¹ÓÃÔÚÃüÁîÐÐÖÐÖ¸¶¨µÄ SCN¡£
ÓëËùÓеIJ»ÍêÈ«»Ö¸´Ò»Ñù£¬Ö®ºó±ØÐëʹÓà RESETLOGS Ñ¡Ïî´ò¿ªÊý¾Ý¿â¡£
Ö´ÐÐÓû§¹ÜÀíµÄ²»ÍêÈ«»Ö¸´£º²½Öè
1.¹Ø±ÕÊý¾Ý¿â¡£
2.»¹ÔÊý¾ÝÎļþ¡£
3.×°ÔØÊý¾Ý¿â¡£
4.»Ö¸´Êý¾Ý¿â¡£
5.ʹÓà RESETLOGS Ñ¡Ïî´ò¿ªÊý¾Ý¿â¡£ resetlogs ½«ÈÕÖ¾ÎļþµÄSCNºÅÇ¿ÖÆÖÃλ1£»
Ö´ÐÐ ALTER DATABASE OPEN RESETLOGS ´ò¿ªÊý¾Ý¿â¡£