RMAN-05537问题解析

RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile canno

今天是2014-06-18，在复制数据的时候出现如下错误：

RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause

操作过程如下：

[oracle@dg1 dbs]$ rman target sys/root@dg1 auxiliary sys/root@dg2    

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 18 13:24:33 2014    

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

connected to target database: RHYS (DBID=2760870303)
connected to auxiliary database: DG2 (not mounted)    

RMAN>     

RMAN>     

RMAN>     

RMAN>     

RMAN> run{
2>  allocate 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>    parameter_value_convert 'dg1','dg2'
13>    set db_unique_name='dg2'
14>    set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
15>    set DB_RECOVERY_FILE_DEST_SIZE='4G'
16>    set control_files='/u01/app/oracle/oradata/dg/control01.ctl'
17>    set db_create_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 standby_file_management='AUTO'
23>    set log_archive_config='dg_config=(dg1,dg2)'
24>    set log_archive_dest_1='location=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_logfiles,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 from 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 instead of recovery catalog
allocated channel: ch1
channel ch1: SID=35 device type=DISK    

allocated channel: ch2
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    

allocated channel: ch7
channel ch7: SID=37 device type=DISK    

allocated channel: ch8
channel ch8: SID=1 device type=DISK    

Starting Duplicate Db at 18-JUN-14
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
released channel: ch5
released channel: ch6
released channel: ch7
released channel: ch8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/18/2014 13:24:43
RMAN-05501: aborting duplication of target database
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause    

RMAN> exit

问题处理，

将备库创建pfile文件，然后从pfile启动即可。

[oracle@dg2 dbs]$ sqlplus / as sysdba    

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 13:25:03 2014    

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             545262632 bytes
Database Buffers          289406976 bytes
Redo Buffers                2355200 bytes
SQL>
SQL>

本栏目更多精彩内容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

以上是小编为您精心准备的的内容，在的博客、问答、公众号、人物、课程等栏目也有的相关内容，欢迎继续使用右上角搜索按钮进行搜索channel interleaving
， channel
， sql server 2014
， set
， database
， ch341
， channels
， release
， rman
type
rman level 0、rman 0级备份、rman 0级备份 1级备份、rman 0 1 2、rman 0级备份恢复，以便于您获取更多的相关知识。