RAJ> select count(1) from working_lines;
select count(1) from working_lines
*
ERROR at line 1:
ORA-00376: file 21 cannot be read at this time
ORA-01110: data file 21: '/dev/rtraidx2_2.dbf'
RAJ> select * from v$recover_file;
21 OFFLINE OFFLINE
RAJ> alter database datafile 21 online;
alter database datafile 21 online
*
ERROR at line 1:
ORA-01113: file 21 needs media recovery
ORA-01110: data file 21: '/dev/rtraidx2_2.dbf'
Recovered by the dba
SQL> RECOVER DATAFILE 21;
enter AUTO
Recovered
RAJ> ALTER DATABASE DATAFILE 21 ONLINE;
Database altered.