1.Copy the init parameter file from source .

2.In target place this init file to $ORACLE_HOME/dbs

3.Change following parameter in init file to make it compatible to single instance.

Replace original instance name to target name in pfile .For my case it should EBILTST as target.

##Remove following parameters##

EBILDR12.__data_transfer_cache_size=0
EBILDR11.__data_transfer_cache_size=0
EBILDR11.__db_cache_size=5939134464
EBILDR12.__db_cache_size=3154116608
EBILDR12.__java_pool_size=234881024
EBILDR11.__java_pool_size=234881024
EBILDR12.__large_pool_size=5335154688
EBILDR11.__large_pool_size=5268045824
EBILDR11.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
EBILDR12.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment
EBILDR12.__pga_aggregate_target=3456106496
EBILDR11.__pga_aggregate_target=3456106496
EBILDR12.__sga_target=17179869184
EBILDR11.__sga_target=17179869184
EBILDR12.__shared_io_pool_size=301989888
EBILDR11.__shared_io_pool_size=469762048
EBILDR11.__shared_pool_size=4127195136
EBILDR12.__shared_pool_size=7012876288
EBILDR12.__streams_pool_size=0
EBILDR11.__streams_pool_size=0

## Create the destination in target server##
*.audit_file_dest=’/u01/app/oracle/admin/EBILTST/adump’
*.audit_trail=’db’
*.cluster_database=true
*.compatible=’12.1.0.2.0′

##Control file location needs to be changed##
*.control_files=’+REDO_BILLP/EBILTST/CONTROLFILE/current.256.926689595′
*.db_block_size=8192

##The datafile and online log destination may be changed##
*.db_create_file_dest=’+DATA_BILLP’
*.db_create_online_log_dest_1=’+REDO_BILLP’

*.db_domain=’tdeprdcl.internal’
*.db_file_multiblock_read_count=8
*.db_files=2048

##DB_NAME should be changed to target database name##
*.db_name=’EBILTST’

*.db_recovery_file_dest=’+FRA’
*.db_recovery_file_dest_size=1020054732800
*.diagnostic_dest=’/u01/app/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=EBILTSTXDB)’

##Instance_number should be removed##
EBILDR11.instance_number=1
EBILDR12.instance_number=2

*.job_queue_processes=8
*.log_archive_dest_1=’LOCATION=+ARCH_BILLP’
*.log_archive_format=’log_%d_%t_%s_%r.arc’
*.log_buffer=2147483648
*.memory_max_target=0
*.memory_target=0
*.open_cursors=500
*.open_links=10
*.open_links_per_instance=100
*.processes=3000

##Remote listener should be removed##
*.remote_listener=’BSCSprd1-scan.tdeprdcl.internal:1591′

*.remote_login_passwordfile=’exclusive’
*.sessions=2272
*.sga_target=17179869184
*.standby_file_management=’AUTO’

##Thread parameter must be removed##
EBILDR12.thread=2
EBILDR11.thread=1

*.undo_retention=3600

##Remove undo tablespace for 2nd instance parameter##
EBILDR12.undo_tablespace=’UNDOTBS2′

EBILTST.undo_tablespace=’UNDOTBS1′

##This parameter is only useful if huge pages is setup##
*.use_large_pages=’ONLY’

4.Please startup database in no mount mode.

5.Please create following redo log directory in ASM

+FRA/EBILTST

6.Please provide tns entry of source database in target tnsnames.ora

7.Please check if sufficient space is available or not.

8.Now you can execute following command for database duplicate.Please note if it is big database,run it in nohup.

A.Nohup step:-

Please add more process for auxiliary channel if you need more parallelism for big database.

vi rman_restore.cmd

run {
set until time = “TO_DATE(’11/02/2017 18:59:00′,’MM/DD/YYYY HH24:MI:SS’)” ;
2> 3> configure auxiliary channel 1 device type sbt parms ‘SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)’;
4> DUPLICATE target DATABASE TO EBILTST
logfile
5> 6> group 1 (‘+FRA/EBILTST/redolog1a.log’) size 512M,
7> group 2 (‘+FRA/EBILTST/redolog2a.log’) size 512M,
8> group 3 (‘+FRA/EBILTST/redolog3a.log’) size 512M;
9> }

