查看: 1766|回复: 1

[安装] 【请教】遇到奇怪问题当duplicate standby DB from active DB

[复制链接]
论坛徽章:
6
数据库板块每日发贴之星
日期:2006-03-10 01:02:15数据库板块每日发贴之星
日期:2006-03-11 01:01:35数据库板块每日发贴之星
日期:2006-03-13 01:02:17会员2006贡献徽章
日期:2006-04-17 13:46:34会员2007贡献徽章
日期:2007-09-26 18:42:10ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44
发表于 2011-8-7 21:45 | 显示全部楼层 |阅读模式
最近在搭建physical DataGuard环境,RAC-> RAC, 数据库版 11.2.0.2.0

duplicatd standby from active database 时, 遇到下面问题,感觉蛮奇怪的,我在11GR1没遇到这样的错误。

...
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
Finished backup at 07-AUG-11

Starting restore at 07-AUG-11
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
using channel ORA_AUX_DISK_5

channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_5: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 07-AUG-11

sql statement: create spfile from memory

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/07/2011 08:39:01
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
....

duplicated 前,确认了N遍,可以连上。

各位帮忙看看,我感觉我的listener也是静态注册的呀,也加UR = A了, 不知道还有哪块忘记了?

谢谢各位了

standby:> sqlplus sys/****@standby as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Aug 7 09:13:11 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

primary:> sqlplus sys/****@standby as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Aug 7 09:14:48 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>


standby listener.ora:

BASE_LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = standby2-vip)(PORT = 1521))
      )
    )
  )

SID_LIST_BASE_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME=stdby.****.com)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0)
      (SID_NAME = stdby1b)
    )
  )
  
standby tnsnames.ora:

standby =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby2-vip.×××.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby1-vip.×××.com)(PORT = 1521))
       (LOAD_BALANCE = yes)
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = stdby1b)
          ( UR = A)
        )
    )
论坛徽章:
2
ITPUB官方微博粉丝徽章
日期:2011-06-29 09:48:25ITPUB十周年纪念徽章
日期:2011-11-01 16:26:59
发表于 2011-8-8 17:08 | 显示全部楼层
在listener.ora 和tnsnames.ora里面要把主库也加进去

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表