This discussion is archived
6 Replies Latest reply: Feb 1, 2013 7:12 AM by $phinx19 RSS

Loss of datafile with no backup in case of RMAN.

$phinx19 Newbie
Currently Being Moderated
Hi All,


I have read that, in case of a loss of a datafile where in which we have no backup of that particular datafile, we just need to take the tablespace offline and:
restore tablespace USERS;
recover tablespace USERS;
alter tablespace USERS online;
If this is the right way I need to know how RMAN recreates the lost datafile even though there is no backup of that datafile.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points