1 问题现象

19c rman 连接PDB，报如下错误：http://www.cndba.cn/dave/article/4723http://www.cndba.cn/dave/article/4723

[dave@www.cndba.cn ~]$ rman target sys/oracle@ustc

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 15 22:59:33 2021
Version 19.3.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-06814: cannot connect to pluggable database USTC

[dave@www.cndba.cn ~]$ oerr rman 06814
6814, 1, "cannot connect to pluggable database %s"
// *Cause:  An error was received when connecting to database because
//          the database is a pluggable database.
// *Action: Connect to the root database and retry the command.

PDB 是正常的，在sqlplus 里可以连接：http://www.cndba.cn/dave/article/4723

SQL> conn sys/oracle@ustc as sysdba
Connected.

2 解决方法

在MOS上没有搜到啥有价值的信息，就说有一些bug和这些相关。

然后啥也没干，只是中间执行了一个有错误的命令，就恢复正常了。http://www.cndba.cn/dave/article/4723http://www.cndba.cn/dave/article/4723http://www.cndba.cn/dave/article/4723

[dave@www.cndba.cn ~]$  rman target sys/oracle@ustc

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 15 23:02:39 2021
Version 19.3.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-06814: cannot connect to pluggable database CDB$ROOT

[dave@www.cndba.cn ~]$
[dave@www.cndba.cn ~]$

注意这里再连时，提示是CDB 的root，而不是我们的PDB. http://www.cndba.cn/dave/article/4723

[dave@www.cndba.cn ~]$  rman target sys/oracle@ustc

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 15 23:06:32 2021
Version 19.3.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-06814: cannot connect to pluggable database CDB$ROOT

执行一次错误的命令：http://www.cndba.cn/dave/article/4723

[dave@www.cndba.cn ~]$  rman target sys/oracle@ustc as sysbackup

Argument     Value          Description
-----------------------------------------------------------------------------
target       quoted-string  connect-string for target database
catalog      quoted-string  connect-string for recovery catalog
auxiliary    quoted-string  connect-string for auxiliary database
nocatalog    none           if specified, then no recovery catalog
cmdfile      quoted-string  name of input command file
log          quoted-string  name of output message log file
trace        quoted-string  name of output debugging message log file
append       none           if specified, log is opened in append mode
debug        optional-args  activate debugging
msgno        none           show RMAN-nnnn prefix for all messages
send         quoted-string  send a command to the media manager
pipe         string         building block for pipe names
script       string         name of catalog script to execute
using        list of args   arguments for rman variables
timeout      integer        number of seconds to wait for pipe input
checksyntax  none           check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "as": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01007: at line 2 column 1 file: command line arguments

在连接，正常了，啥都没干， 诡异.gif。 http://www.cndba.cn/dave/article/4723

[dave@www.cndba.cn ~]$  rman target sys/oracle@ustc

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 15 23:08:50 2021
Version 19.3.0.0.0

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

connected to target database: ORCL:USTC (DBID=3996124539)

RMAN>

版权声明：本文为博主原创文章，未经博主允许不得转载。