TABLESPACE RECOVERY USING RMAN

SQL> select * from jobs;
select * from jobs
              *
ERROR at line 1:
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/product/10.2.0/oradata/orcl/example01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

THE RESOLVE USING RMAN

FIRST MANDATORY

FULL BACKUP PLUS ARCHIVELOG

RMAN>  sql ' alter tablespace example offline immediate';

sql statement:  alter tablespace example offline immediate

RMAN> restore tablespace example;

RMAN> recover tablespace example;

Starting recover at 29-AUG-13

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:02

Finished recover at 29-AUG-13

RMAN> sql ' alter tablespace example online';

sql statement:  alter tablespace example online


EXECUTE QUERY.....