How to Clone an Active Database using RMAN - - On same Host

Active Database duplication on SAME HOST

Here, We will have the Same file structure on another Host too

In this article I will show you how to do Duplicate using Active Database duplication.

My Current DATABASE : NIK6

Another one will be     : NIK6_DUP  (Cloned)

Please Follow Below  steps to Duplicate a Production database on another host with different directory structure using Active database Duplication :-

1. Check that primary database is up and running in Archivelog mode :-

SQL> select name,open_mode,LOG_MODE  from v$database;

NAME      OPEN_MODE            LOG_MODE

--------- -------------------- ------------

NIK6     READ WRITE           ARCHIVELOG

2. Add the tns details of target and auxiliary in both server(Target, Auxiliary)

NIK6 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.20.12)(PORT = 1523))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = NIK6.db.com)

    )

  )

NIK6_DUP =

(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.20.14)(PORT = 1523))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = NIK6.db.com)

    )

  )

3. Add the static entry of Auxiliary instance in listener.ora file

(SID_DESC =

      (GLOBAL_DBNAME = NIK6.db.com)

      (SID_NAME = TEST)

      (ORACLE_HOME = /opt/oracle/product/database/11.2.0.4)

     )

4. On Target host create pfile for Auxiliary Database :-

File Name : initNIK6_DUP.ora

*.audit_file_dest='/ora_backup/TEST/duplicate_test/NIK6/adump'

*.audit_trail='DB'

*.compatible='11.2.0.4.0'

*.control_files='/ora_backup/TEST/duplicate_test/NIK6/control01.ctl','/ora_backup/TEST/duplicate_test/NIK6/control02.ctl'

*.db_block_size=16384

*.db_file_name_convert='/ora_backup/TEST1/restore_test/NIK6/DATA','/ora_backup/TEST/duplicate_test/NIK6/DATA/'

*.log_file_name_convert='/ora_backup/TEST1/restore_test/NIK6/','/ora_backup/TEST/duplicate_test/NIK6/'

*.db_create_online_log_dest_1='/ora_backup/TEST/duplicate_test/NIK6/LOG/'

*.db_create_file_dest='/ora_backup/TEST/duplicate_test/NIK6/DATA/'

*.db_domain='mydb.domain'

*.db_name='NIK6'

*.db_recovery_file_dest='/ora_backup/TEST/duplicate_test/NIK6/FRA'

*.db_recovery_file_dest_size=65G

*.log_archive_dest_1='location=/ora_backup/TEST/duplicate_test/NIK6/FRA/'

*.diagnostic_dest='/ora_backup/TEST/duplicate_test/NIK6/diag'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=1061607680

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

Above parameters in Bold has to be modified according to the auxiliary server.

NOW IN ANOTHER TERMINAL : -

5. Start the auxiliay Instance in nomount mode :-

==>sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 2 01:14:47 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup force nomount pfile='/ora_backup/TEST/duplicate_test/initNIK6.ora'

ORACLE instance started.

Total System Global Area 1060585472 bytes

Fixed Size                  2260000 bytes

Variable Size             633340896 bytes

Database Buffers          402653184 bytes

Redo Buffers               22331392 bytes

6. Create spfile from pfile and start it again using spfile :-

SQL> create spfile from pfile='/ora_backup/TEST/duplicate_test/initNIK6.ora';

File created.

SQL> startup force nomount

ORACLE instance started.

Total System Global Area 1060585472 bytes

Fixed Size                  2260000 bytes

Variable Size             633340896 bytes

Database Buffers          402653184 bytes

Redo Buffers               22331392 bytes

7. Cross Check the below parameters in auxiliary instance :-

SQL> show parameter control_files

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_files                        string      /ora_backup/TEST/duplicate_test/NIK6/control01.ctl, /ora_ba

                                                 ckup/TEST/duplicate_test/NIK6/control02.ctl

SQL> show parameter db_file_name_convert

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert                 string      /ora_backup/TEST1/restore_test/NIK6/DATA,  /ora_backup/TEST/duplicate_test/NIK6/DATA/

