You Lost a particular Datafile ..How to recover !! ?

You have one datafile that has experienced media failure and you want to restore and recover it without restoring the entire tablespace or database.

Scenarion 1: Datafile recovery while database is open

RMAN>Connect target /

RMAN>SQL ‘Alter database datafile 3,4 offline’;

RMAN>Restore datafile 3,4 ;

RMAN>Recover datafile 3,4;

RMAN>Alter database datafile 3,4 online;

Scenarion 2: Datafile recovery while database is not open.

RMAN>Connect target /

RMAN>Startup mount

RMAN>Restore datafile 1 ;

RMAN>Recover datafile 1;

RMAN>Alter database open;