Tuesday, August 7, 2018

Duplicate a Database Using RMAN in Oracle Database 11.2.0.4(Backup Based with Same directory structure)

  • Create a backup of the source database.
[oracle@dmdba-prd ~]$ rman target / catalog rcat_owner/rcat_owner@rcat
Recovery Manager: Release 11.2.0.4.0 – Production on Mon Apr 16 09:29:00 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=302684881)
connected to recovery catalog database
RMAN> list backup summary;
starting full resync of recovery catalog
full resync complete
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
——- — — – ———– ————— ——- ——- ———- —
874 B F A DISK 13-APR-18 1 1 NO TAG20181013T111307
891 B A A DISK 13-APR-18 1 1 YES TAG20181013T111659
905 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
906 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
907 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
908 B 0 A DISK 13-APR-18 1 1 YES TAG20181013T111700
981 B A A DISK 13-APR-18 1 1 YES TAG20181013T141028
1007 B F A DISK 13-APR-18 1 1 NO TAG20181013T141030
RMAN> backup incremental level 0 cumulative database plus archivelog ;
Starting backup at 16-APR-18
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=252 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=8 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=170 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=254 device type=DISK
skipping archived logs of thread 1 from sequence 1 to 2; already backed up
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=957519339
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0ksh55fd_1_1 tag=TAG20181016T093541 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 16-APR-18
Starting backup at 16-APR-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=/u04/app/oracle/oradata/PROD/grants_indexes01.dbf
input datafile file number=00012 name=/u04/app/oracle/oradata/PROD/grants_dataB_05.dbf
input datafile file number=00013 name=/u04/app/oracle/oradata/PROD/grants_dataB_04.dbf
input datafile file number=00019 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_05.dbf
input datafile file number=00023 name=/u04/app/oracle/oradata/PROD/grants_report_dataB.dbf
input datafile file number=00040 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_07.dbf
input datafile file number=00051 name=/u04/app/oracle/oradata/PROD/grant_report_data_B_09.dbf
input datafile file number=00031 name=/u04/app/oracle/oradata/PROD/grant_txn_index011.dbf
input datafile file number=00007 name=/u04/app/oracle/oradata/PROD/dmdba_audit.dbf
input datafile file number=00055 name=/u04/app/oracle/oradata/PROD/da_data01.dbf
input datafile file number=00058 name=/u04/app/oracle/oradata/PROD/grants_isir_data03.dbf
input datafile file number=00009 name=/u04/app/oracle/oradata/PROD/foster_indexes01.dbf
input datafile file number=00008 name=/u04/app/oracle/oradata/PROD/foster_data01.dbf
input datafile file number=00057 name=/u04/app/oracle/oradata/PROD/grant_tmp_data01.dbf
input datafile file number=00050 name=/u04/app/oracle/oradata/PROD/calsoap_indexes01.dbf
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_2: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00011 name=/u04/app/oracle/oradata/PROD/grants_dataB_06.dbf
input datafile file number=00044 name=/u04/app/oracle/oradata/PROD/grants_dataB_08.dbf
input datafile file number=00016 name=/u04/app/oracle/oradata/PROD/grants_dataB.dbf
input datafile file number=00022 name=/u04/app/oracle/oradata/PROD/grants_report_dataB_02.dbf
input datafile file number=00038 name=/u04/app/oracle/oradata/PROD/grant_txn_dataB_02.dbf
input datafile file number=00053 name=/u04/app/oracle/oradata/PROD/grant_report_data_B_10.dbf
input datafile file number=00002 name=/u04/app/oracle/oradata/PROD/undotbs01.dbf
input datafile file number=00026 name=/u04/app/oracle/oradata/PROD/grants_web_files01.dbf
input datafile file number=00046 name=/u04/app/oracle/oradata/PROD/grants_isir_indexes.dbf
input datafile file number=00003 name=/u04/app/oracle/oradata/PROD/sysaux01.dbf
input datafile file number=00034 name=/u04/app/oracle/oradata/PROD/users01.dbf
input datafile file number=00035 name=/u04/app/oracle/oradata/PROD/aple_indexes01.dbf
input datafile file number=00032 name=/u04/app/oracle/oradata/PROD/reftabs_data01.dbf
input datafile file number=00024 name=/u04/app/oracle/oradata/PROD/grants_report_indexes02.dbf
channel ORA_DISK_2: starting piece 1 at 16-APR-18
channel ORA_DISK_3: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00017 name=/u04/app/oracle/oradata/PROD/grants_indexes02.dbf
input datafile file number=00001 name=/u04/app/oracle/oradata/PROD/system01.dbf
input datafile file number=00014 name=/u04/app/oracle/oradata/PROD/grants_dataB_03.dbf
input datafile file number=00020 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_04.dbf
input datafile file number=00030 name=/u04/app/oracle/oradata/PROD/grant_txn_dataB.dbf
input datafile file number=00045 name=/u04/app/oracle/oradata/PROD/grants_report_data_B_08.dbf
input datafile file number=00039 name=/u04/app/oracle/oradata/PROD/grants_isir_data02.dbf
input datafile file number=00005 name=/u04/app/oracle/oradata/PROD/archive_data01.dbf
input datafile file number=00027 name=/u04/app/oracle/oradata/PROD/grants_web_indexes01.dbf
input datafile file number=00047 name=/u04/app/oracle/oradata/PROD/mcs_data01.dbf
input datafile file number=00056 name=/u04/app/oracle/oradata/PROD/da_data02.dbf
input datafile file number=00041 name=/u04/app/oracle/oradata/PROD/user_securit
input datafile file number=00048 name=/u04/app/oracle/oradata/PROD/mcs_indexes0
input datafile file number=00004 name=/u04/app/oracle/oradata/PROD/aple_data01.
input datafile file number=00033 name=/u04/app/oracle/oradata/PROD/reftabs_inde
channel ORA_DISK_3: starting piece 1 at 16-APR-18
channel ORA_DISK_4: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00010 name=/u04/app/oracle/oradata/PROD/grants_dataB
input datafile file number=00043 name=/u04/app/oracle/oradata/PROD/grants_index
input datafile file number=00015 name=/u04/app/oracle/oradata/PROD/grants_dataB
input datafile file number=00021 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00037 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00052 name=/u04/app/oracle/oradata/PROD/system02.dbf
input datafile file number=00036 name=/u04/app/oracle/oradata/PROD/grants_isir_
input datafile file number=00054 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00028 name=/u04/app/oracle/oradata/PROD/grants_work_
input datafile file number=00029 name=/u04/app/oracle/oradata/PROD/grants_work_
input datafile file number=00006 name=/u04/app/oracle/oradata/PROD/archive_inde
input datafile file number=00042 name=/u04/app/oracle/oradata/PROD/user_securit
input datafile file number=00025 name=/u04/app/oracle/oradata/PROD/grants_repor
input datafile file number=00049 name=/u04/app/oracle/oradata/PROD/calsoap_data
input datafile file number=00059 name=/u04/app/oracle/oradata/PROD/grants_dataB
channel ORA_DISK_4: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_2: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_3: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:38:53
channel ORA_DISK_4: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1 tag=TAG20181016T093556 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:38:52
Finished backup at 16-APR-18
Starting backup at 16-APR-18
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=4 STAMP=957520190
channel ORA_DISK_1: starting piece 1 at 16-APR-18
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=5 STAMP=957521691
channel ORA_DISK_2: starting piece 1 at 16-APR-18
channel ORA_DISK_1: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0psh57ot_1_1 tag=TAG20181016T101453 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 1 at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0qsh57ot_1_1 tag=TAG20181016T101453 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
Finished backup at 16-APR-18
Starting Control File and SPFILE Autobackup at 16-APR-18
piece handle=/u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00 comment=NONE
Finished Control File and SPFILE Autobackup at 16-APR-18
RMAN> exit
Target Database
Edit the init parameter file.
[oracle@dmdba-rnd ~]$ cd $ORACLE_HOME/dbs
[oracle@dmdba-rnd dbs]$ cat initPRODCOPY.ora
*.db_name=’PRODCOPY’
*.audit_file_dest=’/u01/app/oracle/admin/PRODCOPY/adump’
*.control_files=’/u04/app/oracle/oradata/PRODCOPY/control01.ctl’,’/u04/app/oracle/oradata/PRODCOPY/control02.ctl’,’/u04/app/oracle/oradata/PRODCOPY/control03.ctl’
*.core_dump_dest=’/u01/app/oracle/admin/PRODCOPY/cdump’
*.db_create_file_dest=’/u04/app/oracle/oradata/PRODCOPY’
*.db_file_name_convert=(‘/u04/app/oracle/oradata/PROD/’,’/u04/app/oracle/oradata/PRODCOPY’)
*.log_file_name_convert=(‘/u04/app/oracle/oradata/PROD/’,’/u04/app/oracle/oradata/PRODCOPY’)
*.diagnostic_dest=’/u01/app/oracle/admin/PRODCOPY/bdump’
Start the target database in nomount
[oracle@dmdba-rnd dbs]$ sqlplus “/ as sysdba”
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 16 10:01:37 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1920831488 bytes
Fixed Size 2243232 bytes
Variable Size 436208992 bytes
Database Buffers 1476395008 bytes
Redo Buffers 5984256 bytes
SQL> show parameter db_name;
NAME TYPE VALUE
———————————— ———– ——————————
db_name string PRODCOPY
SQL> show parameter convert
NAME TYPE VALUE
———————————— ———– ——————————
db_file_name_convert string /u04/app/oracle/oradata/PROD/
, /u04/app/oracle/oradata/PROD
COPY
log_file_name_convert string /u04/app/oracle/oradata/PROD/
, /u04/app/oracle/oradata/PROD
COPY
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Start the rman duplication Process
[oracle@dmdba-rnd dbs]$ rman target sys/Welcome1@PROD catalog rcat_owner/rcat_owner@RCAT auxiliary /
Recovery Manager: Release 11.2.0.4.0 – Production on Mon Apr 16 10:16:54 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=302684881)
connected to recovery catalog database
connected to auxiliary database: PRODCOPY (not mounted)
RMAN> DUPLICATE DATABASE TO PRODCOPY NOFILENAMECHECK;
Starting Duplicate Db at 16-APR-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=249 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=5 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=86 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=168 device type=DISK
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 1920757760 bytes
Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes
contents of Memory Script:
{
sql clone “alter system set db_name =
”PROD” comment=
”Modified by RMAN duplicate” scope=spfile”;
sql clone “alter system set db_unique_name =
”PRODCOPY” comment=
”Modified by RMAN duplicate” scope=spfile”;
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ”PROD” comment= ”Modified by RMAN duplicate” scope=spfile
sql statement: alter system set db_unique_name = ”PRODCOPY” comment= ”Modified by RMAN duplicate” scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1920757760 bytes
Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes
Starting restore at 16-APR-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=244 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=5 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=86 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=168 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/control_file_c-302684881-20181016-00 tag=TAG20181016T101455
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u04/app/oracle/oradata/PRODCOPY/control01.ctl
output file name=/u04/app/oracle/oradata/PRODCOPY/control02.ctl
output file name=/u04/app/oracle/oradata/PRODCOPY/control03.ctl
Finished restore at 16-APR-18
database mounted
contents of Memory Script:
{
set until scn 7064436942;
set newname for datafile 1 to
“/u04/app/oracle/oradata/PRODCOPYsystem01.dbf”;
set newname for datafile 2 to
“/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf”;
set newname for datafile 3 to
“/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf”;
set newname for datafile 4 to
“/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf”;
set newname for datafile 5 to
“/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf”;
set newname for datafile 6 to
“/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf”;
set newname for datafile 7 to
“/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf”;
set newname for datafile 8 to
“/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf”;
set newname for datafile 9 to
“/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf”;
set newname for datafile 10 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf”;
set newname for datafile 11 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf”;
set newname for datafile 12 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf”;
set newname for datafile 13 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf”;
set newname for datafile 14 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf”;
set newname for datafile 15 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf”;
set newname for datafile 16 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf”;
set newname for datafile 17 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf”;
set newname for datafile 18 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf”;
set newname for datafile 19 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf”;
set newname for datafile 20 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf”;
set newname for datafile 21 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf”;
set newname for datafile 22 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf”;
set newname for datafile 23 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf”;
set newname for datafile 24 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf”;
set newname for datafile 25 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf”;
set newname for datafile 26 to
“/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf”;
set newname for datafile 27 to
“/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf”;
set newname for datafile 28 to
“/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf”;
set newname for datafile 29 to
“/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf”;
set newname for datafile 30 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf”;
set newname for datafile 31 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf”;
set newname for datafile 32 to
“/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf”;
set newname for datafile 33 to
“/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf”;
set newname for datafile 34 to
“/u04/app/oracle/oradata/PRODCOPYusers01.dbf”;
set newname for datafile 35 to
“/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf”;
set newname for datafile 36 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf”;
set newname for datafile 37 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf”;
set newname for datafile 38 to
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf”;
set newname for datafile 39 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf”;
set newname for datafile 40 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf”;
set newname for datafile 41 to
“/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf”;
set newname for datafile 42 to
“/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf”;
set newname for datafile 43 to
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf”;
set newname for datafile 44 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf”;
set newname for datafile 45 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf”;
set newname for datafile 46 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf”;
set newname for datafile 47 to
“/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf”;
set newname for datafile 48 to
“/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf”;
set newname for datafile 49 to
“/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf”;
set newname for datafile 50 to
“/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf”;
set newname for datafile 51 to
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf”;
set newname for datafile 52 to
“/u04/app/oracle/oradata/PRODCOPYsystem02.dbf”;
set newname for datafile 53 to
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf”;
set newname for datafile 54 to
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf”;
set newname for datafile 55 to
“/u04/app/oracle/oradata/PRODCOPYda_data01.dbf”;
set newname for datafile 56 to
“/u04/app/oracle/oradata/PRODCOPYda_data02.dbf”;
set newname for datafile 57 to
“/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf”;
set newname for datafile 58 to
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf”;
set newname for datafile 59 to
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.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
Starting restore at 16-APR-18
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
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 /u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00011 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
channel ORA_AUX_DISK_1: restoring datafile 00016 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
channel ORA_AUX_DISK_1: restoring datafile 00022 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00024 to /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00026 to /u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00032 to /u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00034 to /u04/app/oracle/oradata/PRODCOPYusers01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00035 to /u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00038 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00044 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
channel ORA_AUX_DISK_1: restoring datafile 00046 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
channel ORA_AUX_DISK_1: restoring datafile 00053 to /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0fsgte9e_1_1
channel ORA_AUX_DISK_2: starting datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_2: restoring datafile 00006 to /u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00010 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
channel ORA_AUX_DISK_2: restoring datafile 00015 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
channel ORA_AUX_DISK_2: restoring datafile 00021 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
channel ORA_AUX_DISK_2: restoring datafile 00025 to /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00028 to /u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00029 to /u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00036 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00037 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
channel ORA_AUX_DISK_2: restoring datafile 00042 to /u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00043 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
channel ORA_AUX_DISK_2: restoring datafile 00049 to /u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
channel ORA_AUX_DISK_2: restoring datafile 00052 to /u04/app/oracle/oradata/PRODCOPYsystem02.dbf
channel ORA_AUX_DISK_2: restoring datafile 00054 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
channel ORA_AUX_DISK_2: restoring datafile 00059 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
channel ORA_AUX_DISK_2: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0hsgte9e_1_1
channel ORA_AUX_DISK_3: starting datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_3: restoring datafile 00007 to /u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
channel ORA_AUX_DISK_3: restoring datafile 00008 to /u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00009 to /u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00012 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
channel ORA_AUX_DISK_3: restoring datafile 00013 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
channel ORA_AUX_DISK_3: restoring datafile 00018 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00019 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
channel ORA_AUX_DISK_3: restoring datafile 00023 to /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
channel ORA_AUX_DISK_3: restoring datafile 00031 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
channel ORA_AUX_DISK_3: restoring datafile 00040 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
channel ORA_AUX_DISK_3: restoring datafile 00050 to /u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00051 to /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
channel ORA_AUX_DISK_3: restoring datafile 00055 to /u04/app/oracle/oradata/PRODCOPYda_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00057 to /u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
channel ORA_AUX_DISK_3: restoring datafile 00058 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
channel ORA_AUX_DISK_3: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0esgte9e_1_1
channel ORA_AUX_DISK_4: starting datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_4: restoring datafile 00001 to /u04/app/oracle/oradata/PRODCOPYsystem01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00004 to /u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00005 to /u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00014 to /u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
channel ORA_AUX_DISK_4: restoring datafile 00017 to /u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00020 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
channel ORA_AUX_DISK_4: restoring datafile 00027 to /u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00030 to /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
channel ORA_AUX_DISK_4: restoring datafile 00033 to /u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00039 to /u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00041 to /u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00045 to /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
channel ORA_AUX_DISK_4: restoring datafile 00047 to /u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00048 to /u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
channel ORA_AUX_DISK_4: restoring datafile 00056 to /u04/app/oracle/oradata/PRODCOPYda_data02.dbf
channel ORA_AUX_DISK_4: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181013_0gsgte9e_1_1
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0fsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 02:15:12
channel ORA_AUX_DISK_2: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0hsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 02:31:23
channel ORA_AUX_DISK_3: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0esgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 02:49:24
channel ORA_AUX_DISK_4: piece handle=/u04/app/oracle/backup/PROD/PROD_20181013_0gsgte9e_1_1 tag=TAG20181013T111700
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 02:57:34
Finished restore at 16-APR-18
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=60 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYsystem01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=61 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=62 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=63 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=64 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=65 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=66 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=67 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=68 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=69 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=70 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=71 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=72 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=73 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=74 STAMP=957532891 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=75 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=76 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=77 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=78 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=79 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=80 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=81 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=82 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=83 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=84 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=85 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=86 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=87 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=88 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=89 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=90 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=91 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=92 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=93 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=94 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=95 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=96 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=97 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=98 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=99 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=100 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=101 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=102 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=103 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=104 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=105 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=106 STAMP=957532892 file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=107 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=108 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=109 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=110 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
datafile 52 switched to datafile copy
input datafile copy RECID=111 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=112 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=113 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=114 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=115 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=116 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=117 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=118 STAMP=957532893 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
contents of Memory Script:
{
set until scn 7064436942;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 16-APR-18
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
channel ORA_AUX_DISK_1: starting incremental datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
destination for restore of datafile 00010: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
destination for restore of datafile 00015: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
destination for restore of datafile 00021: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
destination for restore of datafile 00025: /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
destination for restore of datafile 00028: /u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
destination for restore of datafile 00029: /u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
destination for restore of datafile 00036: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
destination for restore of datafile 00037: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
destination for restore of datafile 00042: /u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
destination for restore of datafile 00043: /u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
destination for restore of datafile 00049: /u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
destination for restore of datafile 00052: /u04/app/oracle/oradata/PRODCOPYsystem02.dbf
destination for restore of datafile 00054: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
destination for restore of datafile 00059: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1
channel ORA_AUX_DISK_2: starting incremental datafile backup set restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /u04/app/oracle/oradata/PRODCOPYsystem01.dbf
destination for restore of datafile 00004: /u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
destination for restore of datafile 00005: /u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
destination for restore of datafile 00014: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
destination for restore of datafile 00017: /u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
destination for restore of datafile 00020: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
destination for restore of datafile 00027: /u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
destination for restore of datafile 00030: /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
destination for restore of datafile 00033: /u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
destination for restore of datafile 00039: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
destination for restore of datafile 00041: /u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
destination for restore of datafile 00045: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
destination for restore of datafile 00047: /u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
destination for restore of datafile 00048: /u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
destination for restore of datafile 00056: /u04/app/oracle/oradata/PRODCOPYda_data02.dbf
channel ORA_AUX_DISK_2: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1
channel ORA_AUX_DISK_3: starting incremental datafile backup set restore
channel ORA_AUX_DISK_3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00007: /u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
destination for restore of datafile 00008: /u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
destination for restore of datafile 00009: /u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
destination for restore of datafile 00012: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
destination for restore of datafile 00013: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
destination for restore of datafile 00018: /u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
destination for restore of datafile 00019: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
destination for restore of datafile 00023: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
destination for restore of datafile 00031: /u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
destination for restore of datafile 00040: /u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
destination for restore of datafile 00050: /u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
destination for restore of datafile 00051: /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
destination for restore of datafile 00055: /u04/app/oracle/oradata/PRODCOPYda_data01.dbf
destination for restore of datafile 00057: /u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
destination for restore of datafile 00058: /u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
channel ORA_AUX_DISK_3: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1
channel ORA_AUX_DISK_4: starting incremental datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
destination for restore of datafile 00003: /u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
destination for restore of datafile 00011: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
destination for restore of datafile 00016: /u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
destination for restore of datafile 00022: /u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
destination for restore of datafile 00024: /u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
destination for restore of datafile 00026: /u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
destination for restore of datafile 00032: /u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
destination for restore of datafile 00034: /u04/app/oracle/oradata/PRODCOPYusers01.dbf
destination for restore of datafile 00035: /u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
destination for restore of datafile 00038: /u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
destination for restore of datafile 00044: /u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
destination for restore of datafile 00046: /u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
destination for restore of datafile 00053: /u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
channel ORA_AUX_DISK_4: reading from backup piece /u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1
channel ORA_AUX_DISK_1: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0osh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_2: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0nsh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_3: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0lsh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_4: piece handle=/u04/app/oracle/backup/PROD/PROD_20181016_0msh55fu_1_1 tag=TAG20181016T093556
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:00:15
starting media recovery
archived log for thread 1 with sequence 4 is already on disk as file /u04/backup/PROD/arch/1_4_957265928.dbf
archived log for thread 1 with sequence 5 is already on disk as file /u04/backup/PROD/arch/1_5_957265928.dbf
archived log file name=/u04/backup/PROD/arch/1_4_957265928.dbf thread=1 sequence=4
archived log file name=/u04/backup/PROD/arch/1_5_957265928.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:01
Finished recover at 16-APR-18
Oracle instance started
Total System Global Area 1920757760 bytes
Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes
contents of Memory Script:
{
sql clone “alter system set db_name =
”PRODCOPY” 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 = ”PRODCOPY” 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 1920757760 bytes
Fixed Size 2229544 bytes
Variable Size 452987608 bytes
Database Buffers 1442840576 bytes
Redo Buffers 22700032 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “PRODCOPY” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4674
LOGFILE
GROUP 1 ( ‘/u04/app/oracle/oradata/PRODCOPYredo01a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo01b.log’ ) SIZE 1 G REUSE,
GROUP 2 ( ‘/u04/app/oracle/oradata/PRODCOPYredo02a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo02b.log’ ) SIZE 1 G REUSE,
GROUP 3 ( ‘/u04/app/oracle/oradata/PRODCOPYredo03a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo03b.log’ ) SIZE 1 G REUSE,
GROUP 4 ( ‘/u04/app/oracle/oradata/PRODCOPYredo04a.log’, ‘/u04/app/oracle/oradata/PRODCOPYredo04b.log’ ) SIZE 1 G REUSE
DATAFILE
‘/u04/app/oracle/oradata/PRODCOPYsystem01.dbf’
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
“/u04/app/oracle/oradata/PRODCOPYtemp01.dbf”;
set newname for tempfile 2 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp1.dbf”;
set newname for tempfile 3 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp2.dbf”;
set newname for tempfile 4 to
“/u04/app/oracle/oradata/PRODCOPYtempGrp3.dbf”;
switch clone tempfile all;
catalog clone datafilecopy “/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf”,
“/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf”,
“/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYusers01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf”,
“/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf”,
“/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf”,
“/u04/app/oracle/oradata/PRODCOPYsystem02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf”,
“/u04/app/oracle/oradata/PRODCOPYda_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYda_data02.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf”,
“/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf”;
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u04/app/oracle/oradata/PRODCOPYtemp01.dbf in control file
renamed tempfile 2 to /u04/app/oracle/oradata/PRODCOPYtempGrp1.dbf in control file
renamed tempfile 3 to /u04/app/oracle/oradata/PRODCOPYtempGrp2.dbf in control file
renamed tempfile 4 to /u04/app/oracle/oradata/PRODCOPYtempGrp3.dbf in control file
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf RECID=1 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf RECID=2 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf RECID=3 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf RECID=4 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf RECID=5 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf RECID=6 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf RECID=7 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf RECID=8 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf RECID=9 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf RECID=10 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf RECID=11 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf RECID=12 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf RECID=13 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf RECID=14 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf RECID=15 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf RECID=16 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf RECID=17 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf RECID=18 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf RECID=19 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf RECID=20 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf RECID=21 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf RECID=22 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf RECID=23 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf RECID=24 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf RECID=25 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf RECID=26 STAMP=957532932
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf RECID=27 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf RECID=28 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf RECID=29 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf RECID=30 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf RECID=31 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf RECID=32 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf RECID=33 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf RECID=34 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf RECID=35 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf RECID=36 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf RECID=37 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf RECID=38 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf RECID=39 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf RECID=40 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf RECID=41 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf RECID=42 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf RECID=43 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf RECID=44 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf RECID=45 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf RECID=46 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf RECID=47 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf RECID=48 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf RECID=49 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf RECID=50 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf RECID=51 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf RECID=52 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf RECID=53 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf RECID=54 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf RECID=55 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf RECID=56 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf RECID=57 STAMP=957532933
cataloged datafile copy
datafile copy file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf RECID=58 STAMP=957532933
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYundotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYsysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYaple_data01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYarchive_data01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYarchive_indexes01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYdmdba_audit.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYfoster_data01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYfoster_indexes01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_07.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_06.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_05.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_04.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_03.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_02.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes02.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_05.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_04.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_03.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB_02.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_dataB.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes02.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_indexes01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_files01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=957532932 file name=/u04/app/oracle/oradata/PRODCOPYgrants_web_indexes01.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_files01.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_work_indexes01.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_index011.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_data01.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYreftabs_indexes01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYusers01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYaple_indexes01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_06.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_txn_dataB_02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data02.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_07.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_data01.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYuser_security_indexes01.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_indexes03.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_08.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_08.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=45 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_indexes.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=46 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYmcs_data01.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=47 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYmcs_indexes01.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=48 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_data01.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=49 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYcalsoap_indexes01.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=50 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_09.dbf
datafile 52 switched to datafile copy
input datafile copy RECID=51 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYsystem02.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=52 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_report_data_B_10.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=53 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_report_data_B_11.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=54 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYda_data01.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=55 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYda_data02.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=56 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrant_tmp_data01.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=57 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_isir_data03.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=58 STAMP=957532933 file name=/u04/app/oracle/oradata/PRODCOPYgrants_dataB_09.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 16-APR-18
RMAN>
Check the Database
[oracle@dmdba-rnd trace]$ sqlplus “/ as sysdba”
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 16 13:24:13 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
PRODCOPY READ WRITE
SQL> select count(*),online_status from dba_data_files group by online_status;
COUNT(*) ONLINE_
———- ——-
57 ONLINE
2 SYSTEM
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)