Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Error: Cannot Identify/Lock Data File

By: FYIcenter.com

(Continued from previous topic...)

What Happens If You Lost a Data File?

After you shuting down an Oracle database, you accidently deleted a data file from the operating system. If you try to start the database again you will get error when Oracle tries to open the database after mounting the database. The following tutorial examples shows you what will happen if the data file c:\temp\my_space.dbf is deleted. Oracle can still start the database instance and mount the database. But it will fail on openning the database as shown below in a SQL*Plus session:

>sqlplus /nolog

SQL> connect SYSTEM/fyicenter AS SYSDBA

SQL> STARTUP
ORACLE instance started.

Total System Global Area  100663296 bytes
Fixed Size                  1285956 bytes
Variable Size              58720444 bytes
Database Buffers           37748736 bytes
Redo Buffers                2908160 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR
  trace file
ORA-01110: data file 5: 'C:\TEMP\MY_SPACE.DBF'

SQL> SHUTDOWN;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

(Continued on next topic...)

  1. What Is an Oracle Tablespace?
  2. What Is an Oracle Data File?
  3. How a Tablespace Is Related to Data Files?
  4. How a Database Is Related to Tablespaces?
  5. How To View Tablespaces in the Current Database?
  6. What Are the Predefined Tablespaces in a Database?
  7. How To View Data Files in the Current Database?
  8. How To Create a New Oracle Data File?
  9. How To Create a New Tablespace?
  10. How To Rename a Tablespace?
  11. How To Drop a Tablespace?
  12. What Happens to Data Files If a Tablespace Is Dropped?
  13. How To Create a Table in a Specific Tablespace?
  14. How To See Free Space of Each Tablespace?
  15. How To Bring a Tablespace Offline?
  16. How To Bring a Tablespace Online?
  17. How To Add Another Datafile to a Tablespace?
  18. What Happens If You Lost a Data File?
  19. How Remove Data Files before Opening a Database?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...