[oracle@orcloel7 ~]$ rman Recovery Manager: Release 19.0.0.0.0 - Production on Sun Nov 22 10:31:00 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. RMAN> RMAN> connect auxiliary / connected to auxiliary database: DBCLON (not mounted) RMAN> connect catalog vpcbronze/vpcbronze@zdlras1-scan:1521/zdlras1 connected to recovery catalog database RMAN> run{ 2> allocate auxiliary channel RA1 DEVICE TYPE 'SBT_TAPE' PARMS "SBT_LIBRARY=/u01/app/oracle/product/19.3.0.0/dbhome_1/lib/libra.so, ENV=(RA_WALLET='location=file:/u01/app/oracle/product/19.3.0.0/dbhome_1/dbs/ra_wallet CREDENTIAL_ALIAS=zdlras1-scan:1521/zdlras1:VPCBRONZE')"; 3> duplicate database ORCL19C to DBCLON NOFILENAMECHECK; 4> } allocated channel: RA1 channel RA1: SID=38 device type=SBT_TAPE channel RA1: RA Library (ZDLRAS1) SID=B4AFD129EAE2193DE053010310ACDCD0 Starting Duplicate Db at 22/11/2020 10:36:50 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 4294963960 bytes Fixed Size 9143032 bytes Variable Size 1694498816 bytes Database Buffers 2583691264 bytes Redo Buffers 7630848 bytes allocated channel: RA1 channel RA1: SID=35 device type=SBT_TAPE channel RA1: RA Library (ZDLRAS1) SID=B4AFD2FFF33019A1E053010310AC997E duplicating Online logs to Oracle Managed File (OMF) location duplicating Datafiles to Oracle Managed File (OMF) location contents of Memory Script: { sql clone "alter system set db_name = ''ORCL19C'' comment= ''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''DBCLON'' comment= ''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate; startup clone force nomount restore clone primary controlfile; alter clone database mount; } executing Memory Script sql statement: alter system set db_name = ''ORCL19C'' comment= ''Modified by RMAN duplicate'' scope=spfile sql statement: alter system set db_unique_name = ''DBCLON'' comment= ''Modified by RMAN duplicate'' scope=spfile Oracle instance shut down Oracle instance started Total System Global Area 4294963960 bytes Fixed Size 9143032 bytes Variable Size 1694498816 bytes Database Buffers 2583691264 bytes Redo Buffers 7630848 bytes allocated channel: RA1 channel RA1: SID=35 device type=SBT_TAPE channel RA1: RA Library (ZDLRAS1) SID=B4AFD50A264C1A13E053010310AC4687 Starting restore at 22/11/2020 10:37:55 channel RA1: starting datafile backup set restore channel RA1: restoring control file channel RA1: reading from backup piece c-1487680695-20201122-01 channel RA1: piece handle=c-1487680695-20201122-01 tag=TAG20201122T103413 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:15 output file name=/u01/app/oracle/oradata/DBCLON/control01.ctl output file name=/u01/app/oracle/oradata/DBCLON/control02.ctl Finished restore at 22/11/2020 10:38:11 database mounted contents of Memory Script: { set until scn 2824241; set newname for clone datafile 1 to new; set newname for clone datafile 3 to new; set newname for clone datafile 4 to new; set newname for clone datafile 5 to new; set newname for clone datafile 6 to new; set newname for clone datafile 7 to new; set newname for clone datafile 8 to new; set newname for clone datafile 9 to new; set newname for clone datafile 10 to new; set newname for clone datafile 11 to new; set newname for clone datafile 12 to new; 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 executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 22/11/2020 10:38:20 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00005 to /u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_system_%u_.dbf channel RA1: reading from backup piece ORCL19C_g8vfpmfu_1_1 channel RA1: piece handle=ORCL19C_g8vfpmfu_1_1 tag=TAG20201117T235315 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:07 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00006 to /u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_sysaux_%u_.dbf channel RA1: reading from backup piece ORCL19C_gbvfpmo8_1_1 channel RA1: piece handle=ORCL19C_gbvfpmo8_1_1 tag=TAG20201117T235315 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:07 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00008 to /u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_undotbs1_%u_.dbf channel RA1: reading from backup piece ORCL19C_gcvfpmrh_1_1 channel RA1: piece handle=ORCL19C_gcvfpmrh_1_1 tag=TAG20201117T235315 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:03 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00003 to /u01/app/oracle/oradata/DBCLON/datafile/o1_mf_sysaux_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21164_3 channel RA1: piece handle=VB$_1918343643_21164_3 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:01:15 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00001 to /u01/app/oracle/oradata/DBCLON/datafile/o1_mf_system_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21136_1 channel RA1: piece handle=VB$_1918343643_21136_1 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:01:25 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00004 to /u01/app/oracle/oradata/DBCLON/datafile/o1_mf_undotbs1_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21216_4 channel RA1: piece handle=VB$_1918343643_21216_4 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:35 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00009 to /u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_system_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21253_9 channel RA1: piece handle=VB$_1918343643_21253_9 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:25 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00011 to /u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_undotbs1_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21264_11 channel RA1: piece handle=VB$_1918343643_21264_11 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:15 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00010 to /u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_sysaux_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21265_10 channel RA1: piece handle=VB$_1918343643_21265_10 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:35 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00007 to /u01/app/oracle/oradata/DBCLON/datafile/o1_mf_users_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21282_7 channel RA1: piece handle=VB$_1918343643_21282_7 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:25 channel RA1: starting datafile backup set restore channel RA1: specifying datafile(s) to restore from backup set channel RA1: restoring datafile 00012 to /u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_users_%u_.dbf channel RA1: reading from backup piece VB$_1918343643_21283_12 channel RA1: piece handle=VB$_1918343643_21283_12 tag=TAG20201122T094928 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:07 Finished restore at 22/11/2020 10:43:41 contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=15 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_system_hvndkl06_.dbf datafile 3 switched to datafile copy input datafile copy RECID=16 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_sysaux_hvndgwn7_.dbf datafile 4 switched to datafile copy input datafile copy RECID=17 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_undotbs1_hvndlv24_.dbf datafile 5 switched to datafile copy input datafile copy RECID=18 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_system_hvnddgwo_.dbf datafile 6 switched to datafile copy input datafile copy RECID=19 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_sysaux_hvnddoxp_.dbf datafile 7 switched to datafile copy input datafile copy RECID=20 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_users_hvndp2nn_.dbf datafile 8 switched to datafile copy input datafile copy RECID=21 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_undotbs1_hvnddx63_.dbf datafile 9 switched to datafile copy input datafile copy RECID=22 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_system_hvndmr1z_.dbf datafile 10 switched to datafile copy input datafile copy RECID=23 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_sysaux_hvndo13n_.dbf datafile 11 switched to datafile copy input datafile copy RECID=24 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_undotbs1_hvndn5kd_.dbf datafile 12 switched to datafile copy input datafile copy RECID=25 STAMP=1057142623 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_users_hvndpbc9_.dbf contents of Memory Script: { set until scn 2824241; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 22/11/2020 10:43:43 starting media recovery channel RA1: starting archived log restore to default destination channel RA1: restoring archived log archived log thread=1 sequence=113 channel RA1: reading from backup piece ORCL19C_hevg5d8l_1_1 channel RA1: piece handle=ORCL19C_hevg5d8l_1_1 tag=TAG20201122T103357 channel RA1: restored backup piece 1 channel RA1: restore complete, elapsed time: 00:00:07 archived log file name=/u01/app/oracle/oradata/DBCLON/archivelog/2020_11_22/o1_mf_1_113_hvndpsjy_.arc thread=1 sequence=113 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/oradata/DBCLON/archivelog/2020_11_22/o1_mf_1_113_hvndpsjy_.arc RECID=173 STAMP=1057142636 media recovery complete, elapsed time: 00:00:00 Finished recover at 22/11/2020 10:44:00 released channel: RA1 Oracle instance started Total System Global Area 4294963960 bytes Fixed Size 9143032 bytes Variable Size 1694498816 bytes Database Buffers 2583691264 bytes Redo Buffers 7630848 bytes contents of Memory Script: { sql clone "alter system set db_name = ''DBCLON'' comment= ''Reset to original value by RMAN'' scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; } executing Memory Script sql statement: alter system set db_name = ''DBCLON'' comment= ''Reset to original value by RMAN'' scope=spfile sql statement: alter system reset db_unique_name scope=spfile Oracle instance started Total System Global Area 4294963960 bytes Fixed Size 9143032 bytes Variable Size 1694498816 bytes Database Buffers 2583691264 bytes Redo Buffers 7630848 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DBCLON" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 200 M , GROUP 2 SIZE 200 M , GROUP 3 SIZE 200 M DATAFILE '/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_system_hvndkl06_.dbf', '/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_system_hvnddgwo_.dbf', '/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_system_hvndmr1z_.dbf' CHARACTER SET WE8ISO8859P15 contents of Memory Script: { set newname for clone tempfile 1 to new; set newname for clone tempfile 2 to new; set newname for clone tempfile 3 to new; switch clone tempfile all; catalog clone datafilecopy "/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_sysaux_hvndgwn7_.dbf", "/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_undotbs1_hvndlv24_.dbf", "/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_sysaux_hvnddoxp_.dbf", "/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_users_hvndp2nn_.dbf", "/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_undotbs1_hvnddx63_.dbf", "/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_sysaux_hvndo13n_.dbf", "/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_undotbs1_hvndn5kd_.dbf", "/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_users_hvndpbc9_.dbf"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/oradata/DBCLON/datafile/o1_mf_temp_%u_.tmp in control file renamed tempfile 2 to /u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_temp_%u_.tmp in control file renamed tempfile 3 to /u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_temp_%u_.tmp in control file cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_sysaux_hvndgwn7_.dbf RECID=1 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_undotbs1_hvndlv24_.dbf RECID=2 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_sysaux_hvnddoxp_.dbf RECID=3 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_users_hvndp2nn_.dbf RECID=4 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_undotbs1_hvnddx63_.dbf RECID=5 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_sysaux_hvndo13n_.dbf RECID=6 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_undotbs1_hvndn5kd_.dbf RECID=7 STAMP=1057142666 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_users_hvndpbc9_.dbf RECID=8 STAMP=1057142666 datafile 3 switched to datafile copy input datafile copy RECID=1 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_sysaux_hvndgwn7_.dbf datafile 4 switched to datafile copy input datafile copy RECID=2 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_undotbs1_hvndlv24_.dbf datafile 6 switched to datafile copy input datafile copy RECID=3 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_sysaux_hvnddoxp_.dbf datafile 7 switched to datafile copy input datafile copy RECID=4 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/datafile/o1_mf_users_hvndp2nn_.dbf datafile 8 switched to datafile copy input datafile copy RECID=5 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/89CCCBF6CCD8043CE053010310ACA0D7/datafile/o1_mf_undotbs1_hvnddx63_.dbf datafile 10 switched to datafile copy input datafile copy RECID=6 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_sysaux_hvndo13n_.dbf datafile 11 switched to datafile copy input datafile copy RECID=7 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_undotbs1_hvndn5kd_.dbf datafile 12 switched to datafile copy input datafile copy RECID=8 STAMP=1057142666 file name=/u01/app/oracle/oradata/DBCLON/89CCF7B8BDCC0C30E053010310ACD002/datafile/o1_mf_users_hvndpbc9_.dbf contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened contents of Memory Script: { sql clone "alter pluggable database all open"; } executing Memory Script sql statement: alter pluggable database all open Cannot remove created server parameter file Finished Duplicate Db at 22/11/2020 10:44:37 RMAN> RMAN> exit Recovery Manager complete. [oracle@orcloel7 ~]$ [oracle@orcloel7 ~]$