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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment