dataguard ORA-17628 处理

最新推荐文章于 2026-06-13 15:37:22 发布
转载 最新推荐文章于 2026-06-13 15:37:22 发布 · 1.2k 阅读 · 0
本文记录了在使用RMAN进行数据库复制以创建备用库时遇到ORA-17628错误的过程。通过执行RMAN命令进行数据文件和控制文件的备份与恢复，以及对归档日志的处理，最终成功解决权限问题并完成备用库的创建。
dataguard ORA-17628 处理

点击(此处)折叠或打开

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

  3. Starting Duplicate Db at 02-JUL-18
  4. using target database control file instead of recovery catalog
  5. allocated channel: ORA_AUX_DISK_1
  6. channel ORA_AUX_DISK_1: SID=396 device type=DISK


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


  18. Starting backup at 02-JUL-18
  19. allocated channel: ORA_DISK_1
  20. channel ORA_DISK_1: SID=408 device type=DISK
  21. Finished backup at 02-JUL-18


  24. contents of Memory Script:
  25. {
  26.    backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
  27.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
  28.  '/u01/app/oracle/oradata/netdata/control01.ctl';
  29. }
  30. executing Memory Script


  33. Starting backup at 02-JUL-18
  34. using channel ORA_DISK_1
  35. channel ORA_DISK_1: starting datafile copy
  36. copying standby control file
  37. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T183426 RECID=1 STAMP=980447667
  38. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  39. Finished backup at 02-JUL-18


  42. Starting restore at 02-JUL-18
  43. using channel ORA_AUX_DISK_1


  46. channel ORA_AUX_DISK_1: copied control file copy
  47. Finished restore at 02-JUL-18


  50. contents of Memory Script:
  51. {
  52.    sql clone 'alter database mount standby database';
  53. }
  54. executing Memory Script


  57. sql statement: alter database mount standby database


  60. contents of Memory Script:
  61. {
  62.    set newname for tempfile 1 to
  63.  "/u01/app/oracle/oradata/netdata/temp01.dbf";
  64.    switch clone tempfile all;
  65.    set newname for datafile 1 to
  66.  "/u01/app/oracle/oradata/netdata/system01.dbf";
  67.    set newname for datafile 2 to
  68.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf";
  69.    set newname for datafile 3 to
  70.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf";
  71.    set newname for datafile 4 to
  72.  "/u01/app/oracle/oradata/netdata/users01.dbf";
  73.    backup as copy reuse
  74.    datafile 1 auxiliary format
  75.  "/u01/app/oracle/oradata/netdata/system01.dbf" datafile
  76.  2 auxiliary format
  77.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
  78.  3 auxiliary format
  79.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
  80.  4 auxiliary format
  81.  "/u01/app/oracle/oradata/netdata/users01.dbf" ;
  82.    sql 'alter system archive log current';
  83. }
  84. executing Memory Script


  87. executing command: SET NEWNAME


  90. renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file


  93. executing command: SET NEWNAME


  96. executing command: SET NEWNAME


  99. executing command: SET NEWNAME


  102. executing command: SET NEWNAME


  105. Starting backup at 02-JUL-18
  106. using channel ORA_DISK_1
  107. channel ORA_DISK_1: starting datafile copy
  108. input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
  109. output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T183437
  110. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
  111. channel ORA_DISK_1: starting datafile copy
  112. input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  113. output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T183437
  114. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
  115. channel ORA_DISK_1: starting datafile copy
  116. input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  117. output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T183437
  118. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  119. channel ORA_DISK_1: starting datafile copy
  120. input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
  121. output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T183437
  122. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  123. Finished backup at 02-JUL-18


  126. sql statement: alter system archive log current


  129. contents of Memory Script:
  130. {
  131.    backup as copy reuse
  132.    archivelog like "/u01/archive/1_8_980442214.dbf" auxiliary format
  133.  "/u01/archive/1_8_980442214.dbf" ;
  134.    catalog clone archivelog "/u01/archive/1_8_980442214.dbf";
  135.    switch clone datafile all;
  136. }
  137. executing Memory Script


  140. Starting backup at 02-JUL-18
  141. using channel ORA_DISK_1
  142. channel ORA_DISK_1: starting archived log copy
  143. input archived log thread=1 sequence=8 RECID=4 STAMP=980447742
  144. RMAN-00571: ===========================================================
  145. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  146. RMAN-00571: ===========================================================
  147. RMAN-03002: failure of Duplicate Db command at 07/02/2018 18:35:43
  148. RMAN-05501: aborting duplication of target database
  149. RMAN-03015: error occurred in stored script Memory Script
  150. RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/02/2018 18:35:43
  151. ORA-17628: Oracle error 19505 returned by remote Oracle server
