Creating a clone database in oracle 11g called as active database cloning

normally in Oracle9i/10g cloning is done using duplicate cloning command, we do the RMAN cloning.and

We need a RMAN full backup for cloning the database in oracle9i/10g.

In oracle 11g provides a new feature, without RMAN database backup we can clone the database.

follow these simple steps to perform cloning database in oracle 11g,screenshota are also provided for a better result

Step 1)_Configure the network files like tnsnames.ora and listener.ora,as the configuration for the clone server/database is totally dependent on the network files this step is very important

Step 2)_Make entries for source and target/clone database into the listener file(preferably through net manager) and restart the listener afterwards

Step 3)_Make entry for the target/clone database in the tnsnames.ora file

Step 4)_Place the UR=A parameter in the tnsnames file to avoid connection blocking error generated from listener

Step 5)_Create a new instance on the clone server for the new target/clone database

Step 6)_Create a password file with a password for the target database format for the same would be PWDinstancename.ora

Step 7)_Connect with the source database and create a pfile from spfile

Step 8)_Make the following changes in the newly created pfile(left one is of source db and right one is created for clone db)

Step 9)_Create appropriate folder in the same location as in the source database for adump

Step 10)_Create appropriate folder in the same location as in the source database for clonedb files in oradata folder

Step 11)_Set oracle sid for clone db and connect and start in nomount mode with newly created pfile

Step 12)_Now create the spfile from the newly created pfile and then shutdown and start the db in nomount mode again

Step 13)_Connect with the rman of source database with user sys and the password for sys user(not like rman target /,because this will create problems)

Step 14)_Connect with the auxiliarry clone database with the password for the sys user given in the password file

Step 15)_Perform the cloning of the database using the following command

RMAN> duplicate target database to clonedb from active database nofilenamecheck;

Step 16)_After the successful execution of the cloning process connect with the clone db and check for the working status as well as total objects

CONGRATULATIONS!!!!

You have successfully created a clone database using active database cloning method in oracle 11g