RMAN-03009 & ORA-17628

最新推荐文章于 2023-11-29 22:46:35 发布

amto001

最新推荐文章于 2023-11-29 22:46:35 发布

阅读量1w

点赞数

CC 4.0 BY-SA版权

分类专栏： Duplicate & Auxiliary 文章标签： ORA-17628 RMAN-03009

本文链接：https://blog.youkuaiyun.com/amto001/article/details/10011643

Duplicate & Auxiliary 专栏收录该内容

2 篇文章

订阅专栏

在尝试使用RMAN的duplicate命令创建辅助数据库时，遇到RMAN-03009和ORA-17628错误。问题根源是控制文件路径指定错误。解决方案是精确指定每个数据文件的新名称，并正确设置control_file参数，例如：control_file='/oradata/prod/control01.ctl'。调整后，错误得以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

执行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: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/16/2013 21:03:34
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 08/16/2013 21:03:34
ORA-17628: Oracle error 19505 returned by remote Oracle server

环境描述：

在生产端数据库控制文件存放在

/oradata/prod/control01.ctl,/oradata/prod/control02.ctl,/oradata/prod/control03.ctl

AUXILIARY端的控制文件路径也保持与生产端一致。

问题原因和解决方法：

问题原因为控制文件的路径指定错误，修改之前的脚本为：

run{
SET NEWNAME for datafile 1 to '/oradata/prod/system01.dbf';
SET NEWNAME for datafile 2 to '/oradata/prod/sysaux01.dbf';
SET NEWNAME for datafile 3 to '/oradata/prod/undotbs01.dbf';
SET NEWNAME for datafile 4 to '/oradata/prod/users01.dbf';
}
duplicate target database
for standby
from active database
DORECOVER nofilenamecheck
spfile
set db_unique_name='prodx'
set log_archive_dest_1='location=/arch142 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prodx'
set log_archive_dest_2='SERVICE=prodb ASYNC LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prodb'
set standby_file_management='AUTO'
set fal_server='prodb'
set fal_client='prodx'
set control_files='/oradata/prod'
set memory_target='0'
set sga_target='600M';