DUPLICATE Oracle database and set new SID from RMAN Full backup

@target

- full backup rman (controlfile,datafile,archivelog)

- create pfile='initNEW_SID.ora' from spfile;
- change current_instance_name to new_instance_name in pfile
- add *.LOG_FILE_NAME_CONVERT and *.DB_FILE_NAME_CONVERT to last line in pfile

exp:
*.LOG_FILE_NAME_CONVERT='/u01/old_log_file_path','/u02/new_log_file_path'
*.DB_FILE_NAME_CONVERT='/u01/old_data_file_path','/u02/new_data_file_path'


**** for Multiple path Oracle datafile
*.LOG_FILE_NAME_CONVERT='/data1/oradata/ORCLG','/data1/oradata/DUPDB',
                    '/data2/oradata/ORCL','/data2/oradata/DUPDB',
                    '/data3/oradata/ORCL','/data3/oradata/DUPDB'



*.DB_FILE_NAME_CONVERT='/data1/oradata/ORCL','/data1/oradata/DUPDB',
                    '/data2/oradata/ORCL','/data2/oradata/DUPDB',
                    '/data3/oradata/ORCL','/data3/oradata/DUPDB',
                    '/data4/oradata/ORCL','/data4/oradata/DUPDB',
                    '/data5/oradata/ORCL','/data5/oradata/DUPDB',
                    '/data6/oradata/ORCL','/data6/oradata/DUPDB'

- create folder datafile and logfile for new_instance_name

@auxiliary

- startup pfile='initNEW_SID.ora' nomount;
- connect to RMAN by command 'rman auxiliary /'



duplicate database to "newSID" backup location '/backup_rman/oldSID';


trick-2:
create auxiliary by dbca and set new datafile + log file path for newSID

- connect rman as auxiliary  using command

duplicate database to "newSID" nofilenamecheck  backup location '/backup_rman/oldSID';