Oracle Backup-Bases database Cloning

 Oracle Backup-Bases database Cloning 

For DBA Refreshing Table, Schema and Database are routine activity. You can refresh/Clone database using below method:

1.Conventional Restore method and Rename DB post DB Refresh
2.Conventional Duplicate Database method
3. Active database Cloning 
4.Backup Base Cloning

We will cover all these methods of cloning in individual blogs. In This blog , We will discuss about how to refresh/Clone Database using Backup-Bases loning. 

In Backup-Based, Auxiliary Database is cloned from the backup of the target databases. Backup of the target database must be accessible from the the auxiliary database server . In Case of the Backup-Base Cloning there is no need to connect to the target database. 

Below are the step followed to perform Backup-Bases database duplication

1) Create Pfile for auxiliary database

auxdb.__data_transfer_cache_size=0
auxdb.__db_cache_size=7952400384
auxdb.__java_pool_size=234881024
auxdb.__large_pool_size=1476395008
auxdb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
auxdb.__pga_aggregate_target=27078426624
auxdb.__sga_target=13958643712
auxdb.__shared_io_pool_size=536870912
auxdb.__shared_pool_size=3724541952
auxdb.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/auxdb/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/u01/oradata/auxdb/controlfile/auxdb01.ctl','/u01/app/oracte/fast_recovery_area/auxdb/controlfile/auxdb02.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u02_oracle/oradata/'
*.db_domain=''
*.db_name='auxdb'
*.db_recovery_file_dest_size=7516192768
*.db_recovery_file_dest=''
*.db_securefile='PREFERRED'
*.diagnostic_dest='/u01/app/oracle'
*.open_cursors=300
*.pga_aggregate_target=25820m
*.processes=200
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=13958643712
*.undo_retention=6400
.undo_tablespace='UNDOTBS1'
db_file_name_convert =("+DATA","/u02_oracle/oradata/auxdb")
log_file_name_convert =("+RECO","/u01/oradata/auxdb","+DATA","/u01/app/oracle/fast_recovery_area/auxdb")

2) Create Directories for auxiliary database redo log ,datafile, tempfile and Dump

      mkdir -p /u01/app/oracle/fast_recovery_area/auxdb/ntulearn/
mkdir -p /u01/oradata/auxdb/ntulearn/onlinelog/
mkdir -p /u01/app/oracle/fast_recovery_area/auxdb/ntulearn/onlinelog
mkdir -p /u01/oradata/auxdb/ntulearn/onlinelog/
mkdir -p /u02_oracle/oradata/auxdb
mkdir -p /u01_oracle/oradata/auxdb

     3) Start Auxiliary instance in nomount stage.

          SYS@auxdb> startup nomount pfile='/tmp/initauxdb.ora'

     4) Clone Database with auxdb name on non-prod.

      rman auxiliary /

