www.eygle.com

« 使用dbms_backup_restore修改DBID | Blog首页 | 北大荒啊北大仓 -- 回到北京 »

Duplicate standby 与 RMAN-05501 错误

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2008/05/dulicate_standby_rman_05501.html

---

在Oracle9i中，当使用RMAN进行DataGuard创建过程时
如果在RMAN恢复时不指定 nofilenamecheck 参数
则在数据文件相同文件名恢复时会出现RMAN-05501错误


错误信息可能类似如下：

sql statement: alter database mount standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/20/2008 16:34:17
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename D:\EEYGLE\PERFSTAT.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\XDB01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\USERS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\TOOLS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\ODM01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\INDX01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\EXAMPLE01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\DRSYS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\CWMLITE01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\UNDOTBS01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\SYSTEM01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\REDO03.LOG conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\REDO02.LOG conflicts with a file used by the target database
RMAN-05001: auxiliary filename D:\EEYGLE\REDO01.LOG conflicts with a file used by the target database

为了解决这个问题，在恢复时需要指定nofilenamecheck 参数：
duplicate target database for standby nofilenamecheck;

以下是一个范例输出：

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 20-MAY-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=8 devtype=DISK

printing stored script: Memory Script
{
restore clone standby controlfile to clone_cf;
replicate clone controlfile from clone_cf;
sql clone 'alter database mount standby database';
}
executing script: Memory Script

Starting restore at 20-MAY-08

............

-The End-

By eygle on 2008-05-29 16:56 | Comments (3) | Posted to Advanced | Edit |

相关文章	随机文章
DataGuard ORA-01111文件创建失败问题解决 DataGuard的STANDBY_ARCHIVE_DEST参数 HDS Truecopy实现原理及项目的选择 Logical Standby ORA-01425错误处理一则 Oracle DataGuard 常用维护命令参考手册	DataMining-在Oracle学习 如何将复制队列表移出系统(SYSTEM)表空间 想到达明天 现在就要启程 - 假期就要开始喽 如何转储B*Tree索引的分枝结构 Nobody用户定时Movable Type的预约发布功能

留言 (3)

Posted by: lisli at June 3, 2008 5:41 PM

Posted by: eygle at June 4, 2008 9:18 AM

Posted by: wangliang at April 17, 2009 3:51 PM

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: