Ora-12720 During Rman Duplication Of Database (文件 ID 341089.1)

rongshiyuan發表於2013-12-04
Ora-12720 During Rman Duplication Of Database (文件 ID 341089.1)

In this Document

Symptoms
Cause
Solution

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2013***


Symptoms

RMAN duplicate fails:


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/14/2005 12:29:05
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE
failed
ORA-12720: operation requires database is in EXCLUSIVE mode
Recovery Manager complete.

Cause

CLUSTER_DATABASE parameter set to true during duplication.  RMAN duplicate executes a create controlfile so it must follow the same rules as SQL CREATE CONTROLFILE.

Oracle Database SQL Reference, CREATE CONTROLFILE:

The database must not be mounted by any instance. Oracle Database leaves the database mounted in
EXCLUSIVE state after successful creation of the control file. If you are using the database with
Real Application Clusters, you must then shut down and remount the database in SHARED mode (which
is the default if the value of the CLUSTER_DATABASE initialization parameter is TRUE) before other
instances can start up.

Solution

Change CLUSTER_DATABASE parameter to false or comment out the parameter to default to false in the init.ora used to start the auxiliary instance for duplication.

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

相關文章