Oracle Home Cloning

Todays Agenda :

1. What is Home Cloning?
2. How it is different from New Installation?
3. Why it is required?
4. How it can be done?
5. Practical

What is Home Cloning?

Home Cloning is nothing but just installing/cloning already running home on production.

For example I have oracle 11g database running on my production now if I want to use the same home for new database setup on seperate server then instead of setting up new home I will clone this home from my production database to the destination.

How it is different from New Installation?

Now here the question arises which is quite valid as well that why not to install new home on the new server instead of cloning the old one so the answer is that in real environment patches are regularly applied to database so when there is requirement of cloning production on test environment we are bound to clone the same home and can't use new installation because on new home we will have to manually apply all the patches etc applied on the prod so this is the actual sceanario where we are left with the only option of home cloning.

Why it is required?

It is required in testing environment where we are simulating production environment.

How it can be done?

It is quite similar to new installation the steps are as follow.

1. Apply oracle pre-requisites on the new server.
2. Make .zip.tar file of the home on the production (Oracle recommends to shutdown all the services while making .zip.tar file of the home)
3. copy the .zip.tar file to the new server.
4. Create proper directory structure for oracle home on the new server like /u01/app/oracle/product/11.2.0.1/dbhome_1 don't create dbhome_1 as it will automatically created when the file is unzipped and untared so make directory structure as /u01/app/oracle/product/11.2.0.1.
5. Unzip and untar the file.
6. Run the command

cd /u01/app/oracle/product/11.2.0.1        

gunzip dbhome_1.tar.gz     ##This command will unzip and give (dbhome_1.tar)file.        

tar -xvf dbhome_1.tar         ##This will untar the file and will give (dbhome_1)        

cd /u01/app/oracle/product/11.2.0.1/dbhome_1/clone/bin          

/.clone.pl -silent ORACLE_HOME=/u01/app/oracle/product/11.2.0.1/dbhome_1 ORACLE_BASE=/u01/app/oracle        ##Keep in mind to provide correct oracle home and base location else cloning will fail.        

When the cloning starts it will give logfile just tail that and properly observer and at the end of cloning run the provided scripts from root user which are must and can't be skipped.

Thanks & Regards,

Dost Muhammad Khalil (OCP)

For support reach us through : +92 311 4848475

Email : [email protected]

#oracle #databases #it