RMAN> duplicate database to 'TEST' pluggable database PDB1 2> UNTIL TIME "TO_DATE ('15-10-2018 04:40:00','dd-mm-yyyy hh24:mi:ss')" 3> backup location '/home/oracle/pdb1/'; Starting Duplicate Db at 15-OCT-18 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 3221225472 bytes Fixed Size 8797928 bytes Variable Size 1040187672 bytes Database Buffers 2164260864 bytes Redo Buffers 7979008 bytes contents of Memory Script: { sql clone "alter system set db_name = ''RDB'' comment= ''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''test'' comment= ''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate; startup clone force nomount restore clone primary controlfile from '/home/oracle/pdb1/back/autobackup/2018_10_14/o1_mf_s_989510455_fw6t1qhf_.bkp'; alter clone database mount; } executing Memory Script sql statement: alter system set db_name = ''RDB'' comment= ''Modified by RMAN duplicate'' scope=spfile sql statement: alter system set db_unique_name = ''test'' comment= ''Modified by RMAN duplicate'' scope=spfile Oracle instance shut down Oracle instance started Total System Global Area 3221225472 bytes Fixed Size 8797928 bytes Variable Size 1040187672 bytes Database Buffers 2164260864 bytes Redo Buffers 7979008 bytes Starting restore at 15-OCT-18 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=1 device type=DISK channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/oradata/test/control01.ctl output file name=/u01/app/oracle/fast_recovery_area/test/control02.ctl Finished restore at 15-OCT-18 database mounted released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=1 device type=DISK Skipping pluggable database PDB_RDB1 Skipping pluggable database PDB_RDB2 Skipping pluggable database PDB_RDB_MIDRP Skipping pluggable database PDB_M1 Skipping pluggable database PDB_SAEED Automatically adding tablespace SYSTEM Automatically adding tablespace SYSAUX Automatically adding tablespace PDB$SEED:SYSTEM Automatically adding tablespace PDB$SEED:SYSAUX Automatically adding tablespace UNDOTBS1 Skipping tablespace USERS Skipping tablespace TEST2 Skipping tablespace TEST Not connected to TARGET, cannot verify that set of tablespaces being duplicated does not have SYS objects contents of Memory Script: { set until scn 1683700835; set newname for clone datafile 1 to new; set newname for clone datafile 2 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 170 to new; set newname for clone datafile 171 to new; set newname for clone datafile 172 to new; set newname for clone datafile 173 to new; restore clone database skip forever tablespace "USERS", "TEST2", "TEST", "PDB_RDB1":"USERS", "PDB_RDB1":"UNDOTBS1", "PDB_RDB1":"TEST", "PDB_RDB1":"SYSTEM", "PDB_RDB1":"SYSAUX", "PDB_RDB1":"SLOW_STORAGE_TS", "PDB_RDB1":"MEDIUM_STORAGE_TS", "PDB_RDB1":"FAST_STORAGE_TS", "PDB_RDB2":"USERS", "PDB_RDB2":"UNDOTBS1", "PDB_RDB2":"SYSTEM", "PDB_RDB2":"SYSAUX", "PDB_RDB2":"SLOW_STORAGE", "PDB_RDB2":"MEDIUM_STORAGE", "PDB_RDB2":"FAST_STORAGE", "PDB_RDB_MIDRP":"USERS", "PDB_RDB_MIDRP":"UNDOTBS1", "PDB_RDB_MIDRP":"SYSTEM", "PDB_RDB_MIDRP":"SYSAUX", "PDB_M1":"USERS", "PDB_M1":"UNDOTBS1", "PDB_M1":"TEST1", "PDB_M1":"TBS_03", "PDB_M1":"TBS_02", "PDB_M1":"SYSTEM", "PDB_M1":"SYSAUX", "PDB_SAEED":"USERS", "PDB_SAEED":"UNDOTBS1", "PDB_SAEED":"SYSTEM", "PDB_SAEED":"SYSAUX", "PDB_SAEED":"INEXPENSIVE_DISK", "PDB_SAEED":"EXPENSIVE_DISK" ; } 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 Starting restore at 15-OCT-18 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/oracle/oradata/TEST/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/TEST/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/TEST/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/pdb1/back/92tflehv channel ORA_AUX_DISK_1: piece handle=/home/oracle/pdb1/back/92tflehv tag=MY_BACK channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:05 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 00002 to /u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/pdb1/back/97tfleop channel ORA_AUX_DISK_1: piece handle=/home/oracle/pdb1/back/97tfleop tag=MY_BACK channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25 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 00170 to /u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00171 to /u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00172 to /u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00173 to /u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_users_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/pdb1/back/96tflenv channel ORA_AUX_DISK_1: piece handle=/home/oracle/pdb1/back/96tflenv tag=MY_BACK channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 Finished restore at 15-OCT-18 contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=11 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_system_fw8hrv7r_.dbf datafile 2 switched to datafile copy input datafile copy RECID=12 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_system_fw8hwrff_.dbf datafile 3 switched to datafile copy input datafile copy RECID=13 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_sysaux_fw8hrv7m_.dbf datafile 4 switched to datafile copy input datafile copy RECID=14 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_sysaux_fw8hwrh5_.dbf datafile 5 switched to datafile copy input datafile copy RECID=15 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_undotbs1_fw8hrv8p_.dbf datafile 6 switched to datafile copy input datafile copy RECID=16 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_undotbs1_fw8hwrgj_.dbf datafile 170 switched to datafile copy input datafile copy RECID=17 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_system_fw8hxklf_.dbf datafile 171 switched to datafile copy input datafile copy RECID=18 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_sysaux_fw8hxkmx_.dbf datafile 172 switched to datafile copy input datafile copy RECID=19 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_undotbs1_fw8hxkm6_.dbf datafile 173 switched to datafile copy input datafile copy RECID=20 STAMP=989565632 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_users_fw8hxkmz_.dbf contents of Memory Script: { set until time "to_date('OCT 15 2018 04:40:00', 'MON DD YYYY HH24:MI:SS')"; recover clone database skip forever tablespace "USERS", "TEST2", "TEST", "PDB_RDB1":"USERS", "PDB_RDB1":"UNDOTBS1", "PDB_RDB1":"TEST", "PDB_RDB1":"SYSTEM", "PDB_RDB1":"SYSAUX", "PDB_RDB1":"SLOW_STORAGE_TS", "PDB_RDB1":"MEDIUM_STORAGE_TS", "PDB_RDB1":"FAST_STORAGE_TS", "PDB_RDB2":"USERS", "PDB_RDB2":"UNDOTBS1", "PDB_RDB2":"SYSTEM", "PDB_RDB2":"SYSAUX", "PDB_RDB2":"SLOW_STORAGE", "PDB_RDB2":"MEDIUM_STORAGE", "PDB_RDB2":"FAST_STORAGE", "PDB_RDB_MIDRP":"USERS", "PDB_RDB_MIDRP":"UNDOTBS1", "PDB_RDB_MIDRP":"SYSTEM", "PDB_RDB_MIDRP":"SYSAUX", "PDB_M1":"USERS", "PDB_M1":"UNDOTBS1", "PDB_M1":"TEST1", "PDB_M1":"TBS_03", "PDB_M1":"TBS_02", "PDB_M1":"SYSTEM", "PDB_M1":"SYSAUX", "PDB_SAEED":"USERS", "PDB_SAEED":"UNDOTBS1", "PDB_SAEED":"SYSTEM", "PDB_SAEED":"SYSAUX", "PDB_SAEED":"INEXPENSIVE_DISK", "PDB_SAEED":"EXPENSIVE_DISK" delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 15-OCT-18 using channel ORA_AUX_DISK_1 Executing: alter database datafile 91 offline drop Executing: alter database datafile 90 offline drop Executing: alter database datafile 95 offline drop Executing: alter database datafile 88 offline drop Executing: alter database datafile 89 offline drop Executing: alter database datafile 94 offline drop Executing: alter database datafile 93 offline drop Executing: alter database datafile 92 offline drop Executing: alter database datafile 99 offline drop Executing: alter database datafile 98 offline drop Executing: alter database datafile 96 offline drop Executing: alter database datafile 97 offline drop Executing: alter database datafile 100 offline drop Executing: alter database datafile 102 offline drop Executing: alter database datafile 101 offline drop Executing: alter database datafile 106 offline drop Executing: alter database datafile 105 offline drop Executing: alter database datafile 103 offline drop Executing: alter database datafile 104 offline drop Executing: alter database datafile 122 offline drop Executing: alter database datafile 121 offline drop Executing: alter database datafile 127 offline drop Executing: alter database datafile 128 offline drop Executing: alter database datafile 129 offline drop Executing: alter database datafile 119 offline drop Executing: alter database datafile 120 offline drop Executing: alter database datafile 133 offline drop Executing: alter database datafile 132 offline drop Executing: alter database datafile 130 offline drop Executing: alter database datafile 131 offline drop Executing: alter database datafile 135 offline drop Executing: alter database datafile 134 offline drop 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=1719 channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/pdb1/2018_10_14/o1_mf_annnn_TAG20181014T160051_fw6t1mqy_.bkp channel ORA_AUX_DISK_1: piece handle=/home/oracle/pdb1/2018_10_14/o1_mf_annnn_TAG20181014T160051_fw6t1mqy_.bkp tag=TAG20181014T160051 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/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1719_fw8hy5jn_.arc thread=1 sequence=1719 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1719_fw8hy5jn_.arc RECID=1 STAMP=989565639 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=1720 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1721 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1722 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1723 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1724 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1725 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=1726 channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/pdb1/back/9atfmvbq channel ORA_AUX_DISK_1: piece handle=/home/oracle/pdb1/back/9atfmvbq tag=TAG20181015T054945 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1720_fw8hy9f1_.arc thread=1 sequence=1720 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1720_fw8hy9f1_.arc RECID=5 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1721_fw8hy9hf_.arc thread=1 sequence=1721 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1721_fw8hy9hf_.arc RECID=4 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1722_fw8hy99j_.arc thread=1 sequence=1722 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1722_fw8hy99j_.arc RECID=8 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1723_fw8hy9h5_.arc thread=1 sequence=1723 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1723_fw8hy9h5_.arc RECID=3 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1724_fw8hy9dx_.arc thread=1 sequence=1724 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1724_fw8hy9dx_.arc RECID=6 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1725_fw8hy997_.arc thread=1 sequence=1725 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1725_fw8hy997_.arc RECID=7 STAMP=989565699 archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1726_fw8hy9lv_.arc thread=1 sequence=1726 Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01157: cannot identify/lock data file 7 - see DBWR trace file ORA-01110: data file 7: '/u01/app/oracle/oradata/rdb/users01.dbf' channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TEST/archivelog/2018_10_15/o1_mf_1_1726_fw8hy9lv_.arc RECID=2 STAMP=989565655 media recovery complete, elapsed time: 00:01:39 Finished recover at 15-OCT-18 Oracle instance started Total System Global Area 3221225472 bytes Fixed Size 8797928 bytes Variable Size 1040187672 bytes Database Buffers 2164260864 bytes Redo Buffers 7979008 bytes contents of Memory Script: { sql clone "alter system set db_name = ''TEST'' 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 = ''TEST'' 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 3221225472 bytes Fixed Size 8797928 bytes Variable Size 1040187672 bytes Database Buffers 2164260864 bytes Redo Buffers 7979008 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST" 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/TEST/datafile/o1_mf_system_fw8hrv7r_.dbf', '/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_system_fw8hwrff_.dbf', '/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_system_fw8hxklf_.dbf' CHARACTER SET AL32UTF8 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 10 to new; switch clone tempfile all; catalog clone datafilecopy "/u01/app/oracle/oradata/TEST/datafile/o1_mf_sysaux_fw8hrv7m_.dbf", "/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_sysaux_fw8hwrh5_.dbf", "/u01/app/oracle/oradata/TEST/datafile/o1_mf_undotbs1_fw8hrv8p_.dbf", "/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_undotbs1_fw8hwrgj_.dbf", "/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_sysaux_fw8hxkmx_.dbf", "/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_undotbs1_fw8hxkm6_.dbf", "/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_users_fw8hxkmz_.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/TEST/datafile/o1_mf_temp_%u_.tmp in control file renamed tempfile 2 to /u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_temp_%u_.tmp in control file renamed tempfile 10 to /u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_temp_%u_.tmp in control file cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_sysaux_fw8hrv7m_.dbf RECID=1 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_sysaux_fw8hwrh5_.dbf RECID=2 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_undotbs1_fw8hrv8p_.dbf RECID=3 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_undotbs1_fw8hwrgj_.dbf RECID=4 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_sysaux_fw8hxkmx_.dbf RECID=5 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_undotbs1_fw8hxkm6_.dbf RECID=6 STAMP=989565826 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_users_fw8hxkmz_.dbf RECID=7 STAMP=989565826 datafile 3 switched to datafile copy input datafile copy RECID=1 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_sysaux_fw8hrv7m_.dbf datafile 4 switched to datafile copy input datafile copy RECID=2 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_sysaux_fw8hwrh5_.dbf datafile 5 switched to datafile copy input datafile copy RECID=3 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/datafile/o1_mf_undotbs1_fw8hrv8p_.dbf datafile 6 switched to datafile copy input datafile copy RECID=4 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/600D468F6EFD3E2AE0539B0110AC21B5/datafile/o1_mf_undotbs1_fw8hwrgj_.dbf datafile 171 switched to datafile copy input datafile copy RECID=5 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_sysaux_fw8hxkmx_.dbf datafile 172 switched to datafile copy input datafile copy RECID=6 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_undotbs1_fw8hxkm6_.dbf datafile 173 switched to datafile copy input datafile copy RECID=7 STAMP=989565826 file name=/u01/app/oracle/oradata/TEST/78167189EA4279C9E0539E6E10ACD711/datafile/o1_mf_users_fw8hxkmz_.dbf Reenabling controlfile options for auxiliary database Executing: alter database add supplemental log data Executing: alter database force logging contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Executing: drop pluggable database "PDB_RDB1" including datafiles Executing: drop pluggable database "PDB_RDB2" including datafiles Executing: drop pluggable database "PDB_RDB_MIDRP" including datafiles Executing: drop pluggable database "PDB_M1" including datafiles Executing: drop pluggable database "PDB_SAEED" including datafiles contents of Memory Script: { sql clone "alter pluggable database all open"; } executing Memory Script sql statement: alter pluggable database all open Dropping offline and skipped tablespaces Executing: alter database default tablespace system Executing: drop tablespace "USERS" including contents cascade constraints Executing: drop tablespace "TEST2" including contents cascade constraints Executing: drop tablespace "TEST" including contents cascade constraints Cannot remove created server parameter file Finished Duplicate Db at 15-OCT-18