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
复制