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-16084: an apply engine is already running

1 Answers  


TNS-12631: Username retrieval failed

1 Answers  


TNS-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


ORA-01629: max # extents (string) reached saving undo for tablespace string

1 Answers  


DRG-11501: identifier string found in place of column name on line string

1 Answers  


TNS-01152: All addresses specified for the listener name, string, failed

1 Answers  


KUP-03018: invalid date mask "string" specified for column string

1 Answers  


DRG-50853: fetch error

1 Answers  


ORA-23487: object groups "string"."string" and "string"."string" do not have the same connection qualifier

1 Answers  


PCB-00101: Could not find or open system configuration file

1 Answers  


ORA-19001: Invalid storage option specified

1 Answers  


TNS-00076: component by specifying the component name in

1 Answers  


Categories