select t.FILE# from V$datafile t where t.STATUS!='SYSTEM' and t.STATUS!='ONLINE'
sqlplus "/ as sysdba"
shutdown immediate
startup mount
recover datafile 5;
alert database open;
stutdown immediate
startup
show parameter dump
sqlplus "/ as sysdba"
shutdown immediate
startup mount
recover datafile 5;
alert database open;
stutdown immediate
startup
show parameter dump