RMAN-05501: aborting duplication of target database

最新推荐文章于 2024-07-05 12:22:56 发布
转载 最新推荐文章于 2024-07-05 12:22:56 发布 · 1.9k 阅读 · 0
文章标签：

#数据库

这篇博客探讨了在遇到RMAN-05501错误时如何处理目标数据库的复制中断。内容来源于ITPUB博客，分享了关于数据库管理的实践经验。

1.       

问题：

在搭建DG的时候，duplicate的时候出现以下错误；

Starting backup at 15-JUL-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/prod1/system01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:52:57

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/prod1/sysaux01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:52:59

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/app/oracle/oradata/prod1/example01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:53:00

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/prod1/undotbs01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:53:01

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/prod1/users01.dbf

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 07/15/2016 14:53:02

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 07/15/2016 14:53:02

ORA-17628: Oracle error 19505 returned by remote Oracle server

2.

原因：

参数文件错误：

[oracle@prod1 dbs]$ cat initprod1.ora

最低0.47元/天 解锁文章
congwei2855
关注
Oracle DG复制中断：RMAN-03015和RMAN-06094
Sebastien23的博客
08-21 1272
⭐️。
RMAN-05501 AND RMAN-05001
技术专栏
08-16 1386
在通过 rman active duplicate 创建 standby数据库时，报下面的错误： contents of Memory Script: {    sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter databas
DG 搭建错误
千里足迹
12-16 2031
报错1： [oracle@dgcrm ~]$ rman target sys/123456@CRM auxiliary sys/123456@DGCRM Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 1 10:26:53 2016 Copyright (c) 1982, 2011, Oracle an
Oracle-Rman duplicate文件坏块问题处理ORA-19849 19612
sinat_36757755的博客
11-22 1873
最近，在使用rman duplicate进行备库环境搭建时，遇到了ORA-19849 19612坏块报错，最终分析是发现由于网络的配置导致。
RMAN-05501 RMAN-05001
冰刀(skate)
10-28 8697
author：skate time：2011/10/28   错误信息： RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary file name /oracle/oradata/skatedb/tbs_statspack01.dbf conflicts with a file used by
RMAN DUPLICATE FAILURE RMAN-05501 RMAN-06617
jnrjian的博客
07-05 1038
# RMAN Duplicate fails with error RMAN-06617RUN { set until time "to_date('Mar 25 2014 19:33:00','Mon DD YYYY HH24:MI:SS')"; DUPLICATE DATABASE TO BACKUP LOCATION '//backupsets' NOFILENAMECHECK; } RMAN-06199: database moun
b2b-dg:/home/oracle#rman target sys/oracle@ecps auxiliary sys/oracle@ecpsdg Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 24 17:26:34 2025 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ECPS (DBID=3593407971) connected to auxiliary database: ECPS (not mounted) RMAN> duplicate target database for standby from active database nofilenamecheck; Starting Duplicate Db at 24-OCT-25 using target database control file instead of recovery catalog configuration for DISK channel 2 is ignored allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=350 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/home/app2/oracle/11.2.0.4/dbs/orapwecps1' auxiliary format '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwecpsdg' ; } executing Memory Script Starting backup at 24-OCT-25 released channel: ORA_AUX_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/24/2025 17:26:45 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-12001: could not open channel ORA_DISK_1 RMAN-10008: could not create channel context RMAN-10003: unable to connect to target database ORA-12154: TNS:could not resolve the connect identifier specified
最新发布
10-25
- RMAN-05501：这通常表示"aborting channel"或类似问题，可能与通道配置有关。 - RMAN-03015：可能表示"error occurred in stored script"，但需要确认。 - RMAN-12001：这可能与恢复目录相关，如"autobackup found...
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 24 15:45:41 2025 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ECPS (DBID=3593407971) connected to auxiliary database (not started) RMAN> RMAN> duplicate target database for standby from active database nofilenamecheck; Starting Duplicate Db at 24-OCT-25 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/24/2025 15:48:07 RMAN-05501: aborting duplication of target database RMAN-06403: could not obtain a fully authorized session RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory
10-25
我们正在解决RMAN执行`duplicate target database for standby from active database nofilenamecheck`命令时出现RMAN-06403、ORA-01034和ORA-27101错误的问题。 根据错误代码，我们可以分析： - ORA-01034: ...
channel ORA_AUX_DISK_1: SID=4375 instance=jshwsmta2 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/25/2025 16:19:42 RMAN-05501: aborting duplication of target database RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
04-26
# Example of setting up a basic duplication process after mounting. RUN { ALLOCATE CHANNEL aux_ch DEVICE TYPE DISK FORMAT '/path/to/destination/%U'; DUPLICATE TARGET DATABASE TO newdb ...
[20171221]RMAN-05501.txt
12-21 203
[20171221]RMAN-05501 aborting duplication of target database.txt --//昨天使用rman duplicate建立dg,出现如下错误: rman > d...
RMAN-05001
zuixinnet的专栏
05-05 1056
duplicate target database for standby  from active database; sql statement: alter database mount standby database RMAN-00571: =========================================================== RMAN-00569:
linux 时区 -0500,RMAN-05001
weixin_36213143的博客
05-16 410
今天duplicate database for standby的时候，出现了RMAN-05001错误:RMAN> duplicate target database for standby;Starting Duplicate Db at 18-OCT-12using channel ORA_AUX_DISK_1contents of Memory Script.:{restore clo...
RMAN duplicate 复制standby 数据库是的报错
cn00909332的博客
06-12 714
今天做RMAN搭建standby 数据库的时候报了一个错 2：RMAN> duplicate target database for standby from active database doreco...
rman报错oracle链接断开,RMAN-06217: 错误
weixin_42299150的博客
04-09 527
这个错误的原因是连接方式的错误最初采用[oracle@host~]$rmantargetsys/oracle@BOLO102stdauxiliary/RecoveryManager:Release11.2.0.3.0-ProductiononFriAug2315:25:532013Copyright(c)1982,2011,Oracleand/orit...
RMAN-06217: not connected to auxiliary database with a net service name
liuzhilong的博客
12-22 1924
        rman target sys/Oracle1234@test auxiliary  / nocatalog run{     allocate channel c1 device type disk;     allocate channel c2 device type disk;     allocate channel c3 device type disk;     al...
Oracle之Rman常见错误
cuanxixia1496的博客
11-13 339
Oracle之Rman常见错误 =========================================================== RMAN-05501: aborting duplication...
ORA-19801 RMAN-06136
weixin_43131669的博客
11-08 319
其实该参数在spfile中已经设置了，不知道为什么没有生效。c:\oracle既是spfile文件所在的位置。根据网上的博文设置一下即可。
RMAN-05541: no archived logs found in target database
congxinlan3332的博客
04-17 270
我们在创建Data Guard，复制standby数据库的时候执行以下命令：duplicate target database to ractest from active database nofilenamecheck;出现...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值