CLONING THE TARGET DATABASE USING RMAN

How RMAN Duplication works..??

EXAMPLE OF CLONING USING RMAN..!!

EXAMPLE OF CLONING FROM A PREVIOUS BACKUP..!!

                   CLONING THE TARGET DATABASE USING RMAN

HOW RMAN DUPLICATION WORKS?

The duplication process of the RMAN can be broken into its distinct pieces:

●    RMAN determines the nature and location of the backups.

●    RMAN allocates an auxiliary channel at the auxiliary instance.

●    RMAN restores the datafiles to the auxiliary instance.

●    RMAN builds a new auxiliary control file.

●    RMAN restores archive logs from backup and performs any necessary recovery.

●    RMAN resets the DBID for the auxiliary instance and opens the database with open resetlogs.

Before starting with the cloning steps add the following entries in the .bash_profile of the user

vi .bash_profile

add the following entries

export ORACLE_SID=robin

export ORACLE_BASE=/vol1/robin

export ORACLE_HOME=$ORACLE_BASE/10.2.0

export PATH=$ORACLE_HOME/bin:$PATH

save and exit and then source the environment

before proceeding further please check whether you have a valid online backup along with the archive logs if not then execute the following on the target database before proceeding with the RMAN duplication.

[diana@rac2 dbs]$ rman target=rman_admin/rman_admin catalog=rman/rman@rman

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jan 21 21:40:26 2010

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

connected to target database: DIANA (DBID=925397895)

connected to recovery catalog database

RMAN> backup database plus archivelog;

Starting backup at 21-JAN-10

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=17 recid=29 stamp=708179244

input archive log thread=1 sequence=18 recid=30 stamp=708903962

channel ORA_DISK_1: starting piece 1 at 21-JAN-10

channel ORA_DISK_1: finished piece 1 at 21-JAN-10

piece handle=/vol1/diana/backup/diana/diana_1rl4210r_1_1.bak tag=TAG20100121T214603 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

Finished backup at 21-JAN-10

Starting backup at 21-JAN-10

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/vol1/diana/oradata/diana/system01.dbf

input datafile fno=00003 name=/vol1/diana/oradata/diana/sysaux01.dbf

input datafile fno=00005 name=/vol1/diana/oradata/diana/admin01.dbf

input datafile fno=00002 name=/vol1/diana/oradata/diana/undotbs01.dbf

input datafile fno=00004 name=/vol1/diana/oradata/diana/users01.dbf

channel ORA_DISK_1: starting piece 1 at 21-JAN-10

channel ORA_DISK_1: finished piece 1 at 21-JAN-10

piece handle=/vol1/diana/backup/diana/diana_1sl4210v_1_1.bak tag=TAG20100121T214607 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 21-JAN-10

channel ORA_DISK_1: finished piece 1 at 21-JAN-10

piece handle=/vol1/diana/backup/diana/diana_1tl4211p_1_1.bak tag=TAG20100121T214607 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 21-JAN-10

Starting backup at 21-JAN-10

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=19 recid=31 stamp=708903995

channel ORA_DISK_1: starting piece 1 at 21-JAN-10

channel ORA_DISK_1: finished piece 1 at 21-JAN-10

piece handle=/vol1/diana/backup/diana/diana_1ul4211s_1_1.bak tag=TAG20100121T214636 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 21-JAN-10

Archive the current online redo log file too and then archive all the archive logs for once.

RMAN> sql 'alter system archive log current';

sql statement: alter system archive log current

RMAN> backup archivelog all;

Starting backup at 21-JAN-10

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=17 recid=29 stamp=708179244

input archive log thread=1 sequence=18 recid=30 stamp=708903962

input archive log thread=1 sequence=19 recid=31 stamp=708903995

input archive log thread=1 sequence=20 recid=32 stamp=708904018

input archive log thread=1 sequence=21 recid=33 stamp=708904031

channel ORA_DISK_1: starting piece 1 at 21-JAN-10

channel ORA_DISK_1: finished piece 1 at 21-JAN-10

piece handle=/vol1/diana/backup/diana/diana_1vl42130_1_1.bak tag=TAG20100121T214712 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 21-JAN-10

STEPS to clone a database using RMAN

STEP:1 Create the respective directory structure on the auxiliary instance once the Oracle binaries are installed. Assuming that all the oracle binaries are installed in the                                       /vol1/robin/10.2.0

cd /vol1/robin

[robin@rac2 ~]$ mkdir -p oradata/robin

[robin@rac2 ~]$ mkdir -p oradata/arch

[robin@rac2 ~]$ mkdir -p admin/robin/adump

