RMAN Active Duplicate Database from RAC ASM to RAC ASM

Some Tips:

1) Always make sure to have relative soft link to tnsnames.ora & listener.ora in $ORACLE_HOME/network/admin if they are in non-default location (like in Oracle EBS: tnsnames.ora & listener.ora exist in $ORACLE_HOME/network/admin/SID_hostname Directory)

2) Make Appropriate TNS Entry in all RAC (Target / Auxiliary) Nodes, with local listener host and port, so that instance name wise service get registered for active duplicate. (Dynamic registration with SCAN doesn't work)

PREPROD=

        (DESCRIPTION=

                (ADDRESS=(PROTOCOL=tcp)(HOST=inblrdrdbadm01.tajhotels.com)(PORT=1555))

            (CONNECT_DATA=

                (SERVICE_NAME=PREPROD1)

                (INSTANCE_NAME=PREPROD1)

                 (UR = A)

            )

        )

3) Mention DB_FILE_NAME_CONVERT & LOG_FILE_NAME_CONVERT properly, if there are any datafiles / online redo log files with OMF/Non-OMF and within same Disk Group.

SQL> show parameter convert

NAME                                 TYPE        VALUE

------------------------------------ ----------- -----------------------------------------------------------------------------

db_file_name_convert                 string      +DATA_DR/EBSPRD, +DATA_DR/PREPROD,

log_file_name_convert                string      +DATA_DR/EBSPRD, +RECO_DR/PREPROD, +RECO_DR/EBSPRD, +RECO_DR/PREPROD

References:

STEP BY STEP RMAN DUPLICATE Database From RAC ASM To RAC ASM (Doc ID 1913937.1)

RMAN DUPLICATE / RESTORE including Standby in ASM with OMF / non-OMF / Mixed Name for Datafile / Online Log / Controlfile (Doc ID 1910175.1)