Sunday, 4 November 2012

Database Cloning

Database Cloning can be done in two ways: 1. With Rman. 2. Without Rman.

Database Cloning through Rman is easy and efficient way for performing Cloning.

Steps for Database Cloning using Rman:

Note: Before performing the operation make sure u have know the following:

          Target Database Name, Duplicate Database Name(which u want to set), catalog database name,
          tnsnames for Target Database and the catalog.

Step 1. Set the Environment Variable for Duplicate Database.

            $export ORACLE_SID=DUPDB.

Step 2. Create an init.ora file for duplicate database.

Step 3. Bring the duplicate database to nomount state using the above created init.ora file.

            $ echo $ORACLE_SID

            $ sqlplus '/as sysdba'
   
            sql> startup nomount

Step 4. Connect to Rman.

            $ rman target=system/password@targetdb catalog=rman/password@catalog auxiliary /

step 5. Run the command.

           rman> run{
                      allocate auxiliary channel aux1 device type disk;
                      duplicate target database to DUPDP;
                      }

This will create a Duplicate Database for your Target Database using RMAN.