rman duplicate出現PLS-00201錯誤解決

shawnloong發表於2018-01-31
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部落格 ” ，連結：http://blog.itpub.net/24486203/viewspace-2150717/，如需轉載，請註明出處，否則將追究法律責任。

相關文章