alter database datafile 6 offline drop;
SQL> alter database open;
0alter database open
ERROR at line 1:
#L3f0ORA-01115: IO error reading block from file 92 (block # 39457)
0ORA-01110: data file 92: '/opt/oracle/oradata/rundata/runvistadata218.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 39457
information: 12288
SQL> recover datafile 92;
ORA-00283: recovery session canceled due to errors
`0ORA-12801: error signaled in parallel query server P001
q0Y Y.] V L y T+u)i0ORA-01115: IO error reading block from file 92 (block # 39455)
ORA-01110: data file 92: '/opt/oracle/oradata/rundata/runvistadata218.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional informat
SQL> alter database datafile 92 offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS