source database TROY - TROY_1, TROY_2
target database - TROY - TORY_1, TROY_2
Prerequisite - Full level 0 backup of source database including controlfile and spfile backup is taken and transfered to target serverhere we will duplicate RAC database to NON-RAC database and then we will convert that database to RAC database using RCONFIG.
due to network limitation we are not able to connect to source database so we will perform duplicate using auxiliary database only
on target server we will create a temporary pfile
*.db_name='TROY'
*.db_block_size=8192
*.remote_login_passwordfile='exclusive'
*.compatible='11.2.0.0.0'
*.control_files='+REDO','+DATA_FC'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDO'
*.db_create_online_log_dest_2='+DATA_FC'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=100G
*.diagnostic_dest=/u01/orabasemake sure you create audit file location beforehand as per your diagnostic_dest parameter value
mkdir -p /u01/orabase/admin/TROY/adumpnow start auxiliary database in nomount state suing the pfile created above
prepare rman command
run
{
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE disk;
ALLOCATE AUXILIARY CHANNEL c3 DEVICE TYPE disk;
ALLOCATE AUXILIARY CHANNEL c4 DEVICE TYPE disk;
ALLOCATE AUXILIARY CHANNEL c5 DEVICE TYPE disk;
ALLOCATE AUXILIARY CHANNEL c6 DEVICE TYPE disk;
DUPLICATE TARGET DATABASE TO TROY
spfile
set memory_max_target='13G'
set memory_target='13G'
set sga_max_size='10G'
set sga_target='10G'
set db_cache_size='2G'
set pga_aggregate_target='1G'
set shared_pool_size='1G'
set db_recovery_file_dest_size='1000G'
set CLUSTER_DATABASE='FALSE'
set audit_file_dest='/u01/orabase/admin/TROY/adump'
set CLUSTER_DATABASE='FALSE'
BACKUP LOCATION '/u01/backup/TROY_bkp/' NOFILENAMECHECK;
}you can see that we are using memory parameters here because we are using SPFILE clause which will input parameters as per source database.In our case value of memory parameters in source database is high and we don’t have that much memory on target database so we are overidding these values by defining them in rman command
set memory_max_target='13G'
set memory_target='13G'
set sga_max_size='10G'
set sga_target='10G'
set db_cache_size='2G'
set pga_aggregate_target='1G'
set shared_pool_size='1G'set CLUSTER_DATABASE=’FALSE’ is needed because you are duplicating a rac database into a signgle instance database (we will convert it later into RAC). if you do not set this parameter you will receieve this error
Rman duplicate fail with RMAN-06136, ORA-01503, ORA-12720, ORA-00494 enqueue [CF] (Doc ID 1335479.1)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/06/2020 15:25:40
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode
set db_recovery_file_dest_size=’1000G’ is needed to be set to a value of more than then the value in source. It doesn’t matter if you have that much space in your FRA but just to satisfy ego of RMAN you need to set this value otherwise you will recieve this error
Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 13466
ORA-06512: at line 1
RMAN-03015: error occurred in stored script Memory Script
RMAN-10035: exception raised in RPC:
ORA-19583: conversation terminated due to error
ORA-19870: error while restoring backup piece /u01/backup/NCP11ORT_bkp/NCP11ORT_NCP11ORT_20201006_1059.arc
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 471859200 bytes disk space from 214748364800 limit
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 2338
RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/06/2020 18:31:22
RMAN-05501: aborting duplication of target databaseBACKUP LOCATION ‘/u01/backup/TROY_bkp/’ NOFILENAMECHECK; is needed because we are not connecting to target database or catalog database.
now connect to auxiliary instance and run the duplicate.
no need to connect to target database or catlog database
rman auxiliary / cmdfile=rman_TROY.rcv log=rman_TROY.loglogfile
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Oct 6 21:25:04 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: TROY (not mounted)
RMAN> run
2> {
3> ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
4> ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE disk;
5> ALLOCATE AUXILIARY CHANNEL c3 DEVICE TYPE disk;
6> ALLOCATE AUXILIARY CHANNEL c4 DEVICE TYPE disk;
7> ALLOCATE AUXILIARY CHANNEL c5 DEVICE TYPE disk;
8> ALLOCATE AUXILIARY CHANNEL c6 DEVICE TYPE disk;
9> DUPLICATE TARGET DATABASE TO TROY
10> spfile
11> set memory_max_target='13G'
12> set memory_target='13G'
13> set sga_max_size='10G'
14> set sga_target='10G'
15> set db_cache_size='2G'
16> set pga_aggregate_target='1G'
17> set shared_pool_size='1G'
18> set db_recovery_file_dest_size='1000G'
19> set CLUSTER_DATABASE='FALSE'
20> set audit_file_dest='/u01/orabase/admin/TROY/adump'
21> set CLUSTER_DATABASE='FALSE'
22> BACKUP LOCATION '/u01/backup/TROY_bkp/' NOFILENAMECHECK;
23> }
24>
25>
allocated channel: c1
channel c1: SID=432 device type=DISK
allocated channel: c2
channel c2: SID=9 device type=DISK
allocated channel: c3
channel c3: SID=150 device type=DISK
allocated channel: c4
channel c4: SID=291 device type=DISK
allocated channel: c5
channel c5: SID=433 device type=DISK
allocated channel: c6
channel c6: SID=10 device type=DISK
Starting Duplicate Db at 06-OCT-20
contents of Memory Script:
{
restore clone spfile to '/u01/oracle/product/11.2.0.3/db_1/dbs/spfileTROY.ora' from
'/u01/backup/TROY_bkp/AUTOCTRL_TROY_c-132944012-20201006-03';
sql clone "alter system set spfile= ''/u01/oracle/product/11.2.0.3/db_1/dbs/spfileTROY.ora''";
}
executing Memory Script
Starting restore at 06-OCT-20
channel c2: skipped, AUTOBACKUP already found
channel c3: skipped, AUTOBACKUP already found
channel c4: skipped, AUTOBACKUP already found
channel c5: skipped, AUTOBACKUP already found
channel c6: skipped, AUTOBACKUP already found
channel c1: restoring spfile from AUTOBACKUP /u01/backup/TROY_bkp/AUTOCTRL_TROY_c-132944012-20201006-03
channel c1: SPFILE restore from AUTOBACKUP complete
Finished restore at 06-OCT-20
sql statement: alter system set spfile= ''/u01/oracle/product/11.2.0.3/db_1/dbs/spfileTROY.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''TROY'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set memory_max_target =
13G comment=
'''' scope=spfile";
sql clone "alter system set memory_target =
13G comment=
'''' scope=spfile";
sql clone "alter system set sga_max_size =
10G comment=
'''' scope=spfile";
sql clone "alter system set sga_target =
10G comment=
'''' scope=spfile";
sql clone "alter system set db_cache_size =
2G comment=
'''' scope=spfile";
sql clone "alter system set pga_aggregate_target =
1G comment=
'''' scope=spfile";
sql clone "alter system set shared_pool_size =
1G comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest_size =
1000G comment=
'''' scope=spfile";
sql clone "alter system set CLUSTER_DATABASE =
FALSE comment=
'''' scope=spfile";
sql clone "alter system set audit_file_dest =
''/u01/orabase/admin/TROY/adump'' comment=
'''' scope=spfile";
sql clone "alter system set CLUSTER_DATABASE =
FALSE comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''TROY'' comment= ''duplicate'' scope=spfile
sql statement: alter system set memory_max_target = 13G comment= '''' scope=spfile
sql statement: alter system set memory_target = 13G comment= '''' scope=spfile
sql statement: alter system set sga_max_size = 10G comment= '''' scope=spfile
sql statement: alter system set sga_target = 10G comment= '''' scope=spfile
sql statement: alter system set db_cache_size = 2G comment= '''' scope=spfile
sql statement: alter system set pga_aggregate_target = 1G comment= '''' scope=spfile
sql statement: alter system set shared_pool_size = 1G comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest_size = 1000G comment= '''' scope=spfile
sql statement: alter system set CLUSTER_DATABASE = FALSE comment= '''' scope=spfile
sql statement: alter system set audit_file_dest = ''/u01/orabase/admin/TROY/adump'' comment= '''' scope=spfile
sql statement: alter system set CLUSTER_DATABASE = FALSE comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 10689474560 bytes
Fixed Size 2237776 bytes
Variable Size 1174407856 bytes
Database Buffers 9495904256 bytes
Redo Buffers 16924672 bytes
allocated channel: c1
channel c1: SID=919 device type=DISK
allocated channel: c2
channel c2: SID=8 device type=DISK
allocated channel: c3
channel c3: SID=313 device type=DISK
allocated channel: c4
channel c4: SID=620 device type=DISK
allocated channel: c5
channel c5: SID=928 device type=DISK
allocated channel: c6
channel c6: SID=9 device type=DISK
contents of Memory Script:
{
sql clone "alter system set control_files =
''+REDO/TROY/controlfile/current.306.1053120335'', ''+DATA_FC/TROY/controlfile/current.306.1053120335'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''TROY'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''TROY'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/u01/backup/TROY_bkp/AUTOCTRL_TROY_TROY_20201006_1049_1.RMAN';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+REDO/TROY/controlfile/current.306.1053120335'', ''+DATA_FC/TROY/controlfile/current.306.1053120335'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''TROY'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''TROY'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 10689474560 bytes
Fixed Size 2237776 bytes
Variable Size 1174407856 bytes
Database Buffers 9495904256 bytes
Redo Buffers 16924672 bytes
allocated channel: c1
channel c1: SID=919 device type=DISK
allocated channel: c2
channel c2: SID=8 device type=DISK
allocated channel: c3
channel c3: SID=313 device type=DISK
allocated channel: c4
channel c4: SID=620 device type=DISK
allocated channel: c5
channel c5: SID=928 device type=DISK
allocated channel: c6
channel c6: SID=9 device type=DISK
Starting restore at 06-OCT-20
channel c2: skipped, AUTOBACKUP already found
channel c3: skipped, AUTOBACKUP already found
channel c4: skipped, AUTOBACKUP already found
channel c5: skipped, AUTOBACKUP already found
channel c6: skipped, AUTOBACKUP already found
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:00:10
output file name=+REDO/TROY/controlfile/current.306.1053120335
output file name=+DATA_FC/TROY/controlfile/current.306.1053120335
Finished restore at 06-OCT-20
database mounted
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set until scn 17222041908083;
set newname for datafile 1 to
"+data";
set newname for datafile 2 to
"+data";
set newname for datafile 3 to
"+data";
set newname for datafile 4 to
"+data";
set newname for datafile 5 to
"+data";
set newname for datafile 6 to
"+data";
set newname for datafile 7 to
"+data";
set newname for datafile 8 to
"+data";
set newname for datafile 9 to
"+data";
set newname for datafile 10 to
"+data";
set newname for datafile 11 to
"+data";
set newname for datafile 12 to
"+data";
set newname for datafile 13 to
"+data";
set newname for datafile 14 to
"+data";
set newname for datafile 15 to
"+data";
set newname for datafile 16 to
"+data";
set newname for datafile 17 to
"+data";
set newname for datafile 18 to
"+data";
set newname for datafile 19 to
"+data";
set newname for datafile 20 to
"+data";
set newname for datafile 21 to
"+data";
set newname for datafile 22 to
"+data";
set newname for datafile 23 to
"+data";
set newname for datafile 24 to
"+data";
set newname for datafile 25 to
"+data";
set newname for datafile 26 to
"+data";
set newname for datafile 27 to
"+data";
set newname for datafile 28 to
"+data";
set newname for datafile 29 to
"+data";
set newname for datafile 30 to
"+data";
set newname for datafile 31 to
"+data";
set newname for datafile 32 to
"+data";
set newname for datafile 33 to
"+data";
set newname for datafile 34 to
"+data";
set newname for datafile 35 to
"+data";
set newname for datafile 36 to
"+data";
set newname for datafile 37 to
"+data";
set newname for datafile 38 to
"+data";
set newname for datafile 39 to
"+data";
set newname for datafile 40 to
"+data";
set newname for datafile 41 to
"+data";
set newname for datafile 42 to
"+data";
set newname for datafile 43 to
"+data";
set newname for datafile 44 to
"+data";
set newname for datafile 45 to
"+data";
set newname for datafile 46 to
"+data";
set newname for datafile 47 to
"+data";
set newname for datafile 48 to
"+data";
set newname for datafile 49 to
"+data";
set newname for datafile 50 to
"+data";
set newname for datafile 51 to
"+data";
set newname for datafile 52 to
"+data";
set newname for datafile 53 to
"+data";
set newname for datafile 54 to
"+data";
set newname for datafile 55 to
"+data";
set newname for datafile 56 to
"+data";
set newname for datafile 57 to
"+data";
set newname for datafile 58 to
"+data";
set newname for datafile 59 to
"+data";
set newname for datafile 60 to
"+data";
set newname for datafile 61 to
"+data";
set newname for datafile 62 to
"+data";
set newname for datafile 63 to
"+data";
set newname for datafile 64 to
"+data";
set newname for datafile 65 to
"+data";
set newname for datafile 66 to
"+data";
set newname for datafile 67 to
"+data";
set newname for datafile 68 to
"+data";
set newname for datafile 69 to
"+data";
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
Starting restore at 06-OCT-20
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +data
channel c1: restoring datafile 00026 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1016_1.RMAN
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00002 to +data
channel c2: restoring datafile 00027 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1017_1.RMAN
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00003 to +data
channel c3: restoring datafile 00039 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1018_1.RMAN
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00004 to +data
channel c4: restoring datafile 00067 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1029_1.RMAN
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00005 to +data
channel c5: restoring datafile 00040 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1015_1.RMAN
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00006 to +data
channel c6: restoring datafile 00025 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1037_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1037_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:13:55
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00007 to +data
channel c6: restoring datafile 00024 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1027_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1029_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:14:02
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00008 to +data
channel c4: restoring datafile 00053 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1028_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1016_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:14:37
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00009 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1020_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1017_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:14:37
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00010 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1045_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1018_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:15:13
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00011 to +data
channel c3: restoring datafile 00013 to +data
channel c3: restoring datafile 00014 to +data
channel c3: restoring datafile 00016 to +data
channel c3: restoring datafile 00018 to +data
channel c3: restoring datafile 00019 to +data
channel c3: restoring datafile 00020 to +data
channel c3: restoring datafile 00038 to +data
channel c3: restoring datafile 00066 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1038_1.RMAN
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1015_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:15:16
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00012 to +data
channel c5: restoring datafile 00035 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1014_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1045_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:07:14
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00015 to +data
channel c2: restoring datafile 00054 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1030_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1027_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:12:31
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00017 to +data
channel c6: restoring datafile 00068 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1031_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1028_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:13:09
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00021 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1040_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1020_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:12:41
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00022 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1022_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1038_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:18:20
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00023 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1032_1.RMAN
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1014_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:19:32
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00028 to +data
channel c5: restoring datafile 00062 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1010_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1030_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:13:22
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00029 to +data
channel c2: restoring datafile 00050 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1009_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1040_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:09:47
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00030 to +data
channel c4: restoring datafile 00041 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1008_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1022_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:12:55
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00031 to +data
channel c1: restoring datafile 00048 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1006_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1031_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:14:03
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00032 to +data
channel c6: restoring datafile 00051 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1011_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1032_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:13:31
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00033 to +data
channel c3: restoring datafile 00049 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1007_1.RMAN
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1010_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:17:11
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00034 to +data
channel c5: restoring datafile 00037 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1005_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1009_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:18:51
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00036 to +data
channel c2: restoring datafile 00045 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1012_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1008_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:19:31
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00042 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1043_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1006_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:18:20
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00043 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1041_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1011_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:18:20
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00044 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1019_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1007_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:18:50
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00046 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1042_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1043_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:09:25
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00047 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1039_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1041_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:08:25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00052 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1033_1.RMAN
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1005_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:19:26
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00055 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1023_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1019_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:13:01
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00056 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1024_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1012_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:18:51
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00057 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1034_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1042_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:09:46
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00058 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1044_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1039_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:10:21
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00059 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1047_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1033_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:12:31
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00060 to +data
channel c1: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1021_1.RMAN
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1034_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:12:20
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00061 to +data
channel c2: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1046_1.RMAN
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1024_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:13:25
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00063 to +data
channel c6: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1025_1.RMAN
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1023_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:14:25
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00064 to +data
channel c5: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1026_1.RMAN
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1044_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:10:35
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00065 to +data
channel c3: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1035_1.RMAN
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1047_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:10:45
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00069 to +data
channel c4: reading from backup piece /u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1036_1.RMAN
channel c1: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1021_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:11:45
channel c2: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1046_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:09:20
channel c6: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1025_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:11:40
channel c4: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1036_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:10:26
channel c3: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1035_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:11:31
channel c5: piece handle=/u01/backup/TROY_bkp/INCR0_TROY_TROY_20201006_1026_1.RMAN tag=INC0_TROY_06OCT20_10_08_53
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:12:16
Finished restore at 06-OCT-20
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=70 STAMP=1053126261 file name=+DATA/TROY/datafile/system.601.1053120415
datafile 2 switched to datafile copy
input datafile copy RECID=71 STAMP=1053126261 file name=+DATA/TROY/datafile/sysaux.598.1053120415
datafile 3 switched to datafile copy
input datafile copy RECID=72 STAMP=1053126261 file name=+DATA/TROY/datafile/undotbs1.599.1053120415
datafile 4 switched to datafile copy
input datafile copy RECID=73 STAMP=1053126261 file name=+DATA/TROY/datafile/tools.596.1053120417
datafile 5 switched to datafile copy
input datafile copy RECID=74 STAMP=1053126261 file name=+DATA/TROY/datafile/undotbs2.600.1053120415
datafile 6 switched to datafile copy
input datafile copy RECID=75 STAMP=1053126261 file name=+DATA/TROY/datafile/users.597.1053120417
datafile 7 switched to datafile copy
input datafile copy RECID=76 STAMP=1053126261 file name=+DATA/TROY/datafile/audit_tbs.594.1053121215
datafile 8 switched to datafile copy
input datafile copy RECID=77 STAMP=1053126261 file name=+DATA/TROY/datafile/colt_usr_tbs.592.1053121221
datafile 9 switched to datafile copy
input datafile copy RECID=78 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_data.591.1053121253
datafile 10 switched to datafile copy
input datafile copy RECID=79 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_indexes.590.1053121253
datafile 11 switched to datafile copy
input datafile copy RECID=80 STAMP=1053126261 file name=+DATA/TROY/datafile/xdb.587.1053121295
datafile 12 switched to datafile copy
input datafile copy RECID=81 STAMP=1053126261 file name=+DATA/TROY/datafile/perfstat.579.1053121297
datafile 13 switched to datafile copy
input datafile copy RECID=82 STAMP=1053126261 file name=+DATA/TROY/datafile/system.586.1053121297
datafile 14 switched to datafile copy
input datafile copy RECID=83 STAMP=1053126261 file name=+DATA/TROY/datafile/sysaux.585.1053121297
datafile 15 switched to datafile copy
input datafile copy RECID=84 STAMP=1053126261 file name=+DATA/TROY/datafile/undotbs1.577.1053121693
datafile 16 switched to datafile copy
input datafile copy RECID=85 STAMP=1053126261 file name=+DATA/TROY/datafile/tools.584.1053121297
datafile 17 switched to datafile copy
input datafile copy RECID=86 STAMP=1053126261 file name=+DATA/TROY/datafile/undotbs2.575.1053121965
datafile 18 switched to datafile copy
input datafile copy RECID=87 STAMP=1053126261 file name=+DATA/TROY/datafile/users.583.1053121297
datafile 19 switched to datafile copy
input datafile copy RECID=88 STAMP=1053126261 file name=+DATA/TROY/datafile/audit_tbs.582.1053121297
datafile 20 switched to datafile copy
input datafile copy RECID=89 STAMP=1053126261 file name=+DATA/TROY/datafile/colt_usr_tbs.581.1053121297
datafile 21 switched to datafile copy
input datafile copy RECID=90 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_indexes.574.1053122007
datafile 22 switched to datafile copy
input datafile copy RECID=91 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_data.573.1053122013
datafile 23 switched to datafile copy
input datafile copy RECID=92 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_data.572.1053122389
datafile 24 switched to datafile copy
input datafile copy RECID=93 STAMP=1053126261 file name=+DATA/TROY/datafile/nc_data.595.1053121211
datafile 25 switched to datafile copy
input datafile copy RECID=94 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.602.1053120375
datafile 26 switched to datafile copy
input datafile copy RECID=95 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.607.1053120375
datafile 27 switched to datafile copy
input datafile copy RECID=96 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.606.1053120375
datafile 28 switched to datafile copy
input datafile copy RECID=97 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.571.1053122463
datafile 29 switched to datafile copy
input datafile copy RECID=98 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.568.1053122493
datafile 30 switched to datafile copy
input datafile copy RECID=99 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.566.1053122597
datafile 31 switched to datafile copy
input datafile copy RECID=100 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.564.1053122793
datafile 32 switched to datafile copy
input datafile copy RECID=101 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.562.1053122809
datafile 33 switched to datafile copy
input datafile copy RECID=102 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.560.1053123203
datafile 34 switched to datafile copy
input datafile copy RECID=103 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.558.1053123499
datafile 35 switched to datafile copy
input datafile copy RECID=104 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.588.1053121291
datafile 36 switched to datafile copy
input datafile copy RECID=105 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.557.1053123619
datafile 37 switched to datafile copy
input datafile copy RECID=106 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.559.1053123495
datafile 38 switched to datafile copy
input datafile copy RECID=107 STAMP=1053126262 file name=+DATA/TROY/datafile/xdb.580.1053121297
datafile 39 switched to datafile copy
input datafile copy RECID=108 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.605.1053120375
datafile 40 switched to datafile copy
input datafile copy RECID=109 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.603.1053120375
datafile 41 switched to datafile copy
input datafile copy RECID=110 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.567.1053122593
datafile 42 switched to datafile copy
input datafile copy RECID=111 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_indexes.555.1053123765
datafile 43 switched to datafile copy
input datafile copy RECID=112 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_indexes.554.1053123889
datafile 44 switched to datafile copy
input datafile copy RECID=113 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.553.1053123905
datafile 45 switched to datafile copy
input datafile copy RECID=114 STAMP=1053126262 file name=+DATA/TROY/datafile/perfstat.556.1053123623
datafile 46 switched to datafile copy
input datafile copy RECID=115 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_indexes.552.1053124329
datafile 47 switched to datafile copy
input datafile copy RECID=116 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_indexes.551.1053124329
datafile 48 switched to datafile copy
input datafile copy RECID=117 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.565.1053122789
datafile 49 switched to datafile copy
input datafile copy RECID=118 STAMP=1053126262 file name=+DATA/TROY/datafile/nc_data.561.1053123199
datafile 50 switched to datafile copy
input datafile copy RECID=119 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.569.1053122489
datafile 51 switched to datafile copy
input datafile copy RECID=120 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.563.1053122805
datafile 52 switched to datafile copy
input datafile copy RECID=121 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.550.1053124395
datafile 53 switched to datafile copy
input datafile copy RECID=122 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.593.1053121217
datafile 54 switched to datafile copy
input datafile copy RECID=123 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.578.1053121687
datafile 55 switched to datafile copy
input datafile copy RECID=124 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.549.1053124661
datafile 56 switched to datafile copy
input datafile copy RECID=125 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.548.1053124685
datafile 57 switched to datafile copy
input datafile copy RECID=126 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.547.1053124751
datafile 58 switched to datafile copy
input datafile copy RECID=127 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_indexes.546.1053124915
datafile 59 switched to datafile copy
input datafile copy RECID=128 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_indexes.545.1053124951
datafile 60 switched to datafile copy
input datafile copy RECID=129 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.544.1053125145
datafile 61 switched to datafile copy
input datafile copy RECID=130 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_indexes.543.1053125491
datafile 62 switched to datafile copy
input datafile copy RECID=131 STAMP=1053126263 file name=+DATA/TROY/datafile/perfstat.570.1053122469
datafile 63 switched to datafile copy
input datafile copy RECID=132 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.542.1053125491
datafile 64 switched to datafile copy
input datafile copy RECID=133 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.541.1053125525
datafile 65 switched to datafile copy
input datafile copy RECID=134 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.540.1053125551
datafile 66 switched to datafile copy
input datafile copy RECID=135 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.589.1053121289
datafile 67 switched to datafile copy
input datafile copy RECID=136 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.604.1053120375
datafile 68 switched to datafile copy
input datafile copy RECID=137 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.576.1053121961
datafile 69 switched to datafile copy
input datafile copy RECID=138 STAMP=1053126263 file name=+DATA/TROY/datafile/nc_data.539.1053125595
contents of Memory Script:
{
set until scn 17222041908083;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 06-OCT-20
starting media recovery
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=2 sequence=2901
channel c1: restoring archived log
archived log thread=1 sequence=2415
channel c1: restoring archived log
archived log thread=2 sequence=2902
channel c1: restoring archived log
archived log thread=1 sequence=2416
channel c1: restoring archived log
archived log thread=1 sequence=2417
channel c1: restoring archived log
archived log thread=2 sequence=2903
channel c1: restoring archived log
archived log thread=1 sequence=2418
channel c1: restoring archived log
archived log thread=2 sequence=2904
channel c1: restoring archived log
archived log thread=1 sequence=2419
channel c1: restoring archived log
archived log thread=2 sequence=2905
channel c1: reading from backup piece /u01/backup/TROY_bkp/TROY_TROY_20201006_1059.arc
channel c2: starting archived log restore to default destination
channel c2: restoring archived log
archived log thread=1 sequence=2420
channel c2: restoring archived log
archived log thread=2 sequence=2906
channel c2: restoring archived log
archived log thread=1 sequence=2421
channel c2: restoring archived log
archived log thread=1 sequence=2422
channel c2: restoring archived log
archived log thread=2 sequence=2907
channel c2: restoring archived log
archived log thread=1 sequence=2423
channel c2: restoring archived log
archived log thread=2 sequence=2908
channel c2: restoring archived log
archived log thread=1 sequence=2424
channel c2: restoring archived log
archived log thread=2 sequence=2909
channel c2: restoring archived log
archived log thread=2 sequence=2910
channel c2: restoring archived log
archived log thread=2 sequence=2911
channel c2: restoring archived log
archived log thread=2 sequence=2912
channel c2: restoring archived log
archived log thread=1 sequence=2425
channel c2: restoring archived log
archived log thread=2 sequence=2913
channel c2: reading from backup piece /u01/backup/TROY_bkp/TROY_TROY_20201006_1060.arc
channel c3: starting archived log restore to default destination
channel c3: restoring archived log
archived log thread=1 sequence=2426
channel c3: restoring archived log
archived log thread=2 sequence=2914
channel c3: restoring archived log
archived log thread=2 sequence=2915
channel c3: restoring archived log
archived log thread=1 sequence=2427
channel c3: restoring archived log
archived log thread=2 sequence=2916
channel c3: restoring archived log
archived log thread=2 sequence=2917
channel c3: restoring archived log
archived log thread=2 sequence=2918
channel c3: restoring archived log
archived log thread=2 sequence=2919
channel c3: restoring archived log
archived log thread=2 sequence=2920
channel c3: reading from backup piece /u01/backup/TROY_bkp/TROY_TROY_20201006_1061.arc
channel c3: piece handle=/u01/backup/TROY_bkp/TROY_TROY_20201006_1061.arc tag=TAG20201006T112441
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:25
channel c2: piece handle=/u01/backup/TROY_bkp/TROY_TROY_20201006_1060.arc tag=TAG20201006T112441
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:01:05
channel c1: piece handle=/u01/backup/TROY_bkp/TROY_TROY_20201006_1059.arc tag=TAG20201006T112441
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:15
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2901.2846.1053126273 thread=2 sequence=2901
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2415.994.1053126273 thread=1 sequence=2415
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2901.2846.1053126273 RECID=25 STAMP=1053126370
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2902.1988.1053126271 thread=2 sequence=2902
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2415.994.1053126273 RECID=24 STAMP=1053126369
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2416.2534.1053126271 thread=1 sequence=2416
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2416.2534.1053126271 RECID=27 STAMP=1053126371
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2417.2504.1053126271 thread=1 sequence=2417
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2902.1988.1053126271 RECID=30 STAMP=1053126371
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2903.3007.1053126371 thread=2 sequence=2903
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2417.2504.1053126271 RECID=31 STAMP=1053126371
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2418.1387.1053126271 thread=1 sequence=2418
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2903.3007.1053126371 RECID=33 STAMP=1053126398
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2904.2040.1053126271 thread=2 sequence=2904
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2418.1387.1053126271 RECID=28 STAMP=1053126371
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2419.1177.1053126369 thread=1 sequence=2419
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2904.2040.1053126271 RECID=29 STAMP=1053126371
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2905.1751.1053126271 thread=2 sequence=2905
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2419.1177.1053126369 RECID=32 STAMP=1053126398
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2420.1711.1053126271 thread=1 sequence=2420
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2905.1751.1053126271 RECID=26 STAMP=1053126370
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2906.3124.1053126271 thread=2 sequence=2906
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2420.1711.1053126271 RECID=23 STAMP=1053126333
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2421.2313.1053126271 thread=1 sequence=2421
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2421.2313.1053126271 RECID=20 STAMP=1053126333
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2422.2810.1053126271 thread=1 sequence=2422
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2906.3124.1053126271 RECID=21 STAMP=1053126333
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2907.2970.1053126271 thread=2 sequence=2907
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2422.2810.1053126271 RECID=22 STAMP=1053126333
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2423.2009.1053126271 thread=1 sequence=2423
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2907.2970.1053126271 RECID=18 STAMP=1053126300
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2908.2639.1053126273 thread=2 sequence=2908
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2423.2009.1053126271 RECID=19 STAMP=1053126317
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2424.2273.1053126271 thread=1 sequence=2424
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2908.2639.1053126273 RECID=8 STAMP=1053126273
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2909.1087.1053126273 thread=2 sequence=2909
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2909.1087.1053126273 RECID=10 STAMP=1053126274
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2910.2842.1053126275 thread=2 sequence=2910
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2910.2842.1053126275 RECID=11 STAMP=1053126274
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2911.1191.1053126275 thread=2 sequence=2911
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2911.1191.1053126275 RECID=13 STAMP=1053126274
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2912.1766.1053126273 thread=2 sequence=2912
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2424.2273.1053126271 RECID=15 STAMP=1053126276
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2425.1157.1053126275 thread=1 sequence=2425
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2912.1766.1053126273 RECID=9 STAMP=1053126273
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2913.1862.1053126275 thread=2 sequence=2913
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2425.1157.1053126275 RECID=12 STAMP=1053126274
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2426.2414.1053126271 thread=1 sequence=2426
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2913.1862.1053126275 RECID=14 STAMP=1053126275
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2914.1799.1053126271 thread=2 sequence=2914
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2914.1799.1053126271 RECID=16 STAMP=1053126289
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2915.2202.1053126271 thread=2 sequence=2915
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2426.2414.1053126271 RECID=17 STAMP=1053126290
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2427.2456.1053126271 thread=1 sequence=2427
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2915.2202.1053126271 RECID=1 STAMP=1053126271
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2916.3083.1053126271 thread=2 sequence=2916
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2916.3083.1053126271 RECID=7 STAMP=1053126272
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2917.2953.1053126271 thread=2 sequence=2917
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2917.2953.1053126271 RECID=2 STAMP=1053126271
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2918.1737.1053126271 thread=2 sequence=2918
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2918.1737.1053126271 RECID=6 STAMP=1053126271
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2919.3117.1053126271 thread=2 sequence=2919
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2919.3117.1053126271 RECID=4 STAMP=1053126271
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2920.2237.1053126271 thread=2 sequence=2920
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_1_seq_2427.2456.1053126271 RECID=5 STAMP=1053126271
channel clone_default: deleting archived log(s)
archived log file name=+FRA/TROY/archivelog/2020_10_06/thread_2_seq_2920.2237.1053126271 RECID=3 STAMP=1053126271
media recovery complete, elapsed time: 00:00:45
Finished recover at 06-OCT-20
Oracle instance started
Total System Global Area 10689474560 bytes
Fixed Size 2237776 bytes
Variable Size 1174407856 bytes
Database Buffers 9495904256 bytes
Redo Buffers 16924672 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''TROY'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''TROY'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 10689474560 bytes
Fixed Size 2237776 bytes
Variable Size 1174407856 bytes
Database Buffers 9495904256 bytes
Redo Buffers 16924672 bytes
allocated channel: c1
channel c1: SID=919 device type=DISK
allocated channel: c2
channel c2: SID=8 device type=DISK
allocated channel: c3
channel c3: SID=313 device type=DISK
allocated channel: c4
channel c4: SID=620 device type=DISK
allocated channel: c5
channel c5: SID=928 device type=DISK
allocated channel: c6
channel c6: SID=9 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TROY" RESETLOGS ARCHIVELOG
MAXLOGFILES 1024
MAXLOGMEMBERS 5
MAXDATAFILES 2048
MAXINSTANCES 128
MAXLOGHISTORY 2336
LOGFILE
GROUP 21 ( '+redo', '+data_fc' ) SIZE 500 M REUSE,
GROUP 22 ( '+redo', '+data_fc' ) SIZE 500 M REUSE,
GROUP 23 ( '+redo', '+data_fc' ) SIZE 500 M REUSE
DATAFILE
'+DATA/TROY/datafile/system.601.1053120415'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 24 ( '+redo', '+data_fc' ) SIZE 500 M REUSE,
GROUP 25 ( '+redo', '+data_fc' ) SIZE 500 M REUSE,
GROUP 26 ( '+redo', '+data_fc' ) SIZE 500 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"+data";
set newname for tempfile 2 to
"+data";
set newname for tempfile 3 to
"+data";
switch clone tempfile all;
catalog clone datafilecopy "+DATA/TROY/datafile/sysaux.598.1053120415",
"+DATA/TROY/datafile/undotbs1.599.1053120415",
"+DATA/TROY/datafile/tools.596.1053120417",
"+DATA/TROY/datafile/undotbs2.600.1053120415",
"+DATA/TROY/datafile/users.597.1053120417",
"+DATA/TROY/datafile/audit_tbs.594.1053121215",
"+DATA/TROY/datafile/colt_usr_tbs.592.1053121221",
"+DATA/TROY/datafile/nc_data.591.1053121253",
"+DATA/TROY/datafile/nc_indexes.590.1053121253",
"+DATA/TROY/datafile/xdb.587.1053121295",
"+DATA/TROY/datafile/perfstat.579.1053121297",
"+DATA/TROY/datafile/system.586.1053121297",
"+DATA/TROY/datafile/sysaux.585.1053121297",
"+DATA/TROY/datafile/undotbs1.577.1053121693",
"+DATA/TROY/datafile/tools.584.1053121297",
"+DATA/TROY/datafile/undotbs2.575.1053121965",
"+DATA/TROY/datafile/users.583.1053121297",
"+DATA/TROY/datafile/audit_tbs.582.1053121297",
"+DATA/TROY/datafile/colt_usr_tbs.581.1053121297",
"+DATA/TROY/datafile/nc_indexes.574.1053122007",
"+DATA/TROY/datafile/nc_data.573.1053122013",
"+DATA/TROY/datafile/nc_data.572.1053122389",
"+DATA/TROY/datafile/nc_data.595.1053121211",
"+DATA/TROY/datafile/nc_data.602.1053120375",
"+DATA/TROY/datafile/nc_data.607.1053120375",
"+DATA/TROY/datafile/nc_data.606.1053120375",
"+DATA/TROY/datafile/nc_data.571.1053122463",
"+DATA/TROY/datafile/perfstat.568.1053122493",
"+DATA/TROY/datafile/perfstat.566.1053122597",
"+DATA/TROY/datafile/perfstat.564.1053122793",
"+DATA/TROY/datafile/perfstat.562.1053122809",
"+DATA/TROY/datafile/perfstat.560.1053123203",
"+DATA/TROY/datafile/perfstat.558.1053123499",
"+DATA/TROY/datafile/nc_data.588.1053121291",
"+DATA/TROY/datafile/nc_data.557.1053123619",
"+DATA/TROY/datafile/nc_data.559.1053123495",
"+DATA/TROY/datafile/xdb.580.1053121297",
"+DATA/TROY/datafile/nc_data.605.1053120375",
"+DATA/TROY/datafile/nc_data.603.1053120375",
"+DATA/TROY/datafile/nc_data.567.1053122593",
"+DATA/TROY/datafile/nc_indexes.555.1053123765",
"+DATA/TROY/datafile/nc_indexes.554.1053123889",
"+DATA/TROY/datafile/nc_data.553.1053123905",
"+DATA/TROY/datafile/perfstat.556.1053123623",
"+DATA/TROY/datafile/nc_indexes.552.1053124329",
"+DATA/TROY/datafile/nc_indexes.551.1053124329",
"+DATA/TROY/datafile/nc_data.565.1053122789",
"+DATA/TROY/datafile/nc_data.561.1053123199",
"+DATA/TROY/datafile/nc_data.569.1053122489",
"+DATA/TROY/datafile/nc_data.563.1053122805",
"+DATA/TROY/datafile/nc_data.550.1053124395",
"+DATA/TROY/datafile/nc_data.593.1053121217",
"+DATA/TROY/datafile/nc_data.578.1053121687",
"+DATA/TROY/datafile/nc_data.549.1053124661",
"+DATA/TROY/datafile/nc_data.548.1053124685",
"+DATA/TROY/datafile/nc_data.547.1053124751",
"+DATA/TROY/datafile/nc_indexes.546.1053124915",
"+DATA/TROY/datafile/nc_indexes.545.1053124951",
"+DATA/TROY/datafile/nc_data.544.1053125145",
"+DATA/TROY/datafile/nc_indexes.543.1053125491",
"+DATA/TROY/datafile/perfstat.570.1053122469",
"+DATA/TROY/datafile/nc_data.542.1053125491",
"+DATA/TROY/datafile/nc_data.541.1053125525",
"+DATA/TROY/datafile/nc_data.540.1053125551",
"+DATA/TROY/datafile/nc_data.589.1053121289",
"+DATA/TROY/datafile/nc_data.604.1053120375",
"+DATA/TROY/datafile/nc_data.576.1053121961",
"+DATA/TROY/datafile/nc_data.539.1053125595";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
renamed tempfile 2 to +data in control file
renamed tempfile 3 to +data in control file
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/sysaux.598.1053120415 RECID=1 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/undotbs1.599.1053120415 RECID=2 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/tools.596.1053120417 RECID=3 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/undotbs2.600.1053120415 RECID=4 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/users.597.1053120417 RECID=5 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/audit_tbs.594.1053121215 RECID=6 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/colt_usr_tbs.592.1053121221 RECID=7 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.591.1053121253 RECID=8 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.590.1053121253 RECID=9 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/xdb.587.1053121295 RECID=10 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.579.1053121297 RECID=11 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/system.586.1053121297 RECID=12 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/sysaux.585.1053121297 RECID=13 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/undotbs1.577.1053121693 RECID=14 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/tools.584.1053121297 RECID=15 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/undotbs2.575.1053121965 RECID=16 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/users.583.1053121297 RECID=17 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/audit_tbs.582.1053121297 RECID=18 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/colt_usr_tbs.581.1053121297 RECID=19 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.574.1053122007 RECID=20 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.573.1053122013 RECID=21 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.572.1053122389 RECID=22 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.595.1053121211 RECID=23 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.602.1053120375 RECID=24 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.607.1053120375 RECID=25 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.606.1053120375 RECID=26 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.571.1053122463 RECID=27 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.568.1053122493 RECID=28 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.566.1053122597 RECID=29 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.564.1053122793 RECID=30 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.562.1053122809 RECID=31 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.560.1053123203 RECID=32 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.558.1053123499 RECID=33 STAMP=1053126489
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.588.1053121291 RECID=34 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.557.1053123619 RECID=35 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.559.1053123495 RECID=36 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/xdb.580.1053121297 RECID=37 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.605.1053120375 RECID=38 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.603.1053120375 RECID=39 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.567.1053122593 RECID=40 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.555.1053123765 RECID=41 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.554.1053123889 RECID=42 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.553.1053123905 RECID=43 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.556.1053123623 RECID=44 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.552.1053124329 RECID=45 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.551.1053124329 RECID=46 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.565.1053122789 RECID=47 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.561.1053123199 RECID=48 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.569.1053122489 RECID=49 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.563.1053122805 RECID=50 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.550.1053124395 RECID=51 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.593.1053121217 RECID=52 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.578.1053121687 RECID=53 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.549.1053124661 RECID=54 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.548.1053124685 RECID=55 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.547.1053124751 RECID=56 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.546.1053124915 RECID=57 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.545.1053124951 RECID=58 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.544.1053125145 RECID=59 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_indexes.543.1053125491 RECID=60 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/perfstat.570.1053122469 RECID=61 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.542.1053125491 RECID=62 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.541.1053125525 RECID=63 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.540.1053125551 RECID=64 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.589.1053121289 RECID=65 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.604.1053120375 RECID=66 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.576.1053121961 RECID=67 STAMP=1053126490
cataloged datafile copy
datafile copy file name=+DATA/TROY/datafile/nc_data.539.1053125595 RECID=68 STAMP=1053126490
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=1053126489 file name=+DATA/TROY/datafile/sysaux.598.1053120415
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1053126489 file name=+DATA/TROY/datafile/undotbs1.599.1053120415
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1053126489 file name=+DATA/TROY/datafile/tools.596.1053120417
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1053126489 file name=+DATA/TROY/datafile/undotbs2.600.1053120415
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1053126489 file name=+DATA/TROY/datafile/users.597.1053120417
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1053126489 file name=+DATA/TROY/datafile/audit_tbs.594.1053121215
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1053126489 file name=+DATA/TROY/datafile/colt_usr_tbs.592.1053121221
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.591.1053121253
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_indexes.590.1053121253
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=1053126489 file name=+DATA/TROY/datafile/xdb.587.1053121295
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.579.1053121297
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=1053126489 file name=+DATA/TROY/datafile/system.586.1053121297
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=1053126489 file name=+DATA/TROY/datafile/sysaux.585.1053121297
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=1053126489 file name=+DATA/TROY/datafile/undotbs1.577.1053121693
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=1053126489 file name=+DATA/TROY/datafile/tools.584.1053121297
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=1053126489 file name=+DATA/TROY/datafile/undotbs2.575.1053121965
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=1053126489 file name=+DATA/TROY/datafile/users.583.1053121297
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=1053126489 file name=+DATA/TROY/datafile/audit_tbs.582.1053121297
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=1053126489 file name=+DATA/TROY/datafile/colt_usr_tbs.581.1053121297
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_indexes.574.1053122007
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.573.1053122013
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.572.1053122389
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.595.1053121211
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.602.1053120375
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.607.1053120375
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.606.1053120375
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=1053126489 file name=+DATA/TROY/datafile/nc_data.571.1053122463
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.568.1053122493
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.566.1053122597
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.564.1053122793
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.562.1053122809
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.560.1053123203
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=1053126489 file name=+DATA/TROY/datafile/perfstat.558.1053123499
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.588.1053121291
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.557.1053123619
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.559.1053123495
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=1053126490 file name=+DATA/TROY/datafile/xdb.580.1053121297
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.605.1053120375
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.603.1053120375
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.567.1053122593
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.555.1053123765
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.554.1053123889
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.553.1053123905
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=1053126490 file name=+DATA/TROY/datafile/perfstat.556.1053123623
datafile 46 switched to datafile copy
input datafile copy RECID=45 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.552.1053124329
datafile 47 switched to datafile copy
input datafile copy RECID=46 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.551.1053124329
datafile 48 switched to datafile copy
input datafile copy RECID=47 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.565.1053122789
datafile 49 switched to datafile copy
input datafile copy RECID=48 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.561.1053123199
datafile 50 switched to datafile copy
input datafile copy RECID=49 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.569.1053122489
datafile 51 switched to datafile copy
input datafile copy RECID=50 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.563.1053122805
datafile 52 switched to datafile copy
input datafile copy RECID=51 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.550.1053124395
datafile 53 switched to datafile copy
input datafile copy RECID=52 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.593.1053121217
datafile 54 switched to datafile copy
input datafile copy RECID=53 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.578.1053121687
datafile 55 switched to datafile copy
input datafile copy RECID=54 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.549.1053124661
datafile 56 switched to datafile copy
input datafile copy RECID=55 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.548.1053124685
datafile 57 switched to datafile copy
input datafile copy RECID=56 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.547.1053124751
datafile 58 switched to datafile copy
input datafile copy RECID=57 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.546.1053124915
datafile 59 switched to datafile copy
input datafile copy RECID=58 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.545.1053124951
datafile 60 switched to datafile copy
input datafile copy RECID=59 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.544.1053125145
datafile 61 switched to datafile copy
input datafile copy RECID=60 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_indexes.543.1053125491
datafile 62 switched to datafile copy
input datafile copy RECID=61 STAMP=1053126490 file name=+DATA/TROY/datafile/perfstat.570.1053122469
datafile 63 switched to datafile copy
input datafile copy RECID=62 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.542.1053125491
datafile 64 switched to datafile copy
input datafile copy RECID=63 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.541.1053125525
datafile 65 switched to datafile copy
input datafile copy RECID=64 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.540.1053125551
datafile 66 switched to datafile copy
input datafile copy RECID=65 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.589.1053121289
datafile 67 switched to datafile copy
input datafile copy RECID=66 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.604.1053120375
datafile 68 switched to datafile copy
input datafile copy RECID=67 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.576.1053121961
datafile 69 switched to datafile copy
input datafile copy RECID=68 STAMP=1053126490 file name=+DATA/TROY/datafile/nc_data.539.1053125595
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 06-OCT-20
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
Recovery Manager complete.
Now we will convert our database into RAC database.
refer
https://dbatracker.com/2020/06/22/convert-single-instance-db-to-rac-db-using-rconfig-admin-managed/
DBATracker 