Delete Current log in Oracle Archive mode incomplete recovery

Archive mode

[email protected]> archive log listDatabase log mode          Archive ModeAutomatic archival         EnabledArchive destination        /u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence     5Next log sequence to archive   7Current log sequence           7

View Log Groups

[email protected]> select group#,status from v$log;    GROUP# STATUS---------- ----------------     1 INACTIVE     2 CURRENT     3 INACTIVE

View current Log group file path

select member from v$logfile;MEMBER------------------------------------------------------------------------------------------------------------------------/u01/app/oracle/oradata/orcl/redo03.log/u01/app/oracle/oradata/orcl//redo02.log/u01/app/oracle/oradata/orcl//redo01.log

Delete log files
Rm-rf/u01/app/oracle/oradata/orcl/redo02.log
Start Database error

[email protected]> startupORACLE instance started.Total System Global Area  835104768 bytesFixed Size          2257840 bytesVariable Size         536874064 bytesDatabase Buffers      289406976 bytesRedo Buffers            

View Trace alert log, indicating that the file could not be found

ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/orcl/redo02.log‘ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3

for recovery

recover database until cancel;alter database open resetlogs;

Delete Current log in Oracle Archive mode incomplete recovery