重庆思庄Oracle、Redhat认证学习论坛

标题: RMAN-06820 备库rman备份异常处理 [打印本页]

作者: denglj 时间: 2022-1-26 16:56
标题: RMAN-06820 备库rman备份异常处理
主备数据库版本：11.2.0.4
备份操作放在standby端进行操作，不仅可以节省主库磁盘资源，还能转移备份需要的性能消耗.
在一次测试库模拟备库执行rman备份时，出现RMAN-06820异常，如下：
[oracle@OEL792 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jan 23 00:04:36 2022

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

connected to target database: ORCL150 (DBID=4034131047)

RMAN> backup database plus archivelog delete input;

Starting backup at 23-JAN-22
using target database control file instead of recovery catalog
RMAN-06820: WARNING: failed to archive current log at primary database
ORACLE error from target database:
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-00942: table or view does not exist

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting archived log backup set

.....(省略若干)

根据错误提示，查询MOS发现对应的bug信息，当oracle尝试访问主库过程时，需要将全部的standby log获取到，当连接失败时就会发生报错。
从官方文档（ID：1616074.1）了解到，此为11.2.0.4版本的一个bug 8740124，应该使用用户名加密码的方式连接，如：$ rman target sys/password@连接字符串

如下解决步骤：
[oracle@OEL792 ~]$ rman target sys/password@orcl151

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jan 22 21:27:42 2022

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

connected to target database: ORCL150 (DBID=4034131047)

RMAN> backup database plus archivelog delete input;

Starting backup at 22-JAN-22
using target database control file instead of recovery catalog
RMAN-06820: WARNING: failed to archive current log at primary database
ORACLE error from target database:
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12543: TNS:destination host unreachable
ORA-17629: Cannot connect to the remote database server

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
....(省略若干)

问题依然存在，造成这个问题的原因经确认为主库端防火墙未关.
关闭主库防火墙后，再次连接rman做备份操作，此后无问题发生。

[oracle@OEL792 ~]$ rman target sys/password@orcl151

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jan 23 00:02:54 2022

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

connected to target database: ORCL150 (DBID=4034131047)

RMAN> backup database plus archivelog delete input;

Starting backup at 23-JAN-22
using target database control file instead of recovery catalog
current log archived at primary database
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=132 RECID=185 STAMP=1094681022

.....(省略若干)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)