归档模式下redo丢失或损坏(inactive状态）



归档模式下redo丢失或损坏(inactive状态）

1）inactive  logfile损坏的情况

++++Session 1

SQL> select * from v$Log;

GROUP#   THREAD#  SEQUENCE#    BYTES  BLOCKSIZE   MEMBERS ARC STATUS   FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
 1        1         0       52428800    512       1      YES  UNUSED    1629032      29-DEC-15  1629391      29-DEC-15
 2        1        17       20971520    512       1      NO   CURRENT   1629391      29-DEC-15  2.8147E+14
 3        1        15       52428800    512       1      YES  INACTIVE  1629028      29-DEC-15  1629032      29-DEC-15
 

SQL> col member format a50
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                             IS_
---------- ------- ------- -------------------------------------
  1    ONLINE  /u01/app/oracle/oradata/orcl/redo01.log       NO
  2    ONLINE  /u01/app/oracle/oradata/orcl/redo02.log       NO
  3    ONLINE  /u01/app/oracle/oradata/orcl/redo03.log       NO

++++Session 2

[oracle@zw_test_26_75 trace]$ dd if=/dev/null of=/u01/app/oracle/oradata/orcl/redo03.log bs=512 count=10
0+0 records in
0+0 records out
0 bytes (0 B) copied, 0.00015951 s, 0.0 kB/s
 

SQL> startup
ORACLE instance started.

Total System Global Area  952020992 bytes
Fixed Size      2258960 bytes
Variable Size    314574832 bytes
Database Buffers   629145600 bytes
Redo Buffers      6041600 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 17653
Session ID: 145 Serial number: 3

alert_orcl.log报错
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter database open;

Database altered.

或者直接删除日志，打开数据库后再重新添加；

SQL> alter database drop logfile group 3;
Database altered.

SQL> alter database open;
Database altered.

SQL> alter database add logfile group 3 ('/home/ora10g/oradata/roger/redo03.log') size 10m reuse;
Database altered.