Troubleshoot & Fix RMAN Duplicate database failed with ORA-12720 RMAN-06136

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Details:
RMAN-00571: ===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===================================================
RMAN-03002: failure of Duplicate Db command at 11/03/2011 02:51:49
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

Solution#1:
You have to remove or comment out the cluster parameters from init.ora file for Auxiliary database
Solution #2:
Set cluster_database to FALSE in init.ora file of auxiliary database before starting the RMAN duplicate.

Show parameter cluster
SQL> show parameter cluster

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------
_kgl_cluster_lock_read_mostly        boolean     TRUE
cluster_database                     boolean     FALSE
cluster_database_instances           integer     2

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer