All datafiles of a tablespace goes missing !! what to do ?

You are seeing a media error assosiated with several datafiles cotained in one tablespace.You want to perform a tablespace level recovery:

Scenario 1: Database is open and you want to perform tablespace-level recovery:

·         RMAN >connect target /

·         RMAN>SQL ‘alter tablespace data_ts offline immediate’ ;

·         RMAN>restore tablespace data_ts;

·         RMAN>recover tablespace data_ts;

·         RMAN>SQL ‘Alter tablespace data_ts online’;

Scenario 2: Database is down or mounted and you want to perform tablespace-recovery:

·         RMAN >Connect target /

·         RMAN>startup mount

·         RMAN>restore tablespace data_ts;

·         RMAN>recover tablespace data_ts;

·         RMAN>alter database open;