小编给大家分享一下rman duplicate出现PLS-00201错误怎么办，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！
rman duplicate出现以下错误
APPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.4 [Release 9.0.1 to 11.2]
SYMPTOMS
You are attempting to connect to the target database in RMAN and
are receiving a "PLS-00201: identifier 'xxx...' must be declared"
error:
target database Password:
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-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_BACKUP_RESTORE.SET_CHARSET' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
RMAN-04015: error setting target database character set to US7ASCII
Also, if you log into the target database as the user SYS and issue:
SQL> select *
from dba_objects
where object_name like '%DBMS_BACKUP_RESTORE%';
you get 0 rows returned or the status is INVALID
CAUSE
The package identified in the PLS-00201 error was not successfully
created when catproc.sql was originally run on this database. As
a general rule, for any RMAN "PLS-00201: identifier 'xxx...' must
be declared" error, re-run catproc.sql.
主要是少了这个包DBMS_BACKUP_RESTORE
SOLUTION
Re-run catproc.sql. This will in turn call the dbmsbkrs.sql script
which creates the DBMS_BACKUP_RESTORE package.
NOTE : Keep inmind that running catproc.sql will invalidate all PL/SQL
and many other related objects.
Running catproc is recommended, as when the RMAN-packages are missing,
there could be others missing aswell.
If the problem has been identified as RMAN-only, than run :
SQL>@?/rdbms/admin/dbmsrman.sql
@?/rdbms/admin/prvtrmns.plb
@?/rdbms/admin/dbmsbkrs.sql
@?/rdbms/admin/prvtbkrs.plb
以上是“rman duplicate出现PLS-00201错误怎么办”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！
