11.2 rman 备份 放在DG 库上跑,可能遇到的问题。

 

 

问题:

在这里 DB DG 切换,发现一个问题,主库A的模式切换到备库模式 时候,该主库日志会有如下提示:

 

 

ORA-17627: ORA-01017: invalid username/password; logon denied

ORA-17629: Cannot connect to the remote database server

 

 

检查:

1.  经过检查,发现该报错来自于rman@pdbdb03 (TNS V1-V3) 进程

*** MODULE NAME:(rman@pdbdb03 (TNS V1-V3)) 2020-06-08 01:31:36.843

krsd_get_primary_connect_string

 

    询问了,备份是跑数据库 A 上,备份也是正常的, 说明这个报错不会影响备份。

附录:通过检查,虽然有这个这个报错,但是归档日志,仍然仍然可以备份成功的,带过来的问题,可能是如果是备份在standby, 那么归档日志没办法自动清理。需要

调整备份策略从 tape 调整为 applyed to standby.

 

 

 

2. 经过分析,应该是触发了一个bug  Bug 17580082 - ACTIVE STANDBY - RMAN-06820: WARNING: FAILED TO ARCHIVE CURRENT LOG AT PRIMARY
Status: 32 - Not a Bug. To Filer

 

     在11.2 环境下,如果rman 备份发生在备库,oracle 会强制主库做一个switch logfile 操作。如果连不上主库,就会触发这个报错。

   

as of 11.2.0.4, we now include the current standby redo log as part of an RMAN archivelog backup at the standby site. This is achieved by forcing a log switch at the primary site.

 

 

规避方法:

    

1。如果备份 发起在 容灾库备份,备份脚本 使用用户名+ 密码方式登录。

    Instead put in the username and password for the SYSDBA user:

$ rman target sys/password@stby

 

而不是That is, do not use just the "/" (operating system authentication) connect to the standby database: 这样会导致 备库的备份连接不到主库,产生这个报错的

$ rman target /

  

 

2。这个Bug  Bug 21476308/17580082  在如下版本得到修复,12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU)

 

ORA-1017 by RMAN When Connecting to Target with Username/Password from RMAN Operations Platforms affected  Generic (all / most platforms affected)

 

Fixed:

12.2.0.1 (Base Release)

12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU)

 

  (Enhancement Request/Bug 18070699 allows for the use of other user/password apart from sys password to connect to remote database for RMAN operation.
          Bug 18070699:  ALLOW NON-SYS USERNAME GRANTED SYSDBA TO RESYNC DB_UNIQUE_NAME ALL

Patches are available for this issue by searching bug 21476308 for patch name or number.  )

 

 

附录:通过检查,虽然有这个这个报错,但是归档日志,仍然仍然可以备份成功。


For UNIX/Linux Platforms
$ export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
$ rman target /
...

list archivelog all backed up 1 times to sbt_tape;

 

315876 1 298408 A 2020/10/19 06:28:58
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298408_hrsk2qmc_.arc

315877 1 298409 A 2020/10/19 06:40:19
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298409_hrsk332y_.arc

315879 1 298410 A 2020/10/19 06:40:26
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298410_hrsk49h9_.arc

315878 1 298411 A 2020/10/19 06:40:34
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298411_hrsk3lqv_.arc

315881 1 298412 A 2020/10/19 06:40:39
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298412_hrsk52qw_.arc

315882 1 298413 A 2020/10/19 06:40:44
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298413_hrsk55cy_.arc

315880 1 298414 A 2020/10/19 06:40:49
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298414_hrsk4c19_.arc

315886 1 298415 A 2020/10/19 06:40:54
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298415_hrsk6h0d_.arc

315884 1 298416 A 2020/10/19 06:41:00
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298416_hrsk60wr_.arc

315887 1 298417 A 2020/10/19 06:41:06
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298417_hrsk6y9r_.arc

315883 1 298418 A 2020/10/19 06:41:11
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298418_hrsk53po_.arc

315888 1 298419 A 2020/10/19 06:41:17
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298419_hrsk7dnl_.arc

315890 1 298420 A 2020/10/19 06:41:24
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298420_hrsk8812_.arc

315885 1 298421 A 2020/10/19 06:41:32
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298421_hrsk6csj_.arc

315891 1 298422 A 2020/10/19 06:41:41
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298422_hrsk8joc_.arc

315893 1 298423 A 2020/10/19 06:41:52
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298423_hrsk92no_.arc

315895 1 298424 A 2020/10/19 06:42:05
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298424_hrsk9rsq_.arc

315889 1 298425 A 2020/10/19 06:42:17
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298425_hrsk7n18_.arc

315894 1 298426 A 2020/10/19 06:42:28
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298426_hrsk9mdt_.arc

315897 1 298427 A 2020/10/19 06:42:35
Name: /db/db/fra/db/archivelog/2020_10_19/o1_mf_1_298427_hrskbhkw_.arc

 

posted @ 2020-06-10 14:55  feiyun8616  阅读(804)  评论(0编辑  收藏  举报