[robin@rac2 ~]$ mkdir -p admin/robin/bdump

[robin@rac2 ~]$ mkdir -p admin/robin/cdump

[robin@rac2 ~]$ mkdir -p admin/robin/udump

[robin@rac2 ~]$ mkdir -p admin/robin/pfile

[robin@rac2 ~]$ mkdir -p admin/robin/dpdump

final directory structure looks like as follows:

[robin@rac2 ~]$ cd /vol1/robin

[robin@rac2 ~]$ ls -lrt

total 12

drwxr-x---  54 robin dba 4096 Jan 21 19:59 10.2.0  <-- oracle binaries

drwxr-xr-x   4 robin dba 4096 Jan 21 20:38 oradata <-- oracle data

drwxr-xr-x   3 robin dba 4096 Jan 21 20:41 admin   <-- alert log files etc...

STEP:2 Copy the init.ora of the target to the auxiliary instance and make changes to the file as needed.

remove all references of the target in the init.ora and change then to the auxiliary

ex:

Open the init.ora in vi editor

vi init.ora

and then enter the command in normal mode (not in insert mode)

:%s?diana?robin?g

once done add the following for the filename conversion from the target to the auxiliary database during the cloning

*.db_file_name_convert=('/vol1/diana/oradata/diana','/vol1/robin/oradata/robin')

*.log_file_name_convert=('/vol1/diana/oradata/diana','/vol1/robin/oradata/robin')

STEP:3 Create the password file for the auxiliary instance

[robin@rac2 dbs]$ orapwd file=orapwrobin password=sysadmin entries=5

[robin@rac2 dbs]$ ls -lrt

total 40

-rw-r-----  1 robin dba  8385 Sep 11  1998 init.ora

-rw-r-----  1 robin dba 12920 May  3  2001 initdw.ora

-rw-r--r--  1 robin dba   997 Jan 21 21:04 initdiana.ora

-rw-r--r--  1 robin dba   989 Jan 21 21:06 initrobin.ora

-rw-r-----  1 robin dba  2048 Jan 21 21:07 orapwrobin

STEP:4  Now start the auxiliary instance in nomount state as we do not have the control files we can mount the auxiliary instance at time point.

