What was new for Oracle Backup and Recovery at 11g?

Oracle 12c is around the corner and due that I have received many questions from fellow DBAs about what was new about Backup and Recovery at 11g I have decided to write a small white paper about it.

Hope you will enjoy reading it as much I enjoyed writing it.



Francisco Munoz Alvarez

5 Replies to “What was new for Oracle Backup and Recovery at 11g?”

  1. Hello,

    Will you please share some info on differences between set newname and db_file_convert. I have used the later for the most.

    Thanks Michael.

    • Hi Michael,

      The following are new clauses and format options for the SET NEWNAME command at 11gR2:


      And the following variables are introduced for SET NEWNAME:

      %b – The file name remains same as the original. For example, if a datafile is named D:\oracle\oradata\matrix\test.dbf, then %b results in test.dbf.
      %f – Specifies the absolute file number of the datafile for which the new name is generated.
      %I – Specifies the DBID.
      %N – Specifies the tablespace name.
      %U – Specifies the following format: data-D-%d_id-%I_TS-%N_FNO-%f.

      The main benefit is that improves flexibility of RESTORE, DUPLICATE, and TSPITR operations.

      As per example, at earlier versions of oracle we were forced to mention the SET NEWNAME command to rename the duplicate datafiles while restoring/duplicating the database, mentioning each and every datafile at command line.

      # set new filenames for the datafiles
      SET NEWNAME FOR DATAFILE 1 TO ‘/dup/oracle/oradata/trgt/system01.dbf’;
      SET NEWNAME FOR DATAFILE 2 TO ‘/dup/oracle/oradata/trgt/undotbs01.dbf’;

      At 11gR2 using the new SET NEWNAME FOR DATABASE has made all things easier to us (all done in one command), if you want to do it at datafile level th.

      In the end the main diferences between DB_FILE_NAME_CONVERT and SET NEW NAME are the restrictions and flexibility. SET NEW NAME allows you to change the locations of datafiles as per example in one single command without the need to specify one by one (your process will not fail due that you misspell a datafile path or forgot to include a path as it will occurr when using DB_FILE_NAME_CONVERT) it also supports ASM disk groups. You cannot use the DB_FILE_NAME_CONVERT clause of the DUPLICATE command to control generation of new names for files at the duplicate instance that are in the Oracle Managed Files (OMF) format at the source database instance.



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.