【DataGuarad】ORA-01671: cannot make a standby control file

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> 

时间： 2024-09-12 07:53:58

【DataGuarad】ORA-01671: cannot make a standby control file的相关文章

【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database 2011-10-

当试图开启备库的flashback功能时报如下错误: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-01153: an incompatible media recovery is active 原因:备库还在应用日志 ORA-1153, 00000, "an incompatible media recovery is active" // *Cause:

【DataGuarad】获取standby 库的配置信息的脚本

从oracle MOS 上获得一个关于获取standby 库的配置信息的脚本 Note 241438.1 Script. to Collect Data Guard Physical Standby Diagnostic Information set echo off  set feedback off  column timecol new_value timestamp  column spool_extension new_value suffix  select to_char(sys

【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database

当试图开启备库的flashback功能时报如下错误: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-01153: an incompatible media recovery is active 原因:备库还在应用日志 ORA-1153, 00000, "an incompatible media recovery is active" // *Cause:

【DataGuarad】逻辑迁移与standby备库

standby 库不支持expdp,可以使用exp代替 oracle@rac3:/home/oracle>expdp yang/yang directory=dump dumpfile=yang.dmp tables=yang                      Export: Release 11.2.0.1.0 - Production on Tue Sep 20 19:46:42 2011 Copyright (c) 1982, 2009, Oracle and/or its aff

【caffe】无法找到gpu/mxGPUArray.h: No such file or directory

@tags: caffe 问题出现在,windows下编译caffe的过程中.按照github.com/microsoft/caffe的readme配置的. 问题原因是,用的matlab版本较新(2016a),mxGPUArray.h换位置了. 解决办法:/windows/CommonSettings.props里面,找到包含<MatlabDir>的地方,往下两行<IncludePath>里面,添加一项(插在原有两项之间): $(MatlabDir)\toolbox\distcom

【DG】主rac + 备rac dg 部署

[DG]主rac + 备rac dg 部署 一.1  BLOG文档结构图       一.2  前言部分   一.2.1  导读和注意事项 各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~: ① 主库为rac,备库为rac的物理dg的搭建(重点) ② dbca 静默方式创建rac数据库 ③ 如何将数据库加入crsctl管理 ④ rac库修改归档路径和归档模式 ⑤ 如何添加standby日志 ⑥ 简单物理dg的维护     Tips:    

【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库 (三)

[DATAGUARD] 基于同一个主机建立物理备库和逻辑备库 (三) blog文档结构图:         需求: 在同一台机器配置10g单实例+物理dg+逻辑dg,即一个主库上挂2个备库,一个物理备库,一个逻辑备库,总体思路为:先搭建2台物理dg,然后将其中的一台转换为逻辑dg   之前发布过一步一步搭建 oracle 11gR2 rac + dg,这里的dg为物理dg,但是实际自己使用过程中发现需要开3个虚拟机,机器特卡,所以决定在同一台机器上再搭建一台物理和逻辑dg. 一步一步搭建 ora

【RMAN】利用备份片还原数据库

[RMAN]利用备份片还原数据库 BLOG文档结构图       群里有同学说把ORACLE_BASE目录删掉了,现在只有备份片和归档文件了,试问如何恢复.坑,,,,咋能这么干,ORACLE_BASE都敢删,,试着恢复了下,并且记录下来,当然软件安装部分就不记录了. 我再说说目前的情况,只有备份片和归档文件,且从文件名称是看不出dbname和dbid的,在这种情况下其实恢复控制文件是很重要的了,但是鬼知道备份片里边是不是有控制文件的备份呢?我们可能碰到的就是这样的情况,只有备份文件,其它的什么都

【DATAGUARD】 基于同一个主机建立物理备库和逻辑备库（一）

[DATAGUARD] 基于同一个主机建立物理备库和逻辑备库(一)      之前发布过一步一步搭建 oracle 11gR2 rac + dg,这里的dg为物理dg,但是实际自己使用过程中发现需要开3个虚拟机,机器特卡,所以决定在同一台机器上再搭建一台物理和逻辑dg. 一步一步搭建 oracle 11gR2 rac + dg 之前传(一) http://blog.itpub.net/26736162/viewspace-1290405/  一步一步搭建oracle 11gR2 rac+dg之环