Rman duplicate fail with RMAN-06136, ORA-01503, ORA-12720 (文件 ID 1335479.1)

rongshiyuan發表於2013-12-05
Rman duplicate fail with RMAN-06136, ORA-01503, ORA-12720 (文件 ID 1335479.1)

In this Document

Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***

Symptoms

Trying to duplicate a RAC source database and getting this error stack:

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TABPICPY" RESETLOGS ARCHIVELOG
MAXLOGFILES 384
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 64
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 2000 M ,
GROUP 2 SIZE 2000 M ,
GROUP 7 SIZE 2000 M ,
GROUP 8 SIZE 2000 M ,
GROUP 9 SIZE 2000 M
DATAFILE
'+DATA_XDHFD1/tabpicpy/datafile/system.576.755692229'
CHARACTER SET AL32UTF8

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/05/2011 10:32:00
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

Cause

Duplicating a RAC database to RAC is not supported

Bug 10183090: RMAN DUPLICATE COMMAND FAILS WHEN TRYING TO REPEAT AFTER FAILURE ...
Status 84 - Closed, not feasible to fix

Solution


RMAN does not have support for RAC auxiliary, it can duplicate a RAC source database to
single instance and once duplicate finishes the single instance can be made RAC.

To workaround this issue, when duplicating a spfile from a RAC instance,
use SET clause of duplicate:
 

  duplicate ...
     spfile set CLUSTER_DATABASE=FALSE
     ... ;

 

References


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1062277/,如需轉載,請註明出處,否則將追究法律責任。

相關文章