First method :
RMAN> report schema;
oracle> cd /u01/app/oracle/venu
oracle venu> ls
oracle venu> rm users01.dbf
oracle venu> ls
RMAN> validate database;
RMAN> sql 'alter database datafile <file_id> offline;
RMAN> restore datafile <file_id>;
RMAN> recover datafile <file_id>;
RMAN> sql 'alter database datafile <file_id> online;
Second method :
RMAN> startup mount
RMAN> restore datafile <file_id>;
RMAN> recover datafile <file_id>;
RMAN> sql 'alter database open resetlogs';
Third method :
oracle venu> rm user01.dbf
oracle venu> ls
RMAN> validate database;
RMAN> list failure;
RMAN> advice failure;
Note : copy n paste the given script with @ (or)
RMAN> repair failure;
Note : cat <path of the script to see the contents>
