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

advertisements

_____________________________________________________________________________________________________________________

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 (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

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