Scribd
Upload
11 views13 pages

Actvive Duplication

The document details the steps taken to start and configure Oracle database listeners on two servers, including the creation and modification of listener configuration files and the use of RMAN to duplicate a target database. It includes commands executed in the Linux shell for managing Oracle services, as well as the setup of necessary directories and parameter files. The process concludes with the successful initiation of the database instance and the RMAN duplication command for the auxiliary database.

Uploaded by

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

Actvive Duplication

The document details the steps taken to start and configure Oracle database listeners on two servers, including the creation and modification of listener configuration files and the use of RMAN to duplicate a target database. It includes commands executed in the Linux shell for managing Oracle services, as well as the setup of necessary directories and parameter files. The process concludes with the successful initiation of the database instance and the RMAN duplication command for the auxiliary database.

Uploaded by

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

Need to start source listener:-

=================================

[oracle@server1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2022 21:00:28

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 23-JAN-2022 20:52:47
Uptime 0 days 0 hr. 7 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File
/u01/app/oracle/diag/tnslsnr/server1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.mydomain.com)(PORT=1521)))
Services Summary...
Service "proddb" has 1 instance(s).
Instance "proddb", status READY, has 1 handler(s) for this service...
Service "proddbXDB" has 1 instance(s).
Instance "proddb", status READY, has 1 handler(s) for this service...
The command completed successfully

Target:-
=========
[oracle@server2 rmanbkp]$ vi /etc/oratab
[oracle@server2 rmanbkp]$ . oraenv
ORACLE_SID = [dev] ? uat
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@server2 rmanbkp]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
[oracle@server2 admin]$ vi listener.ora
[oracle@server2 admin]$ ls -lrt
total 8
-rw-r--r-- 1 oracle oinstall 381 Dec 17 2012 shrept.lst
drwxr-xr-x 2 oracle oinstall 4096 Nov 2 20:55 samples
-rw-r--r-- 1 oracle oinstall 0 Jan 23 20:55 listener.ora
[oracle@server2 admin]$ vi listener.ora
[oracle@server2 admin]$ cat listener.ora
LISTENER_uat =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102 )(PORT = 1522))
)
)
SID_LIST_LISTENER_uat =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = uat)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = uat )
))
[oracle@server2 admin]$ lsnrctl start LISTENER_uat

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2022 20:59:04

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production


System parameter file is
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/server2/listener_uat/alert/log.xml
TNS-01151: Missing listener name, LISTENER_uat, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

[oracle@server2 admin]$ vi listener.ora


[oracle@server2 admin]$ lsnrctl start LISTENER_uat

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2022 20:59:56

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production


System parameter file is
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/server2/listener_uat/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_uat
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 23-JAN-2022 20:59:56
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/server2/listener_uat/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1522)))
Services Summary...
Service "uat" has 1 instance(s).
Instance "uat", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@server2 admin]$
[oracle@server2 admin]$
[oracle@server2 admin]$ vi tnsnames.ora
[oracle@server2 admin]$ tnsping proddb
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2022 21:04:06

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias


Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.101)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
proddb)))
OK (0 msec)
[oracle@server2 admin]$ tnsping uat

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2022 21:04:11

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias


Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.102)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
uat)))
OK (0 msec)
[oracle@server2 admin]$ cat tnsnames.ora
proddb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = proddb)
)
)

uat =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = uat)
)
)

[oracle@server2 admin]$ cd ../../dbs/


