ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Duplicate Database fails with Rman-5001 [ID 334588.1]

Duplicate Database fails with Rman-5001 [ID 334588.1]

原创 Linux操作系统 作者:v_fantasy 时间:2011-05-11 14:33:39 0 删除 编辑

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2010***

Symptoms

RMAN Duplicate fails with following errors, even though allocated channel for duplication is auxiliary.

sql statement: alter database mount standby database
released channel: aux1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/18/2005 02:07:52
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_03.dbf
conflicts with a file used by the target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_02.dbf

Cause

Production and Auxiliary have same directory structure and are running on two different machines.  RMAN must be told not check that the target datafiles are sharing the same names as the duplicated files being created.   Otherwise, the following errors will be returned:

RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_03.dbf
conflicts with a file used by the target database
RMAN-05001: auxiliary filename /qmaxnt/u04/qmaxntorafiles/table/QMAXAD08_02.dbf

Solution

To implement the solution, please use nofilenamecheck in syntax as follows:

1. Connect to Target, auxiliary, and rman catalog and
2. use script. as

run{
set until time "to_date('2005/09/17 14:00:00','yyyy/mm/dd HH24:MI:SS')";
allocate auxiliary channel aux1 type 'sbt_tape';
allocate auxiliary channel aux2 type 'sbt_tape';
duplicate target database for standby dorecover nofilenamecheck;
}

Make sure to use auxiliary type of channel so RMAN restore take place at auxiliary database.

Connecting to recovery catalog is optional here.

nofilenamecheck clause instructs rman not to check whether target database file names share the same name as auxiliary database 

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

请登录后发表评论 登录
全部评论

注册时间:2008-10-07

  • 博文量
    98
  • 访问量
    179506