2021-12-01
RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed,请问备库中的rac服务是怎么来的?

请问备库这个Service "rac" has 1 instance(s). Instance "stbrac1", status BLOCKED, has 1 handler(s) for this service...
是哪里来的?
问题背景
已经将rac to rac的dataguard搭建好了。然后将备库中的数据文件、控制文件、pfile、spfile全部清理掉重新搭建,出现了下面的问题。
报错信息
[oracle@stb-rac1 dbs]$ rman TARGET sys/xxx@rac AUXILIARY sys/xxx@stbrac Recovery Manager: Release 12.2.0.1.0 - Production on Wed Dec 1 13:57:09 2021 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: RAC (DBID=2677927145) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed
复制
截图
备库信息
[grid@stb-rac1 admin]$ cat $ORACLE_HOME/network/admin/listener.ora LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent MGMTLSNR=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR)))) # line added by Agent LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM)))) # line added by Agent SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = stbrac) (ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1) (SID_NAME = stbrac1) ) ) ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MGMTLSNR=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_MGMTLSNR=SUBNET # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent [grid@stb-rac1 admin]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 01-DEC-2021 13:54:39 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 01-DEC-2021 13:47:10 Uptime 0 days 0 hr. 7 min. 28 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/12.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/stb-rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.92)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.93)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_OCR" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "rac" has 1 instance(s). Instance "stbrac1", status BLOCKED, has 1 handler(s) for this service... Service "stbrac" has 1 instance(s). Instance "stbrac1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [grid@stb-rac1 admin]$ su - oracle Password: Last login: Wed Dec 1 13:45:39 EST 2021 on pts/1 [oracle@stb-rac1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. RAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scan-cluster)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac) ) ) stbrac = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = stb-rac1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = stbrac)(UR=A) ) ) [oracle@stb-rac1 ~]$
复制
我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
回答交流
Markdown
请输入正文
提交
相关推荐
关于Oracle DG的归档目录问题
回答 2
已采纳
不需重启数据库(之前记错了),注意rac俩节点sid'',不影响dg
DataGuard的两端(Primary&Standby)都要配成multi-tenant,请问比较high-level的步骤有哪些啊?
回答 1
参考https://www.modb.pro/db/162937
oracle dg搭建传输时间估算
回答 2
受网络和服务器网卡配置的限制,我这边旧服务器是千兆网卡目标端万兆,但也就只能按千兆算,每秒传输90Mb左右,3T过一点的数据我大概需要8个小时左右。
oracle DG问题
回答 2
备库的参数文件里提前写好controlfiles参数,指向备库ASM磁盘组的路径上
请教一个dataguard备库恢复的问题
回答 3
已采纳
问题解决了,多谢各位的帮助。dbname是可以设置成不同的,这个不是必须。主库的controlfile每次恢复后会把DATA2下的文件引用弄丢,这个可能是跟我的配置有关,但是生产库不敢乱动,这次的问题
一个长时间关闭的Data Guard从库,现在要重新运行起来,需要怎样操作,有什么注意点?
回答 2
已采纳
adg会接收主库相差的归档日志,并应用归档,保持实时同步。需要确定主库的归档清理规则如:主库归档保留7天,并使用force命令强制删除归档,而adg库14天就停了,那就会导致,缺失归档,这可以使用增量
Oracle dataguard
回答 1
您好,检查一下主备文件路径及权限。
oracle 11g rac to rac adg搭建问题
回答 2
ADG搭建时主要是有个dbuniquename设置,方便区分主备逻辑关系,在进行日志的同步或者异步操纵不会出现混乱的情况。主备库的SID可以相同,也可以不相同,差异主要在进行转换参数的设置上;可以查看
dataguard主从切换,从库哪些参数是必须配置的
回答 1
你说的对,只要弄清楚参数含义,很容易理解了,所幸DG涉及参数还不多https://docs.oracle.com/en/database/oracle/oracledatabase/19/sbydb/
Oracle 12cR2 RAC to Rac搭建datagurad控制文件复制过程中报错,是控制文件损坏吗,可以通过什么方式解决?
回答 5
已采纳
问题解决方法通过查询alert日志找到问题原因<msgtime'20210910T13:41:10.83904:00'orgid'oracle'compid'rdbms'type'UNKNOWN
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
热门文章
11g搭建DataGuard
如何通过 RMAN 的增量备份恢复 DataGuard中 Standby 端的数据
[译] Data Guard:Oracle Database 21c 中的 PREPARE DATABASE FOR DATA GUARD 命令
通过NBU备份搭建oracle 19c ADG (RAC-RAC)
zCloud的dbPaaS能力(三):高可用管理 Part1 - Oracle
19c dataguard 快速配置
PG DATAGUARD
ORACLE 11G 搭建DATAGUARD步骤
Oracle dataguard困惑解答,如何应对常见挑战?
搭DG之ORA-12537: TNS:connection closed