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

一、搭建DG使用RMAN同步数据到备库时报错

1. RMAN> duplicate target database for standby from active database;
   
2. 
   
3. Starting Duplicate Db at 15-JUN-18
   
4. using channel ORA_AUX_DISK_1
   
5. 
   
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
    
13. 
    
14. Starting backup at 15-JUN-18
    
15. using channel ORA_DISK_1
    
16. Finished backup at 15-JUN-18
    
17. 
    
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
    
25. 
    
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
    
33. 
    
34. Starting restore at 15-JUN-18
    
35. using channel ORA_AUX_DISK_1
    
36. 
    
37. 
    
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
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 15 01:03:44 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
   
6. 
   
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;
   
2. 
   
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
   
6. 
   
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
    
14. 
    
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
    
19. 
    
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
    
27. 
    
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
    
35. 
    
36. Starting restore at 15-JUN-18
    
37. using channel ORA_AUX_DISK_1
    
38. 
    
39. channel ORA_AUX_DISK_1: copied control file copy
    
40. Finished restore at 15-JUN-18
    
41. 
    
42. contents of Memory Script:
    
43. {
    
44.    sql clone 'alter database mount standby database';
    
45. }
    
46. executing Memory Script
    
47. 
    
48. sql statement: alter database mount standby database
    
49. 
    
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
    
67. 
    
68. executing command: SET NEWNAME
    
69. 
    
70. renamed tempfile 1 to /oradata/ORCLS/datafile/o1_mf_temp_%u_.tmp in control file
    
71. 
    
72. executing command: SET NEWNAME
    
73. 
    
74. executing command: SET NEWNAME
    
75. 
    
76. executing command: SET NEWNAME
    
77. 
    
78. executing command: SET NEWNAME
    
79. 
    
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
    
99. 
    
100. sql statement: alter system archive log current
     
101. 
     
102. contents of Memory Script:
     
103. {
     
104.    switch clone datafile all;
     
105. }
     
106. executing Memory Script
     
107. 
     
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
     
117. 
     
118. RMAN>

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

转载于:http://blog.itpub.net/31427447/viewspace-2156955/