ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Duplicate standby 与 RMAN-05501 错误

Duplicate standby 与 RMAN-05501 错误

原创 Linux操作系统 作者:atlantisholic 时间:2011-03-03 17:26:38 0 删除 编辑

在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

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23071790/viewspace-688372/,如需转载,请注明出处,否则将追究法律责任。

上一篇: standby简单配置
请登录后发表评论 登录
全部评论

注册时间:2010-08-30

  • 博文量
    130
  • 访问量
    632264