Export Instance name of  target database

export ORACLE_SID=EBILTST

vi rman_restore.sh
rman catalog BACKUP/p4ssw0rd@ERMANP01 auxiliary / target sys/eb4i3ll5p@EBILPD1 auxiliary / msglog /home/oracle/rman_restore.log cmdfile=/home/oracle/rman_restore.cmd

nohup rman_restore.sh &

keep checking /home/oracle/rman_restore.log

B.Direct from terminal:-

[oracle@cdv1pradbakdbv01 dbs]$ rman catalog BACKUP/p4ssw0rd@ERMANP01 auxiliary / target sys/eb4i3ll5p@EBILPD1

Recovery Manager: Release 12.1.0.2.0 – Production on Fri Nov 3 07:41:09 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: EBILPD1 (DBID=831846396)
connected to recovery catalog database
connected to auxiliary database: EBILTST (not mounted)

RMAN> run {
set until time = “TO_DATE(’11/02/2017 18:59:00′,’MM/DD/YYYY HH24:MI:SS’)” ;
2> 3> configure auxiliary channel 1 device type sbt parms ‘SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)’;
4> DUPLICATE target DATABASE TO EBILTST
logfile
5> 6> group 1 (‘+FRA/EBILTST/redolog1a.log’) size 512M,
7> group 2 (‘+FRA/EBILTST/redolog2a.log’) size 512M,
8> group 3 (‘+FRA/EBILTST/redolog3a.log’) size 512M;
9> }

executing command: SET until clause

old RMAN configuration parameters:
CONFIGURE AUXILIARY CHANNEL 1 DEVICE TYPE ‘SBT_TAPE’ PARMS ‘SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)’;
new RMAN configuration parameters:
CONFIGURE AUXILIARY CHANNEL 1 DEVICE TYPE ‘SBT_TAPE’ PARMS ‘SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=OCRMPD1,OB2BARLIST=CDV-PRD-DB-OCRMPD1_MENSUAL)’;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Starting Duplicate Db at 03-NOV-17
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=737 device type=DISK
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=2 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Data Protector A.09.00/110

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 5184159744 bytes

Fixed Size 5294472 bytes
Variable Size 1358956152 bytes
Database Buffers 3808428032 bytes
Redo Buffers 11481088 bytes

