Recover a tablespace using RMAN

Recover a tablespace using RMAN:

Step:1 create a tablespace Rahul.

Step:2 view the tablespaces present in the database using

      Select tablespace_name from dba_tablespaces;

Step:3 Backup the tablespace and backup the database plus archivelog.

Step:4 select the sequence number of the current logfile from v$log view using,

      Select sequence# from v$log where status=’current’;

Step:5 Switch the log file using,

      Alter system switch logfile;

Step:6 Drop the tablespace Rahul by issuing the command,

      Drop tablespace Rahul including contents and datafiles;

Step:7 Then check the sequence number of the current logfile.

Step:8 After that recover the dropped tablespace Rahul using,

      Recover tablespace Rahul until logseq 15 auxiliary destination ‘/home/oracle/’;

Dropped tablespace – rahul is recovered using RMAN. You can view that tablespace in dba_tablespaces view.