Unable to Rename or Drop wrong Redologfile and Tempfile
Hi,
While restoring DB from Window to Linux. By mistake one Redo logfile and Tempfile created wrong, Now I want to drop them and create new one.
But I am unable to drop due to below error.
SQL> select member from v$logfile;
MEMBER
------------------------------------------------------------
/asmkvm_store/oradata\REDO03.LOG { Wrong location }
/asmkvm_store/oradata/REDO02.LOG
/asmkvm_store/oradata/REDO01.LOG
SQL> select name from v$tempfile;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/asmkvm_store/oradata\TEMP01.DBF
I tried to drop and rename but both are getting failed.
--------------------------------------------------------------------------------------------------------
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1: