Performing Tablespace-Level Recovery

In this post I want to explain how to Tablespace-Level Recovery when we have lost all the datafiles contained in one tablespace.

For performing Tablespace-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 tablespace <TABLESPACE NAME>;

RMAN> recover tablespace <TABLESPACE NAME>;

RMAN> alter database open;

2.       Recover While database open:

RMAN> connect target /

RMAN> sql ‘alter tablespace <TABLESPACE NAME> offline immediate’;

RMAN> restore tablespace <TABLESPACE NAME>;

RMAN> recover tablespace <TABLESPACE NAME>;

RMAN> sql ‘alter tablespace <TABLESPACE NAME> online’;

This method of taking tablespace offline and then restore , recover and then back to online would work for every tablespace except SYSTEM and UNDO tablespace.