检查备库alert日志

点击(此处)折叠或打开

  1. Additional information: 3
  2. Mon Jul 02 18:35:43 2018
  3. Errors in file /u01/app/oracle/diag/rdbms/netdata_st1/netdata/trace/netdata_ora_4020.trc:
  4. ORA-19505: failed to identify file "/u01/archive/1_8_980442214.dbf"
  5. ORA-27040: file create error, unable to create file
  6. Linux-x86_64 Error: 13: Permission denied
  7. Additional information: 1

很明显的错误，由于之前是用root建的的目录未修改权限

点击(此处)折叠或打开

  1. chown -R oracle:oinstall /u01/archive

修改后删除备库之前复制文件

点击(此处)折叠或打开

  1. rm -rf /u01/app/oracle/oradata/netdata

重新duplicate

点击(此处)折叠或打开

  1. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
  2. Starting Duplicate Db at 02-JUL-18
  3. using target database control file instead of recovery catalog
  4. allocated channel: ORA_AUX_DISK_1
  5. channel ORA_AUX_DISK_1: SID=10 device type=DISK


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


  17. Starting backup at 02-JUL-18
  18. allocated channel: ORA_DISK_1
  19. channel ORA_DISK_1: SID=404 device type=DISK
  20. Finished backup at 02-JUL-18


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


  32. Starting backup at 02-JUL-18
  33. using channel ORA_DISK_1
  34. channel ORA_DISK_1: starting datafile copy
  35. copying standby control file
  36. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T185303 RECID=2 STAMP=980448784
  37. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  38. Finished backup at 02-JUL-18


  41. Starting restore at 02-JUL-18
  42. using channel ORA_AUX_DISK_1


  45. channel ORA_AUX_DISK_1: copied control file copy
  46. Finished restore at 02-JUL-18


  49. contents of Memory Script:
  50. {
  51.    sql clone 'alter database mount standby database';
  52. }
  53. executing Memory Script


  56. sql statement: alter database mount standby database


  59. contents of Memory Script:
  60. {
  61.    set newname for tempfile 1 to
  62.  "/u01/app/oracle/oradata/netdata/temp01.dbf";
  63.    switch clone tempfile all;
  64.    set newname for datafile 1 to
  65.  "/u01/app/oracle/oradata/netdata/system01.dbf";
  66.    set newname for datafile 2 to
  67.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf";
  68.    set newname for datafile 3 to
  69.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf";
  70.    set newname for datafile 4 to
  71.  "/u01/app/oracle/oradata/netdata/users01.dbf";
  72.    backup as copy reuse
  73.    datafile 1 auxiliary format
  74.  "/u01/app/oracle/oradata/netdata/system01.dbf" datafile
  75.  2 auxiliary format
  76.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
  77.  3 auxiliary format
  78.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
  79.  4 auxiliary format
  80.  "/u01/app/oracle/oradata/netdata/users01.dbf" ;
  81.    sql 'alter system archive log current';
  82. }
  83. executing Memory Script


  86. executing command: SET NEWNAME


  89. renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file


  92. executing command: SET NEWNAME


  95. executing command: SET NEWNAME


  98. executing command: SET NEWNAME


  101. executing command: SET NEWNAME


  104. Starting backup at 02-JUL-18
  105. using channel ORA_DISK_1
  106. channel ORA_DISK_1: starting datafile copy
  107. input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
  108. output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T185311
  109. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
  110. channel ORA_DISK_1: starting datafile copy
  111. input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  112. output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T185311
  113. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
  114. channel ORA_DISK_1: starting datafile copy
  115. input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  116. output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T185311
  117. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  118. channel ORA_DISK_1: starting datafile copy
  119. input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
  120. output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T185311
  121. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  122. Finished backup at 02-JUL-18


  125. sql statement: alter system archive log current


  128. contents of Memory Script:
  129. {
  130.    backup as copy reuse
  131.    archivelog like "/u01/archive/1_9_980442214.dbf" auxiliary format
  132.  "/u01/archive/1_9_980442214.dbf" ;
  133.    catalog clone archivelog "/u01/archive/1_9_980442214.dbf";
  134.    switch clone datafile all;
  135. }
  136. executing Memory Script


  139. Starting backup at 02-JUL-18
  140. using channel ORA_DISK_1
  141. channel ORA_DISK_1: starting archived log copy
  142. input archived log thread=1 sequence=9 RECID=5 STAMP=980448836
  143. output file name=/u01/archive/1_9_980442214.dbf RECID=0 STAMP=0
  144. channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
  145. Finished backup at 02-JUL-18


  148. cataloged archived log
  149. archived log file name=/u01/archive/1_9_980442214.dbf RECID=1 STAMP=980448838


  152. datafile 1 switched to datafile copy
  153. input datafile copy RECID=2 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/system01.dbf
  154. datafile 2 switched to datafile copy
  155. input datafile copy RECID=3 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  156. datafile 3 switched to datafile copy
  157. input datafile copy RECID=4 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  158. datafile 4 switched to datafile copy
  159. input datafile copy RECID=5 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/users01.dbf


  162. contents of Memory Script:
  163. {
  164.    set until scn 973806;
  165.    recover
  166.    standby
  167.    clone database
  168.     delete archivelog
  169.    ;
  170. }
  171. executing Memory Script


  174. executing command: SET until clause


  177. Starting recover at 02-JUL-18
  178. using channel ORA_AUX_DISK_1


  181. starting media recovery


  184. archived log for thread 1 with sequence 9 is already on disk as file /u01/archive/1_9_980442214.dbf
  185. archived log file name=/u01/archive/1_9_980442214.dbf thread=1 sequence=9
  186. media recovery complete, elapsed time: 00:00:01
  187. Finished recover at 02-JUL-18
  188. Finished Duplicate Db at 02-JUL-18

  190. RMAN> quit
  191. Recovery Manager complete.



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

