RMAN-05537 Problem Analysis

Rman-05537:duplicate without TARGET connection when auxiliary instance are started with SPFile Canno

Today is 2014-06-18, the following error occurred while replicating the data:

Rman-05537:duplicate without TARGET connection when auxiliary instance are started with SPFile cannot use SPFile

The operation process is as follows:

[ORACLE@DG1 dbs]$ Rman target SYS/ROOT@DG1 auxiliary sys/root@dg2 Recovery manager:release 11.2.0.4.0-pro  Duction on Wed June 13:24:33 2014 Copyright (c) 1982, Oracle and/or its affiliates.    
        
All rights reserved. Connected to target Database:rhys (dbid=2760870303) connected to auxiliary database:dg2 (not mounted) R man> rman> rman> rman> rman> run{2> alloca    
TE channel ch1 type disk;    
3> Allocate channel CH2 type disk;    
4> Allocate channel CH3 type disk;    
5> Allocate channel CH4 type disk;    
6> Allocate channel CH5 type disk;    
7> Allocate channel CH6 type disk;    
8> Allocate channel CH7 type disk;    
9> Allocate auxiliary channel CH8 type disk; 10> duplicate target database for standby from active database Nofilenamecheck 11> spfile 12> parame Ter_value_convert ' DG1 ', ' dg2 ' 13> set db_unique_name= ' DG2 ' 14> set db_recovery_file_dest= '/u01/app/oracle/fast_recovery_area ' 15> set D B_recovery_file_dest_size= ' 4G ' 16> set control_files= '/u01/app/oracle/oradata/dg/control01.ctl ' 17> set Db_cre ate_file_dest= '/U01/APP/ORACLE/ORADATA/DG ' 18> set db_create_online_log_dest_1= '/U01/APP/ORACLE/ORADATA/DG ' 19 > Set log_archive_max_processes= ' 5 ' 20> set fal_client= ' DG2 ' 21> set fal_server= ' DG1 ' 22> set Stan Dby_file_management= ' AUTO ' 23> set log_archive_config= ' dg_config= (DG1,DG2) ' 24> set log_archive_dest_1= ' Locati On=use_db_recovery_file_dest valid_for= (all_logfiles,all_roles) ' 25> set log_archive_dest_2= ' SERVICE=DG1 LGWR    
Sync valid_for= (online_logfiles,primary_role) DB_UNIQUE_NAME=DG1 ';    
26> SQL Channel CH6 "alter system set LOG_ARCHIVE_MAX_PROCESSES=5";    
27> SQL Channel CH7 "alter system set FAL_CLIENT=DG1";   28> SQL Channel CH7 "alter system set FAL_SERVER=DG2"; 
29> SQL Channel CH5 "alter system set Standby_file_management=auto";    
30> SQL Channel CH6 "alter system set log_archive_config= ' dg_config= (DG1,DG2) '"; 31> SQL Channel CH7 "alter system set log_archive_dest_2= ' Service=dg2 lgwr sync valid_for= (online_logfiles,primary    
_role) Db_unique_name=dg2 ' "; 32> SQL Channel CH6 "alter system set log_archive_dest_1= ' Location=use_db_recovery_file_dest valid_for= (all_logfil    
es,all_roles) ' ";    
33> SQL Channel CH1 "alter system archive log current"; 34> SQL Channel CH8 "ALTER DATABASE recover managed standby database using current logfile disconnect ' session"    
;    
35> release channel CH1;    
36> release channel CH2;    
37> release channel CH3;    
38> release channel CH4;    
39> release channel Ch5;    
40> release channel Ch6;    
41> release channel Ch7;    
42> release channel Ch8; 43>} using Target database control file insteadof recovery Catalog allocated CHANNEL:CH1 channel CH1:SID=35 device Type=disk allocated Channel:ch    
        
2 channel ch2:sid=42 device Type=disk allocated CHANNEL:CH3 channel ch3:sid=44 device Type=disk  Allocated CHANNEL:CH4 channel ch4:sid=38 device Type=disk allocated CHANNEL:CH5 Channel ch5:sid=36 device Type=disk allocated CHANNEL:CH6 channel ch6:sid=41 device Type=disk al Located CHANNEL:CH7 Channel ch7:sid=37 device Type=disk allocated CHANNEL:CH8 channel ch8:sid=1 D Evice Type=disk starting Duplicate Db at 18-jun-14 released Channel:ch1 released Channel:ch2 re Leased Channel:ch3 released Channel:ch4 released Channel:ch5 released Channel:ch6 released Channel:ch 7 released Channel:ch8 RMAN-00571: =========================================================== RMAN-00569: = = ============= ERROR MESSAge STACK follows =============== RMAN-00571: =========================================================== RMAN-030 02:failure of Duplicate Db command at 06/18/2014 13:24:43 rman-05501:aborting duplication of target database RMAN-05    
        
537:duplicate without TARGET connection when auxiliary instance are started with SPFile cannot use SPFile Rman> exit

Problem handling,

Create a pfile file for the standby, and then start from Pfile.

 [oracle@dg2 dbs]$ sqlplus/as sysdba sql*plus:release 11.2.0.4.0 Production on Wed June 18 13:25:03 20  Copyright (c) 1982, 2013, 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> shutdown immediate;    
Ora-01507:database not mounted ORACLE instance shut down.    
        
sql> sql> Create pfile= '/home/oracle/pfile.ora ' from SPFile;    
        
File created.    
sql> startup Nomount pfile= '/home/oracle/pfile.ora ';    
        
ORACLE instance started. Total System Global area 839282688 bytes Fixed size 2257880 bytes Variable Size 5452 62632 bytes Database buffers 289406976 bytes Redo buffers 2355200 bytes sql> S Ql> 

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/