rman备份pdb。需要被授予SYSBACKUP权限？

12c: RMAN Remote Connection from Backup User Raises ORA-1017 (文档 ID 1997947.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

SYMPTOMS

RMAN User fails to establish remote connection to 12c Database

$ rman target rman_user/`tellme system`@PROD

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Apr 7 09:01:15 2015

Copyright (c) 1982, 2014, 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

CHANGES

RMAN user has been granted SYSBACKUP privilege:

SQL> grant SYSBACKUP to rman_user;

CAUSE

In order to authenticate the access from an RMAN user to the remote database, the passwordfile needs to be created with the 12c FORMAT

This has been documented at:

12c Database Administrator's Guide
http://docs.oracle.com/database/121/nav/portal_4.htm

"The administrative privileges SYSBACKUP, SYSDG, and SYSKM are supported in the password file only when the file is created created with the FORMAT=12 argument. 12 is the default for the FORMAT command-line argument."
 

SOLUTION

Recreate the passwordfile making sure to include FORMAT=12

orapwd FILE=filename ENTRIES=max_users FORMAT=12
 

REFERENCES

NOTE:1521005.1 - RMAN Pluggable Database Backup and Recovery in a Multitenant Environment