ORA-01121: cannot rename database file string – file is in use or recovery



Share this article :

Error Message

ORA-01121: cannot rename database file string – file is in use or recovery

Cause

Attempted to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.

Action

Close database in all instances and end all recovery sessions.

Related posts

ORA-00018: maximum number of sessions exceeded
ORA-00216: control file could not be resized for migration from 8.0.2
ORA-00228: length of alternate control file name exceeds maximum of string
ORA-00304: requested INSTANCE_NUMBER is busy
© 2017 ITsiti. All Rights Reserved
Powered by KEEM