2. 非归档模式下,非current redo丢失或损坏(active状态)
如果immediate关闭,可直接clear;
如果abort,需要不完全恢复
注意:归档模式方法一样
----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 97 52428800 512 1 NO ACTIVE 1628603 29-DEC-15 1628880 29-DEC-15
2 1 95 20971520 512 1 NO INACTIVE 1628590 29-DEC-15 1628594 29-DEC-15
3 1 98 52428800 512 1 NO CURRENT 1628880 29-DEC-15 2.8147E+14
---Session 2
root@zw_test_26_75 u01]# dd if=/dev/null of=/u01/app/oracle/oradata/orcl/redo01.log bs=512 count=10
0+0 records in
0+0 records out
0 bytes (0 B) copied, 0.000136094 s, 0.0 kB/s
SQL> shutdown abort; 注意是abort,如果是immediate可直接clear
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup