rman创建 DG 备库时报错:ORA-17629

在尝试使用RMAN创建Oracle Data Guard备库时遇到ORA-17629错误,该错误与远程数据库服务器连接失败有关。错误原因是TNS连接超时或权限被拒绝。通过检查发现防火墙未开放所需端口。为快速解决问题,关闭了防火墙,从而解决了TNS连接问题,成功创建备库。

[oracle@pridb ~]$ rman target / auxiliary sys/oraclesys@sbdb2
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jul 24 21:36:45 2013
Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: pridb (DBID=1818030427)
connected to auxiliary database: sbdb2 (not mounted)

RMAN>

duplicate target database for standby nofilenamecheck
from active database
dorecover
SPFILE
SET db_unique_name = ‘sbdb2’
SET log_archive_dest_1 = ‘LOCATION=/u01/flash_recovery_area/pridb/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)’
SET log_archive_dest_2 = ‘SERVICE=pridb REOPEN=60 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pridb’
SET fal_client = ‘sbdb2’
SET fal_server = ‘pridb’
SET control_files = ‘/u01/oradata/sbdb2/control01.ctl’,’ /u01/flash_recovery_area/sbdb2/control02.ctl’;

Starting Duplicate Db at 2013/07/24 21:37:08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwpridb’ auxiliary format
‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwsbdb2’ targetfile
‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilepridb.ora’ auxiliary format
‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilesbdb2.ora’ ;
sql clone “alter system set spfile= ‘’/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilesbdb2.ora’’”;
}
executing Memory Script
Starting backup at 2013/07/24 21:37:09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/23/2020 21:37:10
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12170: TNS: 连接超时; logon denied
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-runRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/23/2020 21:37:11
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/23/2020 21:37:11
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12170: TNS: 连接超时; logon denied
ORA-17629: Cannot connect to the remote database server

分析:
备库今天才安装,发生TNS访问拒绝,尝试从主库登录备库,发现了TNS-12170的错误。
检查防火墙,发现防火墙没有开启端口,由于是内部使用,暂时把防火墙关闭,问题解决。

解决:
systemctl disable firewalld
systemctl stop firewalld

附:
备库:CENTOS 7.7 +oracle 11.2.0.1

评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值