如何处理日志文件丢失

select group#,members from v$log;

查看日志文件的状态

select  group#,status from v$log;

有状态来决定执行步骤

status:    active            alter system checkpoint;            alter database clear logfile group         inactive,unused            alter database clear logfile group                 current            alter system switch logfile;            alter system checkpoint;            alter database clear logfile group