contents of Memory Script:
{
set until scn 44821971954;
sql clone “alter system set control_files =
”+DATA/EBILTST/CONTROLFILE/current.498.959067807” comment=
”Set by RMAN” scope=spfile”;
sql clone “alter system set db_name =
”EBILPD1” comment=
”Modified by RMAN duplicate” scope=spfile”;
sql clone “alter system set db_unique_name =
”EBILTST” 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

executing command: SET until clause

sql statement: alter system set control_files = ”+DATA/EBILTST/CONTROLFILE/current.498.959067807” comment= ”Set by RMAN” scope=spfile

sql statement: alter system set db_name = ”EBILPD1” comment= ”Modified by RMAN duplicate” scope=spfile

sql statement: alter system set db_unique_name = ”EBILTST” comment= ”Modified by RMAN duplicate” scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 5184159744 bytes

Fixed Size 5294472 bytes
Variable Size 1358956152 bytes
Database Buffers 3808428032 bytes
Redo Buffers 11481088 bytes

Starting restore at 03-NOV-17
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=2 device type=DISK
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=51 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Data Protector A.09.00/110

channel ORA_AUX_DISK_1: restoring control file
ORA-19625: error identifying file /NFSPREPROD/CF_HPDP/ctrl_EBILPD1_44288.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file (/NFSPREPROD/CF_HPDP/ctrl_EBILPD1_44288.dbf)
ORA-19601: output file is control file (+DATA/EBILTST/CONTROLFILE/current.498.959067807)

failover to previous backup

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: restoring control file
channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-831846396-20171102-00
channel ORA_AUX_SBT_TAPE_1: piece handle=c-831846396-20171102-00 tag=TAG20171102T143147
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
output file name=+DATA/EBILTST/CONTROLFILE/current.498.959067807
Finished restore at 03-NOV-17

database mounted

contents of Memory Script:
{
set until scn 44821971954;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
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

Starting restore at 03-NOV-17
using channel ORA_AUX_DISK_1
using channel ORA_AUX_SBT_TAPE_1

channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00002 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36833:958948289:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36833:958948289:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:01:31
channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00004 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36834:958948289:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36834:958948289:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:01:01
channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00005 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36832:958948289:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36832:958948289:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:01:05
channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00006 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36837:958948315:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36837:958948315:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00001 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36836:958948315:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36836:958948315:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_AUX_SBT_TAPE_1: starting datafile backup set restore
channel ORA_AUX_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_SBT_TAPE_1: restoring datafile 00003 to +DATA
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36835:958948289:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_MENSUAL<EBILPD1_36835:958948289:1>.dbf tag=TAG20171101T223128
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:01:25
Finished restore at 03-NOV-17

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=942 STAMP=959068298 file name=+DATA/EBILTST/DATAFILE/system.462.959068193
datafile 2 switched to datafile copy
input datafile copy RECID=943 STAMP=959068299 file name=+DATA/EBILTST/DATAFILE/undotbs2.470.959067947
datafile 3 switched to datafile copy
input datafile copy RECID=944 STAMP=959068300 file name=+DATA/EBILTST/DATAFILE/sysaux.461.959068249
datafile 4 switched to datafile copy
input datafile copy RECID=945 STAMP=959068301 file name=+DATA/EBILTST/DATAFILE/undotbs1.487.959068031
datafile 5 switched to datafile copy
input datafile copy RECID=946 STAMP=959068302 file name=+DATA/EBILTST/DATAFILE/tbs_botdba.464.959068085
datafile 6 switched to datafile copy
input datafile copy RECID=947 STAMP=959068303 file name=+DATA/EBILTST/DATAFILE/users.463.959068149

contents of Memory Script:
{
set until time “to_date(‘NOV 02 2017 18:59:00’, ‘MON DD YYYY HH24:MI:SS’)”;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 03-NOV-17
using channel ORA_AUX_DISK_1
using channel ORA_AUX_SBT_TAPE_1

starting media recovery

channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=2172
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36854:959005893:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36854:959005893:1>.dbf tag=TAG20171102T143053
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=2 sequence=2112
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36852:959005892:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36852:959005892:1>.dbf tag=TAG20171102T143053
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2112.370.959068393 thread=2 sequence=2112
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2172.371.959068347 thread=1 sequence=2172
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2172.371.959068347 RECID=9361 STAMP=959068349
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=2173
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36855:959005893:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36855:959005893:1>.dbf tag=TAG20171102T143053
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2173.371.959068439 thread=1 sequence=2173
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2112.370.959068393 RECID=9362 STAMP=959068393
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=2 sequence=2113
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36856:959005896:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36856:959005896:1>.dbf tag=TAG20171102T143053
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2113.370.959068483 thread=2 sequence=2113
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2173.371.959068439 RECID=9363 STAMP=959068439
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=2174
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36859:959023854:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36859:959023854:1>.dbf tag=TAG20171102T193054
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2174.371.959068529 thread=1 sequence=2174
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2113.370.959068483 RECID=9364 STAMP=959068484
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=2 sequence=2114
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36858:959023854:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36858:959023854:1>.dbf tag=TAG20171102T193054
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2114.370.959068585 thread=2 sequence=2114
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2174.371.959068529 RECID=9365 STAMP=959068540
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=2175
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36860:959023854:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36860:959023854:1>.dbf tag=TAG20171102T193054
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2175.371.959068629 thread=1 sequence=2175
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2114.370.959068585 RECID=9366 STAMP=959068585
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=2 sequence=2115
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36861:959023855:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-ARCHIVE-EBILLPD1<EBILPD1_36861:959023855:1>.dbf tag=TAG20171102T193054
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2115.370.959068675 thread=2 sequence=2115
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2115.370.959068675 RECID=9368 STAMP=959068676
channel ORA_AUX_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=2 sequence=2116
channel ORA_AUX_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=2176
channel ORA_AUX_SBT_TAPE_1: reading from backup piece CDV-PRD-DB-EBILLPD1_<EBILPD1_36874:959034744:1>.dbf
channel ORA_AUX_SBT_TAPE_1: piece handle=CDV-PRD-DB-EBILLPD1_<EBILPD1_36874:959034744:1>.dbf tag=TAG20171102T223224
channel ORA_AUX_SBT_TAPE_1: restored backup piece 1
channel ORA_AUX_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2116.370.959068721 thread=2 sequence=2116
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2175.371.959068629 RECID=9367 STAMP=959068629
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2176.369.959068721 thread=1 sequence=2176
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_1_seq_2176.369.959068721 RECID=9369 STAMP=959068723
channel clone_default: deleting archived log(s)
archived log file name=+ARCHIVE/EBILTST/ARCHIVELOG/2017_11_03/thread_2_seq_2116.370.959068721 RECID=9370 STAMP=959068724
media recovery complete, elapsed time: 00:00:00
Finished recover at 03-NOV-17
Oracle instance started

Total System Global Area 5184159744 bytes

Fixed Size 5294472 bytes
Variable Size 1358956152 bytes
Database Buffers 3808428032 bytes
Redo Buffers 11481088 bytes

contents of Memory Script:
{
sql clone “alter system set db_name =
”EBILTST” comment=
”Reset to original value by RMAN” scope=spfile”;
sql clone “alter system reset db_unique_name scope=spfile”;
}
executing Memory Script

sql statement: alter system set db_name = ”EBILTST” comment= ”Reset to original value by RMAN” scope=spfile

sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started

Total System Global Area 5184159744 bytes

Fixed Size 5294472 bytes
Variable Size 1358956152 bytes
Database Buffers 3808428032 bytes
Redo Buffers 11481088 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “EBILTST” RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( ‘+FRA/EBILTST/redolog1a.log’ ) SIZE 512 M ,
GROUP 2 ( ‘+FRA/EBILTST/redolog2a.log’ ) SIZE 512 M ,
GROUP 3 ( ‘+FRA/EBILTST/redolog3a.log’ ) SIZE 512 M
DATAFILE
‘+DATA/EBILTST/DATAFILE/system.462.959068193’
CHARACTER SET WE8ISO8859P15

 

contents of Memory Script:
{
set newname for clone tempfile 1 to new;
switch clone tempfile all;
catalog clone datafilecopy “+DATA/EBILTST/DATAFILE/undotbs2.470.959067947”,
“+DATA/EBILTST/DATAFILE/sysaux.461.959068249”,
“+DATA/EBILTST/DATAFILE/undotbs1.487.959068031”,
“+DATA/EBILTST/DATAFILE/tbs_botdba.464.959068085”,
“+DATA/EBILTST/DATAFILE/users.463.959068149”;
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

cataloged datafile copy
datafile copy file name=+DATA/EBILTST/DATAFILE/undotbs2.470.959067947 RECID=1 STAMP=959068758
cataloged datafile copy
datafile copy file name=+DATA/EBILTST/DATAFILE/sysaux.461.959068249 RECID=2 STAMP=959068758
cataloged datafile copy
datafile copy file name=+DATA/EBILTST/DATAFILE/undotbs1.487.959068031 RECID=3 STAMP=959068758
cataloged datafile copy
datafile copy file name=+DATA/EBILTST/DATAFILE/tbs_botdba.464.959068085 RECID=4 STAMP=959068758
cataloged datafile copy
datafile copy file name=+DATA/EBILTST/DATAFILE/users.463.959068149 RECID=5 STAMP=959068758

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=959068758 file name=+DATA/EBILTST/DATAFILE/undotbs2.470.959067947
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=959068758 file name=+DATA/EBILTST/DATAFILE/sysaux.461.959068249
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=959068758 file name=+DATA/EBILTST/DATAFILE/undotbs1.487.959068031
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=959068758 file name=+DATA/EBILTST/DATAFILE/tbs_botdba.464.959068085
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=959068758 file name=+DATA/EBILTST/DATAFILE/users.463.959068149
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
Executing: alter database enable block change tracking

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Cannot remove created server parameter file
Finished Duplicate Db at 03-NOV-17

RMAN>

One Reply to “RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name”

Leave a Reply

Your email address will not be published. Required fields are marked *