Database Administration (MOSC)

MOSC Banner

Unable to Rename or Drop wrong Redologfile and Tempfile

edited Feb 13, 2019 4:00AM in Database Administration (MOSC) 11 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center