eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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

Duplicate standby 与 RMAN-05501 错误
modb.pro

在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-


历史上的今天...
    >> 2019-05-29文章:
    >> 2016-05-29文章:
    >> 2007-05-29文章:
    >> 2006-05-29文章:
           醇歌美酒 内蒙归来

By eygle on 2008-05-29 16:56 | Comments (5) | Advanced | 1914 |

5 Comments

dulicate standby ---名字写错了 :)

修改之,谢谢:S

10g 是不是不用加这个参数了呢?

我按你的方法做了,又出现下面的问题,不知道怎么解决。

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/09/2010 09:10:12
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

解决问题了,感谢!


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com