RMAN-06820 备库rman备份异常处理
发布时间：2022-03-08
主备数据库版本：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
.....(省略若干)
备份操作放在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
.....(省略若干)
