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..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23464: flavor lacks column string of "string"."string"

1 Answers  


PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  


imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.

1 Answers  


NNL-00202: No shutdown currently scheduled

1 Answers  


ORA-27206: requested file not found in media management catalog

1 Answers  


ORA-12341: maximum number of open mounts exceeded

1 Answers  


ORA-16622: Two or more broker database objects resolve to one physical database.

1 Answers  


PCC-00079: ANSI requires colon on label in WHENEVER statement

1 Answers  


ORA-26006: Incorrect bind variable in column string's sql expression - string

1 Answers  


EXP-00078: Error exporting metadata for index string. Index creation will be skipped

1 Answers  


ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

1 Answers  


ORA-00448: normal completion of background process

1 Answers  


Categories