【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三

Starting backup at 11-SEP-11

RMAN-03009: failure of backup command on c1 channel at 09/11/2011 17:48:09

ORA-19505: failed to identify file "/opt/rac/oracle/11.2.0/db/dbs/orapwrac1"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

continuing other job steps, job failed will not be re-run

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/11/2011 17:48:10

RMAN-03015: error occurred in stored script. Memory Script

RMAN-03009: failure of backup command on c1 channel at 09/11/2011 17:48:09

ORA-19505: failed to identify file "/opt/rac/oracle/11.2.0/db/dbs/orapwrac1"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

提示说明找不到rac1 节点的密码文件,查看节点rac1上的存在orapwrac1 和orapwrac2文件,而节点rac2上不存在

解决办法

将节点rac1上的密码文件orapwrac1拷贝到节点rac2上

#scp orapwrac1 10.250.7.241:/opt/oracle/11.2.0/alifpre/

=============================================================================== 

connected to auxiliary database (not started)

released channel: c2

released channel: c1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 09/11/2011 17:59:06

RMAN-03015: error occurred in stored script. Memory Script

RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system

RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

这里遇见 ORA-00845,因为目标库上运行了两个数据库,内存空间不足,导致 ORA-00845!

解决办法:关闭另外一个数据库实例。

==============================================================================

备库日志中出现:

PING[ARC2]: Heartbeat failed to connect to standby 'yangdb'. Error is 16032.

Sun Sep 11 19:03:49 2011

Errors in file /opt/rac/oracle/diag/rdbms/rac/rac2/trace/rac2_arc2_25846.trc:

ORA-16032: parameter  destination string cannot be translated

PING[ARC2]: Heartbeat failed to connect to standby 'yangdb'. Error is 16032.

Sun Sep 11 19:09:49 2011

Errors in file /opt/rac/oracle/diag/rdbms/rac/rac2/trace/rac2_arc2_25846.trc:

ORA-16032: parameter  destination string cannot be translated

PING[ARC2]: Heartbeat failed to connect to standby 'yangdb'. Error is 16032.

Sun Sep 11 19:15:50 2011

Errors in file /opt/rac/oracle/diag/rdbms/rac/rac2/trace/rac2_arc2_25846.trc:

ORA-16032: parameter  destination string cannot be translated

PING[ARC2]: Heartbeat failed to connect to standby 'yangdb'. Error is 16032.

原因:目的参数无法解析。查看了mos文档,次错误与备库的standby_archive_dest的设置方式有关

解决方法:

SQL> show parameter standby 

NAME                             TYPE         VALUE

------------------------------ ----------------------------------------

standby_archive_dest             string   location=/opt/rac/oracle/arch

standby_file_management          string   MANUAL

SQL> alter system set standby_archive_dest='/opt/rac/oracle/arch' scope=both sid='*';

System altered.

SQL> show parameter standby 

NAME                      TYPE        VALUE

---------------------- ------------  ------------------------------

standby_archive_dest     string      /opt/rac/oracle/arch

standby_file_management  string      MANUAL

再次执行,问题解决。。

时间: 2024-11-01 07:43:42

【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三的相关文章

【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一

环境: 版本  11.2.0.1  1   primary :      name: rac      ip: 10.250.7.226     scan ip:10.250.7.200     使用ASM存储数据  2  standby :     name : yangdb     ip :10.250.7.241    使用filesystem 存储数据 在11gr2 版本中,oracle 提供了duplicate from active database 的功能,也就是可以不用备份源数据

【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二

oracle@rac3:/opt/oracle/11.2.0/yangdb/dbs>rman target sys/yang402@rac  auxiliary / Starting Duplicate Db at 08-SEP-11 released channel: c1 released channel: s1 released channel: s2 RMAN-00571: =========================================================

【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四

oracle@rac1:/home/oracle>rman target sys/yang402@rac auxiliary sys/yang402@yangdb Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 15:46:58 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to

Data Guard Physical Standby Switchover

Data Guard Physical Standby Switchover 一.确保主库相关参数文件,设置正确 如下为主数据库相关参数 DB_NAME=pridb DB_UNIQUE_NAME=pridb LOG_ARCHIVE_CONFIG='DG_CONFIG=(pridb,stdb)' CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ct' LOG_ARCHIVE_DEST_1= 'LOCATIO

Oracle10G Physical Standby Database笔记

oracle|笔记 试验环境primary server:  windows2000 server + oracle 10.0.1.0.2  ORACLE_SID:dgtest  ORACLE_HOME: D:\oracle\product\10.1.0\db_1standby server: windows XP pro + oracle 10.0.1.0.2ORACLE_SID:dgtestORACLE_HOME: D:\oracle\product\10.1.0\db_1   配置步骤首先

【DataGuard】ORA-16014 and ORA-00312 Messages in Alert.log of Physical Standby

安装完成dg后,发现alert 之中的有如下错误 ORA-16014: log 4 sequence# 44 not archived, no available destinations ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orclpdg/redo04.log' Wed Aug 24 22:55:45 2011 Errors in file /opt/oracle/admin/orcl/bdump/orclpdg_arc

Brief description of Oracle physical standby database configuration and manageme

http://lancexu1212.spaces.live.com/ Brief description of Oracle physical standby database configuration and management Configuration of Oracle physical standby database is quite simple,brief steps are as follows: 1.Install Oracle database software an

Brief description of Oracle physical standby database configuration and management

http://lancexu1212.spaces.live.com/ Brief description of Oracle physical standby database configuration and management Configuration of Oracle physical standby database is quite simple,brief steps are as follows: 1.Install Oracle database software an

【RAC安装】 AIX下安装Oracle 11gR2 RAC

[RAC安装] AIX下安装Oracle 11gR2 RAC   1.1  BLOG文档结构图       1.2  前言部分   1.2.1  导读和注意事项 各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~: ① 基于aix安装rac(重点) ② 静默安装rac软件 ③ dbca静默创建rac数据库     Tips:        ① 若文章代码格式有错乱,推荐使用QQ.搜狗或360浏览器,也可以下载pdf格式的文档来查看,pdf文档