run{
set newname for datafile  1 to '/u02_oracle/oradata/auxdb/system_390_929799645.dbf';
set newname for datafile  2 to '/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf';
set newname for datafile  3 to '/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf';
set newname for datafile  4 to '/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf';
set newname for datafile  5 to '/u02_oracle/oradata/auxdb/users_413_929786877.dbf';
set newname for datafile  6 to '/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf';
set newname for datafile  7 to '/u02_oracle/oradata/auxdb/testdb_admin_data_365_929786877.dbf';
set newname for datafile  8 to '/u02_oracle/oradata/auxdb/testdb_admin_indx_383_929786877.dbf';
set newname for datafile  9 to '/u02_oracle/oradata/auxdb/testdb_data_388_929790455.dbf';
set newname for datafile  10 to '/u02_oracle/oradata/auxdb/testdb_indx_400_929799649.dbf';
set newname for datafile  11 to '/u02_oracle/oradata/auxdb/testdb_stats_data_371_929790457.dbf';
set newname for datafile  12 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_394_929807081.dbf';
set newname for datafile  13 to '/u02_oracle/oradata/auxdb/testdb_cms_data_376_929788647.dbf';
set newname for datafile  14 to '/u02_oracle/oradata/auxdb/testdb_cms_indx_384_929788647.dbf';
set newname for datafile  15 to '/u02_oracle/oradata/auxdb/testdb_cms_doc_data_389_929788623.dbf';
set newname for datafile  16 to '/u02_oracle/oradata/auxdb/testdb_cms_doc_indx_414_929786877.dbf';
set newname for datafile  17 to '/u02_oracle/oradata/auxdb/testdb_data_369_929790457.dbf';
set newname for datafile  18 to '/u02_oracle/oradata/auxdb/testdb_data_364_929799647.dbf';
set newname for datafile  19 to '/u02_oracle/oradata/auxdb/testdb_indx_415_929807243.dbf';
set newname for datafile  20 to '/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf';
set newname for datafile  21 to '/u02_oracle/oradata/auxdb/testdb_stats_data_373_929799647.dbf';
set newname for datafile  22 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_368_929790455.dbf';
set newname for datafile  23 to '/u02_oracle/oradata/auxdb/testdb_stats_data_370_929790457.dbf';
set newname for datafile  24 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_387_929799645.dbf';
set newname for datafile  25 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_392_929790455.dbf';
set newname for datafile  26 to '/u02_oracle/oradata/auxdb/testdb_stats_data_378_929790455.dbf';
set newname for datafile  27 to '/u02_oracle/oradata/auxdb/testdb_data_362_929799649.dbf';
set newname for datafile  28 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_393_929799649.dbf';
set newname for datafile  29 to '/u02_oracle/oradata/auxdb/testdb_stats_data_372_929799647.dbf';
set newname for datafile  30 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_363_929790457.dbf';
set newname for datafile  31 to '/u02_oracle/oradata/auxdb/testdb_data_391_929798073_dbf';
set newname for datafile  32 to '/u02_oracle/oradata/auxdb/testdb_indx_380_929788623_dbf';
set newname for datafile  33 to '/u02_oracle/oradata/auxdb/testdb_stats_data_381_929797911_dbf';
set newname for datafile  34 to '/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf';
set newname for datafile  35 to '/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf';
set newname for datafile  36 to '/u02_oracle/oradata/auxdb/testdb_data_411_929786877.dbf';
set newname for datafile  37 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_408_929786877.dbf';
set newname for datafile  38 to '/u02_oracle/oradata/auxdb/testdb_stats_data_412_929786877.dbf';
set newname for datafile  39 to '/u02_oracle/oradata/auxdb/testdb_stats_indx_357_934709307.dbf';
set newname for datafile  40 to '/u02_oracle/oradata/auxdb/testdb_data_352_934709389.dbf';
set newname for datafile  41 to '/u01_oracle/oradata/auxdb/testdb_indx_356_934709409.dbf';
set newname for datafile  42 to '/u01_oracle/oradata/auxdb/testdb_stats_data_355_934709513.dbf';
set newname for datafile  43 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_422_940929321.dbf';
set newname for datafile  44 to '/u01_oracle/oradata/auxdb/testdb_data_349_941729177.dbf';
set newname for datafile  45 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_323_943695277.dbf';
set newname for datafile  46 to '/u01_oracle/oradata/auxdb/testdb_stats_data_345_944043951.dbf';
set newname for datafile  47 to '/u01_oracle/oradata/auxdb/testdb_data_343_949655627.dbf';
set newname for datafile  48 to '/u01_oracle/oradata/auxdb/testdb_stats_data_342_949656003.dbf';
set newname for datafile  49 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_338_950442403.dbf';
set newname for datafile  50 to '/u01_oracle/oradata/auxdb/testdb_data_344_953213787.dbf';
set newname for datafile  51 to '/u01_oracle/oradata/auxdb/testdb_stats_data_341_953214109.dbf';
set newname for datafile  52 to '/u01_oracle/oradata/auxdb/system_379_929788623.dbf';
set newname for datafile  53 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_340_953214265.dbf';
set newname for datafile  54 to '/u01_oracle/oradata/auxdb/testdb_stats_data_339_955962771.dbf';
set newname for datafile  55 to '/u01_oracle/oradata/auxdb/testdb_data_326_955962959.dbf';
set newname for datafile  56 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_325_958296851.dbf';
set newname for datafile  57 to '/u01_oracle/oradata/auxdb/testdb_stats_data_322_962107655.dbf';
set newname for datafile  58 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_321_962107921.dbf';
set newname for datafile  59 to '/u01_oracle/oradata/auxdb/testdb_data_327_962107967.dbf';
set newname for datafile  60 to '/u01_oracle/oradata/auxdb/testdb_stats_data_347_966245375.dbf';
set newname for datafile  61 to '/u01_oracle/oradata/auxdb/testdb_indx_346_967371785.dbf';
set newname for datafile  62 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_320_967885453.dbf';
set newname for datafile  63 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_358_967885461.dbf';
set newname for datafile  64 to '/u01_oracle/oradata/auxdb/testdb_data_324_967885479;dbf';
set newname for datafile  65 to '/u01_oracle/oradata/auxdb/testdb_data_319_967885483;dbf';
set newname for datafile  66 to '/u01_oracle/oradata/auxdb/testdb_stats_data_318_970565083.dbf';
set newname for datafile  67 to '/u01_oracle/oradata/auxdb/testdb_stats_data_423_974193773.dbf';
set newname for datafile  68 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_429_974194005.dbf';
set newname for datafile  69 to '/u01_oracle/oradata/auxdb/testdb_data_430_974194123.dbf';
set newname for datafile  70 to '/u01_oracle/oradata/auxdb/testdb_stats_data_432_987068637.dbf';
set newname for datafile  71 to '/u01_oracle/oradata/auxdb/testdb_stats_data_433_987068649.dbf';
set newname for datafile  72 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_434_987068749.dbf';
set newname for datafile  73 to '/u01_oracle/oradata/auxdb/testdb_stats_indx_435_987068765.dbf';
DUPLICATE DATABASE TO auxdb BACKUP LOCATION '/u01_oracle/backup/auxdb/database_june2019' NOFILENAMECHECK;
}

Post above database will be coned and up & running. Below are the logs for full activity:

