6 Replies Latest reply: Feb 1, 2013 9:12 AM by $phinx19 RSS

    Loss of datafile with no backup in case of RMAN.

    $phinx19
      Hi All,

      OS:windows
      DB:11g

      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.


      Regards,
      Sphinx