µÚÎåÕ ÆäËü»Ö¸´°¸Àý
5.1Ëð»µÁª»úÈÕÖ¾µÄ»Ö¸´·½·¨
5.1.1Ë𻵷ǵ±Ç°Áª»úÈÕÖ¾
´ó¼Ò¶¼Çå³þ£¬Áª»úÈÕÖ¾·ÖΪµ±Ç°Áª»úÈÕÖ¾ºÍ·Çµ±Ç°Áª»úÈÕÖ¾£¬·Çµ±Ç°Áª»úÈÕÖ¾µÄËð»µÊDZȽϼòµ¥µÄ£¬Ò»°ãͨ¹ýclearÃüÁî¾Í¿ÉÒÔ½â¾öÎÊÌâ¡£
1¡¢Æô¶¯Êý¾Ý¿â£¬Óöµ½ORA-00312 or ORA-00313´íÎó£¬Èç
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\Oracle\ORADATA\TEST\REDO01.LOG'
´ÓÕâÀïÎÒÃÇÖªµÀÈÕÖ¾×é1µÄÊý¾ÝÎļþËð»µÁË
´Ó±¨¾¯Îļþ¿ÉÒÔ¿´µ½¸üÏêϸµÄÐÅÏ¢
2¡¢²é¿´V$logÊÓͼ
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 YES INACTIVE
2 2 YES INACTIVE
3 3 NO CURRENT
¿ÉÒÔÖªµÀ£¬¸Ã×éÊǷǵ±Ç°×´Ì¬£¬¶øÇÒÒѾ¹éµµ¡£
3¡¢ÓÃCLEARÃüÁîÖؽ¨¸ÃÈÕÖ¾Îļþ
SQL>alter database clear logfile group 1;
Èç¹ûÊǸÃÈÕÖ¾×黹ûÓй鵵£¬ÔòÐèÒªÓÃ
SQL>alter database clear unarchived logfile group 1;
4¡¢´ò¿ªÊý¾Ý¿â£¬ÖØб¸·ÝÊý¾Ý¿â
SQL>alter database open;
×¢£º
1¡¢Èç¹ûË𻵵ÄÊǷǵ±Ç°µÄÁª»úÈÕÖ¾Îļþ£¬Ò»°ãÖ»ÐèÒªclear¾Í¿ÉÒÔÖؽ¨¸ÃÈÕÖ¾Îļþ£¬µ«ÊÇÈç¹û¸ÃÊý¾Ý¿â´¦Óڹ鵵״̬µ«¸ÃÈÕÖ¾»¹Ã»Óй鵵£¬¾ÍÐèҪǿÐÐclear£»
2¡¢½¨Òéclear£¬ÌرðÊÇÇ¿ÐÐclearºó×÷Ò»´ÎÊý¾Ý¿âµÄÈ«±¸·Ý£»
3¡¢´Ë·½·¨ÊÊÓÃÓڹ鵵Óë·Ç¹éµµÊý¾Ý¿â¡£
5.1.2Ë𻵵±Ç°Áª»úÈÕÖ¾
¹éµµÄ£Ê½Ïµ±Ç°ÈÕÖ¾µÄËð»µÓÐÁ½ÖÖÇé¿ö£¬
Ò»¡¢ÊÇÊý¾Ý¿âÊÇÕý³£¹Ø±Õ£¬ÈÕÖ¾ÎļþÖÐûÓÐδ¾öµÄÊÂÎñÐèҪʵÀý»Ö¸´£¬µ±Ç°ÈÕÖ¾×éµÄËð »µ¾Í¿ÉÒÔÖ±½ÓÓÃalter database clear unarchived logfile group nÀ´Öؽ¨¡£
¶þ¡¢ÊÇÈÕÖ¾×éÖÐÓлµÄÊÂÎñ£¬Êý¾Ý¿âÐèҪýÌå»Ö¸´£¬ÈÕÖ¾×éÐèÒªÓÃÀ´Í¬²½£¬ÓÐÁ½ÖÖ²¹¾È°ì·¨:
A.×îºÃµÄ°ì·¨¾ÍÊÇͨ¹ý²»ÍêÈ«»Ö¸´£¬¿ÉÒÔ±£Ö¤Êý¾Ý¿âµÄÒ»ÖÂÐÔ£¬µ«ÊÇÕâÖÖ°ì·¨ÒªÇóÔڹ鵵·½Ê½Ï£¬²¢ÇÒÓпÉÓõı¸·Ý
B.ͨ¹ýÇ¿ÖÆÐÔ»Ö¸´£¬µ«ÊÇ¿ÉÄܵ¼ÖÂÊý¾Ý¿â²»Ò»Ö¡£
ÏÂÃæ·Ö±ðÓÃÀ´ËµÃ÷ÕâÁ½ÖÖ»Ö¸´·½·¨£º
5.1.2.1ͨ¹ý±¸·ÝÀ´»Ö¸´
1¡¢´ò¿ªÊý¾Ý¿â£¬»áÓöµ½Ò»¸öÀàËƵĴíÎó
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\Oracle\ORADATA\TEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2)ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ
2¡¢²é¿´V$log£¬·¢ÏÖÊǵ±Ç°ÈÕÖ¾
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARCHIVED STATUS
--------- ---------- -------- ----------------
1 1 NO CURRENT
2 2 YES INACTIVE
3 3 YES INACTIVE
3¡¢·¢ÏÖclear²»³É¹¦
SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of thread 1
ORA-00312: online log 1 thread 1: 'D:\Oracle\ORADATA\TEST\REDO01.LOG'
4¡¢¿½±´ÓÐЧµÄÊý¾Ý¿âµÄÈ«±¸·Ý£¬²¢²»ÍêÈ«»Ö¸´Êý¾Ý¿â£º
¿ÉÒÔ²ÉÓûñÈ¡×î½üµÄSCNµÄ°ì·¨ÓÃuntil scn»Ö¸´»òÓÃuntil cnacel»Ö¸´
recover database until cancel
ÏÈÑ¡Ôñauto£¬¾¡Á¿»Ö¸´¿ÉÒÔÀûÓõĹ鵵ÈÕÖ¾£¬È»ºóÖØÐÂ
recover database until cancel
Õâ´ÎÊäÈëcancel£¬Íê³É²»ÍêÈ«»Ö¸´£¬Ò²¾ÍÊÇ˵»Ö¸´Á½´Î¡£
È磺
SQL> recover database until cancel;
Auto
¡¡
SQL> recover database until cancel;
Cancel;
5¡¢ÀûÓÃalter database open resetlogs´ò¿ªÊý¾Ý¿â.
×¢£º
1¡¢ÕâÖÖ°ì·¨»Ö¸´µÄÊý¾Ý¿âÊÇÒ»ÖµIJ»ÍêÈ«»Ö¸´£¬»á¶ªÊ§µ±Ç°Áª»úÈÕÖ¾ÖеÄÊÂÎñÊý¾Ý;
2¡¢ÕâÖÖ·½·¨ÊʺÏÓڹ鵵Êý¾Ý¿â²¢ÇÒÓпÉÓõÄÊý¾Ý¿âÈ«±¸·Ý;
3¡¢»Ö¸´³É¹¦Ö®ºó£¬¼ÇµÃÔÙ×öÒ»´ÎÊý¾Ý¿âµÄÈ«±¸·Ý;
4¡¢½¨ÒéÁª»úÈÕÖ¾ÎļþÒ»¶¨ÒªÊµÏÖ¾µÏàÔÚ²»Í¬µÄ´ÅÅÌÉÏ£¬±ÜÃâÕâÖÖÇé¿öµÄ·¢Éú£¬ÒòΪÈκÎÊý¾ÝµÄ¶ªÊ§¶ÔÓÚÉú²úÀ´Ëµ¶¼ÊDz»ÈÝÐíµÄ¡£
5.1.2.2Èç¹ûûÓб¸·Ý£¬½øÐÐÇ¿ÖÆÐÔ»Ö¸´
1¡¢´ò¿ªÊý¾Ý¿â£¬»áÓöµ½Ò»¸öÀàËƵĴíÎó
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\Oracle\ORADATA\TEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2)ϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ
2¡¢²é¿´V$log£¬·¢ÏÖÊǵ±Ç°ÈÕÖ¾
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 NO CURRENT
2 2 YES INACTIVE
3 3 YES INACTIVE
3¡¢·¢ÏÖclear²»³É¹¦
SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of thread 1
ORA-00312: online log 1 thread 1: 'D:\Oracle\ORADATA\TEST\REDO01.LOG'
4¡¢°ÑÊý¾Ý¿âdownµô
SQL>shutdown immediate
5¡¢ÔÚinit<sid>.oraÖмÓÈëÈçϲÎÊý
_allow_resetlogs_corruption=TRUE
6¡¢ÖØÐÂÆô¶¯Êý¾Ý¿â,ÀûÓÃuntil cancel»Ö¸´
SQL>recover database until cancel;
Cancel
Èç¹û³ö´í£¬²»ÔÙÀí»á£¬·¢³ö
SQL>alter database open resetlogs;
7¡¢Êý¾Ý¿â±»´ò¿ªºó£¬ÂíÉÏÖ´ÐÐÒ»¸öfull export
8¡¢shutdownÊý¾Ý¿â,È¥µô_all_resetlogs_corrupt²ÎÊý
9¡¢Öؽ¨¿â
10¡¢import²¢Íê³É»Ö¸´
11¡¢½¨ÒéÖ´ÐÐÒ»ÏÂANALYZE TABLE ...VALIDATE STRUCTURE CASCADE;
×¢£º
1¡¢¸Ã»Ö¸´·½·