[robin@rac2 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 21 21:29:23 2010

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

Connected to an idle instance.

SQL> startup nomount pfile='/vol1/robin/10.2.0/dbs/initrobin.ora';

ORACLE instance started.

Total System Global Area  209715200 bytes

Fixed Size                  1218532 bytes

Variable Size              71305244 bytes

Database Buffers          130023424 bytes

Redo Buffers                7168000 bytes

SQL> exit

STEP:5 Configure the listener for the auxiliary instance

now execute netca and configure the listener

once done make the respective changes into the tnsnames.ora and listener.ora

Also add the tns entries of rman and the target instance to auxiliary instance tnsnames.ora.

STEP:6 Now execute the duplicate command to start with the cloning of the RMAN.

connect to the RMAN as follows:

[robin@rac2 dbs]$ rman catalog rman/rman@rman target rman_admin/rman_admin@diana auxiliary sys/sysadmin

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jan 21 21:30:48 2010

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

connected to target database: DIANA (DBID=925397895)

connected to recovery catalog database

connected to auxiliary database: ROBIN (not mounted)

RMAN> duplicate target database to robin

2> pfile=/vol1/robin/10.2.0/dbs/initrobin.ora;

Starting Duplicate Db at 21-JAN-10

using channel ORA_AUX_DISK_1 <-- an auxiliary channel is allocated in here

contents of Memory Script:

{

   set until scn  587547;       <-- SCN to which the incomplete recovery needs to be perfomed -->

   set newname for datafile  1 to   <-- setting new names to the datafiles on auxiliary end -->

 "/vol1/robin/oradata/robin/system01.dbf";

   set newname for datafile  2 to

 "/vol1/robin/oradata/robin/undotbs01.dbf";

   set newname for datafile  3 to

 "/vol1/robin/oradata/robin/sysaux01.dbf";

   set newname for datafile  4 to

 "/vol1/robin/oradata/robin/users01.dbf";

   set newname for datafile  5 to

 "/vol1/robin/oradata/robin/admin01.dbf";

   restore <-- actual datafiles are restored from the backup of the target database -->

   check readonly

   clone database

   ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-JAN-10

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /vol1/robin/oradata/robin/system01.dbf

restoring datafile 00002 to /vol1/robin/oradata/robin/undotbs01.dbf

restoring datafile 00003 to /vol1/robin/oradata/robin/sysaux01.dbf

restoring datafile 00004 to /vol1/robin/oradata/robin/users01.dbf

restoring datafile 00005 to /vol1/robin/oradata/robin/admin01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /vol1/diana/backup/diana/diana_1sl4210v_1_1.bakchannel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/vol1/diana/backup/diana/diana_1sl4210v_1_1.bak tag=TAG20100121T214607

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36

Finished restore at 21-JAN-10

<-- Now the actual part of the control file creation starts here -->

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

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1 ( '/vol1/robin/oradata/robin/redo01.log' ) SIZE 50 M  REUSE,

  GROUP  2 ( '/vol1/robin/oradata/robin/redo02.log' ) SIZE 50 M  REUSE,

  GROUP  3 ( '/vol1/robin/oradata/robin/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/vol1/robin/oradata/robin/system01.dbf'

 CHARACTER SET WE8ISO8859P1

contents of Memory Script:

{

   switch clone datafile all;<-- this statement is equivalent to alter database rename datafile                                                     statement -- >

}

executing Memory Script

released channel: ORA_AUX_DISK_1

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=708904091 filename=/vol1/robin/oradata/robin/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=708904091 filename=/vol1/robin/oradata/robin/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=708904091 filename=/vol1/robin/oradata/robin/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=708904091 filename=/vol1/robin/oradata/robin/admin01.dbf

contents of Memory Script:

{

   set until scn  587547;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause  <-- datafiles are recovered to the SCN value 587547 -->

Starting recover at 21-JAN-10

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: sid=159 devtype=DISK

starting media recovery

archive log thread 1 sequence 19 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_19_703254218_1.arc

archive log thread 1 sequence 20 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_20_703254218_1.arc

archive log thread 1 sequence 21 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_21_703254218_1.arc

archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_19_703254218_1.arc thread=1 sequence=19

archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_20_703254218_1.arc thread=1 sequence=20

archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_21_703254218_1.arc thread=1 sequence=21

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

Finished recover at 21-JAN-10

contents of Memory Script:

{

   shutdown clone;

   startup clone nomount pfile= '/vol1/robin/10.2.0/dbs/initrobin.ora';

}

executing Memory Script

database dismounted

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     209715200 bytes

Fixed Size                     1218532 bytes

Variable Size                 71305244 bytes

Database Buffers             130023424 bytes

Redo Buffers                   7168000 bytes

<-- before this statement is executed somehow oracle resets the DBID (may be it is run silently) so that when the control file script is run again it figures that the DBID is zero generates a new DBID for the cloned database-->

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

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1 ( '/vol1/robin/oradata/robin/redo01.log' ) SIZE 50 M  REUSE,

  GROUP  2 ( '/vol1/robin/oradata/robin/redo02.log' ) SIZE 50 M  REUSE,

  GROUP  3 ( '/vol1/robin/oradata/robin/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/vol1/robin/oradata/robin/system01.dbf'

 CHARACTER SET WE8ISO8859P1

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/vol1/robin/oradata/robin/temp01.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/vol1/robin/oradata/robin/undotbs01.dbf";

   catalog clone datafilecopy  "/vol1/robin/oradata/robin/sysaux01.dbf";

   catalog clone datafilecopy  "/vol1/robin/oradata/robin/users01.dbf";

   catalog clone datafilecopy  "/vol1/robin/oradata/robin/admin01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /vol1/robin/oradata/robin/temp01.dbf in control file

cataloged datafile copy

datafile copy filename=/vol1/robin/oradata/robin/undotbs01.dbf recid=1 stamp=708904106

cataloged datafile copy

datafile copy filename=/vol1/robin/oradata/robin/sysaux01.dbf recid=2 stamp=708904106

cataloged datafile copy

datafile copy filename=/vol1/robin/oradata/robin/users01.dbf recid=3 stamp=708904106

cataloged datafile copy

datafile copy filename=/vol1/robin/oradata/robin/admin01.dbf recid=4 stamp=708904106

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=708904106 filename=/vol1/robin/oradata/robin/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=708904106 filename=/vol1/robin/oradata/robin/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=708904106 filename=/vol1/robin/oradata/robin/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=708904106 filename=/vol1/robin/oradata/robin/admin01.dbf

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 21-JAN-10

RMAN>

EXAMPLE OF CLONING FROMA PREVIOUS BACKUP

RMAN> run

2> {

3> set until time "to_date('27-01-2010 16:42:48','dd-mm-yyyy hh24:mi:ss')";

4> duplicate target database to patty;

5> }

executing command: SET until clause

Starting Duplicate Db at 27-JAN-10

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:

{

   set until scn  641245;

   set newname for datafile  1 to

 "/vol1/patty/oradata/patty/system01.dbf";

   set newname for datafile  2 to

 "/vol1/patty/oradata/patty/undotbs01.dbf";

   set newname for datafile  3 to

 "/vol1/patty/oradata/patty/sysaux01.dbf";

   set newname for datafile  4 to

 "/vol1/patty/oradata/patty/users01.dbf";

   set newname for datafile  5 to

 "/vol1/patty/oradata/patty/admin01.dbf";

   restore

   check readonly

   clone database

   ;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 27-JAN-10

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /vol1/patty/oradata/patty/system01.dbf

restoring datafile 00002 to /vol1/patty/oradata/patty/undotbs01.dbf

restoring datafile 00003 to /vol1/patty/oradata/patty/sysaux01.dbf

restoring datafile 00004 to /vol1/patty/oradata/patty/users01.dbf

restoring datafile 00005 to /vol1/patty/oradata/patty/admin01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /vol2/backup/diana/diana_2ml4h9g8_1_1.bak

channel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/vol2/backup/diana/diana_2ml4h9g8_1_1.bak tag=TAG20100127T164247

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36

Finished restore at 27-JAN-10

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

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1 ( '/vol1/patty/oradata/patty/redo01.log' ) SIZE 50 M  REUSE,

  GROUP  2 ( '/vol1/patty/oradata/patty/redo02.log' ) SIZE 50 M  REUSE,

  GROUP  3 ( '/vol1/patty/oradata/patty/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/vol1/patty/oradata/patty/system01.dbf'

 CHARACTER SET WE8ISO8859P1

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

released channel: ORA_AUX_DISK_1

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=709405660 filename=/vol1/patty/oradata/patty/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=709405660 filename=/vol1/patty/oradata/patty/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=709405660 filename=/vol1/patty/oradata/patty/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=709405660 filename=/vol1/patty/oradata/patty/admin01.dbf

contents of Memory Script:

{

   set until time  "to_date('27-01-2010 16:42:48','dd-mm-yyyy hh24:mi:ss')";

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

executing command: SET until clause

Starting recover at 27-JAN-10

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: sid=159 devtype=DISK

starting media recovery

archive log thread 1 sequence 34 is already on disk as file /vol1/diana/10.2.0/dbs/arch/diana_34_703254218_1.arc

archive log filename=/vol1/diana/10.2.0/dbs/arch/diana_34_703254218_1.arc thread=1 sequence=34

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

Finished recover at 27-JAN-10

contents of Memory Script:

{

   shutdown clone;

   startup clone nomount ;

}

executing Memory Script

database dismounted

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     209715200 bytes

Fixed Size                     1218532 bytes

Variable Size                 71305244 bytes

Database Buffers             130023424 bytes

Redo Buffers                   7168000 bytes

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

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP  1 ( '/vol1/patty/oradata/patty/redo01.log' ) SIZE 50 M  REUSE,

  GROUP  2 ( '/vol1/patty/oradata/patty/redo02.log' ) SIZE 50 M  REUSE,

  GROUP  3 ( '/vol1/patty/oradata/patty/redo03.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/vol1/patty/oradata/patty/system01.dbf'

 CHARACTER SET WE8ISO8859P1

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/vol1/patty/oradata/patty/temp01.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/vol1/patty/oradata/patty/undotbs01.dbf";

   catalog clone datafilecopy  "/vol1/patty/oradata/patty/sysaux01.dbf";

   catalog clone datafilecopy  "/vol1/patty/oradata/patty/users01.dbf";

   catalog clone datafilecopy  "/vol1/patty/oradata/patty/admin01.dbf";

   switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /vol1/patty/oradata/patty/temp01.dbf in control file

cataloged datafile copy

datafile copy filename=/vol1/patty/oradata/patty/undotbs01.dbf recid=1 stamp=709405672

cataloged datafile copy

datafile copy filename=/vol1/patty/oradata/patty/sysaux01.dbf recid=2 stamp=709405672

cataloged datafile copy

datafile copy filename=/vol1/patty/oradata/patty/users01.dbf recid=3 stamp=709405672

cataloged datafile copy

datafile copy filename=/vol1/patty/oradata/patty/admin01.dbf recid=4 stamp=709405672

datafile 2 switched to datafile copy

input datafile copy recid=1 stamp=709405672 filename=/vol1/patty/oradata/patty/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=2 stamp=709405672 filename=/vol1/patty/oradata/patty/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=3 stamp=709405672 filename=/vol1/patty/oradata/patty/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=4 stamp=709405672 filename=/vol1/patty/oradata/patty/admin01.dbf

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 27-JAN-10