KEMBAR78
Oracle Database Cloning Guide | PDF
Scribd
Upload
132 views3 pages

Oracle Database Cloning Guide

This document discusses cloning an Oracle database from one server to another using a cold backup. It involves installing the Oracle software on the target server, creating the necessary directory structure to match the source server, shutting down the source database to take a cold backup, copying all database files from the source to the target server, and starting up the database on the target server. By maintaining the same directory structure, the control file does not need to be recreated when cloning the database to the new server using this method.

Uploaded by

Mohammad Mizanur Rahman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
132 views3 pages

Oracle Database Cloning Guide

This document discusses cloning an Oracle database from one server to another using a cold backup. It involves installing the Oracle software on the target server, creating the necessary directory structure to match the source server, shutting down the source database to take a cold backup, copying all database files from the source to the target server, and starting up the database on the target server. By maintaining the same directory structure, the control file does not need to be recreated when cloning the database to the new server using this method.

Uploaded by

Mohammad Mizanur Rahman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

DATABASE CLONING USING COLD BACKUP | LINUX

CLONING ORACLE DATABASE FROM SERVER TO SERVER

SAME DIRECTORY STRUCTURE :

SOURCE DATABASE : orcl on SERVR01

TARGET DATABASE : orcl on SERVER02

SOURCE IP : 192.168.1.200 SERVER01

TARGET IP : 192.168.1.168 SERVER02

Install Oracle software on target server (choose “Install only”


option in OUI ). No need to create any database.

CREATE DIRECTORIES FOR ADMIN LOG FILES

$ cd /u01/app/oracle/admin

$ mkdir orcl

$ cd orcl

$ mkdir adump bdump cdump pfile udump dpdump

$ cd

CREATE DIRECTORIES FOR PHYSICAL FILES

$ cd /u01/app/oracle/oradata/

$ mkdir orcl

$ cd

As i said , if we have same locations in clone server as source, then we


do NOT need to create control file again just copy all files then
directly we can start the database.

Exploring the Oracle DBA Technology by Gunasekaran ,Thiyagu


DATABASE CLONING USING COLD BACKUP | LINUX

DIRECTORIES FOR orcl DATABASE - SERVER02

SHUT SOURCE DATABASE TO TAKE COLD BACKUP

TAKE BACKUP OF SOURCE DATABASE - SERVER01

Exploring the Oracle DBA Technology by Gunasekaran ,Thiyagu


DATABASE CLONING USING COLD BACKUP | LINUX

I RECEIVED ALL DATABASE FILES - IN SERVER02

Connect as sysdba and Startup the database

In this article , we did NOT recreate control file . If the directory


structure is same , we can copy all required files and startup the
database. If we wish to change DBID or DBNAME , we can.

Exploring the Oracle DBA Technology by Gunasekaran ,Thiyagu

You might also like