SQL> show parameter log_file

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_file_name_convert                string      /ora_backup/TEST1/restore_test/NIK6/, /ora_backup/TEST/duplicate_test/NIK6/

We have to set above parameter when we do a duplicate database on another host with different file structure.

8. Start the RMAN duplicate command. If you are using a SPFILE for auxiliary instance then copy the SPFILE at the default location ($ORACLE_HOME/dbs) as while doing a duplicate RMAN will shut down the Auxiliary instance and start it again using SPFILE.

If you want to use a pfile then mention Pfile parameter in Duplicate command(optional) :-

SQL> ! rman target sys/Passw0rd@NIK6 auxiliary sys/Passw0rd@NIK6_DUP

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Dec 2 01:45:01 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: NIK6 (DBID=2971225332)

connected to auxiliary database: NIK6 (not mounted)

RMAN >  duplicate database to NIK6_DUP

from active database

              pfile=/ora_backup/TEST/duplicate_test/initNIK6.ora;

RMAN> duplicate database to NIK6 from active database;

Starting Duplicate Db at 2014-12-02 01:45:55

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=145 device type=DISK

allocated channel: ORA_AUX_DISK_2

channel ORA_AUX_DISK_2: SID=151 device type=DISK

allocated channel: ORA_AUX_DISK_3

channel ORA_AUX_DISK_3: SID=157 device type=DISK

allocated channel: ORA_AUX_DISK_4

channel ORA_AUX_DISK_4: SID=163 device type=DISK

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''NIK6'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''NIK6'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   backup as copy current controlfile auxiliary format  '/ora_backup/TEST/duplicate_test/NIK6/control01.ctl';

   restore clone controlfile to  '/ora_backup/TEST/duplicate_test/NIK6/control02.ctl' from

 '/ora_backup/TEST/duplicate_test/NIK6/control01.ctl';

   alter clone database mount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''NIK6'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''NIK6'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    1060585472 bytes

Fixed Size                     2260000 bytes

Variable Size                633340896 bytes

Database Buffers             402653184 bytes

Redo Buffers                  22331392 bytes

Starting backup at 2014-12-02 01:53:16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=199 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=217 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=223 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=229 device type=DISK

channel ORA_DISK_1: starting datafile copy

copying current control file

output file name=/opt/oracle/product/database/11.2.0.4/dbs/snapcf_NIK6.f tag=TAG20141202T015327 RECID=22 STAMP=865216412

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

Finished backup at 2014-12-02 01:53:35

Starting restore at 2014-12-02 01:53:35

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=139 device type=DISK

allocated channel: ORA_AUX_DISK_2

channel ORA_AUX_DISK_2: SID=151 device type=DISK

allocated channel: ORA_AUX_DISK_3

channel ORA_AUX_DISK_3: SID=157 device type=DISK

allocated channel: ORA_AUX_DISK_4

channel ORA_AUX_DISK_4: SID=163 device type=DISK

channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found

channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found

channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 2014-12-02 01:53:54

database mounted

contents of Memory Script:

