How to handle the loss of log files
Select group#,members from v$log
View the status of the log file
Select group#,status from v$log
Have the state to decide the execution steps
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
