Cloning oracle database from one server to another existing database in linux

This is the fast and easiest method to clone the oracle database from one server to another existing database server in Linux environment.


1. Take controlfile trace from the source database(TEST).

alter database backup controlfile to trace as '/sw/oracle/oradata/control_new.txt';

2.shutdown the source database.

3. Tar the data files and redolog files from source database'/sw/oracle/oradata/').

tar cvzf /backup/test_backup.tar.gz test


4. move the tar file and control file trace into target machine using the following command.

[oracle@server01 backup]$ scp test_backup.tar.gz root@server02:/backuptmp


5. shut down the target db and remove data,control,redo files.

/u01/app/oracle/oradata/orcl


6.extract the tar file using below command

 tar -zvxf test_backup.tar.gz -C /u01/app/oracle/oradata/orcl/

7.In the trace controlfile(control_new.txt) we have to modify data file and redolog file locations as like target database .

CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u01/app/oracle/oradata/orcl/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/u01/app/oracle/oradata/orcl/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/u01/app/oracle/oradata/orcl/redo03.log'  SIZE 50M BLOCKSIZE 512
DATAFILE
  '/u01/app/oracle/oradata/orcl/system01.dbf',
  '/u01/app/oracle/oradata/orcl/sysaux01.dbf',
  '/u01/app/oracle/oradata/orcl/undotbs01.dbf',
  '/u01/app/oracle/oradata/orcl/users01.dbf'
CHARACTER SET WE8MSWIN1252;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
     SIZE 20971520  REUSE AUTOEXTEND ON NEXT 262144000  MAXSIZE 32767M;

 save this file as create_controlfile.sql.


8. start the target db as below

SQL>startup nomount

9. execute the create_controlfile.sql script

SQL> @/u01/app/oracle/oradata/create_controlfile.sql.

Control file created.

Database altered.


Database cloning is completed.