大家好,又见面了,我是你们的朋友全栈君。
在Oracle 19c中,RMAN 连接PDB时可能会出现ORA-01017的错误,如下:
[dave@www.cndba.cn admin]$ rman target ‘”dave/dave@dave as sysbackup”‘
Recovery Manager: Release 19.0.0.0.0 – Production on Wed Feb 17 16:33:29 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01017: invalid username/password; logon denied
该dave用户通过sqlplus 连接pdb 是正常的:
https://www.cndba.cn/dave/article/4402
[dave@www.cndba.cn admin]$ sqlplus dave/dave@dave
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Feb 17 16:33:17 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Last Successful login time: Fri Feb 05 2021 23:57:46 +08:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.10.0.0.0
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.10.0.0.0
[dave@www.cndba.cn admin]$
这里实际上是缺少SYSBACKUP的权限。 RMAN备份在12cR1 之前备份用户需要授权SYSDBA, 没有较好的职责安全分享方案,在12C R1版本中引入了SYSBACKUP允许用户使用RMAN或SQLPLUS 备份恢复,但无权查看业务数据和其它越权操作。如备份登录方式是:
https://www.cndba.cn/dave/article/4402
rman target ‘” / as sysbackup”‘
[dave@www.cndba.cn ~]$ sqlplus sys/dave@www.cndba.cn as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Feb 17 16:34:51 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.10.0.0.0
SQL> grant sysbackup to dave;
Grant succeeded.
SQL>
再次连接正常:注意这里连接的提示格式是CDB:PDB:CNDBA:DAVE (DBID=3516530670)https://www.cndba.cn/dave/article/4402
https://www.cndba.cn/dave/article/4402
https://www.cndba.cn/dave/article/4402
[dave@www.cndba.cn admin]$ rman target ‘”dave/dave@dave as sysbackup”‘
Recovery Manager: Release 19.0.0.0.0 – Production on Wed Feb 17 16:35:07 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CNDBA:DAVE (DBID=3516530670)
RMAN>
orapwd FILE=filename ENTRIES=max_users FORMAT=12
具体说明参考:https://www.cndba.cn/dave/article/4402https://www.cndba.cn/dave/article/4402
12c: RMAN Remote Connection from Backup User Raises ORA-1017 (Doc ID 1997947.1)
版权声明:本文为博主原创文章,未经博主允许不得转载。
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/138251.html原文链接:https://javaforall.cn