背景:
用duplicate进行ADG搭建
报错内容:
RMAN> duplicate target database for standby from active database dorecover;
Starting Duplicate Db at 10-MAY-22
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1549 instance=TMSPROD1 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbs/orapwTMSPROD2' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTMSPROD1' ;
}
executing Memory Script
Starting backup at 10-MAY-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=438 instance=TMSPROD2 device type=DISK
Finished backup at 10-MAY-22
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '+DATA/tmsprod/controlfile/control.ctl';
}
executing Memory Script
Starting backup at 10-MAY-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/10/2022 11:13:46
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 channel at 05/10/2022 11:13:46
ORA-17628: Oracle error 19505 returned by remote Oracle server
解决:
关键字:Oracle error 19505
检查确认目标端目录是否创建正确
参考:Duplicate from Active Database Failing with: RMAN-03009, ORA-17628, and ORA-19505 (Doc ID 1439632.1)
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




