ORA-01103 when creating physical standby
From: Li Li <litanli_at_gmail.com>
Date: Fri, 6 Feb 2009 15:09:43 -0600
Message-ID: <5f35c2320902061309n3ea49422q79265f5540c14a88_at_mail.gmail.com>
Hi, List,
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-01103: database name 'xxxxxx' in control file is not 'yyyyyyyy'
Date: Fri, 6 Feb 2009 15:09:43 -0600
Message-ID: <5f35c2320902061309n3ea49422q79265f5540c14a88_at_mail.gmail.com>
Hi, List,
I am following this white paper
http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrimaryRACPhysicalStandby.pdf
to create a physical standby, at TASK 3: step 9, when I was trying to
'DUPLICATE TARGET DATABASE FOR STANDBY', I ran into this ORA-01103
error. The standby control file was backed up from the primary
database in RMAN by 'backup current controlfile for standby'. Any idea
what caused this error? Any suggestion would be greatly appreciated!
sql statement: alter database mount standby database
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 02/06/2009 15:58:43RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at 02/06/2009 15:58:43
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-01103: database name 'xxxxxx' in control file is not 'yyyyyyyy'
Thanks,
-Li
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 06 2009 - 15:09:43 CST