Drop datafile which is already removed Locally

Learnomate Technologies > Drop datafile which is already removed Locally
Drop datafile which is already removed Locally – ORA-01157,ORA-01110
18
Aug

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> startupORACLE instance started.Total System Global Area 1325400064 bytesFixed Size 8792488 bytesVariable Size 822085208 bytesDatabase Buffers 486539264 bytesRedo Buffers 7983104 bytesDatabase mounted.ORA-01157: cannot identify/lock data file […]

Posted in: Oracle DBA ,
Tags: Drop datafile which is already removed Locally , ORA-01110 , ORA-01157 ,