[oracle@server2 dbs]$ orapwd file=orapwpuat password=welcome force=y
[oracle@server2 dbs]$
[oracle@server2 dbs]$
[oracle@server2 dbs]$ ls -lrth
total 9.4M
-rw-r--r-- 1 oracle oinstall 2.8K May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 24 Nov 2 21:11 lkDEVDB
-rw-r----- 1 oracle oinstall 1.5K Nov 3 07:49 orapwdevdb
-rw-r----- 1 oracle oinstall 9.3M Nov 3 08:45 snapcf_devdb.f
-rw-r----- 1 oracle oinstall 2.5K Jan 23 19:31 spfiledevdb.ora
-rw-rw---- 1 oracle oinstall 1.6K Jan 23 19:33 hc_devdb.dat
-rw-r----- 1 oracle oinstall 24 Jan 23 19:52 lkPRODDB
-rw-r----- 1 oracle oinstall 1.5K Jan 23 20:22 orapwPRODDB
-rw-r--r-- 1 oracle oinstall 588 Jan 23 20:24 inittest.ora
-rw-r----- 1 oracle oinstall 24 Jan 23 20:24 lkTEST
-rw-rw---- 1 oracle oinstall 1.6K Jan 23 20:34 hc_test.dat
-rw-r--r-- 1 oracle oinstall 753 Jan 23 20:43 initdev.ora
-rw-r----- 1 oracle oinstall 24 Jan 23 20:46 lkDEV
-rw-rw---- 1 oracle oinstall 1.6K Jan 23 20:54 hc_dev.dat
-rw-r----- 1 oracle oinstall 1.5K Jan 23 21:05 orapwpuat
[oracle@server2 dbs]$ orapwd file=orapwuat password=welcome force=y
[oracle@server2 dbs]$ cp initdev.ora inituat.ora
[oracle@server2 dbs]$ vi inituat.ora
[oracle@server2 dbs]$ cat inituat.ora
*.audit_file_dest='/u01/app/oracle/admin/uat/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u02/app/oracle/oradata/uat/control01.ctl','/u01/app/oracle/
fast_recovery_area/uat/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='dev'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='/u01/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=proddbXDB)'
*.memory_target=1652555776
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_file_name_convert='/u01/app/oracle/oradata/proddb','/u02/app/oracle/oradata/uat'
log_file_name_convert='/u01/app/oracle/oradata/proddb','/u02/app/oracle/oradata/
uat'
[oracle@server2 dbs]$ mkdir -p /u01/app/oracle/admin/uat/adump
[oracle@server2 dbs]$ mnkdir -p /u02/app/oracle/oradata/uat/
-bash: mnkdir: command not found
[oracle@server2 dbs]$ mkdir -p /u02/app/oracle/oradata/uat/
[oracle@server2 dbs]$ mkdir -p /u01/app/oracle/fast_recovery_area/uat/
[oracle@server2 dbs]$ mkdir /u02/app/oracle/oradata/uat
mkdir: cannot create directory `/u02/app/oracle/oradata/uat': File exists
[oracle@server2 dbs]$ mkdir -p /u02/app/oracle/oradata/uat
[oracle@server2 dbs]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 23 21:08:41 2022

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

Connected to an idle instance.

SQL> startup nomount


ORACLE instance started.

Total System Global Area 1653518336 bytes


Fixed Size 2253784 bytes
Variable Size 956304424 bytes
Database Buffers 687865856 bytes
Redo Buffers 7094272 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@server2 dbs]$

[oracle@server2 dbs]$ cat inituat.ora


*.audit_file_dest='/u01/app/oracle/admin/uat/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u02/app/oracle/oradata/uat/control01.ctl','/u01/app/oracle/
fast_recovery_area/uat/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='dev'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='/u01/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=proddbXDB)'
*.memory_target=1652555776
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_file_name_convert='/u01/app/oracle/oradata/proddb','/u02/app/oracle/oradata/uat'
log_file_name_convert='/u01/app/oracle/oradata/proddb','/u02/app/oracle/oradata/
uat'
[oracle@server2 dbs]$ vi inituat.ora
[oracle@server2 dbs]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 23 21:12:34 2022

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

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> shut abort


ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1653518336 bytes


Fixed Size 2253784 bytes
Variable Size 956304424 bytes
Database Buffers 687865856 bytes
Redo Buffers 7094272 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@server2 dbs]$ rman target sys/welcome@proddb auxiliary sys/welcome@uat

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jan 23 21:12:55 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODDB (DBID=827751920)
connected to auxiliary database: UAT (not mounted)

RMAN> duplicate target database to uat from active database nofilenamecheck;

Starting Duplicate Db at 23-JAN-22


using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=16 device type=DISK

contents of Memory Script:


{
sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:


{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)


Oracle instance started

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes


Variable Size 973081640 bytes
Database Buffers 671088640 bytes
Redo Buffers 7094272 bytes

contents of Memory Script:


{
sql clone "alter system set db_name =
''PRODDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''UAT'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format
'/u02/app/oracle/oradata/uat/control01.ctl';
restore clone controlfile to
'/u01/app/oracle/fast_recovery_area/uat/control02.ctl' from
'/u02/app/oracle/oradata/uat/control01.ctl';
alter clone database mount;
}
executing Memory Script

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

Oracle instance shut down

Oracle instance started

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes


Variable Size 973081640 bytes
Database Buffers 671088640 bytes
Redo Buffers 7094272 bytes

Starting backup at 23-JAN-22


allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_proddb.f
tag=TAG20220123T211317 RECID=1 STAMP=1094764397
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 23-JAN-22

Starting restore at 23-JAN-22


allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy


Finished restore at 23-JAN-22

database mounted

contents of Memory Script:


{
set newname for datafile 1 to
"/u02/app/oracle/oradata/uat/system01.dbf";
set newname for datafile 2 to
"/u02/app/oracle/oradata/uat/sysaux01.dbf";
set newname for datafile 3 to
"/u02/app/oracle/oradata/uat/undotbs01.dbf";
set newname for datafile 4 to
"/u02/app/oracle/oradata/uat/users01.dbf";
set newname for datafile 5 to
"/u02/app/oracle/oradata/uat/arun01.dbf";
set newname for datafile 6 to
"/u02/app/oracle/oradata/uat/baba01.dbf";
set newname for datafile 7 to
"/u02/app/oracle/oradata/uat/charan01.dbf";
set newname for datafile 8 to
"/u02/app/oracle/oradata/uat/dinesh01.dbf";
set newname for datafile 9 to
"/u02/app/oracle/oradata/uat/ekanth01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u02/app/oracle/oradata/uat/system01.dbf" datafile
2 auxiliary format
"/u02/app/oracle/oradata/uat/sysaux01.dbf" datafile
3 auxiliary format
"/u02/app/oracle/oradata/uat/undotbs01.dbf" datafile
4 auxiliary format
"/u02/app/oracle/oradata/uat/users01.dbf" datafile
5 auxiliary format
"/u02/app/oracle/oradata/uat/arun01.dbf" datafile
6 auxiliary format
"/u02/app/oracle/oradata/uat/baba01.dbf" datafile
7 auxiliary format
"/u02/app/oracle/oradata/uat/charan01.dbf" datafile
8 auxiliary format
"/u02/app/oracle/oradata/uat/dinesh01.dbf" datafile
9 auxiliary format
"/u02/app/oracle/oradata/uat/ekanth01.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 23-JAN-22


using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/proddb/system01.dbf
output file name=/u02/app/oracle/oradata/uat/system01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/proddb/sysaux01.dbf
output file name=/u02/app/oracle/oradata/uat/sysaux01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/proddb/arun01.dbf
output file name=/u02/app/oracle/oradata/uat/arun01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/proddb/baba01.dbf
output file name=/u02/app/oracle/oradata/uat/baba01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/proddb/charan01.dbf
output file name=/u02/app/oracle/oradata/uat/charan01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/u01/app/oracle/oradata/proddb/dinesh01.dbf
output file name=/u02/app/oracle/oradata/uat/dinesh01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/u01/app/oracle/oradata/proddb/ekanth01.dbf
output file name=/u02/app/oracle/oradata/uat/ekanth01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/proddb/undotbs01.dbf
output file name=/u02/app/oracle/oradata/uat/undotbs01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/proddb/users01.dbf
output file name=/u02/app/oracle/oradata/uat/users01.dbf tag=TAG20220123T211324
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 23-JAN-22

sql statement: alter system archive log current

contents of Memory Script:


{
backup as copy reuse
archivelog like
"/u01/app/oracle/fast_recovery_area/PRODDB/archivelog/2022_01_23/o1_mf_1_15_jyty00b
9_.arc" auxiliary format
"/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/o1_mf_1_15_%u_.arc"
;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script

Starting backup at 23-JAN-22


using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=15 RECID=4 STAMP=1094764505
output file name=/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/
o1_mf_1_15_0f0k1hup_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
Finished backup at 23-JAN-22

searching for all files in the recovery area

List of Files Unknown to the Database


=====================================
File Name:
/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/o1_mf_1_15_0f0k1hup_.a
rc
cataloging files...
cataloging done

List of Cataloged Files


=======================
File Name:
/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/o1_mf_1_15_0f0k1hup_.a
rc

datafile 1 switched to datafile copy


input datafile copy RECID=1 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/arun01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=6 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/baba01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=7 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/charan01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=8 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/dinesh01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=9 STAMP=1094764509 file
name=/u02/app/oracle/oradata/uat/ekanth01.dbf

contents of Memory Script:


{
set until scn 1142699;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 23-JAN-22


using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 15 is already on disk as file


/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/o1_mf_1_15_0f0k1hup_.a
rc
archived log file
name=/u01/app/oracle/fast_recovery_area/UAT/archivelog/2022_01_23/
o1_mf_1_15_0f0k1hup_.arc thread=1 sequence=15
media recovery complete, elapsed time: 00:00:00
Finished recover at 23-JAN-22
Oracle instance started

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes


Variable Size 973081640 bytes
Database Buffers 671088640 bytes
Redo Buffers 7094272 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''UAT'' 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 = ''UAT'' 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 1653518336 bytes

Fixed Size 2253784 bytes


Variable Size 973081640 bytes
Database Buffers 671088640 bytes
Redo Buffers 7094272 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "UAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u02/app/oracle/oradata/uat/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u02/app/oracle/oradata/uat/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u02/app/oracle/oradata/uat/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/u02/app/oracle/oradata/uat/system01.dbf'
CHARACTER SET WE8MSWIN1252

contents of Memory Script:


{
set newname for tempfile 1 to
"/u02/app/oracle/oradata/uat/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u02/app/oracle/oradata/uat/sysaux01.dbf",
"/u02/app/oracle/oradata/uat/undotbs01.dbf",
"/u02/app/oracle/oradata/uat/users01.dbf",
"/u02/app/oracle/oradata/uat/arun01.dbf",
"/u02/app/oracle/oradata/uat/baba01.dbf",
"/u02/app/oracle/oradata/uat/charan01.dbf",
"/u02/app/oracle/oradata/uat/dinesh01.dbf",
"/u02/app/oracle/oradata/uat/ekanth01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME

renamed tempfile 1 to /u02/app/oracle/oradata/uat/temp01.dbf in control file

cataloged datafile copy


datafile copy file name=/u02/app/oracle/oradata/uat/sysaux01.dbf RECID=1
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/undotbs01.dbf RECID=2
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/users01.dbf RECID=3
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/arun01.dbf RECID=4
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/baba01.dbf RECID=5
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/charan01.dbf RECID=6
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/dinesh01.dbf RECID=7
STAMP=1094764519
cataloged datafile copy
datafile copy file name=/u02/app/oracle/oradata/uat/ekanth01.dbf RECID=8
STAMP=1094764519

datafile 2 switched to datafile copy


input datafile copy RECID=1 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/arun01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/baba01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/charan01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/dinesh01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1094764519 file
name=/u02/app/oracle/oradata/uat/ekanth01.dbf

contents of Memory Script:


{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 23-JAN-22

You might also like