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
我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