{

   set newname for datafile  1 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//system01.dbf";

   set newname for datafile  2 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//sysaux01.dbf";

   set newname for datafile  3 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//undotbs1.dbf";

   set newname for datafile  4 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//undotbs2.dbf";

   set newname for datafile  5 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//users_1.dbf";

   set newname for datafile  6 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//ts_aud01.dbf";

   set newname for datafile  7 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_data01.dbf";

   set newname for datafile  8 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_idx01.dbf";

   set newname for datafile  9 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_arch01.dbf";

   backup as copy reuse

   datafile  1 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//system01.dbf"   datafile

 2 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//sysaux01.dbf"   datafile

 3 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//undotbs1.dbf"   datafile

 4 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//undotbs2.dbf"   datafile

 5 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//users_1.dbf"   datafile

 6 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//ts_aud01.dbf"   datafile

 7 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_data01.dbf"   datafile

 8 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_idx01.dbf"   datafile

 9 auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//DATA_arch01.dbf"   ;

   sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 2014-12-02 01:54:41

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

channel ORA_DISK_1: starting datafile copy

input datafile file number=00006 name=/ora_backup/TEST1/restore_test/NIK6/DATA/ts_aud01.dbf

channel ORA_DISK_2: starting datafile copy

input datafile file number=00007 name=/ora_backup/TEST1/restore_test/NIK6/DATA/DATA_data01.dbf

channel ORA_DISK_3: starting datafile copy

input datafile file number=00008 name=/ora_backup/TEST1/restore_test/NIK6/DATA/DATA_idx01.dbf

channel ORA_DISK_4: starting datafile copy

input datafile file number=00002 name=/ora_backup/TEST1/restore_test/NIK6/DATA/sysaux01.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/sysaux01.dbf tag=TAG20141202T015442

channel ORA_DISK_4: datafile copy complete, elapsed time: 00:02:05

channel ORA_DISK_4: starting datafile copy

input datafile file number=00001 name=/ora_backup/TEST1/restore_test/NIK6/DATA/system01.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_data01.dbf tag=TAG20141202T015442

channel ORA_DISK_2: datafile copy complete, elapsed time: 00:02:38

channel ORA_DISK_2: starting datafile copy

input datafile file number=00003 name=/ora_backup/TEST1/restore_test/NIK6/DATA/undotbs1.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_idx01.dbf tag=TAG20141202T015442

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:02:37

channel ORA_DISK_3: starting datafile copy

input datafile file number=00004 name=/ora_backup/TEST1/restore_test/NIK6/DATA/undotbs2.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs2.dbf tag=TAG20141202T015442

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:45

channel ORA_DISK_3: starting datafile copy

input datafile file number=00005 name=/ora_backup/TEST1/restore_test/NIK6/DATA/users_1.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/users_1.dbf tag=TAG20141202T015442

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:15

channel ORA_DISK_3: starting datafile copy

input datafile file number=00009 name=/ora_backup/TEST1/restore_test/NIK6/DATA/DATA_arch01.dbf

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs1.dbf tag=TAG20141202T015442

channel ORA_DISK_2: datafile copy complete, elapsed time: 00:01:07

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/system01.dbf tag=TAG20141202T015442

channel ORA_DISK_4: datafile copy complete, elapsed time: 00:01:36

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_arch01.dbf tag=TAG20141202T015442

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:07

output file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/ts_aud01.dbf tag=TAG20141202T015442

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:07:33

Finished backup at 2014-12-02 02:02:19

sql statement: alter system archive log current

contents of Memory Script:

{

   backup as copy reuse

   archivelog like  "/ora_backup/TEST1/restore_test/NIK6/FRA/1_5_864800713.dbf" auxiliary format

 "/ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf"   ;

   catalog clone archivelog  "/ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf";

   switch clone datafile all;

}

executing Memory Script

Starting backup at 2014-12-02 02:07:52

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=5 RECID=17241 STAMP=865216960

output file name=/ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:25

Finished backup at 2014-12-02 02:08:22

cataloged archived log

archived log file name=/ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf RECID=17241 STAMP=865217303

datafile 1 switched to datafile copy

input datafile copy RECID=22 STAMP=865217305 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=23 STAMP=865217306 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=24 STAMP=865217308 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs1.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=25 STAMP=865217309 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs2.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=26 STAMP=865217310 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/users_1.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=27 STAMP=865217312 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/ts_aud01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=28 STAMP=865217313 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_data01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=29 STAMP=865217314 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_idx01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=30 STAMP=865217316 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_arch01.dbf

contents of Memory Script:

{

   set until scn  4943275;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 2014-12-02 02:08:49

using channel ORA_AUX_DISK_1

using channel ORA_AUX_DISK_2

using channel ORA_AUX_DISK_3

using channel ORA_AUX_DISK_4

starting media recovery

archived log for thread 1 with sequence 5 is already on disk as file /ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf

archived log file name=/ora_backup/TEST/duplicate_test/NIK6/FRA/1_5_864800713.dbf thread=1 sequence=5

media recovery complete, elapsed time: 00:00:11

Finished recover at 2014-12-02 02:10:32

Oracle instance started

Total System Global Area    1060585472 bytes

Fixed Size                     2260000 bytes

Variable Size                633340896 bytes

Database Buffers             402653184 bytes

Redo Buffers                  22331392 bytes

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''NIK6'' comment=

 ''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

   shutdown clone immediate;

   startup clone nomount;

}

executing Memory Script

sql statement: alter system set  db_name =  ''NIK6'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area    1060585472 bytes

Fixed Size                     2260000 bytes

Variable Size                633340896 bytes

Database Buffers             402653184 bytes

Redo Buffers                  22331392 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "NIK6" RESETLOGS ARCHIVELOG

  MAXLOGFILES    192

  MAXLOGMEMBERS      3

  MAXDATAFILES     1024

  MAXINSTANCES    32

  MAXLOGHISTORY     4672

 LOGFILE

  GROUP   1 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_1.1335.859503481', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_1.283.859503479' ) SIZE 256 M  REUSE,

  GROUP   2 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_2.284.859503481', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_2.1429.859503481' ) SIZE 256 M  REUSE,

  GROUP  10 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_10.298.859929363', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_10.1258.859929365' ) SIZE 256 M  REUSE

 DATAFILE

  '/ora_backup/TEST/duplicate_test/NIK6/DATA/system01.dbf'

 CHARACTER SET AL32UTF8

