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.
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.