场景:数据库版本 Version 9.2.0.4.0,noarchivelog 模式
所有的redolog 被删除。
现在只要能把数据库启动起来就可以。
如下:
SQL> startup
ORACLE instance started.
Total System Global Area 321882512 bytes
Fixed Size 731536 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 2383872 bytes
Database mounted.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/ora92/oradata/yytest1/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 0 104857600 1 NO UNUSED
5897150553 20-JUN-06