DataGuard Standby备份报错RMAN-06820 ORA-17629解决

Oracle Dataguard是官方重要HA架构的组成部分。通过只读的Standby数据库，可以在确保高可用的基础上，将一部分报表、备份负载从主库上分离出来，提高主库性能。根据Oracle最佳实践，主库Primary是可以不进行直接的备份，核心备份操作可以放在Standby端进行操作，这样不仅可以节省备份资源，还可以有效的将备份的性能消耗转移到Standby端进行。本文记录了笔者在Physical Standby端进行RMAN备份的时候，遇到错误信息的问题解决。记录下来，留待需要的朋友待查。1、环境说明笔者使用Oracle 11gR2进行测试，具体版本为11.2.0.4。Data Guard Primary和Standby采用的版本完全相同。SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0 - ProductionNLSRTL Version 11.2.0.4.0 – Production在Standby端，是采用Active Data Guard只读应用状态。SQL> select open_mode, database_role from v$database;OPEN_MODE DATABASE_ROLE-------------------- ----------------READ ONLY WITH APPLY PHYSICAL STANDBY2、问题故障在standby端，使用RMAN进行备份动作。进行全库备份和归档日志备份，备份之后尝试删除掉已经备份的日志文件。[oracle@vLIFE-URE-OT-DB-STANDBY trace]$ rman nocatalogRecovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 18 13:44:54 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN> connect target /connected to target database: VLIFE （DBID=4207470439）using target database control file instead of recovery catalog进行RMAN备份。RMAN> backup database plus archivelog delete input;Starting backup at 18-OCT-15RMAN-06820: WARNING: failed to archive current log at primary databaseORACLE error from target database: ORA-17629: Cannot connect to the remote database serverORA-17627: ORA-00942: table or view does not existallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=204 device type=DISKspecification does not match any archived log in the repositorybackup cancelled because there are no files to backupFinished backup at 18-OCT-15Starting backup at 18-OCT-15（篇幅原因，有省略……）handle=/u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893423697_c26dj5nb_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 18-OCT-15在备份过程中出现错误，错误提示上好像是要访问Primary端数据库，之后由于权限问题没有能够访问。其他备份动作看似正常，备份集合显示正确。RMAN> list backup;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------6 27.46M DISK 00:00:00 18-OCT-15 BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20151018T133946 Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/backupset/2015_10_18/o1_mf_annnn_TAG20151018T133946_c26d52kd_.bkp List of Archived Logs in backup set 6 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 22 1290925 18-OCT-15 1298642 18-OCT-15 1 23 1298642 18-OCT-15 1298901 18-OCT-15 1 24 1298901 18-OCT-15 1299107 18-OCT-15 1 25 1299107 18-OCT-15 1299528 18-OCT-15 1 26 1299528 18-OCT-15 1301585 18-OCT-15 1 27 1301585 18-OCT-15 1301853 18-OCT-15 1 28 1301853 18-OCT-15 1302226 18-OCT-15 1 29 1302226 18-OCT-15 1303310 18-OCT-15 1 30 1303310 18-OCT-15 1303858 18-OCT-15 1 31 1303858 18-OCT-15 1308314 18-OCT-15BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------11 Full 1.11G DISK 00:00:08 18-OCT-15 BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20151018T134526 Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/backupset/2015_10_18/o1_mf_nnndf_TAG20151018T134526_c26dhpdf_.bkp List of Datafiles in backup set 11 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1308778 18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_system_c2613wz5_.dbf 2 Full 1308778 18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_sysaux_c2613x03_.dbf 3 Full 1308778 18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_undotbs1_c2613x07_.dbf 4 Full 1308778 18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_users_c2613x0d_.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------12 Full 9.36M DISK 00:00:00 18-OCT-15 BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20151018T134541 Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893423697_c26dj5nb_.bkp SPFILE Included: Modification time: 18-OCT-15 SPFILE db_unique_name: VLIFESB Standby Control File Included: Ckp SCN: 1310511 Ckp time: 18-OCT-153、问题分析解决这个问题很不合理，看似应该是Oracle Bug之类的情况。查询MOS，发现了对应的Bug信息：RMAN-06820 ORA-17629 During Backup at Standby Site （文档 ID 1616074.1）。根据文章信息，该问题Oracle一个未发布的bug，编号为Bug 8740124。当Oracle尝试访问主库过程中，需要连带将全部的standby log获取到。当连接失败的时候，就会发生报错。要解决该问题，Oracle提供了一个变通的办法，就是不要使用target /匿名方式登录，而是使用sysdba用户的用户名和密码信息进行直接连接。实验如下：[oracle@vLIFE-URE-OT-DB-STANDBY trace]$ rman nocatalogRecovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 18 13:49:56 2015Copyright （c） 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN> connect target sys/oracle@vlifesbconnected to target database: VLIFE （DBID=4207470439）using target database control file instead of recovery catalogRMAN> backup database plus archivelog delete input;Starting backup at 18-OCT-15current log archived at primary databaseallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=204 device type=DISKchannel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log（s） in backup set（篇幅原因，有省略……）handle=/u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893425827_c26dssbt_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 18-OCT-15没有出现报错信息，问题解决。4、结论笔者思考一下，这个变通策略还是利用了主库和备库在sysdba用户的密码相同这个策略。在备份的时候，将显示记录的sysdba用户密码输入进去，用于进行远程Primary登录和获取。--------------------------------------推荐阅读 --------------------------------------RMAN备份时遭遇ORA-19571 http://www.linuxidc.com/Linux/2015-07/120409.htmRMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htmRMAN备份时遇到ORA-19588 http://www.linuxidc.com/Linux/2015-07/120410.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址