Saturday, December 13, 2008

Restore Non-critical Datafile using RMAN

1) See for which tablespace the datafile belongs.
SQL> select file_name, tablespace_name from dba_data_files;

2) alter tablespace offline;

3) RMAN> restore tablespace ;

4) RMAN> recover tablespace ;

5) RMAN> sql 'alter tablespace online';

No comments:

Post a Comment