Oracle DBA, How To, Error, Cause and Action

ORA-01182: cannot create database file string - file is in use orrecovery

ORA-01182: cannot create database file string - file is in use or recovery




Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that is online in an open instance or is being recovered.




Action: Close database in all instances and end all recovery sessions