How to delete a non-exists log file

Oct 16, 2018 4:58AM

Hi,

I accidentally rename one of my log file to '+DATA' as below

SQL> select group#,member from v$logfile;

GROUP# MEMBER

---------- ----------------------------------------------------------------------------------------------------

3 +DATA

2 +DATA/CFUSION/ONLINELOG/group_2.605.989641873

1 +DATA/CFUSION/ONLINELOG/group_1.604.989641857

3 +DATA/CFUSION/ONLINELOG/group_3.608.989642847

the database is in mount mode and I found no way to delete the '+DATA' file,

I tried

1)

RMAN> alter database drop logfile group 3;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 10/16/2018 04:40:52

ORA-01623: log 3 is current log for instance cfusion (thread 1) - cannot drop

ORA-00312: online log 3 thread 1: '+DATA'

2)

RMAN> ALTER DATABASE RENAME FILE '+DATA' TO '/home/oracle/test.log';

Database Administration (MOSC)