RMAN: SET NEWNAME Command Using SQL

(Doc ID 549972.1)

Last updated on JUNE 29, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database - Enterprise Edition - Version 9.0.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2013***


Goal

When you must restore the database the same directory structure is not always there. If you have a database containing 1000s of datafiles it can be very tedious to setup the set newname commands for all the datafiles. Using sqlplus we can extract the information we need into a file which can then be easily modifed and executed as an RMAN script to complete the task.

Starting from 11.2, we can use SET NEWNAME FOR DATABASE clause to avoid using SET NEWNAME for individual datafiles. eg:
SET NEWNAME FOR DATABASE TO '/oradata1/%b';

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms