Oracle DBA, How To, Error, Cause and Action

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

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

No comments:

Post a Comment

Thanks for your comment.