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