Script to SET NEWNAME for DATAFILES in RMAN for Cloning

-- If doing on Source Server --
::12c-->sqlplus "/as sysdba"
set head off pages 0 feed off echo off verify off
set lines 200
spool rename_datafiles.lst
select 'set newname for datafile ' || file_id || ' to ''/u01/oradata/' ||
substr(file_name,instr(file_name,'/',-1)+1) || ''';'
from dba_data_files ;
spool off
exit;
-- If doing on Target Server --
[oracle@testorcl ~]$ sqlplus "/as sysdba"
set head off pages 0 feed off echo off verify off
set lines 200
spool rename_datafiles.lst
select 'set newname for datafile ' || file# || ' to ''/u01/oradata/' ||
substr(name,instr(name,'/',-1)+1) || ''';'
from v$datafile ;
spool off
exit;

 

Category: DatabaseRMANUncategorized

Tags:

Leave a Reply

Article by: Shadab Mohammad