I really need to clarify a doubt and I think you are the right person to ask for.

I am working in a 3-node RAC env. and I needed to duplicate my DB(10g in RHEL Itanium) using RMAN.

My concept of duplicating a DB is transferring the backups of the source DB to the destination m/c where i have installed the oracle 10g and created a DB using DBCA. and recover and restore the same until the Last SCN or until this time.

Still I am confused so I am writing down what is confusing me by jotting down the steps that I plan to follow:

- Install Oracle 10g software in my destination server.- Create the necessary directories as in the source server.- Take a full backup(including control file,archivelogfiles and spfile..) of my source DB and transfer the same to my destination server.- Create a password file in my destination server.- then configure the tnsname and listener.ora files in destination servers- Take the Database in the nomount state.- Then follow your doc in the url:http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php for duplicating.

Please correct me if I am wrong. I am actually confused with the initora file that should i have to do :SQL>create pfile='path/initdup.ora' from spfile; in the source server like that in oracle Data Guard configuration.and transfer the same to the destination server.

$ rman AUXILIARY /$ rman TARGET sys/password@DB11G-SOURCE AUXILIARY /$ rman CATALOG rman/password@rman-catalog AUXILIARY /$ rman TARGET sys/password@DB11G-SOURCE CATALOG rman/password@rman-catalog AUXILIARY /We can then duplicate the database using one of the following commands. Remember, remove the SPFILE clause if you have manually created a full PFILE or SPFILE.

# Backup files are in matching location to that on the source server.# Duplicate database to TARGET's current state.DUPLICATE TARGET DATABASE TO DB11G SPFILE NOFILENAMECHECK;

Thanks for the document that you shared. I also find it similar till the duplication part. But I am a little confused about the step 7 which says the creation of a tempfile in temporary tbs. Is it necessary?

I have also seen some people adding more logfiles-- Is this necessary or shall I follow with the creation of tempfile itself.

From 8th step onwards shall I follow it blindly(of course the name and path is different).

Temporary tablespaces are full of junk, so RMAN doesn't back them up. When you do a recovery, the system metadata about the temp tablespace is present, but the file is not actually recovered, so you need to create one. That is what this step is doing.

You should never follow anything blindly. You need to convert your single instance database into a RAC database. Those are the steps you need to follow. The poster is creating a 4 node RAC, so many of the commands are run 4 times (1 per node). Your situation will be different for obvious reasons.