sql statement: ALTER DATABASE ADD LOGFILE

  INSTANCE 'i2'

  GROUP   3 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_3.291.859504009', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_3.1303.859504009' ) SIZE 256 M  REUSE,

  GROUP   4 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_4.292.859504011', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_4.1246.859504011' ) SIZE 256 M  REUSE,

  GROUP  20 ( '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_20.858.859929393', '/ora_backup/TEST/duplicate_test/NIK6/DATA/group_20.299.859929393' ) SIZE 256 M  REUSE

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/ora_backup/TEST/duplicate_test/NIK6/DATA//NIK6/datafile/o1_mf_temp_b446vnwf_.tmp";

   switch clone tempfile all;

   catalog clone datafilecopy  "/ora_backup/TEST/duplicate_test/NIK6/DATA/sysaux01.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs1.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs2.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/users_1.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/ts_aud01.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_data01.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_idx01.dbf",

 "/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_arch01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /ora_backup/TEST/duplicate_test/NIK6/DATA//NIK6/datafile/o1_mf_temp_b446vnwf_.tmp in control file

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/sysaux01.dbf RECID=1 STAMP=865217830

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs1.dbf RECID=2 STAMP=865217830

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs2.dbf RECID=3 STAMP=865217831

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/users_1.dbf RECID=4 STAMP=865217831

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/ts_aud01.dbf RECID=5 STAMP=865217832

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_data01.dbf RECID=6 STAMP=865217832

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_idx01.dbf RECID=7 STAMP=865217833

cataloged datafile copy

datafile copy file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_arch01.dbf RECID=8 STAMP=865217833

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=865217830 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=865217830 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs1.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=865217831 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/undotbs2.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=865217831 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/users_1.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=5 STAMP=865217832 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/ts_aud01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=6 STAMP=865217832 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_data01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=7 STAMP=865217833 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_idx01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=8 STAMP=865217833 file name=/ora_backup/TEST/duplicate_test/NIK6/DATA/DATA_arch01.dbf

Reenabling controlfile options for auxiliary database

Executing: alter database force logging

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 2014-12-02 02:19:53

Database Duplicated using Active Database duplication on another host with different file structure .
 If we want to duplicate database on same host then we have to follow the same above process. One thing we have to keep in mind while duplicating on same host , DB name of Auxiliary instance has to be different  from target.