Drop datafile which is already removed Locally – ORA-01157,ORA-01110

I got the below issue while starting the database. Below issue occurred as I have deleted the datafiles from server level and not I am unable to start the datafile.

SQL> startup
ORACLE instance started.

Total System Global Area 1325400064 bytes
Fixed Size 8792488 bytes
Variable Size 822085208 bytes
Database Buffers 486539264 bytes
Redo Buffers 7983104 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 22 - see DBWR trace file
ORA-01110: data file 22: '/data/app/oracle/oradata/bigtbs01.dbf'

We need to remove the datafile information from control file metadata.


shutdown immediate
startup mount
alter database datafile '/data/app/oracle/oradata/bigtbs01.dbf' offline drop;
alter database open

Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!

Share and Enjoy !

0 0 0

Recommended For You


About the Author: ankushthavali

Leave a Reply

Your email address will not be published. Required fields are marked *