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

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google