oracle@rac3:/home/oracle>rman target sys/yang402@yangdb auxiliary sys/yang402@yangdb2
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 18:37:27 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=2349912968)
connected to auxiliary database: RAC (not mounted)
RMAN> run {
2> allocate channel c1 type disk connect 'sys/yang402@yangdb';
3> allocate channel c2 type disk connect 'sys/yang402@yangdb';
4> allocate auxiliary channel s1 type disk;
5> allocate auxiliary channel s2 type disk;
6> duplicate target database for standby from active database
7> spfile
8> set db_name='rac'
9> set db_unique_name='yangdb2'
10> set cluster_database='FALSE'
11> set audit_file_dest='/opt/oracle/admin/yangdb2/adump'
12> set DIAGNOSTIC_DEST='/opt/oracle'
13> set db_create_file_dest='/opt/oracle/oradata/yangdb2'
14> set db_recovery_file_dest='/opt/oracle/flash_recovery_area'
15> set control_files='/opt/oracle/oradata/yangdb2/control01.ctl','/opt/oracle/oradata/yangdb2/control02.ctl','/opt/oracle/oradata/yangdb2/control03.ctl'
16> set undo_tablespace='UNDOTBS1'
17> set service_names='yangdb2'
18> set standby_file_management='AUTO'
19> set log_archive_config='DG_CONFIG=(rac,yangdb2,yangdb)'
20> set log_archive_dest_1='LOCATION=/opt/oracle/arch'
21> set log_archive_dest_2='service=yangdb2 ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangdb2'
22> set log_archive_dest_3=''
23> set log_archive_dest_state_1='enable'
24> set log_archive_dest_state_2='enable'
25> set log_archive_dest_state_2='defer'
26> set log_archive_format='yangdb2_%t_%s_%r.log'
27> set remote_login_passwordfile='exclusive'
28> set LOG_FILE_NAME_CONVERT='/opt/oracle/oradata/yangdb','/opt/oracle/oradata/yangdb2','/opt/oracle/oradata/yangdb/YANDGDG/onlinelog','/opt/oracle/oradata/yangdb2'
29> set DB_FILE_NAME_CONVERT='/opt/oracle/oradata/yangdb','/opt/oracle/oradata/yangdb2','/opt/oracle/oradata/yangdb/YANDGDB/datafile','/opt/oracle/oradata/yangdb2'
30> set remote_listener=''
31> set fal_client='yangdb2'
32> set fal_server='yangdb'
33> NOFILENAMECHECK;
34> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1 device type=DISK
allocated channel: c2
channel c2: SID=32 device type=DISK
allocated channel: s1
channel s1: SID=19 device type=DISK
allocated channel: s2
channel s2: SID=20 device type=DISK
Starting Duplicate Db at 15-SEP-11
contents of Memory Script.:
{
backup as copy reuse
targetfile '/opt/oracle/11.2.0/yangdb2/dbs/orapwyangdb' auxiliary format
'/opt/oracle/11.2.0/yangdb2/dbs/orapwyangdb2' targetfile
'/opt/oracle/11.2.0/yangdb2/dbs/spfileyangdb.ora' auxiliary format
'/opt/oracle/11.2.0/yangdb2/dbs/spfileyangdb2.ora' ;
sql clone "alter system set spfile= ''/opt/oracle/11.2.0/yangdb2/dbs/spfileyangdb2.ora''";
}
executing Memory Script
Starting backup at 15-SEP-11
Finished backup at 15-SEP-11
sql statement: alter system set spfile= ''/opt/oracle/11.2.0/yangdb2/dbs/spfileyangdb2.ora''
contents of Memory Script.:
{
sql clone "alter system set db_name =
''rac'' comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set cluster_database =
FALSE comment=
'''' scope=spfile";
sql clone "alter system set audit_file_dest =
''/opt/oracle/admin/yangdb2/adump'' comment=
'''' scope=spfile";
sql clone "alter system set DIAGNOSTIC_DEST =
''/opt/oracle'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_file_dest =
''/opt/oracle/oradata/yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''/opt/oracle/flash_recovery_area'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''/opt/oracle/oradata/yangdb2/control01.ctl'', ''/opt/oracle/oradata/yangdb2/control02.ctl'', ''/opt/oracle/oradata/yangdb2/control03.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set undo_tablespace =
''UNDOTBS1'' comment=
'''' scope=spfile";
sql clone "alter system set service_names =
''yangdb2'' 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=(rac,yangdb2,yangdb)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''LOCATION=/opt/oracle/arch'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_2 =
''service=yangdb2 ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_3 =
'''' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_1 =
''enable'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_2 =
''enable'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_state_2 =
''defer'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_format =
''yangdb2_%t_%s_%r.log'' comment=
'''' scope=spfile";
sql clone "alter system set remote_login_passwordfile =
''exclusive'' comment=
'''' scope=spfile";
sql clone "alter system set LOG_FILE_NAME_CONVERT =
''/opt/oracle/oradata/yangdb'', ''/opt/oracle/oradata/yangdb2'', ''/opt/oracle/oradata/yangdb/YANDGDG/onlinelog'', ''/opt/oracle/oradata/yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''/opt/oracle/oradata/yangdb'', ''/opt/oracle/oradata/yangdb2'', ''/opt/oracle/oradata/yangdb/YANDGDB/datafile'', ''/opt/oracle/oradata/yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set remote_listener =
'''' comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''yangdb2'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''yangdb'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''rac'' comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''yangdb2'' comment= '''' scope=spfile
sql statement: alter system set cluster_database = FALSE comment= '''' scope=spfile
sql statement: alter system set audit_file_dest = ''/opt/oracle/admin/yangdb2/adump'' comment= '''' scope=spfile
sql statement: alter system set DIAGNOSTIC_DEST = ''/opt/oracle'' comment= '''' scope=spfile
sql statement: alter system set db_create_file_dest = ''/opt/oracle/oradata/yangdb2'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''/opt/oracle/flash_recovery_area'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''/opt/oracle/oradata/yangdb2/control01.ctl'', ''/opt/oracle/oradata/yangdb2/control02.ctl'', ''/opt/oracle/oradata/yangdb2/control03.ctl'' comment= '''' scope=spfile
sql statement: alter system set undo_tablespace = ''UNDOTBS1'' comment= '''' scope=spfile
sql statement: alter system set service_names = ''yangdb2'' 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=(rac,yangdb2,yangdb)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_1 = ''LOCATION=/opt/oracle/arch'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_2 = ''service=yangdb2 ARCH ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangdb2'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_3 = '''' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_state_1 = ''enable'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_state_2 = ''enable'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_state_2 = ''defer'' comment= '''' scope=spfile
sql statement: alter system set log_archive_format = ''yangdb2_%t_%s_%r.log'' comment= '''' scope=spfile
sql statement: alter system set remote_login_passwordfile = ''exclusive'' comment= '''' scope=spfile
sql statement: alter system set LOG_FILE_NAME_CONVERT = ''/opt/oracle/oradata/yangdb'', ''/opt/oracle/oradata/yangdb2'', ''/opt/oracle/oradata/yangdb/YANDGDG/onlinelog'', ''/opt/oracle/oradata/yangdb2'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''/opt/oracle/oradata/yangdb'', ''/opt/oracle/oradata/yangdb2'', ''/opt/oracle/oradata/yangdb/YANDGDB/datafile'', ''/opt/oracle/oradata/yangdb2'' comment= '''' scope=spfile
sql statement: alter system set remote_listener = '''' comment= '''' scope=spfile
sql statement: alter system set fal_client = ''yangdb2'' comment= '''' scope=spfile
sql statement: alter system set fal_server = ''yangdb'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1469792256 bytes
Fixed Size 2213456 bytes
Variable Size 872417712 bytes
Database Buffers 587202560 bytes
Redo Buffers 7958528 bytes
allocated channel: s1
channel s1: SID=19 device type=DISK
allocated channel: s2
channel s2: SID=20 device type=DISK
contents of Memory Script.:
{
backup as copy current controlfile for standby auxiliary format '/opt/oracle/oradata/yangdb2/control01.ctl';
restore clone controlfile to '/opt/oracle/oradata/yangdb2/control02.ctl' from
'/opt/oracle/oradata/yangdb2/control01.ctl';
restore clone controlfile to '/opt/oracle/oradata/yangdb2/control03.ctl' from
'/opt/oracle/oradata/yangdb2/control01.ctl';
}
executing Memory Script
Starting backup at 15-SEP-11
channel c1: starting datafile copy
copying standby control file
released channel: c1
released channel: c2
released channel: s1
released channel: s2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/15/2011 18:37:44
RMAN-03015: error occurred in stored script. Memory Script
RMAN-03009: failure of backup command on c1 channel at 09/15/2011 18:37:44
ORA-01671: control file is a backup, cannot make a standby control file
RMAN>
