ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > rman duplicate出现PLS-00201错误解决

rman duplicate出现PLS-00201错误解决

原创 Oracle 作者：shawnloong 时间：2018-01-31 17:26:30 0 删除 编辑
rman duplicate出现以下错误

点击(此处)折叠或打开

  1. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
  3. Starting Duplicate Db at 30-JAN-18
  4. using channel ORA_AUX_DISK_1
  6. contents of Memory Script:
  7. {
  8. backup as copy reuse
  9. targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
  10. '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl' ;
  11. }
  12. executing Memory Script
  14. Starting backup at 30-JAN-18
  15. using channel ORA_DISK_1
  16. Finished backup at 30-JAN-18
  18. contents of Memory Script:
  19. {
  20. backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/orcl/control01.ctl';
  21. restore clone primary controlfile to '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' from
  22. '/u01/app/oracle/oradata/orcl/control01.ctl';
  23. }
  24. executing Memory Script
  26. Starting backup at 30-JAN-18
  27. using channel ORA_DISK_1
  28. channel ORA_DISK_1: starting datafile copy
  29. copying standby control file
  30. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f tag=TAG20180130T170732 RECID=2 STAMP=966791252
  31. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  32. Finished backup at 30-JAN-18
  34. Starting restore at 30-JAN-18
  35. using channel ORA_AUX_DISK_1
  38. DBGSQL: TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end;
  39. DBGSQL: sqlcode = 6550
  40. DBGSQL: B :fhdbi = 32765
  41. RMAN-00571: ===========================================================
  42. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  43. RMAN-00571: ===========================================================
  44. RMAN-03002: failure of Duplicate Db command at 01/30/2018 17:07:35
  45. RMAN-05501: aborting duplication of target database
  46. RMAN-03015: error occurred in stored script Memory Script
  47. ORA-06550: line 1, column 17:
  48. PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared
  49. ORA-06550: line 1, column 7:
  50. PL/SQL: Statement ignored
加上nocatalog解决

点击(此处)折叠或打开

  1. [oracle@hygzdb01-2-252 dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle@orclst1 nocatalog
  4. Recovery Manager: Release 11.2.0.4.0 - Production on Tue Jan 30 17:09:12 2018
  7. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  10. connected to target database: ORCL (DBID=1494309735)
  11. using target database control file instead of recovery catalog
  12. connected to auxiliary database: ORCL (not mounted)
  15. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
  18. Starting Duplicate Db at 30-JAN-18
  19. allocated channel: ORA_AUX_DISK_1
  20. channel ORA_AUX_DISK_1: SID=126 device type=DISK
  23. contents of Memory Script:
  24. {
  25. backup as copy reuse
  26. targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
  27. '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl' ;
  28. }
  29. executing Memory Script
  32. Starting backup at 30-JAN-18
  33. allocated channel: ORA_DISK_1
  34. channel ORA_DISK_1: SID=872 device type=DISK
  35. Finished backup at 30-JAN-18
  38. contents of Memory Script:
  39. {
  40. backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/orcl/control01.ctl';
  41. restore clone primary controlfile to '/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' from
  42. '/u01/app/oracle/oradata/orcl/control01.ctl';
  43. }
  44. executing Memory Script
  47. Starting backup at 30-JAN-18
  48. using channel ORA_DISK_1
  49. channel ORA_DISK_1: starting datafile copy
  50. copying standby control file
  51. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f tag=TAG20180130T170920 RECID=3 STAMP=966791361
  52. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  53. Finished backup at 30-JAN-18
  56. Starting restore at 30-JAN-18
  57. using channel ORA_AUX_DISK_1
  60. channel ORA_AUX_DISK_1: copied control file copy
  61. Finished restore at 30-JAN-18
  64. contents of Memory Script:
  65. {
  66. sql clone 'alter database mount standby database';
  67. }
  68. executing Memory Script
  71. sql statement: alter database mount standby database
  74. contents of Memory Script:
  75. {
  76. set newname for tempfile 1 to
  77. "/u01/app/oracle/oradata/orcl/temp01.dbf";
  78. switch clone tempfile all;
  79. set newname for datafile 1 to
  80. "/u01/app/oracle/oradata/orcl/system01.dbf";
  81. set newname for datafile 2 to
  82. "/u01/app/oracle/oradata/orcl/sysaux01.dbf";
  83. set newname for datafile 3 to
  84. "/u01/app/oracle/oradata/orcl/undotbs01.dbf";
  85. set newname for datafile 4 to
  86. "/u01/app/oracle/oradata/orcl/users01.dbf";
  87. set newname for datafile 5 to
  88. "/u01/app/oracle/oradata/orcl/tbs_hygz01.dbf";
  89. set newname for datafile 6 to
  90. "/u01/app/oracle/oradata/orcl/tbs_hygz02.dbf";
  91. set newname for datafile 7 to
  92. "/u01/app/oracle/oradata/orcl/tbs_hygz03.dbf";
  93. set newname for datafile 8 to
  94. "/u01/app/oracle/oradata/orcl/tbs_hygz04.dbf";
  95. backup as copy reuse
  96. datafile 1 auxiliary format
  97. "/u01/app/oracle/oradata/orcl/system01.dbf" datafile
  98. 2 auxiliary format
  99. "/u01/app/oracle/oradata/orcl/sysaux01.dbf" datafile
  100. 3 auxiliary format
  101. "/u01/app/oracle/oradata/orcl/undotbs01.dbf" datafile
  102. 4 auxiliary format
  103. "/u01/app/oracle/oradata/orcl/users01.dbf" datafile
  104. 5 auxiliary format
  105. "/u01/app/oracle/oradata/orcl/tbs_hygz01.dbf" datafile
  106. 6 auxiliary format
  107. "/u01/app/oracle/oradata/orcl/tbs_hygz02.dbf" datafile
  108. 7 auxiliary format
  109. "/u01/app/oracle/oradata/orcl/tbs_hygz03.dbf" datafile
  110. 8 auxiliary format
  111. "/u01/app/oracle/oradata/orcl/tbs_hygz04.dbf" ;
  112. sql 'alter system archive log current';
  113. }
  114. executing Memory Script
  117. executing command: SET NEWNAME
  120. renamed tempfile 1 to /u01/app/oracle/oradata/orcl/temp01.dbf in control file
  123. executing command: SET NEWNAME
  126. executing command: SET NEWNAME
  129. executing command: SET NEWNAME
  132. executing command: SET NEWNAME
  135. executing command: SET NEWNAME
  138. executing command: SET NEWNAME
  141. executing command: SET NEWNAME
  144. executing command: SET NEWNAME
  147. Starting backup at 30-JAN-18
  148. using channel ORA_DISK_1
  149. channel ORA_DISK_1: starting datafile copy
  150. input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
mos上有相关介绍
RMAN-554 RMAN-4005 PLS-201 RMAN-4015 when Connecting to Target Database (文档 ID 97294.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.4 [Release 9.0.1 to 11.2]
Information in this document applies to any platform.

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

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24486203/viewspace-2150717/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： EXP-00106：Invalid Database Link Passwords
下一篇： ORA-00130 引发的故障
请登录后发表评论 登录
全部评论
shawnloong

注册时间：2011-08-29

  • 博文量
    110
  • 访问量
    292642

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593