[auxdb oracle@oraclehost01 database_june2019]$ . oraenv ORACLE_SID = [auxdb] ? The Oracle base remains unchanged with value /u01/app/oracle [auxdb oracle@oraclehost01 database_june2019]$ sqlplus   SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 10 21:28:58 2019   Copyright (c) 1982, 2014, Oracle.  All rights reserved.   Enter user-name: / as sysdba Connected to an idle instance.   SYS@auxdb> startup nomount pfile='/tmp/initauxdb.ora' ORACLE instance started.   Total System Global Area 1.3959E+10 bytes Fixed Size                  7658920 bytes Variable Size            5435818584 bytes Database Buffers         8489271296 bytes Redo Buffers               25894912 bytes SYS@auxdb> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [auxdb oracle@oraclehost01 database_june2019]$ [auxdb oracle@oraclehost01 database_june2019]$ [auxdb oracle@oraclehost01 database_june2019]$ rman auxiliary /   Recovery Manager: Release 12.1.0.2.0 - Production on Wed Jul 10 21:30:09 2019   Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.   connected to auxiliary database: auxdb (not mounted)   RMAN>   RMAN>   RMAN> run{ set newname for datafile  1 to '/u02_oracle/oradata/auxdb/system_390_929799645.dbf'; 2> set newname for datafile  2 to '/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf'; set newname for datafile  3 to '/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf'; set newname for datafile  4 to '/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf'; set newname for datafile  5 to '/u02_oracle/oradata/auxdb/users_413_929786877.dbf'; set newname for datafile  6 to '/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf'; 3> set newname for datafile  7 to '/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf'; set newname for datafile  8 to '/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf'; 4> 5> set newname for datafile  9 to '/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf'; 6> 7> set newname for datafile  10 to '/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf'; 8> set newname for datafile  11 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf'; 9> set newname for datafile  12 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf'; 10> set newname for datafile  13 to '/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf'; set newname for datafile  14 to '/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf'; 11> set newname for datafile  15 to '/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf'; set newname for datafile  16 to '/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf'; set newname for datafile  17 to '/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf'; set newname for datafile  18 to '/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf'; 12> set newname for datafile  19 to '/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf'; 13> 14> set newname for datafile  20 to '/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf'; 15> 16> set newname for datafile  21 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf'; set newname for datafile  22 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf'; set newname for datafile  23 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf'; 17> set newname for datafile  24 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf'; set newname for datafile  25 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf'; 18> set newname for datafile  26 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf'; set newname for datafile  27 to '/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf'; 19> 20> set newname for datafile  28 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf'; 21> set newname for datafile  29 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf'; set newname for datafile  30 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf'; set newname for datafile  31 to '/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf'; 22> set newname for datafile  32 to '/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf'; 23> set newname for datafile  33 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf'; set newname for datafile  34 to '/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf'; 24> set newname for datafile  35 to '/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf'; 25> set newname for datafile  36 to '/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf'; 26> set newname for datafile  37 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf'; set newname for datafile  38 to '/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf'; 27> set newname for datafile  39 to '/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf'; set newname for datafile  40 to '/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf'; 28> set newname for datafile  41 to '/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf'; set newname for datafile  42 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf'; set newname for datafile  43 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf'; 29> set newname for datafile  44 to '/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf'; 30> set newname for datafile  45 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf'; 31> 32> set newname for datafile  46 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf'; 33> set newname for datafile  47 to '/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf'; set newname for datafile  48 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf'; set newname for datafile  49 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf'; 34> set newname for datafile  50 to '/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf'; 35> set newname for datafile  51 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf'; set newname for datafile  52 to '/u01_oracle/oradata/auxdb/system_379_929788623.dbf'; set newname for datafile  53 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf'; 36> set newname for datafile  54 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf'; 37> set newname for datafile  55 to '/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf'; 38> set newname for datafile  56 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf'; 39> set newname for datafile  57 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf'; 40> set newname for datafile  58 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf'; set newname for datafile  59 to '/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf'; set newname for datafile  60 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf'; 41> set newname for datafile  61 to '/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf'; set newname for datafile  62 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf'; 42> 43> set newname for datafile  63 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf'; set newname for datafile  64 to '/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf'; 44> set newname for datafile  65 to '/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf'; 45> set newname for datafile  66 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf'; set newname for datafile  67 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf'; set newname for datafile  68 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf'; set newname for datafile  69 to '/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf'; set newname for datafile  70 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf'; 46> set newname for datafile  71 to '/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf'; 47> set newname for datafile  72 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf'; 48> 49> set newname for datafile  73 to '/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.dbf'; 50> DUPLICATE DATABASE TO auxdb BACKUP LOCATION '/u01_oracle/backup/auxdb/database_june2019' NOFILENAMECHECK; 51> }52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76>   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   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   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   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   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   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   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 Duplicate Db at 10-JUL-19   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   13958643712 bytes   Fixed Size                     7658920 bytes Variable Size               2281701976 bytes Database Buffers           11643387904 bytes Redo Buffers                  25894912 bytes   contents of Memory Script: {    sql clone "alter system set  db_name =  ''TRGDB'' comment=  ''Modified by RMAN duplicate'' scope=spfile";    sql clone "alter system set  db_unique_name =  ''auxdb'' comment=  ''Modified by RMAN duplicate'' scope=spfile";    shutdown clone immediate;    startup clone force nomount    restore clone primary controlfile from  '/u01_oracle/backup/auxdb/database_june2019/TRGDB-cf-eku597ao_1_1';    alter clone database mount; } executing Memory Script   sql statement: alter system set  db_name =  ''TRGDB'' comment= ''Modified by RMAN duplicate'' scope=spfile   sql statement: alter system set  db_unique_name =  ''auxdb'' comment= ''Modified by RMAN duplicate'' scope=spfile   Oracle instance shut down   Oracle instance started   Total System Global Area   13958643712 bytes   Fixed Size                     7658920 bytes Variable Size               2281701976 bytes Database Buffers           11643387904 bytes Redo Buffers                  25894912 bytes   Starting restore at 10-JUL-19 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=211 device type=DISK   channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 output file name=/u01/oradata/auxdb/controlfile/auxdb01.ctl output file name=/u01/app/oracte/fast_recovery_area/auxdb/controlfile/auxdb02.ctl Finished restore at 10-JUL-19   database mounted released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=211 device type=DISK   contents of Memory Script: {    set until scn  119788740350;    set newname for datafile  1 to  "/u02_oracle/oradata/auxdb/system_390_929799645.dbf";    set newname for datafile  2 to  "/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf";    set newname for datafile  3 to  "/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf";    set newname for datafile  4 to  "/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf";    set newname for datafile  5 to  "/u02_oracle/oradata/auxdb/users_413_929786877.dbf";    set newname for datafile  6 to  "/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf";    set newname for datafile  7 to  "/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf";    set newname for datafile  8 to  "/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf";    set newname for datafile  9 to  "/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf";    set newname for datafile  10 to  "/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf";    set newname for datafile  11 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf";    set newname for datafile  12 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf";    set newname for datafile  13 to  "/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf";    set newname for datafile  14 to  "/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf";    set newname for datafile  15 to  "/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf";    set newname for datafile  16 to  "/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf";    set newname for datafile  17 to  "/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf";    set newname for datafile  18 to  "/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf";    set newname for datafile  19 to  "/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf";    set newname for datafile  20 to  "/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf";    set newname for datafile  21 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf";    set newname for datafile  22 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf";    set newname for datafile  23 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf";    set newname for datafile  24 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf";    set newname for datafile  25 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf";    set newname for datafile  26 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf";    set newname for datafile  27 to  "/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf";    set newname for datafile  28 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf";    set newname for datafile  29 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf";    set newname for datafile  30 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf";    set newname for datafile  31 to  "/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf";    set newname for datafile  32 to  "/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf";    set newname for datafile  33 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf";    set newname for datafile  34 to  "/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf";    set newname for datafile  35 to  "/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf";    set newname for datafile  36 to  "/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf";    set newname for datafile  37 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf";    set newname for datafile  38 to  "/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf";    set newname for datafile  39 to  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf";    set newname for datafile  40 to  "/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf";    set newname for datafile  41 to  "/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf";    set newname for datafile  42 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf";    set newname for datafile  43 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf";    set newname for datafile  44 to  "/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf";    set newname for datafile  45 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf";    set newname for datafile  46 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf";    set newname for datafile  47 to  "/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf";    set newname for datafile  48 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf";    set newname for datafile  49 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf";    set newname for datafile  50 to  "/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf";    set newname for datafile  51 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf";    set newname for datafile  52 to  "/u01_oracle/oradata/auxdb/system_379_929788623.dbf";    set newname for datafile  53 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf";    set newname for datafile  54 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf";    set newname for datafile  55 to  "/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf";    set newname for datafile  56 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf";    set newname for datafile  57 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf";    set newname for datafile  58 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf";    set newname for datafile  59 to  "/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf";    set newname for datafile  60 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf";    set newname for datafile  61 to  "/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf";    set newname for datafile  62 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf";    set newname for datafile  63 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf";    set newname for datafile  64 to  "/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf";    set newname for datafile  65 to  "/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf";    set newname for datafile  66 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf";    set newname for datafile  67 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf";    set newname for datafile  68 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf";    set newname for datafile  69 to  "/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf";    set newname for datafile  70 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf";    set newname for datafile  71 to  "/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf";    set newname for datafile  72 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf";    set newname for datafile  73 to  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.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   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   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   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   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   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   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 10-JUL-19 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 /u02_oracle/oradata/auxdb/system_390_929799645.dbf channel ORA_AUX_DISK_1: restoring datafile 00032 to /u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf channel ORA_AUX_DISK_1: restoring datafile 00036 to /u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00041 to /u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf channel ORA_AUX_DISK_1: restoring datafile 00069 to /u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-egu596n6_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-egu596n6_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:31: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 /u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf channel ORA_AUX_DISK_1: restoring datafile 00009 to /u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf channel ORA_AUX_DISK_1: restoring datafile 00047 to /u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf channel ORA_AUX_DISK_1: restoring datafile 00054 to /u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf channel ORA_AUX_DISK_1: restoring datafile 00058 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e8u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e8u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:35:45 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 00004 to /u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf channel ORA_AUX_DISK_1: restoring datafile 00005 to /u02_oracle/oradata/auxdb/users_413_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00006 to /u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00013 to /u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf channel ORA_AUX_DISK_1: restoring datafile 00014 to /u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e4u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e4u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:18: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 00017 to /u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf channel ORA_AUX_DISK_1: restoring datafile 00048 to /u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf channel ORA_AUX_DISK_1: restoring datafile 00060 to /u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf channel ORA_AUX_DISK_1: restoring datafile 00066 to /u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf channel ORA_AUX_DISK_1: restoring datafile 00072 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e9u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e9u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:15:26 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 00018 to /u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf channel ORA_AUX_DISK_1: restoring datafile 00030 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf channel ORA_AUX_DISK_1: restoring datafile 00050 to /u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf channel ORA_AUX_DISK_1: restoring datafile 00056 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf channel ORA_AUX_DISK_1: restoring datafile 00068 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ecu5957k_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ecu5957k_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:13:16 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 00003 to /u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf channel ORA_AUX_DISK_1: restoring datafile 00007 to /u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00008 to /u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e3u59566_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e3u59566_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 01:39:26 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 00010 to /u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf channel ORA_AUX_DISK_1: restoring datafile 00020 to /u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf channel ORA_AUX_DISK_1: restoring datafile 00029 to /u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf channel ORA_AUX_DISK_1: restoring datafile 00038 to /u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00064 to /u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-efu596dk_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-efu596dk_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:41:56 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 00011 to /u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf channel ORA_AUX_DISK_1: restoring datafile 00016 to /u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00024 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf channel ORA_AUX_DISK_1: restoring datafile 00039 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf channel ORA_AUX_DISK_1: restoring datafile 00065 to /u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-eau59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-eau59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:38:15 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 00012 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf channel ORA_AUX_DISK_1: restoring datafile 00025 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf channel ORA_AUX_DISK_1: restoring datafile 00040 to /u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf channel ORA_AUX_DISK_1: restoring datafile 00061 to /u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf channel ORA_AUX_DISK_1: restoring datafile 00070 to /u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e7u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e7u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:46: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 00019 to /u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf channel ORA_AUX_DISK_1: restoring datafile 00034 to /u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf channel ORA_AUX_DISK_1: restoring datafile 00044 to /u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf channel ORA_AUX_DISK_1: restoring datafile 00045 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf channel ORA_AUX_DISK_1: restoring datafile 00063 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-eeu59643_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-eeu59643_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:34:26 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 00026 to /u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf channel ORA_AUX_DISK_1: restoring datafile 00042 to /u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf channel ORA_AUX_DISK_1: restoring datafile 00049 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf channel ORA_AUX_DISK_1: restoring datafile 00057 to /u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf channel ORA_AUX_DISK_1: restoring datafile 00067 to /u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-edu595jc_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-edu595jc_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:36:35 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 00015 to /u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf channel ORA_AUX_DISK_1: restoring datafile 00023 to /u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf channel ORA_AUX_DISK_1: restoring datafile 00028 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf channel ORA_AUX_DISK_1: restoring datafile 00051 to /u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf channel ORA_AUX_DISK_1: restoring datafile 00055 to /u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ehu596vf_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ehu596vf_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:35:35 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 00021 to /u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf channel ORA_AUX_DISK_1: restoring datafile 00031 to /u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf channel ORA_AUX_DISK_1: restoring datafile 00043 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf channel ORA_AUX_DISK_1: restoring datafile 00059 to /u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf channel ORA_AUX_DISK_1: restoring datafile 00071 to /u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e6u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e6u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:37: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 00022 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf channel ORA_AUX_DISK_1: restoring datafile 00033 to /u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf channel ORA_AUX_DISK_1: restoring datafile 00035 to /u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf channel ORA_AUX_DISK_1: restoring datafile 00037 to /u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf channel ORA_AUX_DISK_1: restoring datafile 00052 to /u01_oracle/oradata/auxdb/system_379_929788623.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ebu5957k_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-ebu5957k_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:31: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 00027 to /u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf channel ORA_AUX_DISK_1: restoring datafile 00046 to /u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf channel ORA_AUX_DISK_1: restoring datafile 00053 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf channel ORA_AUX_DISK_1: restoring datafile 00062 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf channel ORA_AUX_DISK_1: restoring datafile 00073 to /u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e5u59567_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-dbf-e5u59567_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:36:45 Finished restore at 11-JUL-19   contents of Memory Script: {    switch clone datafile all; } executing Memory Script   datafile 1 switched to datafile copy input datafile copy RECID=74 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/system_390_929799645.dbf datafile 2 switched to datafile copy input datafile copy RECID=75 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf datafile 3 switched to datafile copy input datafile copy RECID=76 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf datafile 4 switched to datafile copy input datafile copy RECID=77 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf datafile 5 switched to datafile copy input datafile copy RECID=78 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/users_413_929786877.dbf datafile 6 switched to datafile copy input datafile copy RECID=79 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf datafile 7 switched to datafile copy input datafile copy RECID=80 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf datafile 8 switched to datafile copy input datafile copy RECID=81 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf datafile 9 switched to datafile copy input datafile copy RECID=82 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf datafile 10 switched to datafile copy input datafile copy RECID=83 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf datafile 11 switched to datafile copy input datafile copy RECID=84 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf datafile 12 switched to datafile copy input datafile copy RECID=85 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf datafile 13 switched to datafile copy input datafile copy RECID=86 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf datafile 14 switched to datafile copy input datafile copy RECID=87 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf datafile 15 switched to datafile copy input datafile copy RECID=88 STAMP=1013334220 file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf datafile 16 switched to datafile copy input datafile copy RECID=89 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf datafile 17 switched to datafile copy input datafile copy RECID=90 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf datafile 18 switched to datafile copy input datafile copy RECID=91 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf datafile 19 switched to datafile copy input datafile copy RECID=92 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf datafile 20 switched to datafile copy input datafile copy RECID=93 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf datafile 21 switched to datafile copy input datafile copy RECID=94 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf datafile 22 switched to datafile copy input datafile copy RECID=95 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf datafile 23 switched to datafile copy input datafile copy RECID=96 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf datafile 24 switched to datafile copy input datafile copy RECID=97 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf datafile 25 switched to datafile copy input datafile copy RECID=98 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf datafile 26 switched to datafile copy input datafile copy RECID=99 STAMP=1013334221 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf datafile 27 switched to datafile copy input datafile copy RECID=100 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf datafile 28 switched to datafile copy input datafile copy RECID=101 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf datafile 29 switched to datafile copy input datafile copy RECID=102 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf datafile 30 switched to datafile copy input datafile copy RECID=103 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf datafile 31 switched to datafile copy input datafile copy RECID=104 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf datafile 32 switched to datafile copy input datafile copy RECID=105 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf datafile 33 switched to datafile copy input datafile copy RECID=106 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf datafile 34 switched to datafile copy input datafile copy RECID=107 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf datafile 35 switched to datafile copy input datafile copy RECID=108 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf datafile 36 switched to datafile copy input datafile copy RECID=109 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf datafile 37 switched to datafile copy input datafile copy RECID=110 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf datafile 38 switched to datafile copy input datafile copy RECID=111 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf datafile 39 switched to datafile copy input datafile copy RECID=112 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf datafile 40 switched to datafile copy input datafile copy RECID=113 STAMP=1013334224 file name=/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf datafile 41 switched to datafile copy input datafile copy RECID=114 STAMP=1013334224 file name=/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf datafile 42 switched to datafile copy input datafile copy RECID=115 STAMP=1013334224 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf datafile 43 switched to datafile copy input datafile copy RECID=116 STAMP=1013334224 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf datafile 44 switched to datafile copy input datafile copy RECID=117 STAMP=1013334224 file name=/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf datafile 45 switched to datafile copy input datafile copy RECID=118 STAMP=1013334224 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf datafile 46 switched to datafile copy input datafile copy RECID=119 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf datafile 47 switched to datafile copy input datafile copy RECID=120 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf datafile 48 switched to datafile copy input datafile copy RECID=121 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf datafile 49 switched to datafile copy input datafile copy RECID=122 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf datafile 50 switched to datafile copy input datafile copy RECID=123 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf datafile 51 switched to datafile copy input datafile copy RECID=124 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf datafile 52 switched to datafile copy input datafile copy RECID=125 STAMP=1013334227 file name=/u01_oracle/oradata/auxdb/system_379_929788623.dbf datafile 53 switched to datafile copy input datafile copy RECID=126 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf datafile 54 switched to datafile copy input datafile copy RECID=127 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf datafile 55 switched to datafile copy input datafile copy RECID=128 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf datafile 56 switched to datafile copy input datafile copy RECID=129 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf datafile 57 switched to datafile copy input datafile copy RECID=130 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf datafile 58 switched to datafile copy input datafile copy RECID=131 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf datafile 59 switched to datafile copy input datafile copy RECID=132 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf datafile 60 switched to datafile copy input datafile copy RECID=133 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf datafile 61 switched to datafile copy input datafile copy RECID=134 STAMP=1013334229 file name=/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf datafile 62 switched to datafile copy input datafile copy RECID=135 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf datafile 63 switched to datafile copy input datafile copy RECID=136 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf datafile 64 switched to datafile copy input datafile copy RECID=137 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf datafile 65 switched to datafile copy input datafile copy RECID=138 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf datafile 66 switched to datafile copy input datafile copy RECID=139 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf datafile 67 switched to datafile copy input datafile copy RECID=140 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf datafile 68 switched to datafile copy input datafile copy RECID=141 STAMP=1013334230 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf datafile 69 switched to datafile copy input datafile copy RECID=142 STAMP=1013334231 file name=/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf datafile 70 switched to datafile copy input datafile copy RECID=143 STAMP=1013334231 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf datafile 71 switched to datafile copy input datafile copy RECID=144 STAMP=1013334231 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf datafile 72 switched to datafile copy input datafile copy RECID=145 STAMP=1013334231 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf datafile 73 switched to datafile copy input datafile copy RECID=146 STAMP=1013334231 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.dbf   contents of Memory Script: {    set until scn  119788740350;    recover    clone database     delete archivelog    ; } executing Memory Script   executing command: SET until clause   Starting recover at 11-JUL-19 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=93675 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264032 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f3u59b51_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f3u59b51_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:25 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93675_929810727.dbf thread=1 sequence=93675 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264032_929810727.dbf thread=2 sequence=264032 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264032_929810727.dbf RECID=2 STAMP=1013334319 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264033 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-eou59a9n_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-eou59a9n_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264033_929810727.dbf thread=2 sequence=264033 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264033_929810727.dbf RECID=3 STAMP=1013334556 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264034 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-enu59a9n_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-enu59a9n_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264034_929810727.dbf thread=2 sequence=264034 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93675_929810727.dbf RECID=1 STAMP=1013334247 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=93676 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264035 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93677 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264036 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93678 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93679 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93681 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f8u59b51_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f8u59b51_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93676_929810727.dbf thread=1 sequence=93676 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264034_929810727.dbf RECID=4 STAMP=1013334710 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264035_929810727.dbf thread=2 sequence=264035 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93676_929810727.dbf RECID=11 STAMP=1013334734 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93677_929810727.dbf thread=1 sequence=93677 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264035_929810727.dbf RECID=10 STAMP=1013334733 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264036_929810727.dbf thread=2 sequence=264036 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93677_929810727.dbf RECID=6 STAMP=1013334724 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93678_929810727.dbf thread=1 sequence=93678 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93678_929810727.dbf RECID=7 STAMP=1013334724 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93679_929810727.dbf thread=1 sequence=93679 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264036_929810727.dbf RECID=8 STAMP=1013334724 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264037 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93680 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93682 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-etu59a9o_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-etu59a9o_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264037_929810727.dbf thread=2 sequence=264037 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93679_929810727.dbf RECID=5 STAMP=1013334724 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93680_929810727.dbf thread=1 sequence=93680 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93680_929810727.dbf RECID=13 STAMP=1013334925 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93681_929810727.dbf thread=1 sequence=93681 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93681_929810727.dbf RECID=9 STAMP=1013334724 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93682_929810727.dbf thread=1 sequence=93682 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93682_929810727.dbf RECID=14 STAMP=1013334925 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=93683 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93684 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93685 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264040 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93686 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-fau59b66_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-fau59b66_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93683_929810727.dbf thread=1 sequence=93683 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93683_929810727.dbf RECID=18 STAMP=1013334927 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93684_929810727.dbf thread=1 sequence=93684 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264037_929810727.dbf RECID=12 STAMP=1013334925 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264038 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264039 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-evu59aa7_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-evu59aa7_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264038_929810727.dbf thread=2 sequence=264038 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93684_929810727.dbf RECID=17 STAMP=1013334927 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93685_929810727.dbf thread=1 sequence=93685 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264038_929810727.dbf RECID=21 STAMP=1013334928 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264039_929810727.dbf thread=2 sequence=264039 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264039_929810727.dbf RECID=20 STAMP=1013334928 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264040_929810727.dbf thread=2 sequence=264040 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264040_929810727.dbf RECID=19 STAMP=1013334927 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264041 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264042 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264043 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-euu59aa7_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-euu59aa7_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264041_929810727.dbf thread=2 sequence=264041 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264041_929810727.dbf RECID=22 STAMP=1013334930 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264042_929810727.dbf thread=2 sequence=264042 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93685_929810727.dbf RECID=16 STAMP=1013334927 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93686_929810727.dbf thread=1 sequence=93686 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264042_929810727.dbf RECID=24 STAMP=1013334930 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264043_929810727.dbf thread=2 sequence=264043 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93686_929810727.dbf RECID=15 STAMP=1013334927 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=93687 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93688 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264044 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93689 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93690 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264045 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93691 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264046 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264047 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=93692 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f9u59b64_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-f9u59b64_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93687_929810727.dbf thread=1 sequence=93687 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93687_929810727.dbf RECID=34 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93688_929810727.dbf thread=1 sequence=93688 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264043_929810727.dbf RECID=23 STAMP=1013334930 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264044_929810727.dbf thread=2 sequence=264044 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93688_929810727.dbf RECID=29 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93689_929810727.dbf thread=1 sequence=93689 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93689_929810727.dbf RECID=33 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93690_929810727.dbf thread=1 sequence=93690 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264044_929810727.dbf RECID=27 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264045_929810727.dbf thread=2 sequence=264045 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93690_929810727.dbf RECID=31 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93691_929810727.dbf thread=1 sequence=93691 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264045_929810727.dbf RECID=32 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264046_929810727.dbf thread=2 sequence=264046 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264046_929810727.dbf RECID=26 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264047_929810727.dbf thread=2 sequence=264047 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93691_929810727.dbf RECID=25 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93692_929810727.dbf thread=1 sequence=93692 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93692_929810727.dbf RECID=30 STAMP=1013334932 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=93693 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=264048 channel ORA_AUX_DISK_1: reading from backup piece /u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-fbu59b67_1_1 channel ORA_AUX_DISK_1: piece handle=/u01_oracle/backup/auxdb/database_june2019/TRGDB-arc-fbu59b67_1_1 tag=JAN2019_PATCHING channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93693_929810727.dbf thread=1 sequence=93693 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264047_929810727.dbf RECID=28 STAMP=1013334932 archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264048_929810727.dbf thread=2 sequence=264048 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/1_93693_929810727.dbf RECID=35 STAMP=1013334936 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch/2_264048_929810727.dbf RECID=36 STAMP=1013334936 media recovery complete, elapsed time: 00:00:01 Finished recover at 11-JUL-19 Oracle instance started   Total System Global Area   13958643712 bytes   Fixed Size                     7658920 bytes Variable Size               2281701976 bytes Database Buffers           11643387904 bytes Redo Buffers                  25894912 bytes   contents of Memory Script: {    sql clone "alter system set  db_name =  ''auxdb'' 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 =  ''auxdb'' 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   13958643712 bytes   Fixed Size                     7658920 bytes Variable Size               2281701976 bytes Database Buffers           11643387904 bytes Redo Buffers                  25894912 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "auxdb" RESETLOGS ARCHIVELOG   MAXLOGFILES   1024   MAXLOGMEMBERS      5   MAXDATAFILES    32767   MAXINSTANCES    32   MAXLOGHISTORY   264096  LOGFILE   GROUP   1 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_1.3139.939139153', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_1.374.939139151' ) SIZE 4 G  REUSE,   GROUP   2 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_2.3134.929975643', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_2.404.929810855' ) SIZE 4 G  REUSE,   GROUP   3 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_3.3124.929975649', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_3.416.929811017' ) SIZE 4 G  REUSE,   GROUP   4 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_4.3116.929975655', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_4.417.929811161' ) SIZE 4 G  REUSE,   GROUP   5 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_5.418.939916727', '/u01/oradata/auxdb/TRGDB/onlinelog/group_5.3079.939916729' ) SIZE 4 G  REUSE,   GROUP   6 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_6.419.939916873', '/u01/oradata/auxdb/TRGDB/onlinelog/group_6.3080.939916877' ) SIZE 4 G  REUSE,   GROUP   7 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_7.3082.969711191', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_7.420.969711195' ) SIZE 4 G  REUSE,   GROUP   8 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_8.421.969711203', '/u01/oradata/auxdb/TRGDB/onlinelog/group_8.11774.969711199' ) SIZE 4 G  REUSE  DATAFILE   '/u02_oracle/oradata/auxdb/system_390_929799645.dbf'  CHARACTER SET AL32UTF8   sql statement: ALTER DATABASE ADD LOGFILE                 INSTANCE 'i2'   GROUP   9 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_9.301.969710753', '/u01/oradata/auxdb/TRGDB/onlinelog/group_9.326.969710751' ) SIZE 4 G  REUSE,   GROUP  10 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_10.316.969710783', '/u01/oradata/auxdb/TRGDB/onlinelog/group_10.1546.969710779' ) SIZE 4 G  REUSE,   GROUP  11 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_11.1703.969710849', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_11.332.969710853' ) SIZE 4 G  REUSE,   GROUP  12 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_12.331.969710859', '/u01/oradata/auxdb/TRGDB/onlinelog/group_12.1728.969710855' ) SIZE 4 G  REUSE,   GROUP  13 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_13.14309.969710863', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_13.329.969710865' ) SIZE 4 G  REUSE,   GROUP  14 ( '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_14.330.969710873', '/u01/oradata/auxdb/TRGDB/onlinelog/group_14.8794.969710869' ) SIZE 4 G  REUSE,   GROUP  15 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_15.13745.969710875', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_15.336.969710879' ) SIZE 4 G  REUSE,   GROUP  16 ( '/u01/oradata/auxdb/TRGDB/onlinelog/group_16.11888.969710883', '/u01/app/oracle/fast_recovery_area/auxdb/TRGDB/onlinelog/group_16.333.969710885' ) SIZE 4 G  REUSE   contents of Memory Script: {    set newname for tempfile  1 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.431.985599429";    set newname for tempfile  2 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.335.935840463";    set newname for tempfile  3 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.436.1004628235";    set newname for tempfile  4 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.437.1004637527";    set newname for tempfile  5 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.438.1004637531";    set newname for tempfile  6 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.439.1004637533";    set newname for tempfile  7 to  "/u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.440.1004637551";    switch clone tempfile all;    catalog clone datafilecopy  "/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf",  "/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf",  "/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf",  "/u02_oracle/oradata/auxdb/users_413_929786877.dbf",  "/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf",  "/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf",  "/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf",  "/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf",  "/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf",  "/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf",  "/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf",  "/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf",  "/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf",  "/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf",  "/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf",  "/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf",  "/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf",  "/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf",  "/u01_oracle/oradata/auxdb/system_379_929788623.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf",  "/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf",  "/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf",  "/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.dbf";    switch clone datafile all; } 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   renamed tempfile 1 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.431.985599429 in control file renamed tempfile 2 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.335.935840463 in control file renamed tempfile 3 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.436.1004628235 in control file renamed tempfile 4 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.437.1004637527 in control file renamed tempfile 5 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.438.1004637531 in control file renamed tempfile 6 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.439.1004637533 in control file renamed tempfile 7 to /u02_oracle/oradata/auxdb/TRGDB/tempfile/temp2.440.1004637551 in control file   cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf RECID=1 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf RECID=2 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf RECID=3 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/users_413_929786877.dbf RECID=4 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf RECID=5 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf RECID=6 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf RECID=7 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf RECID=8 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf RECID=9 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf RECID=10 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf RECID=11 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf RECID=12 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf RECID=13 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf RECID=14 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf RECID=15 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf RECID=16 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf RECID=17 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf RECID=18 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf RECID=19 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf RECID=20 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf RECID=21 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf RECID=22 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf RECID=23 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf RECID=24 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf RECID=25 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf RECID=26 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf RECID=27 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf RECID=28 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf RECID=29 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf RECID=30 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf RECID=31 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf RECID=32 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf RECID=33 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf RECID=34 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf RECID=35 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf RECID=36 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf RECID=37 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf RECID=38 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf RECID=39 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf RECID=40 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf RECID=41 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf RECID=42 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf RECID=43 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf RECID=44 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf RECID=45 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf RECID=46 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf RECID=47 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf RECID=48 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf RECID=49 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf RECID=50 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/system_379_929788623.dbf RECID=51 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf RECID=52 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf RECID=53 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf RECID=54 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf RECID=55 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf RECID=56 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf RECID=57 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf RECID=58 STAMP=1013335182 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf RECID=59 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf RECID=60 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf RECID=61 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf RECID=62 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf RECID=63 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf RECID=64 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf RECID=65 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf RECID=66 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf RECID=67 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf RECID=68 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf RECID=69 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf RECID=70 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf RECID=71 STAMP=1013335183 cataloged datafile copy datafile copy file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.dbf RECID=72 STAMP=1013335183   datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/sysaux_377_929788623.dbf datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/undotbs1_410_929786873.bf datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/undotbs2_382_929788619.bf datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/users_413_929786877.dbf datafile 6 switched to datafile copy input datafile copy RECID=5 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/ggs_admin_tbs_367_929786877.dbf datafile 7 switched to datafile copy input datafile copy RECID=6 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_admin_data_365_929786877.dbf datafile 8 switched to datafile copy input datafile copy RECID=7 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_admin_indx_383_929786877.dbf datafile 9 switched to datafile copy input datafile copy RECID=8 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_388_929790455.dbf datafile 10 switched to datafile copy input datafile copy RECID=9 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_indx_400_929799649.dbf datafile 11 switched to datafile copy input datafile copy RECID=10 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_371_929790457.dbf datafile 12 switched to datafile copy input datafile copy RECID=11 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_394_929807081.dbf datafile 13 switched to datafile copy input datafile copy RECID=12 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_cms_data_376_929788647.dbf datafile 14 switched to datafile copy input datafile copy RECID=13 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_cms_indx_384_929788647.dbf datafile 15 switched to datafile copy input datafile copy RECID=14 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_data_389_929788623.dbf datafile 16 switched to datafile copy input datafile copy RECID=15 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_cms_doc_indx_414_929786877.dbf datafile 17 switched to datafile copy input datafile copy RECID=16 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_369_929790457.dbf datafile 18 switched to datafile copy input datafile copy RECID=17 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_364_929799647.dbf datafile 19 switched to datafile copy input datafile copy RECID=18 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_indx_415_929807243.dbf datafile 20 switched to datafile copy input datafile copy RECID=19 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/wizard_ts_386_929788623.dbf datafile 21 switched to datafile copy input datafile copy RECID=20 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_373_929799647.dbf datafile 22 switched to datafile copy input datafile copy RECID=21 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_368_929790455.dbf datafile 23 switched to datafile copy input datafile copy RECID=22 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_370_929790457.dbf datafile 24 switched to datafile copy input datafile copy RECID=23 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_387_929799645.dbf datafile 25 switched to datafile copy input datafile copy RECID=24 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_392_929790455.dbf datafile 26 switched to datafile copy input datafile copy RECID=25 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_378_929790455.dbf datafile 27 switched to datafile copy input datafile copy RECID=26 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_362_929799649.dbf datafile 28 switched to datafile copy input datafile copy RECID=27 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_393_929799649.dbf datafile 29 switched to datafile copy input datafile copy RECID=28 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_372_929799647.dbf datafile 30 switched to datafile copy input datafile copy RECID=29 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_363_929790457.dbf datafile 31 switched to datafile copy input datafile copy RECID=30 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_391_929798073_dbf datafile 32 switched to datafile copy input datafile copy RECID=31 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_indx_380_929788623_dbf datafile 33 switched to datafile copy input datafile copy RECID=32 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_381_929797911_dbf datafile 34 switched to datafile copy input datafile copy RECID=33 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/undotbs01_385_929788623.dbf datafile 35 switched to datafile copy input datafile copy RECID=34 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/undotbs02_375_929788623.dbf datafile 36 switched to datafile copy input datafile copy RECID=35 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_411_929786877.dbf datafile 37 switched to datafile copy input datafile copy RECID=36 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_408_929786877.dbf datafile 38 switched to datafile copy input datafile copy RECID=37 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_data_412_929786877.dbf datafile 39 switched to datafile copy input datafile copy RECID=38 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_stats_indx_357_934709307.dbf datafile 40 switched to datafile copy input datafile copy RECID=39 STAMP=1013335182 file name=/u02_oracle/oradata/auxdb/bblearn_data_352_934709389.dbf datafile 41 switched to datafile copy input datafile copy RECID=40 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_indx_356_934709409.dbf datafile 42 switched to datafile copy input datafile copy RECID=41 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_355_934709513.dbf datafile 43 switched to datafile copy input datafile copy RECID=42 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_422_940929321.dbf datafile 44 switched to datafile copy input datafile copy RECID=43 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_data_349_941729177.dbf datafile 45 switched to datafile copy input datafile copy RECID=44 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_323_943695277.dbf datafile 46 switched to datafile copy input datafile copy RECID=45 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_345_944043951.dbf datafile 47 switched to datafile copy input datafile copy RECID=46 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_data_343_949655627.dbf datafile 48 switched to datafile copy input datafile copy RECID=47 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_342_949656003.dbf datafile 49 switched to datafile copy input datafile copy RECID=48 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_338_950442403.dbf datafile 50 switched to datafile copy input datafile copy RECID=49 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_data_344_953213787.dbf datafile 51 switched to datafile copy input datafile copy RECID=50 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_341_953214109.dbf datafile 52 switched to datafile copy input datafile copy RECID=51 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/system_379_929788623.dbf datafile 53 switched to datafile copy input datafile copy RECID=52 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_340_953214265.dbf datafile 54 switched to datafile copy input datafile copy RECID=53 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_339_955962771.dbf datafile 55 switched to datafile copy input datafile copy RECID=54 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_data_326_955962959.dbf datafile 56 switched to datafile copy input datafile copy RECID=55 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_325_958296851.dbf datafile 57 switched to datafile copy input datafile copy RECID=56 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_322_962107655.dbf datafile 58 switched to datafile copy input datafile copy RECID=57 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_321_962107921.dbf datafile 59 switched to datafile copy input datafile copy RECID=58 STAMP=1013335182 file name=/u01_oracle/oradata/auxdb/bblearn_data_327_962107967.dbf datafile 60 switched to datafile copy input datafile copy RECID=59 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_347_966245375.dbf datafile 61 switched to datafile copy input datafile copy RECID=60 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_indx_346_967371785.dbf datafile 62 switched to datafile copy input datafile copy RECID=61 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_320_967885453.dbf datafile 63 switched to datafile copy input datafile copy RECID=62 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_358_967885461.dbf datafile 64 switched to datafile copy input datafile copy RECID=63 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_data_324_967885479;dbf datafile 65 switched to datafile copy input datafile copy RECID=64 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_data_319_967885483;dbf datafile 66 switched to datafile copy input datafile copy RECID=65 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_318_970565083.dbf datafile 67 switched to datafile copy input datafile copy RECID=66 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_423_974193773.dbf datafile 68 switched to datafile copy input datafile copy RECID=67 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_429_974194005.dbf datafile 69 switched to datafile copy input datafile copy RECID=68 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_data_430_974194123.dbf datafile 70 switched to datafile copy input datafile copy RECID=69 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_432_987068637.dbf datafile 71 switched to datafile copy input datafile copy RECID=70 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_data_433_987068649.dbf datafile 72 switched to datafile copy input datafile copy RECID=71 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_434_987068749.dbf datafile 73 switched to datafile copy input datafile copy RECID=72 STAMP=1013335183 file name=/u01_oracle/oradata/auxdb/bblearn_stats_indx_435_987068765.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 Cannot remove created server parameter file Finished Duplicate Db at 11-JUL-19   RMAN>   RMAN> exit     Recovery Manager complete. [auxdb oracle@oraclehost01 database_june2019]$ . oraenv ORACLE_SID = [auxdb] ? The Oracle base remains unchanged with value /u01/app/oracle [auxdb oracle@oraclehost01 database_june2019]$ sqlplus   SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 11 10:05:02 2019   Copyright (c) 1982, 2014, Oracle.  All rights reserved.   Enter user-name: / as sysdba   Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options   SYS@auxdb> select name,open_mode from v$database;   NAME      OPEN_MODE --------- -------------------- auxdb   READ WRITE   SYS@auxdb>  Select name,host_name,open_mode,to_char(STARTUP_TIME, 'DD-MON-YYYY, HH24:SS:MM'),STATUS,ARCHIVER,VERSION from v$database,v$instance;   NAME      HOST_NAME --------- ---------------------------------------------------------------- OPEN_MODE            TO_CHAR(STARTUP_TIME,'DD-MON-Y STATUS       ARCHIVE -------------------- ------------------------------ ------------ ------- VERSION ----------------- auxdb   oraclehost01.localdomain READ WRITE           11-JUL-2019, 09:58:07          OPEN         STARTED 12.1.0.2.0     SYS@auxdb> SYS@auxdb> SYS@auxdb> SYS@auxdb> exit

You can learn more about oracle database administration: 

Pro Oracle GoldenGate for the DBA

Oracle Security Tools Installation and Configuration

Expert Oracle Exadata 

Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

       Expert Oracle RAC 12c 

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

     Please check our other blogs for Refresh