My Oracle Support Banner

RMAN: SET NEWNAME Command Using SQL (Doc ID 549972.1)

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.