RMAN Duplicate时PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared

  • 白盲丶

    2018-06-28 11:21:36
  • Oracle
  • 原创
一、搭建DG使用RMAN同步数据到备库时报错

  1. RMAN> duplicate target database for standby from active database;

  3. Starting Duplicate Db at 15-JUN-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/orapworcls' ;
  11. }
  12. executing Memory Script

  14. Starting backup at 15-JUN-18
  15. using channel ORA_DISK_1
  16. Finished backup at 15-JUN-18

  18. contents of Memory Script:
  19. {
  20.    backup as copy current controlfile for standby auxiliary format '/oradata/control01.ctl';
  21.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/orcls/control02.ctl' from
  22.  '/oradata/control01.ctl';
  23. }
  24. executing Memory Script

  26. Starting backup at 15-JUN-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=TAG20180619T202436 RECID=3 STAMP=979244676
  31. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  32. Finished backup at 15-JUN-18

  34. Starting restore at 15-JUN-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 = 32767
  41. RMAN-00571: ===========================================================
  42. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  43. RMAN-00571: ===========================================================
  44. RMAN-03002: failure of Duplicate Db command at 06/15/2018 00:58:58
  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
查询网络资料https://blog.csdn.net/tianlesoftware/article/details/9358939后
解释是使用非catalog，在rman 连接时，加上nocatalog关键字，如下：

  1. [oracle@node2 dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle@orcls nocatalog

  3. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 15 01:03:44 2018

  5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

  7. connected to target database: ORCL (DBID=1506854844)
  8. using target database control file instead of recovery catalog
  9. connected to auxiliary database: ORCL (not mounted)
使用后正常完成同步，如下：

  1. RMAN> duplicate target database for standby from active database nofilenamecheck;

  3. Starting Duplicate Db at 15-JUN-18
  4. allocated channel: ORA_AUX_DISK_1
  5. channel ORA_AUX_DISK_1: SID=1 device type=DISK

  7. contents of Memory Script:
  8. {
  9.    backup as copy reuse
  10.    targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
  11.  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcls' ;
  12. }
  13. executing Memory Script

  15. Starting backup at 15-JUN-18
  16. allocated channel: ORA_DISK_1
  17. channel ORA_DISK_1: SID=36 device type=DISK
  18. Finished backup at 15-JUN-18

  20. contents of Memory Script:
  21. {
  22.    backup as copy current controlfile for standby auxiliary format '/oradata/control01.ctl';
  23.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/orcls/control02.ctl' from
  24.  '/oradata/control01.ctl';
  25. }
  26. executing Memory Script

  28. Starting backup at 15-JUN-18
  29. using channel ORA_DISK_1
  30. channel ORA_DISK_1: starting datafile copy
  31. copying standby control file
  32. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f tag=TAG20180619T202939 RECID=5 STAMP=979244979
  33. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  34. Finished backup at 15-JUN-18

  36. Starting restore at 15-JUN-18
  37. using channel ORA_AUX_DISK_1

  39. channel ORA_AUX_DISK_1: copied control file copy
  40. Finished restore at 15-JUN-18

  42. contents of Memory Script:
  43. {
  44.    sql clone 'alter database mount standby database';
  45. }
  46. executing Memory Script

  48. sql statement: alter database mount standby database

  50. contents of Memory Script:
  51. {
  52.    set newname for clone tempfile 1 to new;
  53.    switch clone tempfile all;
  54.    set newname for clone datafile 1 to new;
  55.    set newname for clone datafile 2 to new;
  56.    set newname for clone datafile 3 to new;
  57.    set newname for clone datafile 4 to new;
  58.    backup as copy reuse
  59.    datafile 1 auxiliary format new
  60.    datafile 2 auxiliary format new
  61.    datafile 3 auxiliary format new
  62.    datafile 4 auxiliary format new
  63.    ;
  64.    sql 'alter system archive log current';
  65. }
  66. executing Memory Script

  68. executing command: SET NEWNAME

  70. renamed tempfile 1 to /oradata/ORCLS/datafile/o1_mf_temp_%u_.tmp in control file

  72. executing command: SET NEWNAME

  74. executing command: SET NEWNAME

  76. executing command: SET NEWNAME

  78. executing command: SET NEWNAME

  80. Starting backup at 15-JUN-18
  81. using channel ORA_DISK_1
  82. channel ORA_DISK_1: starting datafile copy
  83. input datafile file number=00001 name=/oradata/orcl/system01.dbf
  84. output file name=/oradata/ORCLS/datafile/o1_mf_system_06t5s5tr_.dbf tag=TAG20180619T202947
  85. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
  86. channel ORA_DISK_1: starting datafile copy
  87. input datafile file number=00002 name=/oradata/orcl/sysaux01.dbf
  88. output file name=/oradata/ORCLS/datafile/o1_mf_sysaux_07t5s5uu_.dbf tag=TAG20180619T202947
  89. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
  90. channel ORA_DISK_1: starting datafile copy
  91. input datafile file number=00003 name=/oradata/orcl/undotbs01.dbf
  92. output file name=/oradata/ORCLS/datafile/o1_mf_undotbs1_08t5s5vn_.dbf tag=TAG20180619T202947
  93. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  94. channel ORA_DISK_1: starting datafile copy
  95. input datafile file number=00004 name=/oradata/orcl/users01.dbf
  96. output file name=/oradata/ORCLS/datafile/o1_mf_users_09t5s5vq_.dbf tag=TAG20180619T202947
  97. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  98. Finished backup at 15-JUN-18

  100. sql statement: alter system archive log current

  102. contents of Memory Script:
  103. {
  104.    switch clone datafile all;
  105. }
  106. executing Memory Script

  108. datafile 1 switched to datafile copy
  109. input datafile copy RECID=5 STAMP=978829512 file name=/oradata/ORCLS/datafile/o1_mf_system_06t5s5tr_.dbf
  110. datafile 2 switched to datafile copy
  111. input datafile copy RECID=6 STAMP=978829512 file name=/oradata/ORCLS/datafile/o1_mf_sysaux_07t5s5uu_.dbf
  112. datafile 3 switched to datafile copy
  113. input datafile copy RECID=7 STAMP=978829512 file name=/oradata/ORCLS/datafile/o1_mf_undotbs1_08t5s5vn_.dbf
  114. datafile 4 switched to datafile copy
  115. input datafile copy RECID=8 STAMP=978829512 file name=/oradata/ORCLS/datafile/o1_mf_users_09t5s5vq_.dbf
  116. Finished Duplicate Db at 15-JUN-18

  118. RMAN>




请使用浏览器的分享功能分享到微信等