转载于:http://blog.itpub.net/24486203/viewspace-2157175/

cuanshao4773
关注
ORA-17628: Oracle error 19505 returned by remote Oracle server
喝醉酒的小白
02-23 6219
备库控制文件路径
rac-rac搭建dg遇到错误 ora-19845 17628 19660 19662 19845 17628
weixin_43475880的博客
12-20 849
发现此时参数文件，控制文件和数据文件均是正常的，故而此时可以直接open数据库，在open的过程中，数据库会自动创建redo文件
搭建dg在duplicate过程中报错ORA-17628: Oracle error 19505 returned by remote Oracle server
zongzizz的博客
11-17 2386
搭建dg在duplicate过程中报错ORA-17628: Oracle error 19505 returned by remote Oracle server
rman duplicate遇到ORA-17628 该怎么解决？
weixin_33971977的博客
01-11 1814
今天重新做了一次rman duplicate操作[oracle@ora02 ~]$ rman target / auxiliary sys/oracle@PRODRecovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 11 15:32:10 2016Copyright (c) 1982, 2011, Oracl...
DG中DUPLICATE时报ORA-17628错误
08-09 982
在搭建dg时，将DUPLICATE的过程中，在脚本中指定了文件转换路径，也确认路径无误，可在最后报错，错误如下： RMAN-00571:================================...
别再手动复制了！用RMAN的DUPLICATE FOR STANDBY命令，5分钟搞定Oracle 19c DataGuard备库搭建
最新发布
java 学习
06-13 561
本文详细介绍了如何使用RMAN的`DUPLICATE FOR STANDBY`命令快速搭建Oracle 19c DataGuard备库，实现从手工操作到自动化部署的转变。通过关键参数解析和实战操作指南，帮助DBA在5分钟内完成备库搭建，大幅提升效率并降低人为错误风险。
Oracle 19C PDB迁移报错 ORA-17628 error 65338 returned by remote Oracle server
weixin_43937159的博客
06-29 372
3、使用数据库链接(dblink)从一个容器数据库(CDB)迁移可插拔数据库(PDB)到另一个CDB时，创建的dblink需要指向源CDB的服务名。这个服务名是源数据库对外提供的访问入口，它让目标数据库能够通过网络定位并连接到源数据库。4、检查两边用户的权限，是否有创建PDB的权限。5、源库CDB是否处于本地 UNDO 模式。2、注意源库需要开启归档模式。1、检查两边数据库的字符集。
oracle 11g active dataguard,oracle 11gR2 active dataguard duplicate database ORA-17628
weixin_35662417的博客
04-12 735
搭建adg的时候 报错ORA-17628，检查备份脚本信息，发现convert 涉及的目录没有创建，比如datafile onlinelog tempfile 目录相当于datafile copy 无法copy 应该报个linux 的no directory 就好了创建后 重新startup nomount force 重新duplicate 就ok了rman target ...
活动复制数据库时由于控制文件路径不存在报错ORA-17628
cqszpx的博客
08-02 1220
在使用活动复制方式复制数据库搭建物理备库时报错： RMAN-03002:failure of Duplicate Db command at 05/14/2021 12:07:58 RMAN-05501:aborting duplication of target database RMAN-03015:error occurred in stored script Memory Script RMAN-03009:failure of backup command on ORA_DISK_1 .
RMAN-03009 & ORA-17628
热门推荐
技术专栏
08-16 1万+
执行duplicate命令创建auxiliary数据库时，报下面的错误： Starting backup at 16-AUG-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file RMAN-00571: ================
Duplicate from Active Database Failing with: RMAN-03009, ORA-17628, and ORA-19505
gsforget321的博客
08-14 1944
1. 数据有一部分是非OMF方式创建的，可以使用select tablespace_name,file_name from dba_data_files;2. 目录不存在或者存在的目录有相同的文件也会报如题的错误，参考MOS(Doc ID 1439632.1)(1) 使用参数DB_FILE_NAME_CONVERT并使用别名指定数据文件的完整位置；(2)在备库的磁盘组中创建和原库一样的文件路径。我的报错是目录不存在，创建个目录就好了。删除目录中已经存在相同的文件。
oracle的dg搭建在RMAN duplicate所遇到的问题ORA-17628，希望有好心人可以帮忙解决
qq_42417335的博客
06-08 3354
[oracle@Lambor dbs]$ rman target sys/oracle auxiliary sys/oracle@Lambor1:1521/shRecovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 8 15:55:57 2018Copyright (c) 1982, 2011, Oracle and/or its ...
ORA-19845,ORA-17628,ORA-01580
qq_55838069的博客
03-11 300
RMAN报错ORA-19845,ORA-17628,ORA-01580
从NONCDB复制到PDB报ORA-17628错误
cqszpx的博客
09-03 356
使用SYSTEM创建的DBLINK SQL> create database link link_orcl 2 connect to system identified by oracle_4U 3 using '192.168.133.134:1521/orcl'; Database link created. SQL> select * from dual@link_orcl; D - X SQL> create pluggable database pdb_orcl 2 from n
12.2C+远程克隆遭遇ORA-17628: Oracle error 1031 returned by remote Oracle server错误
Brent的专栏
11-07 2383
在使用远程克隆的时候,在目标端数据库执行创建克隆数据库的时候报错: create pluggable database testpdb from testpdb1@ora19c2 file_name_convert=('testpdb1','testpdb') * ERROR at line 1: ORA-17628: Oracle error 1031 returned b...
ora-00245报错解决方法
weixin_45694422的博客
06-23 2509
更多精彩内容，请登录：ke.sandata.com.cn 1.发现问题 最近使用备份软件对客户11G RAC数据库进行备份，发现备份失败查看日志发现数据库报 ORA-00245: control file backup failed; target is likely on a local file system错误。 2.问题分析 本报错出现于oracle 11.2.0.1.0及以后的版本中，应用于所有平台仅仅RAC环境会发生，因为oracle 11Gr2控制文件备份机制的改变，集群中的任何实例
oracle+rac+dg+搭建,Oracle RAC+DG环境搭建（CentOS 7+Oracle 12C）( 十） 部署 DataGuard
weixin_40008566的博客
04-03 1509
一、配置主机1. 设置主机名hostnamectlset-hostnameDG2. 配置网络vim/etc/sysconfig/network-scripts/ifcfg-enp0s3重启网卡systemctlrestartnetwork测试：nslookup重启生效3. 主机环境(1)执行env.sh. 配置环境，脚本如下：(2)执行rpm.sh . 安装依赖包，脚本如下：二、配置共...
ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA
cuiyan1982的专栏
10-26 3894
今天搭建dataguard主从，用rman进行热备时，报 ORA-17627: ORA-12577: Message 12577 not found;  product=RDBMS; facility=ORA 开始几个文件都安全的传输过去了，到第四个就卡住了，后来发现是备库的磁盘空间不足了，所以文件传输失败：）
ORA-17627: ORA-12577：关于文件存储满的问题
cnmeimei的博客
12-05 798
问题描述：搭建DG的时候，要rman从orcl恢复到orclstd数据库来，dup复制了半天，结果最后报错：ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; 　　　　　 facility=ORA网上找了文档，查到是磁盘被写满的问题于是就解决一下。 1.rman target sys/410526@orcl auxiliary sys/410526@orclstdduplicate tar...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值