In this article, we will duplicate the database(with new db_name) from tape backup, without connecting to source database.
We will only connect to the recovery catalog and auxiliary instance.

SOURCE DB – PRODDB
AUXILIARY DB – TESTDB
CATALOG DB – ORACAT

I.e we will duplicat the database with db_name TESTDB from rman tape backup of PRODDB.

1. Prepare pfile for the new database.

export ORACLE_SID=TESTDB

cd $ORACLE_HOME/dbs

cat initTESTDB.ora

Below two parameters are required, if the new database structure is different from the original database.

*.db_file_name_convert=’/PRODDB/datafile/OMDEV1/’,’/archive/TESTDB/’
*.log_file_name_convert=’/PRODDB/datafile/OMDEV1/’,’/archive/TESTDB/’

2. Connect to auxilary and catalog.

3. Startup clone nomount:

4. Now run the below-run block from RMAN.

Here we are doing point in time recovery, So we have mentioned timestamp also.

With this, our duplication has been completed. Our new database is ready for use.