删除inactive日志组，重启数据库后恢复

----- 当前日志组状态

1. SQL> select group#,members,status from v$log;
   
2. 
   
3.     GROUP# MEMBERS STATUS
   
4. ---------- ---------- ----------------
   
5.          1 1 CURRENT
   
6.          2 1 INACTIVE
   
7.          3 1 INACTIVE
   
8. SQL> select group#,member from v$logfile order by 1;
   
9. 
   
10.     GROUP#
    
11. ----------
    
12. MEMBER
    
13. --------------------------------------------------------------------------------
    
14.          1
    
15. /u01/app/oracle/oradata/HU/redo01.log
    
16. 
    
17.          2
    
18. /u01/app/oracle/oradata/HU/redo02.log
    
19. 
    
20.          3
    
21. /u01/app/oracle/oradata/HU/redo03.log
    
22. 
    
23. 
    
24. SQL>

-----删除第二组日志

1. SQL> !rm /u01/app/oracle/oradata/HU/redo02.log
   
2. 
   
3. SQL> !ls /u01/app/oracle/oradata/HU/*.log
   
4. /u01/app/oracle/oradata/HU/redo01.log /u01/app/oracle/oradata/HU/redo03.log
   
5. 
   
6. SQL>

----- 重启数据库

1. SQL> shutdown immediate
   
2. Database closed.
   
3. Database dismounted.
   
4. ORACLE instance shut down.
   
5. SQL> startup
   
6. ORACLE instance started.
   
7. 
   
8. Total System Global Area 830930944 bytes
   
9. Fixed Size 2257800 bytes
   
10. Variable Size 536874104 bytes
    
11. Database Buffers 289406976 bytes
    
12. Redo Buffers 2392064 bytes
    
13. Database mounted.
    
14. ORA-03113: end-of-file on communication channel
    
15. Process ID: 13901
    
16. Session ID: 1 Serial number: 5
    
17. 
    
18. 
    
19. SQL>

---- 查看alert日志

1. Errors in file /u01/app/oracle/diag/rdbms/hu/HU/trace/HU_lgwr_13857.trc:
   
2. ORA-00313: open failed for members of log group 2 of thread 1
   
3. ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/HU/redo02.log'
   
4. ORA-27037: unable to obtain file status
   
5. Linux-x86_64 Error: 2: No such file or directory

---- 对2号日志组执行cleat操作，oper数据库

1. SQL> conn / as sysdba
   
2. Connected to an idle instance.
   
3. SQL> startup mount
   
4. ORACLE instance started.
   
5. 
   
6. Total System Global Area 830930944 bytes
   
7. Fixed Size 2257800 bytes
   
8. Variable Size 536874104 bytes
   
9. Database Buffers 289406976 bytes
   
10. Redo Buffers 2392064 bytes
    
11. Database mounted.
    
12. SQL> alter database clear logfile group 2;
    
13. 
    
14. Database altered.
    
15. 
    
16. SQL> alter database open;
    
17. 
    
18. Database altered.
    
19. 
    
20. SQL>

---- 查看日志组状态

1. SQL> select group#,members,status from v$log;
   
2. 
   
3.     GROUP# MEMBERS STATUS
   
4. ---------- ---------- ----------------
   
5.          1 1 CURRENT
   
6.          2 1 UNUSED
   
7.          3 1 INACTIVE
   
8. 
   
9. SQL> !ls /u01/app/oracle/oradata/HU/*.log
   
10. /u01/app/oracle/oradata/HU/redo01.log /u01/app/oracle/oradata/HU/redo03.log
    
11. /u01/app/oracle/oradata/HU/redo02.log
    
12. 
    
13. SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2138621/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2138621/