4 Replies Latest reply: Nov 8, 2012 7:49 AM by Pavel RSS

    RMAN-06085

    Pavel
      Hello!

      I try to restore database:
      ...
      set newname for datafile '/....dbf' to '/....dbf';
      set newname for datafile '/....dbf' to '/....dbf';
      restore database;
      switch datafile all;
      release channel ch00;
      }
      During restore of db I get next message:
      *11.2.0.3*
      executing command: SET NEWNAME
      executing command: SET NEWNAME
      Starting restore at 08-NOV-12
      released channel: ch00
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 11/08/2012 19:00:47
      RMAN-06085: must use SET NEWNAME command to restore datafile 1
      Thanks and regards,
      Pavel
        • 1. Re: RMAN-06085
          mseberg
          Hello;

          RMAN-06085 - A RESTORE command for the specified datafile could not find a destination name for the specified datafile.

          Example
          SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/RECLONE/system01.dbf'; 
          
          So it will create the datafile in the correct path.
          With a little dynamic SQL this is easy :
          set heading off
          set feedback off
          set pagesize 400
           
          select ' newname  for datafile ' || file#|| ' to ' || name from v$datafile;
          Make sure your file structure is setup too.

          Best Regards

          mseberg

          Edited by: mseberg on Nov 8, 2012 7:17 AM
          • 2. Re: RMAN-06085
            Pavel
            Hello Mseberg

            I thank You !

            Best regards,
            Pavel
            • 3. Re: RMAN-06085
              mseberg
              Only one Oracle MOS note on this :

              OERR: RMAN 6085 must use SET NEWNAME command to restore datafile %s [ID 48232.1]

              But it has no new information.

              Best Regards

              mseberg
              • 4. Re: RMAN-06085
                Pavel
                Yes , Sir

                thank You again