RMAN-03009 & ORA-17628

来源：互联网发布：在线提醒软件编辑：程序博客网时间：2024/05/22 00:18

执行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';

将control_files='/oradata/prod' 调整为 control_file='/oradata/prod/control01.ctl' 该错误解决。

注意，在我尝试在参数control_files中填写多个控制文件时，仍然报相同的错误，比如：control_file='/oradata/prod/control01.ctl,/oradata/prod/control02.ctl'