3 Replies Latest reply on Jul 22, 2019 3:54 PM by Rami_robot

    restore data file

    Rami_robot

      Gents,

       

      Need your help, i am trying to restore a datafile to a "new location"...using the below RMAN run command block and receiving errors:

       

      run

      {

      set newname for datafile 11 to 'D:\APP\ORCL\VIRTUAL\ORADATA\ORACLE\PDB1\USERS01.DBF';

      restore datafile 11;

      recover datafile 11;

      }

       

      Errors:

       

      starting media recovery

      media recovery failed

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 07/21/2019 19:12:01

      ORA-00283: recovery session canceled due to errors

      RMAN-11003: failure during parse/execution of SQL statement: alter database recover

      if needed datafile 11

      ORA-00283: recovery session canceled due to errors

      ORA-01110: data file 11: 'D:\APP\ORCL\VIRTUAL\ORADATA\ORACLE\PDB1\USERS_NEW_DATA_FILE\USERS01.DBF'

      ORA-01157: cannot identify/lock data file 11 - see DBWR trace file

      ORA-01110: data file 11: 'D:\APP\ORCL\VIRTUAL\ORADATA\ORACLE\PDB1\USERS_NEW_DATA_FILE\USERS01.DBF'