ORA-01157:cannot identify/lock data file 6 - see DBWR trace file ORA-01110:data file 6:‘XX/X/X.dbf‘

 

SQL> startup;
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size                  2253824 bytes
Variable Size            1291848704 bytes
Database Buffers          369098752 bytes
Redo Buffers                7020544 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/home/oracle/watch_dog1.dbf'


SQL> alter database datafile 6 offline drop;

Database altered.

SQL> alter database open;

Database altered.

SQL> SQL> startup;