[oracle@redhat6 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed May 16 14:32:54 2018

Copyright (c) 1982,2009,Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1486787650)

RMAN> backup database;

Starting backup at 16-MAY-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile set
channel ORA_DISK_1: specifying datafile(s) in 
input datafile file number00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile 00002 namesysaux01.dbf
input datafile 00003 nameundotbs01.dbf
input datafile 00005 nameexample01.dbf
input datafile 00009 namemark.bdf
input datafile 00011 nametbs01.bdf
input datafile 00012 nametbs03.dbf
input datafile 00013 nametbs04.dbf
input datafile 00004 nameusers01.dbf
channel ORA_DISK_1: starting piece 1 at 
channel ORA_DISK_1: finished piece 
piece handle/product/0/db_1/dbs/01t31soh_1_1 tag=TAG20180516T144121 comment=NONE
channel ORA_DISK_1: set complete,elapsed time: 00:02:33
channel ORA_DISK_1: starting 00008 nametbs_32k.dbf
channel ORA_DISK_1: starting piece /02t31sta_1_1 tag01
including current control file current SPFILE 
channel ORA_DISK_1: starting piece /03t31stc_1_1 tag
Finished 18

select      t."NAME",d."NAME",d."FILE#"
from        v$tablespace  t,v$datafile d
where       t."TS#"  d."TS#"
order by t.ts#;

NAME                           NAME                                                                                  #
------------------------------ -------------------------------------------------------------------------------- ----------
SYSTEM                         /u01/system01.dbf                                                 1
SYSAUX                         /sysaux01.dbf                                                 2
UNDOTBS1                       /undotbs01.dbf                                                3
USERS                          /users01.dbf                                                  4
EXAMPLE                        /example01.dbf                                                5
TBS_32K                        /tbs_32k.dbf                                                  8
MARK                           /mark.bdf                                                     9
TBS01                          /tbs01.bdf                                                   11
TBS03                          /tbs03.dbf                                                   12
TBS04                          /tbs04.dbf                                                   13
10 rows selected

]$ rm -f /tbs04.dbf

RMAN> list failure;

List of Database Failures
=========================

Failure ID Priority Status    Time Detected Summary
-------- -------- --------- ------------- -------
8          HIGH     OPEN      18     One or more non-system datafiles need media recovery
42         HIGH     13DEC17     One -system datafiles are missing

RMAN advise failure
2 ;

List system datafiles are missing

analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete

Mandatory Manual Actions
========================
no manual actions available

Optional Manual Actions
=======================
1. If you restored the wrong version of data /tbs04.dbf,then replace it with the correct one
2. If /tbs04.dbf was unintentionally renamed or moved,1)">restore it

Automated Repair Options
========================
Option Repair Description
---- ------------------
1      Restore and recover datafile 13; Recover datafile 13 
  Strategy: The repair includes complete media recovery  no data loss
  Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1931299378.hm

]$ more /diag/rdbms/hmreco_1931299378.hm
   # restore and recover datafile
   sql 'alter database datafile 13 offline';
   restore datafile ;
   recover datafile ;
   sql alter database datafile 13 online;
   # recover datafile
   sql ';

RMAN>  sql ';

sql statement: alter database datafile  offline

RMAN> 13;

Starting restore at 
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile set 
channel ORA_DISK_1: specifying datafile(s) to restore from 
channel ORA_DISK_1: restoring datafile 00013 to tbs04.dbf
channel ORA_DISK_1: reading backup piece 01t31soh_1_1
channel ORA_DISK_1: piece handleTAG20180516T144121
channel ORA_DISK_1: restored 
channel ORA_DISK_1: restore complete,1); font-weight: bold">03

RMAN> recover datafile 13;

Starting recover at 
using channel ORA_DISK_1

starting media recovery
media recovery complete,elapsed time: 00

Finished recover at 13 online

sql> shutdown immediate;
 closed.
 dismounted.
ORACLE instance shut down.
sql startup
ORACLE instance started.

Total System Global Area  730714112 bytes
Fixed Size            2216944 bytes
Variable Size          314575888 bytes
Database Buffers      411041792 bytes
Redo Buffers            2879488 mounted.
Database opened.