Oracle数据库联机日志文件丢失处理方法

核心提示： SQL>; alter database clear logfile group 1;Database altered.7、 继续启动dbSQL>;alterdatabaseopen;alterdatabaseopen*ERRORatline1:ORA-00313:openfa

SQL>; alter database clear logfile group 1;

Database altered.

7、 继续启动db

　　SQL>;alterdatabaseopen;
　　alterdatabaseopen
　　*
　　ERRORatline1:
　　ORA-00313:openfailedformembersofloggroup2ofthread1
　　ORA-00312:onlinelog2thread1:'/T3/ORACLE/oradata/ORA9/redo02.log'

8、 看来redo也得恢复，但是redo02是当前redo,直接clear是不行的

　　SQL>;alterdatabaseclearlogfilegroup2;
　　alterdatabaseclearlogfilegroup2
　　*
　　ERRORatline1:
　　ORA-00350:log2ofthread1needstobearchived
　　ORA-00312:onlinelog2thread1:'/T3/ORACLE/oradata/ORA9/redo02.log'
　　尝试clearunarchivedlogfilegroup,报错：
　　SQL>;alterdatabaseclearunarchivedlogfilegroup2;
　　alterdatabaseclearunarchivedlogfilegroup2
　　*
　　ERRORatline1:
　　ORA-00313:openfailedformembersofloggroup2ofthread1
　　ORA-00312:onlinelog2thread1:'/T3/ORACLE/oradata/ORA9/redo02.log'
　　ORA-27037:unabletoobtainfilestatus
　　SVR4Error:2:Nosuchfileordirectory
　　Additionalinformation:3

看来他是因为找不到这个文件，从有效的备份中cp一个过来看看

　　SQL>;hostcp/T3/ORACLE/oradatabak/redo02*/T3/ORACLE/oradata/ORA9
　　SQL>;alterdatabaseclearunarchivedlogfilegroup2;
　　Databasealtered.

搞定……….