EBS DB : SIMPLE RMAN BACKUP BASED DUPLICATION (SAME & DIFFERENT DIRECTORY STRUCTURE)

PROD --> Source
TEST --> Target

SAME DIRECTORY STRUCTURE:
1. Copy the ORACLE_HOME and RMAN backup to the Target server

2. Configure EBS Oracle Home using perl adcfgclone.pl dbTechStack
3. Start the database in nomount state
    sqlplus / as sysdba
    startup nomount

4. Connect to RMAN in the target instance as auxiliary
    rman auxiliary /

5. Run the below RMAN command
    duplicate database to "<target_Sid>" BACKUP LOCATION '<rman_bkP_copied_path>' nofilenamecheck;
Example:
    duplicate database to "TEST" BACKUP LOCATION '/backup/RMANBKP' nofilenamecheck;


DIFFERENT DIRECTORY STRUCTURE:
1. Copy the ORACLE_HOME and RMAN backup to the Target server

2. Configure EBS Oracle Home using perl adcfgclone.pl dbTechStack
3. Start the database in nomount state
    sqlplus / as sysdba
    startup nomount

4. Connect to RMAN in the target instance as auxiliary
    rman auxiliary /

5. Run the below RMAN command, only change between the same and different Directory structure is to add the following lines in the RMAN command

run
{
SET DB_FILE_NAME_CONVERT=’/d01/oradata/proddata’,’/d01/oradata/clonedata′
SET LOG_FILE_NAME_CONVERT=’/d01/oradata/proddata’,’/d01/oradata/clonedata′
duplicate database to "TEST" BACKUP LOCATION '/backup/RMANBKP' nofilenamecheck;
}