rman duplicate出现PLS-00201错误怎么办

小编给大家分享一下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错误怎么办”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！