login as: csisora

csisora@192.168.111.130's password:
Last login: Fri Jul 16 13:35:35 2021 from 192.168.111.1
[csisora@locallost ~]$ cd /u01/backup/
[csisora@locallost backup]$ ll
total 23968
-rw-r----- 1 csisora csisora 14372864 Jul 16 13:33 0804203d_1_1
-rw-r----- 1 csisora csisora 10125312 Jul 16 13:38 STDCTRL_0e04208j_1_1
[csisora@locallost backup]$ rm -rf *
[csisora@locallost backup]$ scp oracle@192.168.111.128:/u01/backup/Archive_20210
716_0f043ur2_1_1 /u01/backup/
oracle@192.168.111.128's password:
Connection closed by 192.168.111.128
[csisora@locallost backup]$ cd /u01/app/csisora/product/11.2.0/dbhome_1/dbs/
[csisora@locallost dbs]$ pwd
/u01/app/csisora/product/11.2.0/dbhome_1/dbs
[csisora@locallost dbs]$ ll
total 40
-rw-rw---- 1 csisora csisora 1544 Jul 16 13:58 hc_orcldr.dat
-rw-r--r-- 1 csisora csisora 2851 May 15 2009 init.ora
-rw-r--r-- 1 csisora csisora 1202 Jul 16 11:13 initorcldr.ora
-rw-rw---- 1 csisora csisora 24 Jul 16 13:39 lkORCLDR
-rw-r----- 1 csisora csisora 1536 Jul 15 21:06 orapworcl
[csisora@locallost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 16 15:02:12 2021

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/csisora/product/11.2.0/dbhome_1/dbs/initorc

ldr.ora';
ORACLE instance started.

Total System Global Area 975081472 bytes

Fixed Size 1348320 bytes
Variable Size 218107168 bytes
Database Buffers 750780416 bytes
Redo Buffers 4845568 bytes
SQL> rman auxiliary /
SP2-0734: unknown command beginning "rman auxil..." - rest of line ignored.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
- Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[csisora@locallost dbs]$ rman auxiliary /

Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jul 16 15:03:08 2021

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

connected to auxiliary database: ORCL (not mounted)

RMAN> run{
DUPLICATE DATABASE TO ORCLDR
BACKUP LOCATION '/u01/backup'
NOFILENAMECHECK;
}2> 3> 4> 5>
Starting Duplicate Db at 16-JUL-21

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 975081472 bytes

Fixed Size 1348320 bytes

Variable Size 264244512 bytes
Database Buffers 704643072 bytes
Redo Buffers 4845568 bytes

contents of Memory Script:

{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ORCLDR'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/u01/backup/Controlback_20210716_0j0
43vf4_1_1';
alter clone database mount;
}
executing Memory Script

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

sql statement: alter system set db_unique_name = ''ORCLDR'' comment= ''Modifie

d by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 975081472 bytes

Fixed Size 1348320 bytes

Variable Size 264244512 bytes
Database Buffers 704643072 bytes
Redo Buffers 4845568 bytes

Starting restore at 16-JUL-21

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

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/csisora/oradata/orcldr/control01.ctl
output file name=/u01/app/csisora/fast_recovery_area/orcldr/control02.ctl
Finished restore at 16-JUL-21

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK

contents of Memory Script:

{
set until scn 1967775;
set newname for datafile 1 to
"/u01/app/csisora/oradata/orcldr//system01.dbf";
set newname for datafile 2 to
"/u01/app/csisora/oradata/orcldr//sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/csisora/oradata/orcldr//undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/csisora/oradata/orcldr//users01.dbf";
set newname for datafile 5 to
"/u01/app/csisora/oradata/orcldr//glow01.dbf";
set newname for datafile 6 to
"/u01/app/csisora/oradata/orcldr//glow_tmp01.dbf";
set newname for datafile 7 to
"/u01/app/csisora/oradata/orcldr//system02.dbf";
set newname for datafile 8 to
"/u01/app/csisora/oradata/orcldr//glow02.dbf";
restore
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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 16-JUL-21

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to
/u01/app/csisora/oradata/orcldr//system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to
/u01/app/csisora/oradata/orcldr//sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to
/u01/app/csisora/oradata/orcldr//undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to
/u01/app/csisora/oradata/orcldr//users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to
/u01/app/csisora/oradata/orcldr//glow01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to
/u01/app/csisora/oradata/orcldr//glow_tmp01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to
/u01/app/csisora/oradata/orcldr//system02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00008 to
/u01/app/csisora/oradata/orcldr//glow02.dbf
channel ORA_AUX_DISK_1: reading from backup piece
/u01/backup/Fullback_20210716_0g043us7_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Fullback_20210716_0g043us7_1_1
tag=TAG20210716T144734
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:29:01
Finished restore at 16-JUL-21

contents of Memory Script:

{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=9 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=10 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/glow01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=14 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/glow_tmp01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=15 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/system02.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=16 STAMP=1078068937 file
name=/u01/app/csisora/oradata/orcldr/glow02.dbf

contents of Memory Script:

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

executing command: SET until clause

Starting recover at 16-JUL-21

using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=97
channel ORA_AUX_DISK_1: reading from backup piece
/u01/backup/Archive_20210716_0i043vf3_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Archive_20210716_0i043vf3_1_1
tag=TAG20210716T145739
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=/u01/app/csisora/1_97_1066562168.dbf thread=1 sequence=97
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/csisora/1_97_1066562168.dbf RECID=1
STAMP=1078068962
media recovery complete, elapsed time: 00:00:20
Finished recover at 16-JUL-21
Oracle instance started

Total System Global Area 975081472 bytes

Fixed Size 1348320 bytes

Variable Size 264244512 bytes
Database Buffers 704643072 bytes
Redo Buffers 4845568 bytes

contents of Memory Script:

{
sql clone "alter system set db_name =
''ORCLDR'' 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 = ''ORCLDR'' 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 975081472 bytes

Fixed Size 1348320 bytes

Variable Size 264244512 bytes
Database Buffers 704643072 bytes
Redo Buffers 4845568 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLDR" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u01/app/csisora/oradata/orcldr//redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/app/csisora/oradata/orcldr//redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/app/csisora/oradata/orcldr//redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/app/csisora/oradata/orcldr/system01.dbf'
CHARACTER SET WE8MSWIN1252

contents of Memory Script:

{
set newname for tempfile 1 to
"/u01/app/csisora/oradata/orcldr//temp01.dbf";
set newname for tempfile 3 to
"/u01/app/csisora/oradata/orcldr//temp03.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/csisora/oradata/orcldr/sysaux01.dbf",
"/u01/app/csisora/oradata/orcldr/undotbs01.dbf",
"/u01/app/csisora/oradata/orcldr/users01.dbf",
"/u01/app/csisora/oradata/orcldr/glow01.dbf",
"/u01/app/csisora/oradata/orcldr/glow_tmp01.dbf",
"/u01/app/csisora/oradata/orcldr/system02.dbf",
"/u01/app/csisora/oradata/orcldr/glow02.dbf";
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/csisora/oradata/orcldr//temp01.dbf in control file

renamed tempfile 3 to /u01/app/csisora/oradata/orcldr//temp03.dbf in control file

cataloged datafile copy

datafile copy file name=/u01/app/csisora/oradata/orcldr/sysaux01.dbf RECID=1
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/undotbs01.dbf RECID=2
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/users01.dbf RECID=3
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/glow01.dbf RECID=4
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/glow_tmp01.dbf RECID=5
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/system02.dbf RECID=6
STAMP=1078069079
cataloged datafile copy
datafile copy file name=/u01/app/csisora/oradata/orcldr/glow02.dbf RECID=7
STAMP=1078069079

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/glow01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/glow_tmp01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/system02.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1078069079 file
name=/u01/app/csisora/oradata/orcldr/glow02.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 16-JUL-21

RMAN>