暂无图片
Oracle 12c dataguard搭建时rman同步数据报错:ORA-17627: ORA-12528
我来答
分享
不如打代码
2021-11-30
Oracle 12c dataguard搭建时rman同步数据报错:ORA-17627: ORA-12528

Oracle 12c dataguard搭建时rman同步数据报错:ORA-17627: ORA-12528

为什么rman的时候可以正常连接,在运行过程中却报错连接不到主机TNS:listener: all appropriate instances are blocking new connections ,求解?

机器环境

db_name=rac
主机:rac1,rac2两个节点
备机:stbrac,stbrac2两个节点

报错信息

[oracle@stb-rac1 ~]$ rman target sys/xxxx@rac auxiliary sys/xxxx@stbrac

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Nov 30 10:26:16 2021

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

connected to target database: RAC (DBID=2677927145)
connected to auxiliary database: RAC (not mounted)

RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate auxiliary channel stbc1 type disk;
5> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
6> SPFILE
7> set 'db_unique_name'='stbrac'
8> set instance_name='stbrac1'
9> set instance_number='1'
10> set db_create_online_log_dest_1='+DATA'
11> set db_create_online_log_dest_2='+DATA'
12> set db_recovery_file_dest='+DATA'
13> set audit_file_dest='/u01/app/oracle/admin/stbrac/adump'
14> set core_dump_dest='/u01/app/oracle/admin/stbrac/cdump'
15> nofilenamecheck
16> dorecover;
17> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=39 instance=rac1 device type=DISK

allocated channel: c2
channel c2: SID=101 instance=rac2 device type=DISK

allocated channel: stbc1
channel stbc1: SID=24 device type=DISK

Starting Duplicate Db at 30-NOV-21

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '+DATA/RAC/PASSWORD/pwdrac.256.1089944947' auxiliary format 
 '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/orapwstbrac1'   targetfile 
 '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfilerac2.ora' auxiliary format 
 '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfilestbrac1.ora'   ;
   sql clone "alter system set spfile= ''/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfilestbrac1.ora''";
}
executing Memory Script

Starting backup at 30-NOV-21
RMAN-03009: failure of backup command on c2 channel at 11/30/2021 10:26:53
ORA-17627: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-run
released channel: c1
released channel: c2
released channel: stbc1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/30/2021 10:26:53
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c1 channel at 11/30/2021 10:26:53
ORA-17627: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-17629: Cannot connect to the remote database server

RMAN> 

监听信息

[oracle@stb-rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 30-NOV-2021 10:30:36

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                30-NOV-2021 10:24:27
Uptime                    0 days 0 hr. 6 min. 8 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

image.png

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
范伟林
2021-11-30
实例blocked很明显了,先把实例关了,确认都关闭完,再把实例启动到nomount,确认监听状态没有blocked,就可以了
暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
不如打代码
题主
2021-11-30
多谢。解决了,是因为,tnsnames.ora 备库里面的的SERVICE_NAME写成主库的了。
Uncopyrightable
2021-11-30

tnsping测试一下别名,然后把备库启动到nomount状态试试,19c得dbca创建备库好使~

https://www.modb.pro/db/69631

暂无图片 评论
暂无图片 有用 0
打赏 0
不如打代码
题主
2021-11-30
多谢,19c的版本我试试
Donnieyen
2022-01-10

正好这2天也在做12C的ADG测试,这个需要在备库的监听文件里配置静态

#增加静态监听

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = standby)

(SID_NAME = standby)

(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)

)

)

[oracle@standby dbs]$ lsnrctl stat

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 10-JAN-2022 10:24:26

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=standby)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 09-JAN-2022 22:39:04
Uptime 0 days 11 hr. 45 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /opt/app/oracle/diag/tnslsnr/standby/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "standby" has 1 instance(s).
Instance "standby", status UNKNOWN, has 1 handler(s) for this service...
Service "standby.com" has 1 instance(s).
Instance "standby", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully



暂无图片 评论
暂无图片 有用 0
打赏 0
Donnieyen
2022-01-10

或者重启实例或者重启监听再连接测试

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