following output is based on the RMAN sctipt used by my following post:
Setup Standby Instance on same host – Oracle 11gR2 / OEL7_64bit
[oraadmin@ol7 work]$ rman target sys/oraadmin@ora11g auxiliary sys/oraadmin@ora11gsd
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 15 15:33:57 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11G (DBID=4278207140)
connected to auxiliary database: ORA11GSD (not mounted)
RMAN> @dup.sql
RMAN> run {
2> allocate channel prmy1 type disk;
3> allocate channel prmy2 type disk;
4> allocate channel prmy3 type disk;
5> allocate channel prmy4 type disk;
6> allocate auxiliary channel stby type disk;
7> duplicate target database for standby from active database spfile parameter_value_convert 'ORA11G','ORA11GSD'
8> set db_unique_name='ORA11GSD'
9> set db_file_name_convert='/u01/app/oracle/oradata/ORA11G/','/u01/app/oracle/oradata/ORA11GSD/'
10> set log_file_name_convert='/ORA11G/','/ORA11GSD/'
11> set control_files='/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl','/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl','/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'
12> set log_archive_max_processes='5'
13> set fal_client='ORA11GSD'
14> set fal_server='ORA11G'
15> set standby_file_management='AUTO'
16> set log_archive_config='dg_config=(ORA11G,ORA11GSD)'
17> set log_archive_dest_1='service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD';
18>
19> }
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=17 device type=DISK
allocated channel: prmy2
channel prmy2: SID=142 device type=DISK
allocated channel: prmy3
channel prmy3: SID=16 device type=DISK
allocated channel: prmy4
channel prmy4: SID=146 device type=DISK
allocated channel: stby
channel stby: SID=134 device type=DISK
Starting Duplicate Db at 15-JUN-15
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11G' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwORA11GSD' targetfile
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11G.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora''";
}
executing Memory Script
Starting backup at 15-JUN-15
Finished backup at 15-JUN-15
sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileORA11GSD.ora''
contents of Memory Script:
{
sql clone "alter system set audit_file_dest =
''/u01/app/oracle/admin/ORA11GSD/adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=ORA11GSDXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''ORA11GSD'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''/u01/app/oracle/oradata/ORA11G/'', ''/u01/app/oracle/oradata/ORA11GSD/'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''/ORA11G/'', ''/ORA11GSD/'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl'', ''/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl'', ''/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_max_processes =
5 comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''ORA11GSD'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''ORA11G'' comment=
'''' scope=spfile";
sql clone "alter system set standby_file_management =
''AUTO'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_config =
''dg_config=(ORA11G,ORA11GSD)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/ORA11GSD/adump'' comment= '''' scope=spfile
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=ORA11GSDXDB)'' comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''ORA11GSD'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/ORA11G/'', ''/u01/app/oracle/oradata/ORA11GSD/'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''/ORA11G/'', ''/ORA11GSD/'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl'', ''/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl'', ''/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl'' comment= '''' scope=spfile
sql statement: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile
sql statement: alter system set fal_client = ''ORA11GSD'' comment= '''' scope=spfile
sql statement: alter system set fal_server = ''ORA11G'' comment= '''' scope=spfile
sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
sql statement: alter system set log_archive_config = ''dg_config=(ORA11G,ORA11GSD)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_1 = ''service=ORA11G valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=ORA11GSD'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1453092864 bytes
Fixed Size 2253304 bytes
Variable Size 905973256 bytes
Database Buffers 536870912 bytes
Redo Buffers 7995392 bytes
allocated channel: stby
channel stby: SID=133 device type=DISK
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
restore clone controlfile to '/u01/app/oracle/HA/redolog2/ORA11GSD/controlfile/controlfile02.ctl' from
'/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
restore clone controlfile to '/u01/app/oracle/HA/redolog3/ORA11GSD/controlfile/controlfile03.ctl' from
'/u01/app/oracle/HA/redolog1/ORA11GSD/controlfile/controlfile01.ctl';
}
executing Memory Script
Starting backup at 15-JUN-15
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_ORA11G.f tag=TAG20150615T153429 RECID=3 STAMP=882459270
channel prmy1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 15-JUN-15
Starting restore at 15-JUN-15
channel stby: copied control file copy
Finished restore at 15-JUN-15
Starting restore at 15-JUN-15
channel stby: copied control file copy
Finished restore at 15-JUN-15
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_temp_bqjqmo79_.tmp";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf" datafile
5 auxiliary format
"/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_temp_bqjqmo79_.tmp in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 15-JUN-15
channel prmy1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_system_bqjqlhlm_.dbf
channel prmy2: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_sysaux_bqjqlzq8_.dbf
channel prmy3: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf
channel prmy4: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11G/datafile/example_01.dbf
output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf tag=TAG20150615T153445
channel prmy1: datafile copy complete, elapsed time: 00:00:35
channel prmy1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11G/datafile/o1_mf_users_bqjqnhqv_.dbf
output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf tag=TAG20150615T153445
channel prmy4: datafile copy complete, elapsed time: 00:00:51
output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf tag=TAG20150615T153445
channel prmy1: datafile copy complete, elapsed time: 00:00:26
output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf tag=TAG20150615T153445
channel prmy2: datafile copy complete, elapsed time: 00:01:17
output file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf tag=TAG20150615T153445
channel prmy3: datafile copy complete, elapsed time: 00:01:17
Finished backup at 15-JUN-15
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=3 STAMP=882459366 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_system_bqjqlhlm_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=4 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_sysaux_bqjqlzq8_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_undotbs1_bqjqmf5p_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/o1_mf_users_bqjqnhqv_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=882459367 file name=/u01/app/oracle/oradata/ORA11GSD/datafile/example_01.dbf
Finished Duplicate Db at 15-JUN-15
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN> **end-of-file**
RMAN>
Banff Rangers 
Leave a comment