Performing Datafile-Level Recovery

In this post I want to explain how to do datafile level recovery when we have lost  some datafiles.

For performing Datafile  level recovery you should have the following conditions:

1.       We have online redo log files.
2.       We have a healthy backup.
3.       We have all archived redo logfiles.

Also we have two solution. First solution is while database open and second is while database not open.

1.     Recover While database Not open:

RMAN> connect target /

RMAN> startup mount;

RMAN> restore datafile ‘<Datafile NAME or Number>’;

RMAN> recover datafile ‘<Datafile NAME or Number>’;

RMAN> alter database open;

2.       Recover While database open:

RMAN> connect target /

RMAN> sql “alter database datafile ‘<Datafile NAME or Number>’ offline”;

RMAN> restore datafile ‘<Datafile NAME or Number>’;

RMAN> recover datafile ‘<Datafile NAME or Number>’;

RMAN> sql “alter database datafile ‘<Datafile NAME or Number>’ online”;